● Administration and management of the entire development, QA and production

environment.

● Installed and configured MySQL on Linux environments.

● Managing/Troubleshooting MySQL 5.7.26 in production and developer environments on Linux.

● Performed installation, new databases design, configuration, backup & recovery, security, upgrade and schema

changes, tuning and data integrity.

● Increased database performance by utilizing MySQL configuration changes, multiple instances.

● Ensured production data being replicated without any data anomalies from the processing databases.

● Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL

Enterprise Monitor.

● Performing optimization, Analyze, repair on tables.

● Table refreshes from one environment to another environment.

● User management like IP level restrictions, password management, connection level restriction.

● Performing mysqldump and MEB be based on the situation.

● Altering tables based on the application team.

● Automating regular tasks by using shell script and scheduling in crontab.

● Upgradation of MySQL from one version to another version.

● Performing optimization to release space chunks from OS level.

● Working on change requests in the prescribed time window.

● Performing the DC to DR switchover.

● Set the password less connectivity between the servers.