Critical Competencies:
Expertise in SQL Server, Oracle, PostgreSQL, and MySQL for administration and migration.
Experience with PostgreSQL/MySQL/PAAS DB, scripting, and automation.
Experience in AWS/Azure Cloud environments.
Key Responsibilities:
Create and maintain SOPs for migration execution.
Formulate and monitor database management policies, procedures, and standards.
Provide design standards and guidance for projects and technical roadmaps.
Mentor and train Level 1 and Level 2 DBAs.
Engage with customers to streamline project deliverables.
Forecast database growth and plan for hardware and storage requirements.
Plan and deploy high availability and disaster recovery strategies.
Execute database software upgrades, patches, and service packs.
Investigate and resolve complex database-related issues.
Develop automation tools to streamline tasks.
Set up monitoring and alerting systems.
Generate performance reports and analysis.
Maintain up-to-date documentation of database configurations.
Resolve incidents, changes, and service requests under client SLAs.
Create detailed RCA reports for problem management.
Evaluate and manage third-party tools for database management.
Participate in sales implementations and vendor calls.
Provide 24x7 production support for database operations.
Execute large, complex database projects.
Knowledge and Skills:
Proficient in SQL Server, Oracle, PostgreSQL, and MySQL for architecture, installation, configuration, performance tuning, high availability, and disaster recovery.
Experience in planning and executing database migrations and upgrades.
Cloud-enabled for project-based migrations, automation, and administration.
Familiarity with industry best practices for database administration.
Effective communication of technical information.
Leadership skills for unexpected situations.
Experience with automation using Python, AWS CLI, PowerShell, Shell.
Knowledge of infrastructure as code with CloudFormation, Terraform, GitHub.
Ability to deploy, manage, and troubleshoot HADR configurations.
Knowledge of deploying and managing RDBMS in cloud platforms.
Understanding of monitoring tools like Datadog, Azure Monitor, AWS CloudWatch.
Usage of ITIL-based ticket tools like ServiceNow.
