Senior Postgres Engineer

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 deploymentsSalary 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 onlyDental provided through UHCNationwide Vision provided by UHCFlexible Spending Account for Health & Dependent CarePre-Tax Account for Commuter Benefit/Parking & Transit (location-specific)Continuing Education and Professional Development via various integrated platforms, e.g. Udemy and CourseraCorporate Wellness Program provided by Goomi GroupEmployee Assistance ProgramWellness Days401k PlanBasic and Supplemental Life InsuranceShort Term & Long Term DisabilityCritical Illness, Critical Hospital, and Voluntary Accident InsuranceTuition Reimbursement (available 6 months after start date, capped)Paid Time Off (accrued and prorated, maximum of 120 hours annually)Paid HolidaysAny other statutory leaves, paid time, or other ancillary benefits required under state and federal lawSummaryLocation: Fremont, CAType: Full time