Senior Database Administrator (MySQL & MongoDB)

Role & responsibilities

Database Architecture & Strategy:

• Architect, implement, and maintain highly available (HA) and disaster recovery (DR) solutions for both MySQL (InnoDB Cluster, Group Replication) and MongoDB (Replica Sets, Sharded Clusters).
• Lead complex database migration projects, including version upgrades, cloud migrations (e.g., to AWS RDS/Aurora, Atlas), and database technology evaluations.
• Design and enforce database standards, policies, and best practices for both SQL and NoSQL environments.
• Collaborate with development teams to advise on optimal data storage solutions (relational vs. document model) and schema design.

Performance Engineering & Optimization:

• Perform advanced performance tuning for both 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 for both database platforms.

• Implement and manage advanced monitoring, alerting, and trending for the entire database stack using tools like Percona Monitoring and Management (PMM), MongoDB Ops Manager, Grafana, or Datadog.

• Operational Excellence & Automation:

• Develop and automate robust backup and recovery strategies:

• MySQL: Using XtraBackup and/or native tools.

• MongoDB: Using mongodump/mongorestore, Ops Manager, or filesystem snapshots.

• Champion Infrastructure as Code (IaC) for database provisioning and management using tools like Ansible, Terraform, or Kubernetes Operators.

• Establish and enforce stringent security policies for both databases, including authentication, authorization, encryption, and auditing.

• Create and maintain comprehensive documentation for architecture, procedures, and runbooks.

Preferred candidate profile

• 5+ years of professional experience as a DBA, with significant hands-on experience in both MySQL (5.7/8.0+) and MongoDB (4.4+)
• For MySQL: Expert knowledge of InnoDB internals, replication, performance tuning, and high-availability solutions (Group Replication, InnoDB Cluster).
• For MongoDB: Deep understanding of replication, sharding, aggregation framework, and performance diagnostics.

Must-Have Technical Skills:

• Proven experience implementing and supporting HA/DR setups for both technologies (MySQL Replication/Group Replication, MongoDB Replica Sets).
• Expertise in backup and recovery tools (Percona XtraBackup for MySQL, Ops Manager/mongodump for MongoDB).
• Strong scripting skills for automation (e.g., Python, Bash, JavaScript for MongoDB scripts).
• Proficient with Linux/Unix systems administration.

Essential Soft Skills:

• Exceptional analytical and problem-solving skills.
• Strong project leadership and communication skills.
• Ability to manage multiple priorities in a fast-paced environment.
• A proactive, automation-first mindset.

Qualifications (Good-to-Have)

• Experience with managed database services (AWS , Google Cloud SQL, MongoDB Atlas).
• Experience with other data technologies (e.g., PostgreSQL, Redis, Elasticsearch, Cassandra).
• Knowledge of DevOps practices and CI/CD tools (Jenkins, GitLab CI).
  Experience with containerization and orchestration (Docker, Kubernetes), especially with running stateful services.
• Relevant certifications (e.g., MongoDB Certified DBA, Oracle MySQL Database Administrator).