Senior Database Engineer

Summary

Join Zuora as a Senior Database Engineer and be part of a talented team supporting and scaling the Zuora service and underlying infrastructures. You will operate and automate MySQL database instances across all environments, ensuring high performance and data recovery capabilities. This hybrid role requires significant experience in Linux and open-source system administration, optimal system design, storage architectures, and automation frameworks. You will work closely with other teams to maintain business continuity and performance, participate in design reviews, and ensure compliance with regulations like PCI and SAS70/SSAE16. The role involves automating tools and processes, executing data migrations, and ensuring best practices are followed. On-call responsibilities are part of the role.

Requirements

• 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, Jenkins, Terraform
• Experience with on-call and customer incident investigations and root cause analysis at database and storage tiers
• Excellent coding skills using Python

Responsibilities

• 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 Zuora'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

Benefits

• Competitive compensation, corporate bonus program and performance rewards, and retirement programs
• Competitive compensation, variable bonus and performance reward opportunities, and retirement programs
• Medical, dental and vision insurance
• Generous, flexible time off
• Paid holidays, “wellness” days and company wide end of year break
• 6 months fully paid parental leave
• Learning & Development stipend
• Opportunities to volunteer and give back, including charitable donation match
• Free resources and support for your mental wellbeing