DBA MySQL

We are looking for a MySQL DBA Senior to join the team of our client. We look for motivated technologists who possess a unique balance of technical depth, business knowledge, and strong interpersonal skills. Your will ensure for the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances.

Responsibilities and Duties

• Participate in design reviews with Development to ensure a given release does not compromise the security, integrity or quality of the underlying data structures used by the application 
• Maintain high security and ethics, adhering to regulatory compliance such as PCI and SAS70/SSAE16 with respect to data storage, management, and access. 
• Automate tools and processes to establish trends in data growth and forecast capacity needs 
• Execute data migrations and database upgrades as part of our client's product releases and ensure our automation is keeping up with our exploding database growth.
• Ensure all databases and processes follow best practices and fit into the strategy. Initially perform, and longer term provide oversight for all MySQL administration including installation, configuration, replication, backups, and performance tuning. 
• Work with the various Engineering groups and ensure database changes are in-line with operational standards and meet the strategies needed to scale. Participate in on-call responsibilities, including at the database and storage tier.
• Work hand in hand with Release Engineering teams to support database changes required for new code deployment. 
   

Qualifications and Skills

• 7-10 years supporting database platforms for online service businesses Have experience in both OLTP and OLAP design methodologies. 
• Drive best practices in monitoring databases with the ability to identify key performance indicators and put facilities in place to alarm on-call personnel for actionable events. 
• Expertise in various MySQL replication technologies including when to use one method over another, limitations, and alternatives. 
• Fluency in horizontally scaling database infrastructures and identifying the most appropriate factors from which to split against based on application design and supported use cases. Experience in designing and managing MySQL clustering is required.
• Strong track record at implementing automated solutions for database operations, including failover, schema changes and sharding to name a few using technologies such as Ansible, Puppet, RunDeck, GoCD, Jenkins.
• Experience with on-call and customer incident investigations and root cause analysis at database and storage tiers.
• Availability to travel to US.

Time shift: full time

English level: Upper intermediate