Roles and Responsibilities:
- Strong proficiency in MySQL / MongoDB database administration and migrations.
- Decent experience with the latest versions of MySQL 8.0
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
- In-depth experience configuring database replication on multiple versions
- Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage Analyzes and provides recommendations to optimize database
- for improved performance, manageability, and scalability
- Expertise in enterprise backups, recovery, and performing point in-time recovery
- Experience in deploying and integrating PMM tools
- Experience in data partitioning and encryption
- Knowledge of de-facto standards and best practices in MySQL and MongoDB
- Proficient in writing and optimizing SQL statements
- Knowledge of MySQL features, such as its event scheduler
- Ability to plan resource requirements from high level specifications
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
- Proficient understanding of code versioning tools such as Git / Mercurial / SVN
Qualifications and Education Requirements:
B.E/B.Tech/M.E/M.Tech/MCA