Remote PostgreSQL Database Consultant — Stabilize & Tune

Bitovi; Chicago (IL); Remote; USD 120,000 - 190,000; Full time

Benefits offered by this job

Completely remote work with flexible/可

401(k) matching

4 weeks PTO + 8 holidays

Health, dental, and vision insurance

Paid maternity and paternity leave

STD, LTD, and Life Insurance

Job summary

Bitovi is seeking a PostgreSQL Database Consultant to diagnose, stabilize, and tune large self-managed PostgreSQL environments for enterprise clients. You will explain PostgreSQL internals, translate insights into actionable configuration changes, and help prevent outages.

You will work remotely in the United States, travel as needed, and collaborate with engineers and stakeholders to improve performance, reliability, and resilience. Strong Linux and scripting skills are required.

Qualifications

• Hands-on production experience administering PostgreSQL on self-managed on-prem infrastructure.
• Expert knowledge of vacuum/autovacuum: tuning thresholds, diagnosing bloat, and preventing wraparound.
• Strong indexing expertise across B-tree, GIN, GiST, BRIN with safe production rebuilds.

Responsibilities

• Stabilize critical PostgreSQL environments by auditing configuration and indexing to reduce incidents.
• Tune vacuum strategy, indexing, queries, and configs for real production load.
• Prevent recurrence with monitoring, alerting, and runbooks for client teams.

Skills

PostgreSQL

Self-managed on-prem

Vacuum tuning

Indexing

Replication

Monitoring

Linux administration

Scripting

Tools

pgBackRest

Barman

Patroni

Job description

Bitovi is seeking a PostgreSQL Database Consultant to diagnose, stabilize, and tune large self-managed PostgreSQL environments for enterprise clients. You will explain PostgreSQL internals, translate insights into actionable configuration changes, and help prevent outages.

You will work remotely in the United States, travel as needed, and collaborate with engineers and stakeholders to improve performance, reliability, and resilience. Strong Linux and scripting skills are required.