MySQL DBA

Job Details :

As a MySQL DBA - Operations, you will play a critical role in managing, optimizing, and securing MySQL and ProxySQL databases across on-premises and public cloud environments (AWS, Azure, GCP). You will ensure high availability, performance, and reliability through clustering, tuning, automation, and proactive monitoring. You will also lead war room efforts and Root Cause Analysis (RCA) to drive operational excellence.

This role reports to the Database Operations Lead and collaborates closely with Application Engineering, Cloud Infrastructure, and COE teams.

Roles & Responsibilities

Manage and optimize the performance, availability, and security of MySQL, PXC clusters, and ProxySQL databases.

Lead and execute public cloud migrations (AWS, Azure GCP).

Develop and deploy automation scripts (Shell, SQL, Python) for provisioning, monitoring, backups, and tuning.

Design and maintain Grafana and PMM dashboards for observability and anomaly detection.

Implement and manage database monitoring and alerting systems.

Ensure adherence to ITIL processes (Incident, Problem, Change Management).

Plan and execute MySQL upgrades, patching, and migrations with minimal downtime.

Troubleshoot and resolve complex database issues in production environments.

Lead war room efforts during critical incidents and coordinate cross-functional resolution.

Conduct RCA for major incidents and implement preventive measures.

Enforce database security best practices (access control, encryption, vulnerability assessments).

Collaborate with application teams to optimize queries, indexing, and schema design.

Stay current with emerging database technologies and cloud best practices.

Qualifications

Bachelor's degree in computer science.

10+ years of experience.

Proven experience as a MySQL and ProxySQL DBA in operational roles.

Expertise in clustering, cloud migrations, scripting, monitoring, ITIL, war room management, and RCA.

Strong experience with AWS, Azure, GCP, and cloud-native database services.

Proficiency in Shell, SQL, and Python scripting.

Deep understanding of ITIL processes and database security principles.

Strong analytical skills for query optimization and indexing strategies.

Excellent communication, leadership, and collaboration skills.

Ability to mentor junior DBAs and work effectively under pressure