Database Engineer - MySQL

<p><p><b>Description :</b><br/><br/><b>Key Responsibilities :</b></p><p><p><b><br/></b></p>- Design, configure, and maintain MySQL database systems for production and development environments.<br/><br/>- Implement and manage database replication, clustering, and backup strategies.<br/><br/>- Monitor database performance and proactively tune queries, indexes, and schema for optimal efficiency.<br/><br/>- Handle database migrations, version upgrades, and automation of routine DB operations.<br/><br/>- Develop and maintain disaster recovery plans and ensure data availability and security.<br/><br/>- Collaborate with application developers to optimize queries and schema design.<br/><br/>- Perform troubleshooting of database-related performance or connectivity issues.<br/><br/>- Implement and monitor database access controls, ensuring compliance with security and audit standards.<br/><br/>- Support data modeling, schema design, and capacity planning for future scalability.<br/><br/>- Document database environments, configurations, and standard operating procedures.<br/><br/><b>Required Skills & Experience :</b></p><p><p><b><br/></b></p>- 7+ years of hands-on experience as a MySQL Database Administrator / Engineer.<br/><br/>- Deep knowledge of MySQL internals, replication (Master-Slave, GTID, Group Replication), and high availability architectures.<br/><br/>- Strong experience in query optimization, indexing, and database tuning.<br/><br/>- Proficiency in Linux/Unix environments, including shell scripting and automation.<br/><br/>- Experience with backup and recovery tools (e.g., Percona XtraBackup, mysqldump).<br/><br/>- Familiarity with cloud-based database environments (AWS RDS, Azure Database for MySQL, or GCP SQL).<br/><br/>- Experience with monitoring tools such as Prometheus, Grafana, or Percona Monitoring and Management (PMM).<br/><br/>- Strong understanding of SQL, stored procedures, triggers, and database security best practices.<br/><br/>- Excellent troubleshooting and problem-solving skills.<br/><br/><b>Preferred Qualifications :</b></p><p><p><b><br/></b></p>- Bachelors or Masters degree in Computer Science, Information Technology, or a related field.<br/><br/>- Experience with NoSQL / NewSQL databases (MongoDB, Cassandra, etc.) is an added advantage.<br/><br/>- Knowledge of CI/CD pipelines, DevOps integration, and database automation tools.<br/><br/>- Certifications such as MySQL Database Administrator / Oracle MySQL Certified Professional preferred.</p><br/></p> (ref:hirist.tech)