Senior Database Reliability Engineer

As a Database Reliability Engineer (DBRE) at Click Up, 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 Click Up!

• Work on database reliability and performance aspects for Click Up from within Platform Engineering
• Participate in OnCall support rotation
• Implement best practices for our Postgre
  
  SQL 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 Click Up's database infrastructure
• Design, build and maintain core database infrastructure pieces that allow Click Up 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.

• 5 years of experience running Postgre
  
  SQL in large production environments.
• 2 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
• 2 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 Postgre
  
  SQL.
• Have experience working in a distributed production environment.
• Share Click Up’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/Postgre
  
  SQL ecosystem
• Bonus if you know non-relational database technologies - Dynamo
  
  DB, Redis, etc.