● 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.