Database Administrator - MySQL

Position : MySQL Database Administrator. Experience : 5 years. Work Mode : Remote/Onsite. Location : Must have experience in cloud environments . Must Have Skills : - Python scripting, Linux administration, MySQL clustering, MySQL replication. Must Have : - Deep expertise in managing large clusters is expected. Job Summary : - We are looking for an experienced MySQL Database Administrator (DBA) with strong expertise in managing large-scale MySQL clusters. - The ideal candidate should have deep knowledge of database architecture, performance tuning, replication, backups, and disaster recovery Additionally, Python scripting skills are required for automation and operational efficiency. Key Responsibilities : - Design, implement, and maintain highly available and scalable MySQL clusters. - Optimize database performance, indexing, and query tuning. - Manage replication, backups, restores, and disaster recovery strategies. - Monitor database health, troubleshoot issues, and proactively resolve performance bottlenecks. - Develop Python scripts for automation, monitoring, and database maintenance. - Ensure database security, compliance, and access control policies. - Collaborate with development teams to support database needs and optimize queries. - Perform schema design, data modeling, and capacity planning. - Upgrade and patch MySQL databases while minimizing downtime. - Work with cloud-based and on-premise MySQL deployments. - Document processes, procedures, and database configurations. Required Skills & Qualifications : - 5 years of experience as a MySQL DBA managing large-scale databases. - Deep expertise in MySQL clustering (InnoDB Cluster, Group Replication, Galera Cluster, etc. - Strong understanding of query optimization, indexing, and performance tuning. - Experience with MySQL replication (asynchronous, semi-sync, GTID-based). - Proficiency in Python for database automation and scripting. - Hands-on experience with monitoring tools like Percona Monitoring and Management (PMM),. Prometheus, Grafana, or Nagios. - Knowledge of backup and recovery tools like Percona XtraBackup or mysqldump. - Familiarity with Linux administration, shell scripting, and system performance tuning. - Experience working with cloud environments (AWS RDS, Google Cloud SQL, Azure Database for MySQL). - Strong problem-solving skills and ability to work under pressure. Preferred Qualifications : - Experience with NoSQL databases (MongoDB, Redis) is a plus. - Knowledge of containerization (Docker, Kubernetes) for database deployment. - Familiarity with Ansible, Terraform, or other automation tools. (ref:hirist.tech)

Location: in, IN

Posted Date: 4/19/2025