Job DescriptionZendesk is seeking a Senior Engineer role to help with our growing database environment. This role is key to help maintain the high reliability and performance of our applications. We have many sharded databases and an environment which is constantly growing. We are looking for a hardworking and experienced DBA with a drive for consistency and reliability, expert knowledge in database administration and scripting, and a great temperament to fit into the team.
What you get to do every day:Install, configure, upgrade, and maintain MySQL, PostgreSQL, MongoDB database instances and analytics server like Clickhouse.Monitor MySQL, PostgreSQL, MongoDB, Clickhouse system performance and tune instances as necessary.Implement and maintain database security protocols.Design, build and maintain cloud infrastructure systems using IaC tools like Terraform.Develop and maintain backups and recovery processes to ensure that our customers' data is always secure.Work with the application development team to develop database architectures, coding standards, and quality assurance policies and procedures.Handle capacity planning and conduct regular system audits to ensure smooth system operation without wasting resources.Document and standardize system procedures and configurations.Perform regular schema changes with no downtime.Automate recurring tasks with crontabs.Be part of team on-call (when on on-call rotation).Basic Qualifications5+ years of proven track record with MySQL/PostgreSQL architecture, replication, sharding, monitoring, troubleshooting and backups.Experience with automation and use of a scripting language (such as Bash, Perl, Python, Ruby, Go).Experience with SQL, NoSQL languages and stored routines.Ability to be part of team on-call (when on rotation).Preferred QualificationsWorking knowledge with Cloud database technologies like Aurora MySQL/PostgreSQL/EC2/Lambda/CloudFormation/Route53 and DynamoDB.Experience working with sharded database environments and associated challenges with performance and growth.Proficient in using Terraform/CloudFormation for infrastructure provisioning.Experience with containerisation tools like Docker and orchestration platforms such as Kubernetes.Multi-functionally in many areas without being constrained by your job function.Knowledge of NoSQL databases like MongoDB is a plus.Problem-solving skills and the ability to think algorithmically.Experience working with DataDog will be a plus.Collaborative, upbeat work ethic where you are expected to take ownership, and have fun.Good communication skills.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. We are an AA/EEO/Veterans/Disabled employer.
Zendesk endeavors to make reasonable accommodations for applicants with disabilities and disabled veterans pursuant to applicable federal and state law.
#J-18808-Ljbffr