Job Description :
Responsibilities:
-
Install, configure, and maintain MySQL multi-level Master-Slave replication
Install, configure, and maintain MYSQL Multi-master Group and Galera replication
Optimize and tune MySQL database performance
Continually improve monitoring, perform database capacity and usage planning
Write and maintain scripts to automate routine DB tasks
Troubleshoot database-related application performance issues
Ensure security and data integrity of all MySQL instances
Perform routine, periodic and proactive DB maintenance
Provide on-call support of MySQL databases
Implement tools to automate database operation and monitoring
Implement database Backup and Monitoring solutions
Test restore(master), recovery(point-in-time), replication
Test cluster/multi-master failover and disaster recovery
Implement, document and maintain database roles and security
Research and evaluate alternatives and recommend solutions for business issues
Create capacity planning reports based on historical data trends and projected data growth
Maintain current knowledge of relevant technologies
Qualifications
===========
3-5+ years of experience in administering MySQL database , replication, tuning, backup and recovery
Experience with MySQL Group replication and Galera replication is a plus
Must be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoring
Strong Expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production MySQL database servers
Strong Knowledge with database architecture design, including data partitioning and application partitioning is a plus
Solid Team player with a positive attitude and team spirit – can work alone and with others
Ability to mentor team members.
Communicates well (oral and written) with customers and management
Degree in Computer Science or equivalent