Job description
The Role We are looking for a high‐caliber DataOps / Database Reliability Engineer who brings robust 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 solid security: authentication, authorization, encryption, auditing.
● Conduct DR drills, capacity planning, and maintain explicit 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.
● Particip

📌 Database Administrator Gurugram
🏢 Lenskart
📍 Gurugram