MYSQL ADMIN

• 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 optimize operational and technical streams.
• Automate the daily task using Cron-Job, Powershell, Task Manager etc.
• Sound knowledge (Access Control, Incident Management, Capacity Management, Problemen Management, Release Mangement, Change Management, Service Management.
• Support Database on AWS, Azure or Goole Cloud (IaaS / PaaS)
• Worked on Database migration from On-prime to cloud.
• Expertise in Database cluster deployment and Managmenet.
• "Estimate MySQL database capacities; develop methods for monitoring database capacity and usage."

Required Skills :

• MySQL Server DBA, MySQL Server on Azure, High Availability, Backup, Performacne Tuning  

Additional Info:

• We need MySQL (not MSSQL) as Primary skills - L3 level . (Expert)
• Need Oracle as secondary  – L2 Level