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.
Collaboration & Incident Response
● 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.
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 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.
Why Lenskart
● 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.
Skills Required
- Deep expertise in MySQL
- Deep expertise in MongoDB
- Experience with HA/DR, replication, and performance tuning
- Infrastructure as Code using Terraform
- Proficiency in Python, Bash, or JavaScript for automation
- Strong foundations in Linux/Unix, networking (DNS, TCP/IP), distributed systems
- Backup and recovery tooling (XtraBackup, mysqldump/mysqlpump, mongodump, Ops Manager, MSSQL native tools)
- Experience building and operating CDC pipelines with Debezium
- CI/CD integration experience (Jenkins, GitLab CI, GitHub Actions)
- Observability and monitoring (PMM, Prometheus, Grafana, Datadog, Alertmanager)
- Incident management experience (PagerDuty or equivalent) and on-call participation
- Configuration/automation tooling (Ansible/Chef)
- Working knowledge of PostgreSQL, Redis, Elasticsearch, Cassandra, BigQuery
- Experience with managed DB services (AWS RDS/Aurora, MongoDB Atlas, BigQuery)
- Relevant DB certifications (MongoDB Certified DBA, Oracle MySQL DBA, MSSQL certifications)
- Strong written communication (design docs, RFCs, runbooks)
What We Do
Lenskart is Asia’s largest eyewear company serving 40 Million people - helping them see better and lead better quality lives. We have more than 1500 omnichannel stores across 175 cities in India, Singapore and Dubai. Our aim is to serve One Billion eyes by 2025 globally. And in this journey, we want to go beyond vision correction to transform the way people see and experience the world. That’s our new purpose - and we can only get there through cutting-edge technology and exceptional people.
