mysql admin

5 months ago


Alpharetta, United States QData Full time
Resolving critical issues with proper analysis and share the Root cause analysis with permanent fix. Managing MySQL Server in (Development testing and production) environments. DB background includes database configuration maintenance troubleshooting and managing day to day operation activities. Provide assistance to the application team in indentifying database problems. Exposure in Database upgradation and Migration. Worked and managed clouds based databased infrastructure. Installed and configured MySQL 5.6/5.7/8.0. Database patche Deployment. Uderstanding of Windows administration / Linux administration to manage the database independenty. Extensive work on High Availabilty and Disaster Recovery Solutions includes (Replication (Master- Slave Multi-Master and Clustering). Security Management (Logins Users Database/Server Roles and Granting/revoking permissions). Have Implemented Replication in MySQL.

Expert in Performance Tuning by analyzing blocking index fragmentation execution plans native tools of MySQL Query Plan Database Tuning Advisor and Event Viewer.

Experience troubleshooting MySQL Server Cron jobs Backup compression Support for large and Complex Databases. Expert in VM ware and Cloud DB infra deployment. Database Consolidation and Solution Design for MySQL Server Database technology. Exposure in Database Audit. Assessing and auditing existing Projects for value-add and SIP to the client in terms of