- Qualifications:
- Bachelor’s or Master’s 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.
Key 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.
Preferred Skills:
- Experience with cloud-based database solutions (e.g., AWS RDS, Google Cloud SQL).
