Provide expertise on database management/design to drive integration of business data, functions, and systems. Establish standards, guidelines, procedures, and other infrastructure necessary to support the objective of integration of data. Resolve performance problems. Plans and schedules daily tasks, uses judgement on a variety of problems requiring deviation from standard practices. Inadequacies and erroneous decisions would cause moderate inconvenience and expense.
Job Description: Senior Certified MySQL DBA (Database Administrator)
Job Summary:
We are seeking a highly experienced and certified Senior MySQL DBA to join our dynamic IT team. The successful candidate will be responsible for managing, optimizing, and securing MySQL databases across various environments. This role involves maintaining high database performance, ensuring data integrity, and providing expert-level support for critical database operations.
Key Responsibilities:
1. Database Administration:
- Manage and maintain MySQL databases in production, staging\QA, and development environments.
- Oversee installation, configuration, and upgrading of MySQL databases and related products.
- Monitor database performance, implement optimization strategies, and resolve issues.
2. Performance Tuning and Optimization:
- Analyze database performance and make recommendations for improvements.
- Implement index strategies, schema changes, and query optimization techniques to enhance performance.
- Troubleshoot and resolve performance bottlenecks.
3. Security and Compliance:
- Ensure database security by implementing and maintaining encryption, user roles, access controls, and auditing procedures.
- Conduct regular security assessments and maintain compliance with internal and external security standards.
4. Backup and Recovery:
- Design and implement database backup strategies (full, incremental, and point-in-time).
- Manage recovery solutions and perform disaster recovery testing.
- Ensure data redundancy and availability across multiple systems or data centers.
5. High Availability and Replication:
- Set up and manage high availability (HA) solutions, including clustering, replication (master-slave, master-master), and failover mechanisms.
- Manage distributed database environments with large-scale replication architectures.
6. Automation and Scripting:
- Develop and maintain scripts to automate database management tasks, such as backups, health checks, and monitoring.
- Leverage automation tools to streamline database operations and reduce manual intervention.
7. Database Design and Architecture:
- Collaborate with development teams to design scalable and efficient database schemas.
- Evaluate and recommend new database technologies and architectures to meet business needs.
8. Monitoring and Reporting:
- Implement monitoring tools and alerting systems to track database health, performance, and resource utilization.
- Provide regular reporting on database status, capacity planning, and future needs.
9. Troubleshooting and Support:
- Provide on-call support for critical production systems.
- Lead root cause analysis for database-related incidents and implement long-term fixes.
10. Mentoring and Training:
- Mentor junior DBAs and provide training on database best practices.
- Share knowledge and conduct regular database training sessions for development and operations teams.
Required Qualifications:
- Certification: MySQL Database Administration Certification (e.g., Oracle Certified MySQL Database Administrator)
- Experience: 5+ years of hands-on MySQL DBA experience in large-scale production environments.
- Expertise in MySQL: Strong knowledge of MySQL architecture, replication, clustering, and advanced database features.
- Performance Tuning: Proven experience with query optimization, indexing strategies, and database performance tuning.
- Scripting: Proficiency in automation scripting using Bash, Python, or similar languages.
- Backup & Recovery: Strong knowledge of backup and recovery techniques and disaster recovery planning.
- Security: Experience implementing database security and encryption practices.
- Tools: Familiarity with MySQL Workbench, Percona, Nagios, or other database monitoring tools.
Preferred Qualifications:
- Experience with cloud databases (e.g. Azure Database for MySQL, AWS RDS or Google Cloud SQL).
- Knowledge of other database systems (e.g. SingleStore, SQL Server, PostgreSQL, MongoDB).
- Familiarity with containerized databases (e.g. Kubernetes, Docker).
Key Competencies:
- Strong problem-solving skills and attention to detail.
- Ability to work independently and in a team environment.
- Excellent communication skills to collaborate with developers, engineers, and business stakeholders.
- Ability to prioritize tasks in a fast-paced, dynamic environment.
This job description provides an overview of the key responsibilities and qualifications required for a Senior MySQL DBA role, ensuring candidates possess both the technical and leadership skills necessary for managing complex database environments.
