Posted:2 days ago|
Platform:
On-site
Part Time
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.
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.
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.
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.
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.
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.
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).
Lenskart
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Instantly access job listings, apply easily, and track applications.
Practice Python coding challenges to boost your skills
Start Practicing Python Now
gurugram, haryana, india
Salary: Not disclosed
5.004 - 6.21 Lacs P.A.
gurugram, haryana, india
Salary: Not disclosed
5.004 - 6.21 Lacs P.A.
gurugram, haryana, india
Salary: Not disclosed
