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 workplace.
- 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).

📌 Senior Database Administrator (MySQL & MongoDB) (Gurugram)
🏢 Lenskart
📍 Gurugram