Senior Postgres Engineer

Astreya; United States; Remote; USD 114,000 - 180,000; Full time

Benefits offered by this job

Medical coverage

Dental

Vision

FSA

Commuter benefits

Education support

Wellness program

Employee Assistance Program

Paid holidays

PTO

Job summary

Astreya is seeking a Senior Postgres Engineer to own and tune our self-managed, on-premises Postgres deployment. You will optimize performance, recommend extensions, and improve reliability across backup, replication, and upgrades.

You will work remotely on infrastructure hosted on-premises and mentor the team, reviewing designs and guiding day-to-day operations. Strong PostgreSQL internals knowledge required.

Qualifications

• 10+ years of hands-on Postgres production tuning at scale.
• Experience with on-prem Postgres, not only cloud services.
• Knowledge of Postgres extensions (pg_stat_statements, pg_partman, pg_repack).
• Deep Postgres internals: MVCC, WAL, autovacuum, planner, locking, replication slots.
• Proven query and index tuning with EXPLAIN ANALYZE and partitioning.
• High availability, replication, and automated failover experience.
• Connection pooling and load balancing experience.
• Backup/recovery incl. PITR and disaster-recovery testing.
• Automation, monitoring, and alerting.
• Strong communication and leadership in root-cause analysis.

Responsibilities

• Assess and tune the deployment across configuration, query and index performance.
• Cover on-prem concerns such as hardware, storage, OS-level tuning, replication, backup and upgrades.
• Identify bottlenecks and recommend prioritized, practical fixes.
• Recommend existing Postgres extensions or plugins we can adopt instead of building custom solutions
• Advise on maturity, maintenance risk, and fit for each recommendation
• 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
• Answer questions and review designs as they come up
• Mentor and guide the engineers who own the system day to day

Skills

PostgreSQL

Performance tuning

On-prem PostgreSQL

Postgres extensions

High availability

Replication

Backup and recovery

Automation scripting

Leadership

Tools

pg_stat_statements

pg_partman

pg_repack

Job description

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

Performance

• Assess 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 up
• Mentor 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

Salary Range

$114,000.00 - $180,000.00 USD (Salary)

• Please note that the salary information provided herein is base pay only (gross); it does not include other forms of compensation which may or may not apply to this specific position, namely, performance-based bonuses, benefits-related payments, or other general incentives - none of which are guaranteed, may be subject to specific eligibility requirements, and are wholly within the discretion of Astreya to remit.
• Further, the salary information noted above is a range that consists of a minimum and maximum rate of pay for this specific position. Where an applicant or employee is placed on this range will depend and be contingent on objective, documented work-related considerations like education, experience, certifications, licenses, preferred qualifications, among other factors.

Astreya offers comprehensive b** enefits to all Regular, Full-Time Employees, **** including:**

• Medical provided throughUHC(PPO, HSA,Surestoptions) / Medical provided through Kaiser (HMO option only) for California employees only
• Dental provided throughUHC
• Nationwide Vision provided byUHC
• Flexible Spending Account for Health & Dependent Care
• Pre-Tax Account for Commuter Benefit/Parking & Transit (location-specific)
• Continuing Education and Professional Development via various integrated platforms, e.g.Udemy and Coursera
• Corporate Wellness Programprovided by Goomi Group
• Employee Assistance Program
• Wellness Days
• Basic and Supplemental Life Insurance
• Short Term & Long Term Disability
• Critical Illness, Critical Hospital, and Voluntary Accident Insurance
• Tuition Reimbursement (available 6 months after start date, capped)
• Paid Time Off (accrued and prorated, maximum of 120 hours annually)
• Paid Holidays
• Any other statutory leaves, paid time, or otherancillarybenefits required under state and federal law