Database Administrator jobs

PostgreSQL Database Consultant

BitoviRemote · US onlyFull-timeNo US visa sponsorshipFirst seen 21 days ago

$120k–$190k/yr listed by the employer

Strong: looks real and checked open today.

On Bitovi’s own careers site (JazzHR).

  • Checked: On the company's own careers siteJazzHR board
  • Checked: Checked open todayJazzHR board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundJazzHR board
  • Trust score 100 / 100 · Strong
See all 5 checksShow fewer
How we check

What you’ll do

  • Audit PostgreSQL configuration, maintenance, and indexing across enterprise environments; identify instability causes and implement fixes.
  • Tune vacuum strategy, indexes, queries, and configuration for production performance and reliability.
  • Set up monitoring, alerting, and runbooks to help catch problems early and guide client teams' response.
  • Consult with clients to develop outcome-driven platforms and address potential problems and challenges.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Deep production experience administering PostgreSQL on self-managed, on-premise infrastructure
  • Experience with replication, high availability, and failover testing
  • Backup, restore, and point-in-time recovery experience, including regular restore validation
  • Experience with connection pooling
  • Experience monitoring and alerting for PostgreSQL
  • Incident response and root cause analysis experience, including writing postmortems and remediation plans
  • Major version upgrades and schema migrations with minimal downtime (preferred)
  • Experience working within change management processes in large, regulated enterprises (preferred)
  • Running PostgreSQL on Kubernetes (preferred)
  • Experience with Oracle, SQL Server, or MySQL (preferred)

Skills

  • Expertise tuning vacuum and autovacuum, diagnosing and remediating table and index bloat, and preventing transaction ID wraparound
  • Strong indexing expertise, including index selection, identifying missing, unused, and duplicate indexes, and safely rebuilding indexes in production
  • Mastery of PostgreSQL configuration, including memory settings, connection limits, checkpoints, WAL, and planner parameters
  • Query performance analysis using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, and pg_stat_* views
  • Solid Linux administration skills related to database hosts, including storage, filesystems, kernel parameters, and resource contention
  • Configuration management for database fleets using Ansible or similar (preferred)
  • Writing runbooks and maintenance procedures (preferred)
  • Capacity planning and performance baselining (preferred)
  • PostgreSQL security hardening, including roles and privileges, pg_hba configuration, TLS, and auditing (preferred)
  • Scripting and automation in Python, Bash, or Go (preferred)

Other requirements

  • Located in and authorized to work in the United States
  • Ability to travel; average travel is 3 to 5 days every quarter
  • Pass a background check

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Health insurance offerings
Dental & vision
Dental and vision insurance offerings
Retirement plan
401(k) matching
Paid time off
4 weeks of paid time off in addition to 8 paid holidays
Parental leave
Paid maternity and paternity leave
Bonus
Annual bonus opportunity
Flexible schedule
Completely remote work with flexible hours
Life & disability insurance
Short-term disability, long-term disability, and life insurance coverage

Full job description

From Bitovi’s careers site

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.

Show full descriptionShow less

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

- Competitive salary and annual bonus opportunity

- Completely remote work with flexible hours

- 401(k) matching

- 4 weeks of paid time off in addition to 8 paid holidays

- Health, dental, and vision insurance offerings

- Paid maternity and paternity leave

- STD, LTD, and Life Insurance coverage

HOW TO APPLY Please share a resume or LinkedIn profile and answer the additional questions. Yes, we read through all the answers!

Please note that we are not interested in working with recruiters. All job offers are contingent on passing a background check. Candidates must be located in and authorized to work in the United States. We are unable to provide visa sponsorship at this time.

Something wrong with this job? Report it

Similar remote jobs

Database Architect

9th Way Insignia · Remote · US only

$79k–$88k/yr

StrongChecked open todayPosted 9 days ago

Database Engineer

GliaCell Technologies · Remote · US only

$100k–$130k/yrFull-time

StrongChecked open todayPosted 21 days ago

Senior Database Engineer

GliaCell Technologies · Remote · US only

$170k–$260k/yrFull-time

StrongChecked open todayPosted 21 days ago

See more like this