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

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