Postgres Engineer

Astreya; Stati Uniti; Remoto; USD 150.000 - 230.000; Tempo pieno

Descrizione del lavoro

Astreya is seeking a Senior Postgres Engineer to own and tune our self-managed, on-premises Postgres deployment. You will optimize performance, tune configurations, and select mature extensions over building custom solutions.

You will work remotely on infrastructure hosted on-premises, lead performance improvements, implement high availability, backups, and disaster recovery, and mentor engineers in best practices for production Postgres deployments.

Competenze

• 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.
• Deep knowledge of Postgres internals (MVCC, WAL, autovacuum, query planner, locking, 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.
• Scripting and automation for provisioning, configuration, and routine operations.
• Experience with monitoring and alerting.
• Strong written and verbal communication, and a record of leading root-cause analysis.

Mansioni

• Tune the deployment across configuration, query and index performance.
• Cover on-prem concerns such as hardware, storage, OS tuning, replication, backup and recovery, and upgrades.
• Recommend existing Postgres extensions or plugins to adopt.
• Design, run, and improve high availability, replication, and failover.
• Own backup, PITR, and 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; mentor engineers.

Conoscenze

PostgreSQL tuning

On-prem deployment

Performance analysis

Query optimization

Automation scripting

Replication and HA

Monitoring and alerting

Leadership / mentoring

Strumenti

pg_stat_statements

pg_partman

pg_repack

EXPLAIN ANALYZE

Replication slots

Descrizione del lavoro

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