Tekion looking for Associate Database Engineer
Experience Needed: 1-3 Years
Key Roles & Responsibilities:
Maintain database systems, ensuring best practice processes are followed and service levels are met.
Hands-on experience with MongoDB database & collections commands, Mongo shell methods, user, role, replication and shard methods, and MongoDB admin commands.
Support MongoDB, MySQL and PostgreSQL databases
maintain database structures, ensure optimal designs and coding practices are followed.
Upgrades of MongoDB, Database Migrations and Updates, and application of database patches.
Develop and implement Defragmentation strategies and Index rebuilds.
Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable.
Data integration with other databases (MongoDB and MySQL).
Fine-tune the configurations – mongo dB and servers for performance improvement.
Support Automation for Configuration and management
Experience with databases like MongoDB, or any NoSQL databases
NoSQL – MongoDB setup with replication, Data Mapping, ReIndexing, Index and cluster health management DB Queries, aggregations
Good understanding of DB schema design, performance tuning and capacity planning
Troubleshoot any problems that may come up with the database environments: performance issues, replication issues, or operational issues.
Establish and maintain backup, restore and recovery processes.Implement and maintain MongoDB OPS Manager/Cloud Manager
Understand and Optimize query performance
Comfortable in using MongoDB tools like mongostat, mongotop, mongoexport, mongoimport, mongodump, mongorestore etc
Experience with SQL and Pl/SQL development experience with MySQL and PostgreSQL databases.
1- 3 Years of experience should be good.
MongoDB Certified DBA Associate preferred
Good at SQL and PL/SQL skills
Expert level knowledge in Python scripting /shell scripting
Hands-on experience with Linux commands
Having experience with MySQL/ MongoDB/PostgreSQL / Oracle will be plus
Having experience with DevOps automation tools such as Jenkins, Ansible will be plus
Good communication candidates.