JOBSEARCHER

Postgres Engineer

AstreyaDenver, COL6 LeadOctober 19th, 2026
Senior Postgres Engineer
Overview: We are seeking a Senior Postgres Engineer to own and tune our self-managed, on-premises Postgres deployment. You will help us get more from Postgres by tuning what we run and adopting existing extensions instead of building our own.
Location: Remote. You will work remotely on infrastructure hosted on-premises.
Responsibilities:
  • PerformanceAssess and tune the deployment across configuration, query and index performance, and operational practices
  • Cover on-prem concerns such as hardware, storage, OS-level tuning, replication, backup and recovery, and upgrades
  • Identify bottlenecks and recommend prioritized, practical fixes
  • Extension selection
  • Recommend existing Postgres extensions or plugins we can adopt instead of building custom solutions
  • Advise on maturity, maintenance risk, and fit for each recommendation
  • Reliability and operations
  • Design, run, and improve high availability, replication (streaming and logical), and failover
  • Own backup, point-in-time recovery, and regular disaster-recovery testing
  • Plan and execute major-version upgrades and patching with minimal downtime
  • Automate provisioning, configuration, and routine maintenance
  • Maintain runbooks, documentation, and database security and access controls
  • Technical leadership
  • Answer questions and review designs as they come upMentor and guide the engineers who own the system day to day
Required Qualifications:
  • 10+ years of hands-on experience operating and tuning Postgres in production at scale
  • Experience running self-managed Postgres on-prem, not only managed cloud services
  • Working knowledge of the Postgres extension ecosystem, such as pg_stat_statements, pg_partman, and pg_repack
  • Deep knowledge of Postgres internals, including MVCC, WAL, autovacuum, the query planner, locking, and replication slots
  • Proven query and index tuning with EXPLAIN ANALYZE, pg_stat_statements, partitioning, and bloat management
  • Production experience with high availability, replication (streaming and logical), and automated failover
  • Experience with connection pooling and load balancing
  • Experience with backup and recovery, including point-in-time recovery and disaster-recovery testing
  • Scripting and automation skills for provisioning, configuration, and routine operations
  • Experience with monitoring and alerting
  • Strong written and verbal communication, and a record of leading root-cause analysis
Preferred Qualifications:
  • Postgres committer or contributor status
  • Experience building Postgres extensions in C or Rust
  • Experience operating multi-terabyte Postgres deployments