1. Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation and upgrade.
2. MySQL user management activities like user creation, grant/revoke privileges etc.
3. Implemented MySQL Replication methods MASTER-SLAVE, MASTER-MASTER, Daisy Chain replication setups for HA.
4. Scripted & deployed Shell Scripts for various MySQL Day to Day monitoring areas for automation.
5. Backup and Recovery planning & maintenance of MySQL Database servers.
6. Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.