Job description

Tech@Lenskart-Mongo DB

Responsibilities:

• Provision MySQL instances, both in clustered and non-clustered configurations

• Ensure performance, security, and availability of databases

• Handle common database procedures, such as upgrade, backup, recovery, migration,

etc.

• Profile server resource usage, optimize and tweak as necessary.

• Should be a self-starter and able to communicate with multiple teams

Required Skills:

• Strong proficiency in MySQL 5. x database management

• Decent experience with recent versions of MySQL

• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

• Tuning of MySQL parameters

• Administration of MySQL and monitoring of performance

• Experience with master-master replication configuration in MySQL and troubleshooting replication

• Proficiency in writing complex queries, stored procedures, and triggers, event scheduler

• Strong Linux shell scripting skills

• Have strong Unix / Shell scripting skills

• Familiarity with other SQL/NoSQL databases such as MongoDB, etc. desirable.

* Install, Deploy and Manage MongoDB on Physical, Virtual, AWS EC2 instances

* Should have experience on MongoDB Active Active sharded cluster setup with high availability

* Should have experience in administering MongoDB on the Linux platform

* Experience on MongoDB version upgrade, preferably from version 4.0 to 4.4, on a production environment with a zero or very minimum application downtime, either with ops manager or custom script

* Good understanding and experience with MongoDB sharding and Disaster Recovery plan

* Knowledge of Cloud technologies is an added advantage

Job requirements

Strong proficiency in MySQL 5. x database management

• Decent experience with recent versions of MySQL

• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

• Tuning of MySQL parameters

• Administration of MySQL and monitoring of performance

• Experience with master-master replication configuration in MySQL and troubleshooting replication

• Proficiency in writing complex queries, stored procedures, and triggers, event scheduler

• Strong Linux shell scripting skills

• Have strong Unix / Shell scripting skills

• Familiarity with other SQL/NoSQL databases such as MongoDB, etc. desirable.

* Install, Deploy and Manage MongoDB on Physical, Virtual, AWS EC2 instances

* Should have experience on MongoDB Active Active sharded cluster setup with high availability

* Should have experience in administering MongoDB on the Linux platform

* Experience on MongoDB version upgrade, preferably from version 4.0 to 4.4, on a

production environment with a zero or very minimum application downtime, either with ops manager or custom script

* Good understanding and experience with MongoDB sharding and Disaster Recovery plan

* Knowledge of Cloud technologies is an added advantage