Position Summary

We are seeking an experienced Senior MySQL Database Administrator with deep expertise in MySQL replication to support and improve a clients production database workplace. The client currently runs MySQL 5.7, with an active migration to MySQL 8 underway. The clients master/primary database is managed by a separate vendor; this role is responsible for the clients three MySQL read replicas, one of which serves live read traffic for the clients application.

This role requires strong hands-on experience designing, monitoring, and troubleshooting MySQL InnoDB replication at scale (~2.5TB), including diagnosing replication delays, rebuilding failed replicas efficiently, and advising the client on ways to modernize and harden the overall replication architecture.

Position Details
Job Title: Senior MySQL DBA - Replication Specialist
Location: [Client Location] (Remote / Hybrid as applicable)
Work Timing: 6AM EST - 7PM EST
Experience: 8+ Years
Engagement Type: Long-term / Multi-year (Contract / Full time)

Key Responsibilities




Replication Monitoring Incident Response: Perform daily monitoring of replication health and lag across all read replicas, proactively identifying and responding to delays before they impact the application.
Diagnose and resolve replication failures on the ~2.5TB production database, minimizing time-to-recovery.
Coordinate with the clients infrastructure team when a replica failure requires a DNS change to route application read traffic to a healthy replica.
Rebuild failed or broken replicas, and identify ways to speed up the rebuild process (e.g., parallelized data copy, Percona XtraBackup-based provisioning, snapshot/clone-based rebuilds, network and disk I/O tuning).
Replication Architecture Improvement: Design Implement Topologies: Architect, deploy, and manage advanced MySQL replication settings, including traditional Asynchronous, Semi-Synchronous, and Group Replication.
Evaluate the clients current

📌 Sr Mysql Dba Bengaluru (India)
🏢 Atlas Systems
📍 India