Database Administrator (MySQL)

Job Description:

Responsibilities

• 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.

Qualification & Experience

• 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.