Must have 3+ years’ experience as MySQL DBA.
Should have command line knowledge on importing and exporting the MySQL backup files.
Should have knowledge on setting up, upgrading, startup and shut down of the MySQL Database Instance.
Should have knowledge on analyzing and fine tuning the performance of the MySQL Instance.
Should have knowledge on the User Account Management and Data Archival.
Should have hands-on experience in configuring the MySQL Database Replication between Master and Slave including bin-log and GTID based replication.
Should have hands on experience in configuring the Master-Slave fail over.
Should have knowledge on comparing the data inconsistencies between MySQL Master and Slave Databases.
Should have knowledge on the Replication logging types like big-log, relay-log and log formats including row based, statement based logging and be able debug the data inconsistency using the logs.
Should have good data modelling skills and be able to create DDL and DML scripts.
Should be hands-on with LINUX.
Understand/ Participate in component design discussions and provide ideas/ suggestions to improve and implement as per design with highest code quality.
Good to have knowledge about MySQL Cluster.
Excellent verbal and written communication skills.
Experience with enterprise backup and recovery strategies.
Good scripting ability and good working knowledge of Shell Scripts, Perl or Python.
Show the full description
Familiarity with other databases such as MS SQL will be an added advantage.