Responsibilities -Ensures the database environment is designed and managed to meet business and IT demands for availability, performance and manageability -Ensures implementation of industry best practices in systems administration. -Serves as the point of contact for advanced level troubleshooting issues, and performs hands-on systems administration as required. -Involved in application development projects to evolve the database architecture and design. -Monitors database operations. -Analyzes and responds to performance and other maintenance issues. -Inventories and documents forms, reports, notices, etc. -Participates in the creation of development, staging & production database instances, and the migration of those instances from one environment to another. -Tests and corrects errors and refines changes. -Tunes the performance of all the staging and production database instances. -Performs back-up and recovery. -Plans and executes disaster recovery. -Performs complex query development. -Other duties that are within education and experience or the incumbent may be assigned for the betterment of the company.
Qualifications -Demonstrated exceptional database design and SQL programming skills to perform data troubleshooting and data manipulation tasks. -Administering of InnoDB and MyISAM table types. -Experience with MYSQL replication. -Experience with multi-master clustering (HA). -Experience with MYSQL performance tuning and optimization. (query optimization, index tuning, caching and buffer tuning). -Experience with data profiling, meta data analysis, data modelling and relational schema design. -Ability to troubleshoot problems in person, over the phone, or via email. -Solid understanding and experience in disaster recovery, planning and implementation. -Experience with backup and recovery process. -Must have hands on experience in Linux. -Attention to detail. -Ability to diagnose and resolve a broad range of technical problems. -Strong teamwork and collaboration skills.