Database Engineer in Zuora

Zuora’s platform and billing engineering team are focused on building and delivering world-class SaaS Products and Services for our customers. We run primarily on a distributed, microservices architecture transformed from our original monolithic codebase allowing for easy customization and extension of our products by our entire engineering group, as well as customers and partners. In addition, we don’t just want to build quickly, we want to build quality. We have a commitment to scalability and quality as a part of our “Engineering DNA”.

WHAT YOU’LL ACHIEVE

• Partner with Engineering teams in design reviews to ensure no compromise to the security, integrity, or quality of the underlying data structures for new functionality
• Maintain high security and ethics, adhering to regulatory compliance such as PCI and SAS70/SSAE16 with respect to data storage, management, and access
• Drive fully automated processes to establish trends in data growth and forecast capacity needs
• Design and deliver data migrations and database upgrades and ensure automation is keeping up with our ever-increasing database growth
• Ensure all databases and processes follow best practices 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.

WHAT YOU’LL NEED TO BE SUCCESSFUL

• 5+ years of experience as a MySQL DBA
• Experience in Snowflake performance tuning, usage/utilization monitoring
• 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 (MySQL clustering, Oracle RAC, Snowflake high-available architecture)
• 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