Remote Senior Postgres Engineer: Performance & HA

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

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.