Key Responsibilities Install, configure, upgrade, and patch MySQL database instances across various environments (development, staging, production). Monitor database performance, availability, and capacity, implementing proactive measures to prevent issues. Set up and manage comprehensive database backup, recovery, and disaster recovery strategies, conducting regular restore drills. Perform advanced MySQL performance tuning, including query optimization, indexing strategies, schema improvements, and server configuration adjustments. Analyze and troubleshoot complex database performance bottlenecks and provide effective solutions. Design, implement and maintain high availability solutions using MySQL Replication (Master-Slave, Group Replication, etc.) and clustering technologies. Ensure robust failover mechanisms and data consistency across replicated environments. Implement and enforce database security best practices, including user access management, encryption, and auditing. Ensure compliance with relevant data privacy and security regulations. Diagnose and resolve complex database-related issues swiftly, providing expert-level support for production incidents. Perform root cause analysis for recurring problems and implement preventive measures. Conduct regular capacity planning to anticipate future database growth and resource requirements. Develop and implement scripts (Shell, Python, etc.) to automate routine database administration tasks, monitoring, and reporting. Collaborate closely with development teams, system administrators, and infrastructure engineers to support application needs and ensure smooth deployments. Maintain comprehensive documentation for database configurations, procedures, and best Qualifications : 5-7 years of dedicated, hands-on experience as a MySQL Database Administrator in a production environment. Deep expertise in MySQL architecture, administration, and troubleshooting. Strong experience with MySQL performance tuning and optimization. Proven experience in setting up and managing MySQL Replication (Master-Slave, Group Replication) and high availability solutions. Proficiency in designing and implementing robust backup and recovery strategies. Excellent command of SQL, including writing complex queries, stored procedures, functions, and understanding indexing strategies. Strong proficiency in Linux/Unix operating systems for database deployment, management, and troubleshooting. Hands-on experience with scripting languages (e.g., Shell scripting, Python) for database : Bachelor's degree in Computer Science, Information Technology, or a related technical QUALIFICATIONS (GOOD TO HAVE) : MySQL certifications (e.g., Oracle Certified Professional, MySQL Database Administrator). Experience with cloud database services (e.g., AWS RDS for MySQL, Azure Database for MySQL, Google Cloud SQL). Familiarity with other database technologies (e.g., PostgreSQL, MongoDB) or NoSQL databases. Experience with database monitoring tools beyond native MySQL (e.g., Percona Monitoring and Management, Prometheus/Grafana). Knowledge of database security best practices and compliance frameworks. Understanding of DevOps principles and experience with infrastructure as code (IaC) (ref:hirist.tech) Show more Show less