We are seeking a skilled MySQL Database Administrator (DBA) responsible for the installation, configuration, maintenance, and performance optimization of MySQL databases. The role involves ensuring database availability, security, backup, and recovery while supporting development and operations teams in troubleshooting database-related issues. The ideal candidate should have strong analytical skills and hands-on experience managing MySQL environments on both Linux and Windows platforms.
Key Responsibilities:
Install, configure, and maintain MySQL database servers on Linux and Windows environments.
Monitor database performance and perform tuning and optimization to ensure high availability and efficiency.
Manage database configuration parameters and optimize system performance.
Perform database backup and recovery operations to ensure data safety and business continuity.
Implement and maintain MySQL replication (Master-Slave) using Binary Log and GTID methods.
Perform database upgrades and patching while ensuring minimal downtime.
Conduct regular database maintenance activities, including indexing, cleanup, and monitoring.
Troubleshoot and resolve database-related issues with strong analytical problem-solving skills.
Manage database users, roles, and access privileges to ensure proper security and compliance.
Develop and maintain basic shell scripts for automation of routine database tasks.
Perform basic OS-level troubleshooting related to database server environments.
Work independently and collaborate with development and infrastructure teams to deliver reliable database solutions.
Qualifications and Skills:
Strong understanding of MySQL architecture and database internals.
Hands-on experience with MySQL installation and configuration on Linux and Windows platforms.
Experience with database replication (Master-Slave) using Binary Log and GTID.
Knowledge of database backup and recovery strategies.
Experience with database upgrades and maintenance activities.
Familiarity with performance tuning and troubleshooting techniques.
Basic knowledge of Shell scripting (Bash) for automation tasks.
Basic knowledge of Operating System level troubleshooting (Linux/Windows).
Strong analytical and problem-solving skills.
Ability to work independently and handle production database environments.