PostgreSQL Database Consultant

Bitovi

Oregon

Hybrid

USD 120,000 - 190,000

Full time

7 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

PLEASE NOTE: At this time, we are only considering candidates located in and authorized to work in the United States.

JOIN OUR TEAM!Bitovi is looking for a PostgreSQL Database Consultant to join us as we transform technology delivery. We help enterprise clients run critical data platforms reliably, and we're looking for people with deep, hands-on PostgreSQL expertise to diagnose, stabilize, and tune large self-managed database environments. If you know Postgres internals well enough to explain why a database fell over and how to make sure it doesn't happen again, we want to work with you!

Compensation: $120,000 to $190,000 annually, depending on experience, plus annual bonus opportunity.

WHO YOU ARE

You're the person teams call when Postgres is misbehaving in production. You understand what's happening under the hood, from MVCC and autovacuum to the planner and WAL, and you can turn that understanding into configuration and maintenance changes that keep systems healthy. You're calm during incidents, rigorous in root cause analysis, and confident communicating findings and recommendations to both engineers and stakeholders.

You'll excel in this role at Bitovi if you have:

Deep, production experience administering PostgreSQL on self-managed, on-premise infrastructure (not only managed services like RDS or Cloud SQL)
Expert knowledge of vacuum and autovacuum: tuning thresholds and cost limits, diagnosing and remediating table and index bloat, and preventing transaction ID wraparound
Strong indexing expertise: choosing among B-tree, GIN, GiST, BRIN, partial, and covering indexes, identifying missing, unused, and duplicate indexes, and rebuilding indexes safely in production
Mastery of PostgreSQL configuration: memory settings, connection limits, checkpoints, WAL, and planner parameters, and the ability to audit an existing configuration and justify every change
Query performance analysis using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, and the pg_stat_* views
Experience with replication and high availability (streaming and logical replication, Patroni, repmgr, or similar) and failover testing
Backup, restore, and point-in-time recovery experience (pgBackRest, Barman, or similar), including regular restore validation
Connection pooling with PgBouncer or Pgpool-II
Monitoring and alerting for Postgres (Prometheus postgres_exporter, pgwatch, Datadog, or similar) focused on catching problems before they become outages
Solid Linux administration skills as they relate to database hosts: storage, filesystems, kernel parameters, and resource contention
Incident response and root cause analysis experience, including writing clear postmortems and remediation plans

Other skills we value

Configuration management for database fleets (Ansible or similar) so settings are consistent, reviewed, and repeatable
Writing runbooks and maintenance procedures that client teams can own after an engagement
Capacity planning and performance baselining
Major version upgrades and schema migrations with minimal downtime
Working within change management processes in large, regulated enterprises
Security hardening: roles and privileges, pg_hba configuration, TLS, and auditing (pgAudit)
Running Postgres on Kubernetes (CloudNativePG, Crunchy Postgres Operator, or similar)
Scripting and automation in Python, Bash, or Go
Experience with other relational databases (Oracle, SQL Server, MySQL)

WHO WE ARE

Bitovi partners with companies to build outcome-focused apps and platforms. Our collaborative approach is driven by validation to deliver the swiftest route to the most valuable solution.We design and build high-profile applications and the infrastructure and data platforms behind them, with tests, full docs, and a real deployment process. We discuss and design architectures, review code, and research new technologies. We talk to our clients, guiding them through the process, identifying potential problems and unknowns, and tackling challenges.We help one another freely. We keep a Slack channel called ask-help, which is constantly used. We develop new skills, build better developer tools, and work on new types of projects regularly.Our fully remote team comprises about 70 developers and designers. We welcome diversity and non-traditional paths into professions. We want the right person, not the right collection of tech keywords.

WHAT YOU'LL DO AT BITOVI

Stabilize critical systems. Audit configuration, maintenance, and indexing across enterprise PostgreSQL environments, identify the root causes of instability, and deliver fixes that measurably reduce incidents.

Tune for performance and reliability. Optimize vacuum strategy, indexing, queries, and configuration so databases stay healthy under real production load.

Prevent recurrence. Put monitoring, alerting, and runbooks in place so problems are caught early and client teams know how to respond.

Consult and manage. Consult with clients to build outcome-driven platforms, guiding them through the process, identifying potential problems and unknowns, and tackling challenges.

Travel. This is a remote, full-time position that requires the ability to travel. We travel an average of 3 to 5 days every quarter, and we'll always do our best to work with your schedule.

Teach. We'll discuss opportunities for you to present at conferences, attend and give training, plan and run meetups or local groups, and create various kinds of content in your expertise.

BENEFITS WE OFFER