Responsibilities
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