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 benefits to all Regular, Full-Time Employees, including:
Medical provided through UHC (PPO, HSA, Surest options) / Medical provided through Kaiser (HMO option only) for California employees only
Dental provided through UHC
Nationwide Vision provided by UHC
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 Program provided by Goomi Group
Employee Assistance Program
Wellness Days
401k Plan
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 other ancillary benefits required under state and federal law
