• Extensive experience of MySQL (5.1/5.5/5.6) Database Administration (Installation, Configuration & Optimization) both open community and enterprise versions.
• Strong experience of system analysis and design for scalability and reliability.
• Excellent shell scripting experience for automation of day to day tasks such as backups, DB Server statistics gathering, performance measurement, memory, I/O, CPU and storage monitoring and building automated proactive alert based system.
• Experience of managing MySQL over Ubuntu, CentOS, RedHat, & Oracle Solaris.
• Intensive use of MySQL Replication to build and maintain load balanced, reliable and scalable architecture for high volume OLTP environment.
• Deployment, installation and management of MHA as high availability solution ([login to view URL]).
• Strong Query Optimization skill (Indexing, query rewriting & step by step technique to handle large volume of data for efficient retrieval).