Senior Postgres Engineer at Astreya, Fremont, CA
Senior Postgres Engineer at Astreya in Fremont, CA. Full-time. $114,000 to $180,000 a year. Apply with swipeandhired.
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 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