Database Administrator

About this role:

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.