Senior Database Engineer
Outbound.io
Job Description
Zendesk 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 Qualifications
5+ 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 Qualifications
Working 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
Hybrid: In this role, our hybrid experience is designed at the team level to give you a rich onsite experience packed with connection, collaboration, learning, and celebration - while also giving you flexibility to work remotely for part of the week. This role must attend our local office for part of the week. The specific in-office schedule is to be determined by the hiring manager.
The intelligent heart of customer experience
Zendesk software was built to bring a sense of calm to the chaotic world of customer service. Today we power billions of conversations with brands you know and love.
Zendesk believes in offering our people a fulfilling and inclusive experience. Our hybrid way of working, enables us to purposefully come together in person, at one of our many Zendesk offices around the world, to connect, collaborate and learn whilst also giving our people the flexibility to work remotely for part of the week.
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. If you are based in the United States and would like more information about your EEO rights under the law, please click here.
Zendesk endeavors to make reasonable accommodations for applicants with disabilities and disabled veterans pursuant to applicable federal and state law. If you are an individual with a disability and require a reasonable accommodation to submit this application, complete any pre-employment testing, or otherwise participate in the employee selection process, please send an e-mail to peopleandplaces@zendesk.com with your specific accommodation request.