Senior Database Administrator

Senior Database Administrator (MySQL & Mongo DB)

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.

Requirements

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.

Preferred Qualifications (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).

Experience Level

Mid Level