Roles Responsibilities:
Database Architecture & Strategy
- Architect, implement, and maintain highly available (HA) and disaster recovery (DR) solutions for MySQL (InnoDB Cluster, Group Replication) and MongoDB (Replica Sets, Sharded Clusters).
- Lead complex database migration projects, including version upgrades, cloud migrations (AWS RDS/Aurora, MongoDB Atlas), and database technology evaluations.
- Design and enforce database standards, policies, and best practices for SQL and NoSQL environments.
- Collaborate with development teams to advise on optimal data storage solutions (relational vs. document models) and schema design.
Performance Engineering & Optimization
- Perform advanced performance tuning across both database technologies:
- MySQL: Query optimization using EXPLAIN, index management, InnoDB buffer pool tuning.
- MongoDB: Query profiling using explain(), index strategy, shard key selection and optimization, working set analysis.
- Analyze and resolve performance bottlenecks related to memory, I/O, and CPU.
- Implement and manage advanced monitoring, alerting, and trend analysis using tools such as Percona Monitoring and Management (PMM), MongoDB Ops Manager, Grafana, and Datadog.
Operational Excellence & Automation
- Develop and automate robust backup and recovery strategies:
- MySQL: Percona XtraBackup and/or native tools.
- MongoDB: mongodump/mongorestore, Ops Manager, or filesystem snapshots.
- Champion Infrastructure as Code (IaC) for database provisioning and management using Ansible, Terraform, and Kubernetes Operators.
- Establish and enforce strong security controls, including authentication, authorization, encryption, and auditing.
- Create and maintain comprehensive documentation covering architecture, procedures, and runbooks.
Leadership & Collaboration
- Mentor junior DBAs and developers on database best practices.
- Serve as the final escalation point for critical database incidents and participate in a 24/7 on-call rotation.
- Lead post-incident reviews and drive implementation of preventative measures.
- Partner with DevOps and SRE teams to integrate database operations into CI/CD pipelines.
Required Qualifications & Skills
- 5+ years of professional DBA experience with strong hands-on expertise in MySQL (5.7/8.0+) and MongoDB (4.4+).
- MySQL: Expert knowledge of InnoDB internals, replication, performance tuning, and high-availability solutions (Group Replication, InnoDB Cluster).
- MongoDB: Deep understanding of replication, sharding, aggregation framework, and performance diagnostics.
Must-Have Technical Skills
- Proven experience designing and supporting HA/DR architectures (MySQL Replication/Group Replication, MongoDB Replica Sets)
- Expertise in backup and recovery tools (Percona XtraBackup for MySQL, Ops Manager or mongodump for MongoDB)
- Strong scripting and automation skills (Python, Bash, JavaScript for MongoDB)
- Proficiency in Linux/Unix systems administration
(Nice-to-Have)
- Experience with managed database services (AWS RDS, Google Cloud SQL, MongoDB Atlas)
- Exposure to additional data technologies (PostgreSQL, Redis, Elasticsearch, Cassandra)
- Knowledge of DevOps practices and CI/CD tools (Jenkins, GitLab, CI)
- Experience with containerization and orchestration (Docker, Kubernetes), particularly for stateful workloads)
- Relevant certifications (MongoDB Certified DBA, Oracle MySQL Database Administrator)
