Database Administrator

Tech@Lenskart- DevOps-Mongo DB Responsibilities:

1. Provision MySQL instances, both in clustered and non-clustered configurations
2. Ensure performance, security, and availability of databases
3. Handle common database procedures, such as upgrade, backup, recovery, migration, etc
4. Profile server resource usage, optimize and tweak as necessary.
5. Should be a self-starter and able to communicate with multiple teams.

Required Skills:

1. Strong proficiency in MySQL 5. x database management
2. Decent experience with recent versions of MySQL • Understanding of MySQLs underlying storage engines, such as InnoDB and MyISAM
3. Tuning of MySQL parameters • Administration of MySQL and monitoring of performance
4. Experience with master-master replication configuration in MySQL and troubleshooting replication
5. Proficiency in writing complex queries, stored procedures, and triggers, event scheduler
6. Strong Linux shell scripting skills • Have strong Unix / Shell scripting skills • Familiarity with other SQL/NoSQL databases such as MongoDB, etc. desirable.
7. Install, Deploy and Manage MongoDB on Physical, Virtual, AWS EC2 instances
8. Should have experience on MongoDB Active Active sharded cluster setup with high availability * Should have experience in administering MongoDB on the Linux platform
9. 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
10. Good understanding and experience with MongoDB sharding and Disaster Recovery plan
11. Knowledge of Cloud technologies is an added advantage