Remote PostgreSQL Performance Consultant

Bitovi; Oregon; Hybrid; USD 120,000 - 190,000; Full time

Benefits offered by this job

Competitive salary and annual bonus

Completely remote work with flexible

401(k) matching

4 weeks of paid time off + 8 holidays

Health, dental, and vision insurance

Paid maternity and paternity leave

STD, LTD, and Life Insurance coverage

Job summary

Bitovi seeks a PostgreSQL Database Consultant to diagnose, stabilize, and tune large self-managed environments in production. You will apply deep internals knowledge (MVCC, autovacuum, WAL) to prevent outages and optimize performance, with strong communication to engineers and stakeholders.

Remote work is allowed with travel to client sites as needed. You will lead vacuum tuning, indexing strategies, replication/HA validation, and PITR exercises while contributing to runbooks and client success.

Qualifications

• Deep production PostgreSQL experience in self-managed on-premise environments.
• Expert vacuum/autovacuum tuning and preventing table/index bloat.
• Strong indexing skills across multiple index types and safe reindexes.
• Auditing and tuning PostgreSQL configuration with justification for changes.
• Query analysis using EXPLAIN (ANALYZE, BUFFERS) and pg_stat views.
• Experience with replication, high availability, and failover testing.
• Backup/restore, PITR, regular restore validation.
• Solid Linux admin skills for DB hosts (storage, kernel params).
• Incident response and clear postmortems with remediation plans.
• Security hardening and access controls (pg_hba, TLS, pgAudit).
• Scripting (Python/Bash/Go) for automation.

Responsibilities

• Stabilize critical PostgreSQL systems across enterprise environments.
• Audit configuration, maintenance, and indexing; identify root causes.
• Tune vacuum, indexing, queries, and overall configuration for reliability.
• Implement monitoring, alerting, and runbooks; reduce incidents.
• Consult with clients to build outcome-driven platforms and migrations.
• Travel up to several days per quarter for on-site work.

Skills

PostgreSQL production

Vacuum autovacuum

Indexing expertise

PostgreSQL configuration

Explain analyze

Replication & HA

Backup & recovery

Linux administration

Incident response

Root cause analysis

Security hardening

Python scripting

Tools

pgBackRest

Barman

Patroni

repmgr

PgBouncer

Pgpool-II

CloudNativePG

Crunchy Postgres Operator

Prometheus postgres_exporter

Datadog

Job description

Bitovi seeks a PostgreSQL Database Consultant to diagnose, stabilize, and tune large self-managed environments in production. You will apply deep internals knowledge (MVCC, autovacuum, WAL) to prevent outages and optimize performance, with strong communication to engineers and stakeholders.

Remote work is allowed with travel to client sites as needed. You will lead vacuum tuning, indexing strategies, replication/HA validation, and PITR exercises while contributing to runbooks and client success.