DataOps / Database Reliability Engineer

The Role We are looking for a highcaliber 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 handson, impactdriven, and aligned with toptier 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 missioncritical 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 InfrastructureasCode (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 oncall 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 hightraffic, consumerfacing 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

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