MySQL DBA

MySQL Database Administrator

As a Database Administrator, you will take complete ownership of our MySQL database systems. Your primary focus will be on maximizing their performance, ensuring seamless scalability, and implementing robust clustering solutions. Your expertise will be crucial in designing, optimizing, and maintaining highly available and performant MySQL infrastructures, directly impacting our firm's operational efficiency and data integrity. You will proactively identify and resolve complex issues related to database performance and availability, ensuring our systems can handle ever-growing demands.

Objectives of this role

• Architect, implement, and maintain highly scalable and performant MySQL database systems, with a strong focus on MySQL clustering for fault tolerance and high availability.
• Drive continuous performance tuning and optimization efforts across all MySQL database instances, ensuring optimal resource utilization and lightning-fast query response times.
• Proactively monitor, identify, and resolve complex performance bottlenecks and scaling challenges within MySQL environments before they impact production, ensuring a seamless flow of information.
• Guarantee data security and integrity through the implementation of stringent access controls, robust backup strategies, and efficient disaster recovery plans for MySQL.
• Lead the execution of disaster recovery plans and procedures, ensuring minimal downtime and rapid MySQL database availability during any system outages or disruptions.

Responsibilities

• Develop and maintain comprehensive MySQL database documentation, including data standards, procedures, and definitions, with a particular focus on best practices for scaled and clustered MySQL environments.
• Collaborate closely with development teams to identify and implement database requirements for new or existing applications, specifically addressing scalability, performance, and clustering needs within MySQL from the design phase onward.
• Spearhead the evaluation, recommendation, and implementation of cutting-edge MySQL technologies and methodologies to achieve superior performance and efficiency at scale.
• Provide expert support and guidance to users and developers, resolving data-related technical issues and troubleshooting queries, emphasizing MySQL performance best practices for large-scale datasets.
• Execute regular MySQL database maintenance tasks, including database defragmentation, backups, and managing complex MySQL replication and clustering configurations.

Required skills and qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of hands-on experience in MySQL database administration, with a proven track record in high-traffic, mission-critical environments.
• Expert-level experience in designing, implementing, and managing highly available MySQL clusters (e.g., Galera Cluster, Group Replication), emphasizing fault tolerance and resilience.
• Demonstrated expertise in advanced MySQL performance optimization, tuning complex queries, and optimizing schema designs for large-scale datasets.
• Comprehensive knowledge of MySQL internals and architecture.
• Exceptional analytical and problem-solving skills, with a business-focused approach to delivering rapid and effective solutions to complex scaling and performance challenges.
• Outstanding communication and collaboration skills to work effectively in a fast-paced, team-oriented environment.

Preferred skills and qualifications

• Proficiency in scripting languages (e.g., Python, Perl) for automating complex MySQL database administration tasks, especially those related to scaling, monitoring, and cluster management.
• Extensive experience with cloud MySQL database technologies (e.g., AWS RDS for MySQL, Azure Database for MySQL, Google Cloud SQL for MySQL), including their scaling and high-availability features.
• Deep understanding of MySQL data security, backup, and recovery procedures, with experience in implementing these within distributed and clustered MySQL architectures.