About the Role We are seeking an experienced Senior MySQL Database Administrator to join our team. As a key member of our database operations team, you will be responsible for designing, implementing, and maintaining a high-performance, scalable, and reliable MySQL database infrastructure.
This is a remote role.
Responsibilities
Database Infrastructure Management : Design, implement, and maintain a replicated and sharded database setup that ensures data consistency, availability, and performance.
Query Performance Analysis and Optimization : Monitor and review queries executed in production to identify opportunities for optimization, applying necessary techniques to improve query performance, efficiency, and overall system responsiveness.
Database High Availability and Reliability : Ensure the high availability, disaster recovery, and reliability of our database infrastructure, implementing measures to minimize downtime and ensure business continuity.
Data Pipeline Management and Data Warehousing : Manage and monitor data pipelines that populate our data warehouse, ensuring high-quality data accuracy, integrity, and timeliness. Develop and implement data warehousing strategies to meet business needs.
Documentation and Knowledge Sharing : Document database architecture and design to educate software developers on database fundamentals, best practices, and performance considerations.
Database Upgrade and Migration : Perform database upgrades and migrations, ensuring minimal disruption to production services and maintaining database integrity.
Database Security and Compliance : Ensure the security of our database systems, implementing measures to protect against data breaches, unauthorized access, and other threats. Comply with relevant regulations and industry standards for database security.
Query Review and Validation : Review new application queries created by software developers for correctness and efficiency, applying expertise to identify potential performance issues and optimize query performance.
On-Call Support and Troubleshooting : Be available on-call to troubleshoot and repair database infrastructure issues, ensuring the reliability and availability of our databases.
Database Monitoring and Management Tools : Familiarize yourself with various database monitoring tools and apply knowledge to optimize database performance, identify potential issues, and implement corrective actions.
Qualifications
8+ years of experience in MySQL/MariaDB database administration
Expert-level knowledge of MySQL/MariaDB architecture, indexing, storage engines (e.g., InnoDB), query optimization techniques, replication, load balancing, and cluster management tools.
Strong understanding of database security, access control, backup/restore procedures, and data warehousing concepts.
Experience with database monitoring tools and technologies to optimize performance, troubleshoot issues, and ensure high availability.
Nice to Have:
Experience with cloud-based MySQL deployments (e.g., AWS RDS, Google Cloud SQL) or containerization technologies (e.g., Docker)
Experience with Data warehouse platforms e.g. Redshift, Snowflake
Experience with ETL tools such as Stitch, AWS Glue
MongoDB experience
Knowledge of automation tools and scripts for database administration tasks