Simple Logic - Database Administrator - MySQL

We are seeking a skilled and experienced MySQL Database Administrator (DBA) to join our team.

The ideal candidate will be responsible for ensuring the performance, availability, and security of MySQL databases across multiple environments.

This role demands hands-on expertise in MySQL architecture, replication, backup and recovery strategies, scripting, and performance tuning.

Key Responsibilities :

• Install, configure, and maintain MySQL database servers across development, testing, and production environments.
• Deep understanding of MySQL architecture including memory structures, background processes, and performance optimization.
• Plan and implement backup and recovery strategies using both native and open-source tools.
• Administer database access, enforce best practices in user management, privileges, and role-based access control.
• Diagnose, troubleshoot, and resolve MySQL performance issues, slow queries, and error logs.
• Design and implement high availability solutions using MySQL Replication (Master-Master, Single Master Multi Slave setups).
• Perform and manage MySQL upgrades and patching, ensuring minimal downtime and data integrity.
• Execute and manage disaster recovery drills, including replication switch-over and switch-back activities.
• Develop automation scripts for recurring database tasks such as backups, health checks, and reports using Shell, Python, or similar scripting languages.
• Monitor and fine-tune database performance using query optimization and indexing strategies.
• Collaborate with development and DevOps teams to support application integration, database design, and data modeling.
• Provide on-call support for production environments, ensuring rapid response to critical issues.
• Maintain documentation for database configurations, procedures, and known issues.
• Stay updated on emerging database technologies and provide recommendations for improvements.

Required Skills :

Good to Have :

(ref : hirist.tech)