Senior Cloud Database Administrator – MySQL, AWS RDS, Aurora

This is a fully remote position, open to applicants in Mexico, +4 more countries.

📋 Description

• Manage and enhance MySQL/InnoDB databases hosted on AWS RDS and Aurora MySQL, encompassing provisioning, scaling, patching, upgrades, and decommissioning activities.

• Diagnose intricate production challenges such as slow queries, replication delays, locking issues, deadlocks, and resource contention.

• Optimize performance via execution plan assessment, query and index enhancement, and InnoDB configuration adjustments.

• Develop and uphold backup, restore, Point-in-Time Recovery (PITR), and disaster recovery strategies that align with specified Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs).

• Facilitate high availability by utilizing Aurora clusters, Multi-AZ deployments, read replicas, and automated failover mechanisms.

• Oversee health, performance, and capacity metrics through CloudWatch and Performance Insights/Database Insights, while proposing right-sizing recommendations.

• Automate DBA tasks and create self-service functionalities employing Python, Bash, SQL, AWS CLI, and Infrastructure as Code when relevant.

• Establish secure, least-privilege configurations, which include IAM, encryption, and credential management, while supporting audits and compliance efforts.

• Engage in on-call duties and incident response, including conducting root cause analyses.

• Collaborate within an Agile/Scrum framework and maintain runbooks, documentation, and database standards.

⛳️ Requirements

• Over 10 years of experience in Database Administration, Database Engineering, or Database Reliability Engineering.

• Extensive practical experience with MySQL and a profound understanding of InnoDB internals (transactions, locking, deadlocks, buffer pool, redo/undo logs, crash recovery).

• Strong hands-on experience managing MySQL on AWS RDS and/or Aurora MySQL.

• Demonstrated skills in performance tuning, query optimization, and troubleshooting.

• Significant experience with backups, restores, PITR, disaster recovery, and high availability solutions (Multi-AZ, read replicas, Aurora failover).

• Practical knowledge of using CloudWatch and Performance Insights/Database Insights.

• Proficient scripting and automation capabilities (Python, Bash, SQL, AWS CLI, or similar tools).

• Comprehensive understanding of AWS security protocols (IAM, encryption, access controls).

• Experience working in Agile teams, complemented by strong communication and documentation abilities.

• Preferred qualifications include: Terraform or CloudFormation; AWS Lambda, Systems Manager, or EventBridge; PostgreSQL; Kubernetes/EKS; CI/CD; experience in regulated environments; AWS cost optimization; and developing self-service database platforms.

🏝️ Benefits

• Experience a vibrant, inclusive, and innovative culture that appreciates your individual contributions and fosters your professional development.

• Daily opportunities for learning, innovation, and excellence.

• Opportunities for career advancement and access to resources.

• A high-energy, engaging work atmosphere.

• Flexibility to work from home or any location of your preference.

• A healthy work-life balance with no stressful commuting.