Senior Postgres Engineer
Astreya is looking for a Senior Postgres Engineer to manage and optimize their on-premises Postgres deployment. This remote position requires 10+ years of hands-on experience in tuning Postgres at scale. Responsibilities include assessing performance, selecting extensions, ensuring reliability and operations, and providing technical leadership. Candidates should have expertise in high availability, replication, and automated failover, along with scripting and automation skills. Comprehensive benefits are offered to full-time employees.
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 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 Days401k 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
Job details
- Published
- October 15, 2026
- Experience
- Senior
- Job source
- myworkdayjobs
- Workplace
- On-site · Fremont, US
- First seen
- October 16, 2026
Benefits
Comprehensive benefits including medical, dental, vision, flexible spending accounts, continuing education, corporate wellness, life insurance, and paid time off.
Skills mentioned in this job
LiftmyCV exclusive data
Astreya Partners, LLC hiring intelligence
Astreya Partners, LLC currently has 9 active jobs tracked by LiftmyCV. 9 new jobs in the past 7 days.
Active openings
9
Currently tracked by LiftmyCV
New in 7 days
9
9 new jobs in the past 30 days
Published salaries
22%
Median disclosed salary: $94,660
Average opening age
1 days
Across 9 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • Network Operations Engineer II
- • Lead AV & Commissioning Engineer III
- • IT Support Specialist II
- • Operations Management, Senior Manager
Frequently requested skills
Median disclosed salary: $94,660 · 22% of jobs publish a salary
As of November 17, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Astreya Partners, LLC
Similar jobs from this company
- Contracts Administrator IAstreya Partners, LLCRemote, GARemote
- Forward Logistics Technician IAstreya Partners, LLCSan Francisco, USOn-site
- Service Delivery ManagerAstreya Partners, LLCFremont, USOn-site
- Site EHS ManagerAstreya Partners, LLCLas Vegas, USOn-site
- IT Support Specialist IVAstreya Partners, LLCPortland, USOn-site$44,232–$69,840 per year
- Quality InspectorAstreya Partners, LLCRemote, CARemote
Across the market
Similar jobs from other companies
- Postgres EngineerSupabaseRemoteRemote
- Informix DBA with PostgresGlobal Business Solutions India Private LtdIND PUNE FL7On-site
- Postgres Product EngineerRenderUSRemote
- MySQL and Postgres DBADxctechnologyIND - AP - HYDERABADOn-site
- Senior Postgres OntwerperKyndryl Nederland B.V.Den Helder, NLOn-site$50,000 per year
- Product Marketing, PostgresClickHouseThe Netherlands, United StatesOn-site
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.