MySQL DBA

AlphaPoint; Ciudad de México; A distancia; MXN 700,000 - 900,000; Jornada completa

Descripción de la vacante

A financial technology company is seeking a MySQL Database Administrator to own and optimize their MySQL systems. You will ensure performance and scalability while implementing clustering solutions and managing data integrity. The ideal candidate has 5+ years in database administration and strong problem-solving skills. This is a 100% remote opportunity offering the chance to work in a diverse, fast-paced environment.

Formación

• 5+ years of hands-on experience in MySQL database administration.
• Expert-level experience in designing and managing MySQL clusters.
• Comprehensive knowledge of MySQL internals and architecture.

Responsabilidades

• Architect and maintain scalable MySQL database systems.
• Drive performance tuning and optimization for MySQL.
• Develop comprehensive database documentation and best practices.

Conocimientos

MySQL database administration

Performance tuning

Database security

Collaboration

Problem-solving

Educación

Bachelor’s degree in Computer Science

Herramientas

Galera Cluster

AWS RDS for MySQL

Azure Database for MySQL

Descripción del empleo

About AlphaPoint:

AlphaPoint is a financial technology company powering digital asset exchanges and brokerages worldwide. Through its secure, scalable, and customizable white-label digital asset trading platform, AlphaPoint has enabled over 150 customers in 35 countries to launch and operate digital asset markets, as well as digitize assets. AlphaPoint and its award-winning blockchain technology have helped startups and institutions discover and execute their blockchain strategies since 2013.

THIS IS A 100% REMOTE OPPORTUNITY

PLEASE SUBMIT CV'S IN ENGLISH ONLY

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.