01Key Responsibilities
Database Management: Install, configure, and maintain MySQL databases, ensuring optimal performance and reliability.
Performance Tuning: Monitor database performance, identify bottlenecks, and implement tuning strategies to enhance efficiency.
Backup and Recovery: Develop and implement backup and recovery strategies to safeguard data integrity and availability.
Security Management: Implement and manage database security measures, including user access controls and data encryption.
Troubleshooting: Diagnose and resolve database issues, including performance problems, data corruption, and connectivity issues.
Replication and Clustering: Set up and manage MySQL replication and clustering for high availability and disaster recovery.
Upgrades and Migrations: Plan and execute database upgrades and migrations with minimal downtime.
Qualifications:
Bachelors or Masters degree in computer science, Information Technology, or a related field.
5-7 years of experience as a MySQL Database Administrator or in a similar role.
Strong knowledge of MySQL database architecture, administration, and performance tuning.
Experience with database backup and recovery strategies.
Familiarity with MySQL replication, clustering, and high availability solutions.
Proficient in SQL and experience with writing complex queries, stored procedures, and triggers.
Knowledge of database security best practices and tools.
Experience with monitoring tools (e.g., Nagios, Zabbix) and performance tuning tools (e.g., MySQL Workbench).
Strong problem-solving skills and the ability to work independently and as part of a team.
Good communication and interpersonal skills.
Preferred Skills:
Experience with cloud-based database solutions (e.g., AWS RDS, Google Cloud SQL). .
