Senior Database Engineer

Summary

Join Zuora as a Senior Database Engineer and become part of a talented team supporting and scaling the Zuora service and underlying infrastructures. You will be responsible for operating and automating MySQL database instances across all environments. This hybrid role requires significant experience in system administration for Linux and open-source environments, fluency in best practices for optimal systems, and a security-minded approach to data privacy and integrity. Prior experience managing highly sensitive data and adhering to regulatory compliance is essential. You will collaborate with other teams to maintain business continuity and performance, participate in design reviews, and ensure database changes align with operational standards. Zuora offers competitive compensation, benefits, and a flexible work environment.

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
• Prior experience in managing database systems that store highly sensitive data and adhere to regulatory compliance such as PCI and SAS70/SSAE16 is a must

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