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

📌 Sr MySQL DBA (Bengaluru)
🏢 Atlas Systems
📍 Bengaluru