About this role
- Provision MySQL instances, both in clustered and non-clustered configurations - Ensure the performance, security, and availability of databases - Perform database administration tasks, including automation, performance monitoring, and tuning, and query optimization. - Prepare documentations and specifications - Handle common database procedures, such as upgrade, backup, recovery, migration, etc. - Profile server resource usage, optimize and tweak as necessary - Collaborate with other team members and stakeholders
- Strong proficiency in MySQL database management - Decent experience with recent versions of MySQL -Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM - Experience with replication configuration in MySQL(Master-slave, Master-Master) - Create and Manage MySQL users with proper permissions. - Proficient in writing and optimizing SQL statements. - Automate day to day regular tasks. - Strong knowledge in MySQL Binlog and point in time recovery. - Decent experience in Linux Administration. - Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
Good to have:
- Knowledge on NoSQL - Knowledge on Cassandra, MongoDB and ElasticSearch - Knowledge on public cloud platform like AWS/Azure/GCP). - Python/Shell scripting. - Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. - Proficient understanding of code versioning tools such as Git / Mercurial / SVN