Lead Database Administrator (MySQL)
- Location Bangalore
- Experience ~5-10 yrs
- Job type Full-time
- Posted 13 Oct 2026
You will be taken to Lenskart’s own careers page to apply. Job ID 430.
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.