DATABASE ADMINISTRATOR
Role :Database Administrator (MySQL / Percona)
Experience : 3+ Years (Immediate Joiner)
Shift :US Eastern Time business hours night shift — approximately 6:30 PM to 3:30 AM IST, shifting by about an hour with US daylight saving.
Budget : 6 LPA - 8LPA
Location : Banglore
About the role
Client runs MySQL / Percona replication clusters that serve production workloads for hundreds of real estate client sites. This is a hands-on engineering role — you own database problems from detection through resolution, not NOC-tier monitoring.
The Database Administrator is responsible for the health, performance, and recoverability of these clusters. The role demands deep MySQL expertise, the ability to diagnose and remediate replication failures, and a disciplined approach to backup verification and capacity management. Solid Linux administration is required, since all database workloads run on Linux VMs.
Setting
● Database: MySQL / Percona Server — multiple primary/replica clusters (moya cluster, listings cluster, separate topologies)
● OS / virtualization:
Oracle Linux / AlmaLinux (Red Hat family) on XCP-ng VMs
● Backup: Percona XtraBackup
● Monitoring: Zabbix with custom MySQL templates
● Automation: Ansible, Bash/Python scripts
● Storage: LVM volumes on XCP-ng SR, Dell PowerStore iSCSI backend
Key responsibilities
● Replication health — SSH to each replica daily; verify Slave_IO_Running and Slave_SQL_Running are Yes and Seconds_Behind_Master is at or near zero. When replication breaks, identify the error, remediate or skip the offending transaction safely, and document the incident.
● Replication diagnosis — Interpret Last_SQL_Error, classify error types (duplicate key 1062, row-not-found 1032, definition mismatch), inspect binlog position with mysqlbinlog, and judge when to skip an event versus rebuild the replica. Escalate data-loss-risk decisions.
● Performance tuning — Review the slow query log, use EXPLAIN to analyze execution plans, identify mis