Database Administrator (MySQL)

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.

● 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.

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

● 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.

● 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.

● 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.

● 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 as Code using Terraform (required).

● Configuration and automation using Ansible/Chef (preferred).

● CI/CD integration with Jenkins, GitLab CI, GitHub Actions.

● Metrics and alerting: PMM, Prometheus, Grafana, Alertmanager.

● Tracing/APM: Datadog, New Relic, OpenTelemetry.

● Incident management experience (PagerDuty or equivalent).

● 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.

● 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.