Job Description
We’re seeking a Senior MySQL DBA to help with our growing database environment. This role is key to help maintain the high reliability and performance of our application. We have many sharded databases and an environment which is constantly expanding. We operate in AWS, and are looking for a hardworking and experience DBA with a drive for consistency and reliability, solid understanding in database administration and scripting and an excellent temperament to fit into the team.
What you get to do every day:
Work closely with the Engineering teams based in all the regions Zendesk has presence
Perform regular database schema changes with no downtime
Perform and lead migrations of customer data between shards
Build new database clusters/shards for support customer data growth
Seek performance issues and suggest optimizations
Automate recurring DBA tasks
Be a member of the DBA team on-call (when on rotation)
Supervise the database environment to maintain high-availability and proactively identify and address issues
Work with and educate our Engineering teams to make good schema design choices and write efficient queries
Observe and improve our backup solution to ensure that our customers’ data is always secure
Influence peer efficiency by staying on top of the industry, as well as give to the industry on behalf of Zendesk
5+ years of consistent, commercial background with MySQL architecture, replication, sharding, monitoring, troubleshooting and backups.
Affinity for automation and strong use of a scripting language (such as Bash, Perl, Python, Ruby, Go)
Experienced with SQL and stored routines
Solid grasp of AWS database technologies like Aurora, DynamoDB, etc would be useful
Experience with MySQL in sharded environment and associated challenges with performance and growth
Experience working with DataDog and ProxySQL will be a plus
Ability to meet results and drive your work to completion within specified timelines
Multi-functionally in many areas without being constrained by your job function
Great interpersonal and communication skills
Collaborative, upbeat work ethic where you are encouraged to take ownership, and have fun
Zendesk is an equal opportunity employer, and we’re proud of our ongoing efforts to foster global diversity, equity, & inclusion in the workplace. Individuals seeking employment and employees at Zendesk are considered without regard to race, color, religion, national origin, age, sex, gender, gender identity, gender expression, sexual orientation, marital status, medical condition, ancestry, disability, military or veteran status, or any other characteristic protected by applicable law.
