Job Description:

Responsibilites:

• Database design and architecture Database servers monitoring and administration Ensure maintenance of MySQL Master/Slave & Master/Master Replication Optimize MySQL Server performance for long queries, creating required indexes, using appropriate data-types for columns and tuning MySQL parameters Perform day to day DBA activities like taking backup, monitoring, query optimization, performance tuning etc. Maintain database security (creating and maintaining users and roles, assign privileges) Work closely with application development team and assisting them with daily operations Creation of development, staging and production database instances, and the synchronization of those instances from one environment to another Performance tuning of different queries, different parameters like max connections, sort-buffer-size, key-buffer-size, read-buffer-size, table cache, etc. on production environment Automated four sets of incremental database dumps Set up cluster servers

Requirements:

• B.E/B.Tech/MCA Rich experience in managing large size production databases Experience in installation/configuration/up-gradation of MySQL 5.5 and above on Linux Platform Excellent Knowledge of different storage engines of MySQL especially InnoDB, MyISAM, CSV and Federated .