Ensure all MySQL databases and processes follow best practices and fit into the strategy Initially perform, and longer term provide oversight for all MySQL database administration including installation, configuration, replication, backups, and performance tuning Drive best practices in monitoring MySQL databases with the ability to identify key performance indicators and put facilities in place to alarm on-call personnel for actionable events Create, maintain and update maintenance scripts for MySQL databases.
Having good knowledge of Linux environment Focused in the Database Administration and development activities of databases.
Performing monitoring, Diagnostic of database problems.
Support of daily operations including job monitoring and troubleshooting the databases and issue fixings MySQL Database Maintenance and Repair Backup policies,Scheduled cycles,Backing up individual tables,Direct copying methods ,Database replication (live and off-line copying) Maintaining MySQL Log Files and Data Directory Monitor long running transactions and have the ability to optimize query executions with index tuning.
Develop, manage, maintain and test backup and recovery plans