Database Administrator - MySQL

<p><p><b>Job Description :</b><br/><br/> Position : MySQL DBA<br/><br/> Location : Bhopal<br/><br/> Experience : 3+ years<br/><br/> Employment type : Full-time<br/><br/><b>Job summary :</b><br/><br/> We are looking for a hands-on MySQL DBA with 23 years of experience to manage, tune and maintain MySQL databases (including clustering & replication) for production systems.<br/><br/> The ideal candidate will own availability, backup & recovery, performance tuning, and monitoring for OLTP workloads.<br/><br/><b>Key responsibilities :</b><br/><br/> - Install, configure and maintain MySQL instances (5.7/8.0 or higher) in production and staging.<br/><br/> - Design, implement and manage MySQL clustering and high-availability solutions (Galera / Percona XtraDB Cluster / MySQL InnoDB Cluster or equivalent).<br/><br/> - Implement and maintain replication topologies (asynchronous, semi-sync, group replication); perform failover and recovery.<br/><br/> - Performance tuning : diagnose slow queries, optimize schema/indexes, tune MySQL configuration and OS-level settings.<br/><br/> - Backup & recovery strategy : implement automated backups, test restores, point-in-time recovery.<br/><br/> - Monitor DB health (alerts, metrics) and troubleshoot DB incidents (connectivity, locking, replication lag).<br/><br/> - Work with developers to review schema changes, query plans and migrations.<br/><br/> - Maintain security best practices : users, roles, encryption, audit as per policy.<br/><br/><b>Required skills & qualifications :</b><br/><br/> - 2 to 3 years hands-on experience as MySQL DBA or Database Engineer.<br/><br/> - Strong practical knowledge of MySQL internals (InnoDB, buffer pool, transaction handling).<br/><br/> - Experience with MySQL clustering & HA solutions (Galera, Percona XtraDB Cluster, MySQL Group Replication, or InnoDB Cluster).<br/><br/> - Experience implementing and troubleshooting replication (master-slave, master-master, multi-source).<br/><br/> - Experience with backup tools (mysqldump, xtrabackup, mysqlpump) and recovery operations.<br/><br/> - Solid Linux administration skills (system tuning, I/O, kernel params).<br/><br/> - Familiarity with monitoring tools (Prometheus/Grafana, Percona Monitoring & Management, Zabbix, Nagios).<br/><br/> - Knowledge of automation/config management (Ansible, Terraform, Chef) is a plus.<br/><br/> - Good troubleshooting, communication and documentation skills.</p><br/></p> (ref:hirist.tech)