Job Summary

Position: 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)

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

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 environments, including traditional Asynchronous, Semi-Synchronous, and Group Replication.
Evaluate the clients current replication setup (external

📌 Sr Mysql Dba Bengaluru
🏢 Atlas Systems
📍 Bengaluru