MySQL DBA

Job Description:

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).

Job Type: Full-time

Pay: From ₹100,000.00 per month

Schedule:

• Monday to Friday

Work Location: In person