Database Reliability Engineer & Administrator

Database Reliability Engineer & Administrator (PostgreSQL & ClickHouse)TCN is looking for a Database Reliability Engineer (DBRE) to join our team in Saint George, Utah. In this role, you will be the guardian of our data layer, ensuring that TCN’s global production databases are performant, scalable, and resilient.While you will share the core DNA of a Site Reliability Engineer, your specific mission is to optimize and manage our high-traffic PostgreSQL environments and our high-performance ClickHouse analytical clusters. You will bridge the gap between application development and database operations, ensuring our data infrastructure keeps pace with our global growth.Key ResponsibilitiesDatabase Architecture & Deployment: Collaborate with developers to design schema migrations and deploy database changes that maintain high availability. Assist in the architectural design of PostgreSQL and ClickHouse clusters to ensure they meet scaling requirementsPerformance Tuning & Optimization: Proactively monitor and tune PostgreSQL (query optimization, indexing strategies, vacuuming) and ClickHouse (merge tree optimizations, shard/replica management) to ensure sub-second latency for our clientsInfrastructure as Code: Automate the provisioning and configuration of database clusters using tools like Terraform, Ansible, or Kubernetes OperatorsResilience & Failure Management: Manage high-availability (HA) solutions (e.g., Patroni, PGBouncer) and ensure robust backup/recovery strategies are tested and functionalDeep Troubleshooting: Lead root-cause analysis for complex database incidents. Debug locking issues, replication lag, and resource contention in a cloud-native environmentObservability: Build and maintain dashboards and alerting for database health, focusing on SLIs/SLOs related to data consistency and query performanceIncident Response: Participate in a 24/7 on-call rotation, serving as the subject matter expert for database-related outagesQualificationsEducation: Bachelor’s degree in Computer Science, Information Technology, or a related fieldExperience: 3+ years in a Linux environment as a Database Administrator (DBA), DBRE, or SRE with a heavy focus on data systemsDatabase Expertise:PostgreSQL: Advanced knowledge of internal mechanics, replication (physical/logical), and extension managementClickHouse: Experience managing OLAP workloads, understanding of MergeTree engines, and distributed table configurationsCloud & Containers: Demonstrated experience with Google Cloud Platform (GCP) and running stateful workloads inside KubernetesLinux Mastery: Deep understanding of the Linux OS, specifically how kernel parameters, storage I/O, and networking impact database performanceAutomation: Proficient in scripting (Bash, Python) and configuration management. Familiarity with Go is a significant plusNetworking: Knowledge of TCP/IP, TLS encryption for data in transit, and load balancing (L4/L7)Soft Skills: Excellent communication skills; the ability to explain "why" a query is slow to a developer and "what" the business impact is to a stakeholderAbout TCNTCN is a fast-growing technology company and provides all its services over the internet in a cloud-based software-as-a-service model. TCN's technology stack and culture are positive and forward-thinking. When you join TCN, you are joining a dedicated team of professionals. Employees often describe our culture as friendly, collaborative, flexible, and fast-paced. To learn more, visit our website.Our benefits include:Medical Insurance (HDHP with HSA)Dental InsuranceVision InsuranceLife Insurance 401k with employer matchCompetitive salaryPaid time off Paid holidays (11 scheduled)Weekly lunches; free drinks and snacksCasual dress and flexible work environmentPowered by JazzHRxTEK3z2hdz