Senior Database Administrator (MySQL & MongoDB)

Lenskart; Gurugram District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Lenskart seeks an experienced DBA to design, implement, and maintain highly available and disaster-ready data platforms for MySQL and MongoDB. You will lead complex migrations, define standards, and collaborate with developers on optimal data models.

The role emphasizes performance optimization, security, and automation across SQL and NoSQL environments, with a strong focus on IaC and monitoring. Based in Gurugram, India, with opportunities for cloud integration.

Qualifications

• 5+ years of DBA experience with MySQL and MongoDB.
• Expert knowledge of InnoDB internals, replication, and high availability.
• Deep understanding of replication, sharding, aggregation, and diagnostics.
• Experience with HA/DR setups for MySQL and MongoDB.
• Experience with managed DB services and cloud migrations.

Responsibilities

• Architect, implement, and maintain HA/DR for MySQL and MongoDB.
• Lead migration projects including upgrades and cloud migrations.
• Design and enforce database standards, policies, and best practices.
• Collaborate with development teams on data storage solutions and schema design.
• Perform advanced performance tuning for MySQL and MongoDB.
• Analyze bottlenecks in memory, I/O, and CPU; monitor using PMM/Grafana/Datadog.
• Automate backup/recovery strategies and IaC for provisioning (Ansible, Terraform, Kubernetes).
• Enforce security policies (auth, authorization, encryption, auditing).
• Create and maintain runbooks and architecture documentation.

Skills

Scripting for automation

Linux/Unix administration

Analytical thinking

Leadership & communication

Multi-tasking

Automation mindset

Tools

Percona Monitoring and Management (PMM)

MongoDB Ops Manager

Grafana

Datadog

XtraBackup

mongodump/mongorestore

Job description

Role & responsibilities

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