Senior Database Administrator (MySQL & Mongo DB) at Lenskart

Gurugram, haryana, India -

Full Time

Start Date

Immediate

Expiry Date

28 Mar, 26

Salary

0.0

Posted On

28 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

MySQL, MongoDB, Database Architecture, Disaster Recovery, Performance Tuning, Automation, Backup Strategies, Security Controls, Scripting, Cloud Migrations, Monitoring Tools, Infrastructure as Code, Replication, Sharding, Documentation, Mentoring

Industry

technology;Information and Internet

Description

Database Architecture & Strategy Architect, implement, and maintain highly available (HA) and disaster recovery (DR) solutions for MySQL (InnoDB Cluster, Group Replication) and MongoDB (Replica Sets, Sharded Clusters). Lead complex database migration projects, including version upgrades, cloud migrations (AWS RDS/Aurora, MongoDB Atlas), and database technology evaluations. Design and enforce database standards, policies, and best practices for SQL and NoSQL environments. Collaborate with development teams to advise on optimal data storage solutions (relational vs. document models) and schema design. Performance Engineering & Optimization Perform advanced performance tuning across both database technologies: MySQL: Query optimization using EXPLAIN, index management, InnoDB buffer pool tuning. MongoDB: Query profiling using explain(), index strategy, shard key selection and optimization, working set analysis. Analyze and resolve performance bottlenecks related to memory, I/O, and CPU. Implement and manage advanced monitoring, alerting, and trend analysis using tools such as Percona Monitoring and Management (PMM), MongoDB Ops Manager, Grafana, and Datadog. Operational Excellence & Automation Develop and automate robust backup and recovery strategies: MySQL: Percona XtraBackup and/or native tools. MongoDB: mongodump/mongorestore, Ops Manager, or filesystem snapshots. Champion Infrastructure as Code (IaC) for database provisioning and management using Ansible, Terraform, and Kubernetes Operators. Establish and enforce strong security controls, including authentication, authorization, encryption, and auditing. Create and maintain comprehensive documentation covering architecture, procedures, and runbooks. Leadership & Collaboration Mentor junior DBAs and developers on database best practices. Serve as the final escalation point for critical database incidents and participate in a 24/7 on-call rotation. Lead post-incident reviews and drive implementation of preventative measures. Partner with DevOps and SRE teams to integrate database operations into CI/CD pipelines. Required Qualifications & Skills 5+ years of professional DBA experience with strong hands-on expertise in MySQL (5.7/8.0+) and MongoDB (4.4+). MySQL: Expert knowledge of InnoDB internals, replication, performance tuning, and high-availability solutions (Group Replication, InnoDB Cluster). MongoDB: Deep understanding of replication, sharding, aggregation framework, and performance diagnostics. Must-Have Technical Skills Proven experience designing and supporting HA/DR architectures (MySQL Replication/Group Replication, MongoDB Replica Sets). Expertise in backup and recovery tools (Percona XtraBackup for MySQL, Ops Manager or mongodump for MongoDB). Strong scripting and automation skills (Python, Bash, JavaScript for MongoDB). Proficiency in Linux/Unix systems administration. Preferred Qualifications (Nice-to-Have) Experience with managed database services (AWS RDS, Google Cloud SQL, MongoDB Atlas). Exposure to additional data technologies (PostgreSQL, Redis, Elasticsearch, Cassandra). Knowledge of DevOps practices and CI/CD tools (Jenkins, GitLab CI). Experience with containerization and orchestration (Docker, Kubernetes), particularly for stateful workloads. Relevant certifications (MongoDB Certified DBA, Oracle MySQL Database Administrator).

Responsibilities

The Senior Database Administrator will architect, implement, and maintain highly available and disaster recovery solutions for MySQL and MongoDB. They will also lead complex database migration projects and collaborate with development teams on optimal data storage solutions.