Database Administrator (MySQL)

Job description

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.