Staff Database Reliability Engineer

ClickUp is the world’s only all-in-one productivity platform that flexes to the way people want to work. It replaces all individual workplace productivity tools with a single, unified platform that includes project management, document collaboration, whiteboards, spreadsheets, and AI. Our dedication to enhancing productivity has earned us recognition on prestigious lists including the Forbes Cloud 100, Fast Company's Most Innovative Companies, Inc. Power Partners and #1 on two of G2's Best Software Products Lists for 2023 - #1 Project Management Product and #1 Collaboration and Productivity Product. With our headquarters based in San Diego and a rapidly expanding global presence, we are shaping the future of work. Join our team at ClickUp, one of the fastest-growing SaaS companies worldwide, and help millions of users be more productive - saving them at least one day every week. 🦄

As a Database Reliability Engineer (DBRE) at ClickUp, you are a hybrid SRE and DBA. You bring your database expertise from an SRE and infrastructure automation perspective. Your software development expertise will mostly be around automation of database infrastructure (IaC). Your primary responsibility as a DBRE is in keeping the database systems running smoothly, ensuring full observability and allowing push-button deployment of the database infrastructure.

If you love unique challenges on database automation, management, scaling, etc. then you will love working this role at ClickUp!

Responsibilities:

• Work on database reliability and performance aspects for ClickUp from within Platform Engineering
• Participate in OnCall support rotation (24x7x365 uptime required, we do follow the sun so 12 hour rotations 5am to 5pm Poland Hours, biweekly rotation, typically 2-3 incidents per week)
• Implement best practices for our PostgreSQL database cluster and its components
• Work on observability of relevant database metrics and make sure we reach our database objectives
• Provide database expertise to engineering teams (review of database migrations, queries and performance optimizations)
• Work on automation of database infrastructure and help engineering succeed by providing self-service tools
• Plan the growth and manage the capacity of ClickUp's database infrastructure
• Design, build and maintain core database infrastructure pieces that allow ClickUp to scale
• Support and debug database production issues across services and levels of the stack
• Make monitoring and alerting alert on symptoms and SLOs, and not on outages
• Document every action so your learnings turn into repeatable actions, then into automation
• Perform and run blameless RCA's on incidents and outages, relentlessly looking for answers that will prevent the incident from ever happening again.
• Help engineering succeed by providing self-service tools
• Work with peer DBAs/DBREs to roll out changes to our production environment
• Help mitigate database-related production incidents
• Provide database expertise to engineering teams (for eg. through reviews of db migrations, query and performance optimizations)
• Design, build and maintain core database pieces for massive scaling
• Support and debug database production issues across services and levels of the stack.

Requirements:

• 6 years of experience running PostgreSQL in large production environments.
• 3 years of experience with infrastructure automation and configuration management (Chef, Ansible, Puppet, Terraform…).
• Managed a DB at least 100GB in size on a high OLTP throughput database environment
• 3 years of experience with any programming language or advanced scripting - Python, bash
• Knowledge of Linux and/or the Unix Shell
• Have solid knowledge of SQL and PL/pgSQL
• Have solid knowledge of the internals of PostgreSQL.
• Have experience working in a distributed production environment.
• Share ClickUp’s core values and work in accordance with those values.
• Have excellent written and verbal English communication skills.
• Great collaborations skills and can communicate asynchronously.
• Being Proactive - You see something broken, you can't help but fix it!
• Urge for delivering quickly and iterating fast.
• Have a passion for stable and secure systems management practices.
• Cloud technology experience with AWS, Azure, GCP
• Some data modeling and design skills
• Show ownership of Relational Database/PostgreSQL ecosystem
• Bonus if you know non-relational database technologies - DynamoDB, Redis, etc.

Unsure if you meet all the qualifications of this job description but are deeply excited about the role? We hire based on ambition, grit, and a passion for improving the way people work. If you think ClickUp is the company for you, we encourage you to apply!

ClickUp was founded on a culture of hard work, consistent growth, and a desire to break norms. We’re a values-driven company and hire based on ambition, merit, and a willingness to do what it takes to succeed. We don’t care where you’re from, what you look like, or who you’re in a relationship with—we hire the best people for the job, and create an environment that supports employees on their journey to do the most exciting work of their lives! ClickUp is an Equal Opportunity Employer, and qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

ClickUp collects and processes personal data in accordance with applicable data protection laws. If you are a European Job Applicant, see our privacy policy for further details.

Please note we are unable to sponsor or take over sponsorship of an employment visa for roles outside of engineering and product at this time. Sponsorship for engineering and product roles is not guaranteed, but is instead based on the business needs for that specific role at that time. Please reach out to the recruiter with any questions.