Senior MySQL DBA (Replication Specialist)

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 client's 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).

Design & Implement Topologies: Architect, deploy, and manage advanced MySQL replication environments, including traditional Asynchronous, Semi-Synchronous, and Group Replication.

Evaluate the client's current replication setup (externally managed master, three read replicas) and recommend and implement improvements to resiliency, failover speed, and rebuild time.

Apply deep replication knowledge — binary logging (Row-Based vs.

Statement-Based Replication), GTID (Global Transaction Identifiers), and multi-source replication — to troubleshoot and optimize the environment.

Support the client's MySQL 5.7 to MySQL 8 migration, ensuring replication compatibility and minimal disruption across all replicas.

Administer and monitor production MySQL InnoDB Clusters, ClusterSets, and Galera/Percona XtraDB Clusters where applicable.

Build, maintain, and test backup and point-in-time recovery (PITR) strategies using Percona XtraBackup, MySQL Enterprise Backup, or cloud-native snapshots.

Monitor, diagnose, and resolve multi-threaded replication delays caused by long-running transactions or disk I/O bottlenecks.

Identify and optimize slow queries impacting the master node to prevent replica performance degradation.

Configure and monitor database metrics using Percona Monitoring and Management (PMM) and related observability tooling.

Use MySQL Router, ProxySQL, or HAProxy for intelligent connection pooling and read/write splitting across replicas.

8+ years of hands-on MySQL DBA experience, with a strong specialization in replication architecture and operations.

Proven experience administering production MySQL InnoDB replication environments at multi-terabyte scale (2TB+).

operating in environments where the primary/master database is managed by a third-party vendor, with DBA ownership limited to read replicas.

Demonstrated experience rebuilding failed replicas on large databases and reducing rebuild time.

with MySQL 5.7 to MySQL 8 upgrade/migration projects.

Strong troubleshooting skills for replication lag, replication failures, and DNS-based failover/traffic rerouting.

MySQL 5.7/8.0, InnoDB Replication, Asynchronous/Semi-Synchronous/Group Replication, GTID, Row-Based vs.

Statement-Based Replication (binary logging), Multi-Source Replication, MySQL InnoDB Cluster/ClusterSet, Galera/Percona XtraDB Cluster.

Percona XtraBackup, MySQL Enterprise Backup, Point-in-Time Recovery (PITR), cloud-native snapshots.

Percona Monitoring and Management (PMM), MySQL Router, ProxySQL, HAProxy.

Query optimization and tuning, disk I/O and OS-level performance tuning, DNS-based failover/traffic routing, large-scale (2.5TB+) database rebuild and provisioning.

Reduced replica rebuild time following failures, measured against current baseline.

Reduced frequency and duration of replication lag/delay incidents.

Improved mean-time-to-recovery (MTTR) for replica failures, including DNS-based failover events.

Disruption-free completion of the MySQL 5.7 to MySQL 8 migration across all replicas.

Strengthened monitoring coverage and proactive alerting for replication health.

Documented, repeatable rebuild and failover runbooks adopted by the client team.