Job Description :
Position : MYSQL DBA
Location : Danbury, CT
Duration : 6+ months

Job Description:

1. Must to have 6-8 year experience. Qualified candidates should have experience with MySQL as well as a strong DBA background in production database administration including proficiency in installation, upgrade and configuration of Cluster and non-cluster databases.
2. This is a 24x7 Operations requirement. Candidate should be flexible to work in shift
3. Understand MySQL Architecture
4. MySQL Administrative Clients mysql, mysqladmin, mysqlimport, mysqlpdump
5. Perform the MySQL start and shutdown operations
6. Perform backup and restore operations utilizing multiple MySQL tools
7. Use stored routines and triggers for administration tasks
8. Understand data locking concepts and the different levels of locking in MySQL
9. Use the INFORMATION_SCHEMA database to access metadata
10. Install and Upgrade MySQL for the most common operating systems
11. Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
12. Improve performance through query optimization
13. Utilize MySQL monitoring tools to improve server performance
14. Evaluate data types and character sets for performance issues
15. Setting Up Master Slave Replication
16. Experience of Creating the database, tablespaces, users, data objects, and granting access privileges. Managing Physical and Logical Database Structure.
17. Hands on experience and good knowledge in performing export, import to reorganize the Database Backup & Recovery through third party or cron job
18. Practical experience in monitoring CPU Utilization, Index rebuilding, Gather Statistics, Optimizers, Hints etc.
As a Senior Administrator, you should be able to handle first point escalation for all technical and process issues. Provide technical subject matter expertise wherever required. Ensure proper communication and quick resolution as a crisis manager. Plan and schedule Changes, Coordinating with different stakeholders. Perform RCA for Major Incidents related to his / her tower Follow quality / security process defined for the engagement. Perform Trend analysis, identify top few incidents and work with respective teams/individual to minimize the incidents, Hardware troubleshooting & Vendor coordination Prepare Weekly and monthly status reports. Participate in business meetings with various stake holders on a need basis. Take corrective actions based on the customer satisfaction surveys. Work on the service improvement programs. Effort estimation/reviews on need basis for new projects. Training of new team members. Able to work on Knowledge acquisition and updates to related documents

Minimum Experience Required: 3-5 YEARS
Mandatory Skills: MS SQL Admin Database High Availability, Database Backup and Recovery, Database Admin, Database Performance Tuning, Infra Storage Administration, Infra Trouble shooting and Operations Desirable Skills: MySQL Admin, MySQL Cluster