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.