Database Reliability Engineer

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.

#LI-REMOTE

#LI-CDG