{"schemaVersion":"jobsearcher.job.v1","id":"70346fa6f1cf6fe3bab59bc0","url":"https://jobsearcher.com/jobs/70346fa6f1cf6fe3bab59bc0","canonicalUrl":"https://jobsearcher.com/jobs/70346fa6f1cf6fe3bab59bc0","title":"Postgres Engineer","description":"Senior Postgres EngineerOverviewWe 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.ResponsibilitiesPerformanceAssess and tune the deployment across configuration, query and index performance, and operational practicesCover on-prem concerns such as hardware, storage, OS-level tuning, replication, backup and recovery, and upgradesIdentify bottlenecks and recommend prioritized, practical fixesExtension selectionRecommend existing Postgres extensions or plugins we can adopt instead of building custom solutionsAdvise on maturity, maintenance risk, and fit for each recommendationReliability and operationsDesign, run, and improve high availability, replication (streaming and logical), and failoverOwn backup, point-in-time recovery, and regular disaster-recovery testingPlan and execute major-version upgrades and patching with minimal downtimeAutomate provisioning, configuration, and routine maintenanceMaintain runbooks, documentation, and database security and access controlsTechnical leadershipAnswer questions and review designs as they come upMentor and guide the engineers who own the system day to dayRequired Qualifications10+ years of hands-on experience operating and tuning Postgres in production at scaleExperience running self-managed Postgres on-prem, not only managed cloud servicesWorking knowledge of the Postgres extension ecosystem, such as pg_stat_statements, pg_partman, and pg_repackDeep knowledge of Postgres internals, including MVCC, WAL, autovacuum, the query planner, locking, and replication slotsProven query and index tuning with EXPLAIN ANALYZE, pg_stat_statements, partitioning, and bloat managementProduction experience with high availability, replication (streaming and logical), and automated failoverExperience with connection pooling and load balancingExperience with backup and recovery, including point-in-time recovery and disaster-recovery testingScripting and automation skills for provisioning, configuration, and routine operationsExperience with monitoring and alertingStrong written and verbal communication, and a record of leading root-cause analysisPreferred QualificationsPostgres committer or contributor statusExperience building Postgres extensions in C or RustExperience operating multi-terabyte Postgres deployments","company":"Astreya","rawCompany":"astreya","city":"Denver","state":"CO","isRemote":false,"isActive":false,"createdAt":"2026-10-19T11:24:35.486Z","occupations":[{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Postgres Engineer","description":"Senior Postgres EngineerOverviewWe 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.ResponsibilitiesPerformanceAssess and tune the deployment across configuration, query and index performance, and operational practicesCover on-prem concerns such as hardware, storage, OS-level tuning, replication, backup and recovery, and upgradesIdentify bottlenecks and recommend prioritized, practical fixesExtension selectionRecommend existing Postgres extensions or plugins we can adopt instead of building custom solutionsAdvise on maturity, maintenance risk, and fit for each recommendationReliability and operationsDesign, run, and improve high availability, replication (streaming and logical), and failoverOwn backup, point-in-time recovery, and regular disaster-recovery testingPlan and execute major-version upgrades and patching with minimal downtimeAutomate provisioning, configuration, and routine maintenanceMaintain runbooks, documentation, and database security and access controlsTechnical leadershipAnswer questions and review designs as they come upMentor and guide the engineers who own the system day to dayRequired Qualifications10+ years of hands-on experience operating and tuning Postgres in production at scaleExperience running self-managed Postgres on-prem, not only managed cloud servicesWorking knowledge of the Postgres extension ecosystem, such as pg_stat_statements, pg_partman, and pg_repackDeep knowledge of Postgres internals, including MVCC, WAL, autovacuum, the query planner, locking, and replication slotsProven query and index tuning with EXPLAIN ANALYZE, pg_stat_statements, partitioning, and bloat managementProduction experience with high availability, replication (streaming and logical), and automated failoverExperience with connection pooling and load balancingExperience with backup and recovery, including point-in-time recovery and disaster-recovery testingScripting and automation skills for provisioning, configuration, and routine operationsExperience with monitoring and alertingStrong written and verbal communication, and a record of leading root-cause analysisPreferred QualificationsPostgres committer or contributor statusExperience building Postgres extensions in C or RustExperience operating multi-terabyte Postgres deployments","datePosted":"2026-10-19T11:24:35.486Z","dateModified":"2026-10-19T11:24:35.486Z","hiringOrganization":{"@type":"Organization","name":"Astreya","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Denver","addressRegion":"CO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"70346fa6f1cf6fe3bab59bc0"},"url":"https://jobsearcher.com/jobs/70346fa6f1cf6fe3bab59bc0"}}