Desired Skills and Experience
- Perform regular database schema changes via Rails migrations and/or online schema updates with minimal downtime
- Perform and manage migrations of customer data between shards
- Create new database clusters/shards and slaves for support data growth
- Troubleshoot performance issues and suggest optimizations
- Automate recurring DBA tasks
- Participate in database space reclamation activities
- Complete capacity planning to accommodate rapid growth
- Be part of DBA team on-call rotation
- Monitor database environment to maintain high availability and proactively identify and solve issues
- Work with and educate our dev team to make good schema design choices and write efficient queries
- Monitor and enhance our backup solution to ensure that our customers’ data is always secure
- Document and practice failover scenarios
- Influence peer productivity by staying on top of the industry, as well as contribute to the industry on behalf of Zendesk
- Work with Engineering teams based in San Francisco, USA and Dublin, Ireland and other regions of the world where Zendesk has presence
- 5+ years of experience with MySQL architecture, replication, sharding, monitoring, troubleshooting and backups.
- Penchant for automation and strong use of a scripting language (such as Bash, Perl, Python or Ruby)
- Expert knowledge with SQL and stored routines
- Experience working with MySQL in sharded environment and associated challenges with performance and growth
- Working knowledge with AWS database technologies like Aurora, DynamoDB, Redshift, etc will be a plus
- Working knowledge with No-SQL technologies like MongoDB and/or other data stores like Riak
- Able to meet deliverables and drive your work to completion within specified timelines
- Can work cross functionally in many areas without being constrained by your job function
- Collaborative, upbeat work ethic where you are expected to communicate well, take ownership, and have fun
Apply