Database Reliability Engineer - MySQL/MongoDB

About Lenskart :

Lenskart builds large-scale, technology-first consumer platforms that serve millions of customers across geographies. Our engineering systems power real-time commerce, supply-chain intelligence, manufacturing automation, and omnichannel experiences all at scale. The DataOps function exists to ensure our data platforms are reliable by design, scalable by default, and invisible to the end user.

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 held to 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 and cloud transitions to AWS RDS / Aurora, MongoDB Atlas, and 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.

• Diagnose and resolve bottlenecks across CPU, memory, and I/O.

• Implement advanced monitoring and alerting (PMM, Ops Manager, Grafana, Datadog).

Operational Excellence & Automation :

• Automate backup and recovery (XtraBackup, mysqldump / mysqlpump, Ops Manager, filesystem snapshots, MSSQL native tools).

• Champion Infrastructure-as-Code with Terraform, Ansible, and Kubernetes Operators.

• Build Change Data Capture (CDC) pipelines using Debezium and integrate them with downstream systems.

• Enforce strong security : authentication, authorization, encryption, and auditing.

• Conduct DR drills and capacity planning, and maintain clear documentation and runbooks.

• Continuously reduce operational toil through automation and engineering solutions.

Collaboration & Incident Response :

• Partner with DevOps / SRE teams to integrate database operations into CI/CD pipelines.

• Mentor engineers on database best practices.