Opportunity brief
Lenskart is hiring for the role of Lead Database Administrator!
Responsibilities of the Candidate:
- Optimise queries, indexes, and workloads using advanced profiling tools across MySQL, MongoDB, MSSQL, and BigQuery.
- Resolve bottlenecks across CPU, memory, and I/O.
- Work closely with product and platform teams to influence system design through the lens of scale, resilience, and cost
- Architect and operate highly available MySQL (InnoDB Cluster, Group Replication), MongoDB (Replica Sets, Sharded Clusters), MSSQL, and BigQuery environments. - Conduct DR drills, capacity planning, and maintain clear documentation/runbooks.
Requirements:
- 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. - 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 as Code using Terraform (required). - Configuration and automation using Ansible/Chef (preferred). - CI/CD integration with Jenkins, GitLab CI, GitHub Actions.