Lead Database Administrator (MySQL)
Gurugram, Haryana, India
Company
Lenskart
Job Description
The Role We are looking for a high-caliber DataOps / Database Reliability Engineer who brings strong engineering fundamentals and a deep sense of ownership. You will design, build, and operate MySQL, MongoDB, MSSQL, and BigQuery platforms that enable product teams to ship quickly and safely - at scale. This role is hands-on, impact-driven, and aligned with top-tier engineering standards.
What You Will Do
Database Architecture & Reliability
? Architect and operate highly available MySQL (InnoDB Cluster, Group Replication), MongoDB (Replica Sets, Sharded
Clusters), MSSQL, and BigQuery environments.
? Lead migrations (version upgrades, cloud transitions to AWS RDS/Aurora, MongoDB Atlas, BigQuery).
? Define and enforce standards, schema design best practices, and governance policies.
? Drive SLIs, SLOs, and error budgets for mission-critical data services.
Performance Engineering
? Optimize queries, indexes, and workloads using advanced profiling tools across MySQL, MongoDB, MSSQL, and BigQuery.
? Tune InnoDB internals, buffer pools, shard keys, working sets, and query execution plans.
? Resolve bottlenecks across CPU, memory, and I/O.
? Implement advanced monitoring and alerting (PMM, Ops Manager, Grafana, Datadog).
Operational Excellence & Automation
? Automate backup/recovery (XtraBackup, mysqldump/mysqlpump, Ops Manager, filesystem snapshots, MSSQL native tools).
? Champion Infrastructure-as-Code (Terraform, Ansible, Kubernetes Operators).
? Implement Change Data Capture (CDC) pipelines using Debezium and integrate with downstream systems.
? Enforce strong security: authentication, authorization, encryption, auditing.
? Conduct DR drills, capacity planning, and maintain clear documentation/runbooks.
? Continuously reduce operational toil through automation and engineering solutions.
Collaboration & Incident Response
? Partner with DevOps/SRE teams to integrate DB ops into CI/CD pipelines.
? Mentor engineers on database best practices.
? Participate in on-call rotations, lead incident response, and write clear, blameless RCAs.
? Work closely with product and platform teams to influence system design through the lens of scale, resilience, and cost
efficiency.
What We’re Looking For
Core Engineering
? Strong foundations in Linux/Unix, networking (DNS, TCP/IP), and distributed systems.
? Proficiency in Python, Bash, or JavaScript for automation and tooling.
? Clean Git practices and strong software engineering discipline.
Databases
? Deep expertise in MySQL and MongoDB.
? Proven experience with HA/DR setups, replication, and performance tuning.
? Backup/recovery expertise with XtraBackup, mongodump, Ops Manager, MSSQL native tools.
? Working knowledge of PostgreSQL, Redis, Elasticsearch, Cassandra, and BigQuery.
? Experience building and operating CDC pipelines with Debezium.
Infrastructure & Tooling
? Infrastructure as Code using Terraform (required).
? Configuration and automation using Ansible/Chef (preferred).
? CI/CD integration with Jenkins, GitLab CI, GitHub Actions.
Observability & Reliability
? Metrics and alerting: PMM, Prometheus, Grafana, Alertmanager.
? Tracing/APM: Datadog, New Relic, OpenTelemetry.
? Incident management experience (PagerDuty or equivalent).
Nice to Have
? Experience with managed database services (AWS RDS/Aurora, MongoDB Atlas, BigQuery).
? Exposure to DevSecOps and cloud security.
? Experience operating high-traffic, consumer-facing systems.
? Relevant certifications (MongoDB Certified DBA, Oracle MySQL DBA, MSSQL certifications).
? Strong written communication (design docs, RFCs, runbooks).
What Success Looks Like at Lenskart
? Databases that are reliable, scalable, and boring in production.
? Faster delivery with fewer incidents.
? Strong developer trust in the data platform.
? Systems that scale seamlessly with business growth.
Why Lenskart
? Real-world scale with tangible customer impact.
? Strong engineering ownership and autonomy.
? Opportunity to shape data platforms used across the company.
? A culture that values craft, clarity, and engineering excellence.