Lenskart - 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.
• 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 Were 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 and recovery expertise with XtraBackup, mongodump, Ops Manager, and MSSQL native tools.
• Working knowledge of PostgreSQL, Redis, Elasticsearch, Cassandra, and BigQuery.
• Experience building and operating CDC pipelines with Debezium.

Infrastructure & Tooling

• Required Infrastructure-as-Code using Terraform.
• Preferred configuration and automation using Ansible / Chef.
• CI/CD integration with Jenkins, GitLab CI, or 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, and runbooks. (ref:hirist.tech)