MySQL DBA Lead

Haryana
Permanent
Full-time

29 days ago
Apply easily

Job Description: MySQL DBA Lead (AWS/Azure Native MySQL)Role Overview:We are seeking an experienced MySQL DBA Lead with expertise in cloud-based database management (AWS, Azure) to lead and optimize our MySQL database environments. The ideal candidate will have extensive experience in MySQL performance tuning, high availability setups, backup and recovery strategies, and managing MySQL in cloud-native platforms like AWS RDS, Aurora, or Azure Database for MySQL.Key Responsibilities:

Lead the design, implementation, and optimization of MySQL databases on AWS and Azure cloud environments.
Manage cloud-native MySQL services such as AWS RDS, Aurora, Azure Database for MySQL.
Oversee database security, including user management, encryption, and backup strategies.
Develop and implement performance tuning strategies, including query optimization, indexing, and hardware scaling.
Design and manage high availability and disaster recovery strategies using replication, clustering, and automated backups.
Automate routine DBA tasks using tools like Ansible, Python, or Shell scripting.
Monitor MySQL database performance using cloud-native monitoring tools and third-party solutions.
Troubleshoot and resolve database-related issues in a timely manner, ensuring high availability and minimal downtime.
Lead and mentor a team of junior DBAs, ensuring effective collaboration with development and operations teams.
Manage database migrations, upgrades, and capacity planning for future growth.

Required Skills & Experience:

Proven experience as a MySQL DBA, with a focus on cloud platforms like AWS (RDS, Aurora) and Azure (Azure Database for MySQL).
Strong expertise in MySQL performance tuning, query optimization, and index management.
Hands-on experience with high availability solutions (replication, clustering) and backup/recovery strategies.
Expertise in cloud-native database management and deployment in AWS and Azure environments.
Proficient in database automation using scripting languages (Python, Bash, Ansible).
Experience with monitoring tools (CloudWatch, Azure Monitor, Percona Monitoring, Nagios).
Strong troubleshooting skills and ability to resolve complex database issues quickly.
Experience with security management, including access control, encryption, and auditing.
Familiarity with database migrations and upgrades in cloud environments.

Preferred Qualifications:

MySQL certifications or cloud certifications (AWS Certified Database – Specialty, Azure Database certifications).
Experience with Infrastructure as Code (Terraform, CloudFormation) for MySQL provisioning.
Familiarity with DevOps and CI/CD processes in a database environment.
Experience in managing MySQL in containerized environments (Docker, Kubernetes).

Qode