11 months ago
Gurgaon, IndiaStaff+
Responsibilities
- Architect and operate highly available MySQL, MongoDB, MSSQL, and BigQuery environments.
- Lead database migrations, including version upgrades and transitions to AWS RDS/Aurora, MongoDB Atlas, and BigQuery.
- Define database standards, schema-design practices, governance policies, and reliability objectives.
- Optimize queries, indexes, workloads, InnoDB internals, shard keys, working sets, and query execution plans.
- Implement monitoring, alerting, backup and recovery, infrastructure automation, and change-data-capture pipelines.
- Conduct disaster-recovery drills, capacity planning, documentation, and runbook maintenance.
- Partner with DevOps, SRE, product, and platform teams to integrate database operations into CI/CD and system design.
- Lead incident response, participate in on-call rotations, write root-cause analyses, and mentor engineers on database practices.
Requirements
- Deep expertise in MySQL and MongoDB, including high-availability, disaster-recovery, replication, and performance tuning.
- Experience with MSSQL, BigQuery, PostgreSQL, Redis, Elasticsearch, Cassandra, and Debezium-based change-data-capture pipelines.
- Proficiency in Linux/Unix, networking fundamentals, distributed systems, and Python, Bash, or JavaScript automation.
- Strong software engineering discipline, clean Git practices, and experience building operational tooling.
- Required experience with Terraform; Ansible or Chef experience is preferred.
- Experience integrating database operations with Jenkins, GitLab CI, or GitHub Actions.
- Experience with PMM, Prometheus, Grafana, Alertmanager, Datadog, New Relic, OpenTelemetry, and PagerDuty or an equivalent incident-management tool.
- Experience with managed database services, high-traffic consumer systems, cloud security, or DevSecOps is desirable.
- Relevant MongoDB, Oracle MySQL, or MSSQL certifications and strong technical writing skills are preferred.
Benefits
- Real-world scale and 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.
Tech Stack
AnsibleApache CassandraAWSBashDatadogElasticsearchGitGitHub ActionsGitLab CI/CDGoogle BigQueryGrafanaJavaScriptJenkinsKubernetesLinuxMicrosoft SQL ServerMongoDBMySQLPostgreSQLPrometheusPythonRedisTerraform
Categories
About Lenskart
Lenskart sells prescription eyeglasses, sunglasses, and contact lenses through an omnichannel model—e-commerce apps plus company-owned and franchised retail stores. It designs and manufactures eyewear and provides eye tests and fitting services for consumers across India and select international markets, including Singapore and the Middle East. Founded in 2008 and headquartered in Gurgaon, it is privately held.