Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Prepare documentations and specifications Handle common database procedures, such as upgrade, backup, recovery, migration, etc Profile server resource usage, optimise and tweak as necessary Collaborate with other team members and stakeholders
Requirements
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 Knowledge of de-facto standards and best practices in MySQL Proficient in writing and optimising SQL statements Knowledge of advanced MySQL features 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 SVN Skills:- DBA, MySQL DBA, MySQL, NOSQL Databases, Linux administration and Shell Scripting
