Senior MySQL Database Administrator

We are seeking an experienced Senior MySQL Database Administrator to manage and optimize our large-scale, mission-critical database infrastructure. You will lead the administration, performance tuning, high-availability, and disaster recovery operations of our diverse MySQL ecosystem running across Google Cloud and AWS environments. This role requires deep expertise in Percona Server for MySQL, advanced query optimization, infrastructure-as-code, and modern DevOps practices.

Responsibilities

Manage and maintain Percona Server for MySQL (5.7, 8.0, 8.4 and later versions) across production, staging, and development environments, including multi-terabyte instances; Design and implement ProxySQL configurations for high availability, load balancing, query routing, and connection pooling at scale; Manage MySQL and PostgreSQL topology using GitHub Orchestrator, including automated failover and orchestration workflows; Design, implement, and maintain backup and disaster recovery strategies using XtraBackup, binary log replication, and point-in-time recovery (PITR) procedures; Perform comprehensive SQL query analysis and optimization using pt-query-digest, EXPLAIN analysis, and query profiling to identify bottlenecks and improve performance; Optimize and tune database performance, including InnoDB configuration, buffer pool settings, query execution plans, and index strategies for workload efficiency; Administer secondary database engines (ClickHouse, Cloud SQL, RDS MySQL, Aurora, SingleStore) and evaluate their optimal use cases within our architecture; Implement and maintain Infrastructure-as-Code using Terraform and Puppet for database infrastructure provisioning and configuration management; Architect and manage multi-region/multi-cloud database deployments across Google Cloud and AWS, balancing cost, latency, and resilience requirements; Develop and execute runbooks for common database operational procedures, incident response, and disaster recovery scenarios; Monitor database health using Percona Monitoring and Management (PMM), custom alerting, and observability tools; investigate and resolve performance degradation; Manage database access controls, user provisioning, privilege auditing, and security hardening in compliance with principle of least privilege; Conduct capacity planning and growth projections based on usage trends, workload analysis, and business requirements; Lead database upgrade initiatives, testing, planning, and execution while minimizing downtime using automated tooling and blue-green deployment strategies; Collaborate with application engineering teams to optimize data models, query patterns, and integration with database infrastructure; Mentor junior DBAs and engineers on database best practices, troubleshooting methodologies, and operational excellence

Requirements

Bachelor's degree in mathematics, statistics, economics, computer science or a related field, or relevant professional experience; Minimum 5+ years' experience as a production Database Administrator; 5+ years experience with MySQL / Percona Server 5.7, 8.x / CloudSQL / AWS RDS; Experience with ProxySQL 2.x, 3.x / Orchestrator, Percona XtraBackup; 5+ years of experience in writing Linux shell scripts, perl scripts, Python etc.; Experience with Postgres; Experience with ClickHouse or other analytical database engines; Experience managing PostgreSQL infrastructure and knowledge of database-agnostic best practices; Knowledge of database security topics: encryption at rest/in transit, authentication/authorization, audit logging; Experience with GitHub Orchestrator or similar MySQL topology orchestration tools; Previous experience mentoring DBAs or conducting technical training; Team Leader; Problem-solving mindset with ability to analyze complex, multi-layered issues systematically; Ownership mentality; comfort with being on-call and responding to critical incidents; Continuous learner; ability to stay current with rapidly evolving database technology and industry practices; Excellent written and verbal communication; ability to document decisions, procedures, and architectural choices; Collaboration across engineering teams; ability to influence without authority; Attention to detail and commitment to operational excellence and data integrity

Nice to have

Certifications (Oracle MySQL, Percona, AWS Database Specialty) are a plus but not required; Familiarity with change data capture (CDC) technologies like Debezium and streaming platforms like Kafka; Exposure to MySQL kernel source code or internal mechanisms; ClickHouse, MongoDB, SingleStore (secondary skills)

Benefits

Responsible PTO policy; Up to 12 fully covered therapy/coaching sessions per year with additional dependent coverage; Monthly gym reimbursement policy; Restricted Stock Units (RSUs) with a 3-year vesting schedule, pending Board approval; Free Coursera subscription and PXA courses; 26 weeks of fully paid parental leave for the primary caregiver and 13 weeks fully paid for the secondary caregiver; Technology stipend for home office setup; Monthly allowance to cover internet expenses