PostgreSQL Database Consultant

New

BitoviDatabase consulting

Candidates must be located in the United States.Full-TimeSenior

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

Apply NowOpens the employer's application page

Job Details

Have deep production experience administering PostgreSQL on self-managed, on-premise infrastructure.
Know vacuum and autovacuum tuning, bloat diagnosis and remediation, and transaction ID wraparound prevention.
Demonstrate indexing expertise across B-tree, GIN, GiST, BRIN, partial, and covering indexes, including safe production index rebuilds.
Master PostgreSQL configuration, including memory, connection limits, checkpoints, WAL, and planner parameters.
Analyze query performance using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, and pg_stat_* views.
Have experience with streaming and logical replication, high availability tools such as Patroni or repmgr, and failover testing.
Have backup, restore, and point-in-time recovery experience, including regular restore validation.
Use connection pooling tools such as PgBouncer or Pgpool-II.
Have experience with PostgreSQL monitoring and alerting tools such as Prometheus postgres_exporter, pgwatch, or Datadog.
Have Linux administration skills related to database hosts, including storage, filesystems, kernel parameters, and resource contention.
Have incident response and root cause analysis experience, including writing postmortems and remediation plans.
Be able to travel an average of 3 to 5 days every quarter.

Audit configuration, maintenance, and indexing across enterprise PostgreSQL environments.
Identify root causes of instability and deliver fixes that reduce incidents.
Optimize vacuum strategy, indexing, queries, and configuration for production workloads.
Put monitoring and alerting in place to catch problems early.
Create runbooks so client teams know how to respond.
Consult with clients to build outcome-driven platforms and identify potential problems.
Travel an average of 3 to 5 days every quarter.
Present at conferences, attend or give training, run meetups or local groups, and create content in areas of expertise.

View Full Description & ApplyYou'll be redirected to the employer's site