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 firms 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

• Bachelors 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.

• Competitive salary
• Unlimited PTO
• Computer equipment and workplace furniture to suit your needs
• Great colleagues and an inspiring startup environment with colleagues internationally