MySQL Database Administrator (DBA)

Job Description

Role Overview We seek an experienced MySQL DBA L3 to manage and optimize our Database-as-a-service (DBaaS) environment. You will ensure the high availability, performance, and security of MySQL databases across cloud platforms (AWS, Azure, GCP). This role involves solving complex issues, automation, and mentoring junior teams, with a focus on innovation in a multi-tenant DBaaS ecosystem. Key Responsibilities - DBaaS Management: Deploy, scale, and monitor MySQL instances in cloud environments (e.g., AWS RDS, Aurora). - Performance Tuning: Optimize queries, indexing, and configuration; use tools like Performance Schema and Percona Toolkit. - High Availability: Implement replication, clustering (InnoDB Cluster, Galera), and failover strategies. - Disaster Recovery: Design backups (physical/logical), point-in-time recovery, and DR drills. - Security & Compliance: Enforce encryption, access controls, auditing, and compliance (GDPR, HIPAA). - Automation: Script tasks (Shell/Python) and automate workflows via Ansible, Terraform, or CI/CD pipelines. - 24/7 Support: Participate in on-call rotations for critical incident resolution. - Mentorship: Guide L1/L2 DBAs and document best practices. - Innovation:Evaluate new MySQL features (e.g., MySQL 8.0+ enhancements) and cloud-native services. - Cost & Capacity Planning: Optimize resource utilization and forecast scaling needs. Qualifications Education:Bachelor s in Computer Science or related field. Experience: 10+ years as MySQL DBA, including 4+ years in DBaaS/cloud environments. Technical Skills: - Expertise in MySQL architecture, InnoDB, and replication. - Cloud platforms (AWS, Azure, GCP) and managed services (Aurora, Cloud SQL). - Scripting (Python/Shell) and IaC tools (Terraform, Ansible). - Monitoring tools (Prometheus, Grafana, Nagios). - ProxySQL, Orchestrator, or similar middleware. Soft Skills: - Strong problem-solving, communication, and collaboration abilities. -Certifications (Preferred): Oracle MySQL Professional, AWS Certified DBA, or Azure DB Administrator. Preferred Skills - Multi-tenant DBaaS architecture experience. - Familiarity with PostgreSQL,Oracle or distributed databases. - Containerization (Docker, Kubernetes) and serverless databases. - Knowledge of DevOps practices and CI/CD pipelines.