PostgreSQL Database Consultant
Chicago, IL - USA
Job Summary
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 were 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 doesnt happen again we want to work with you!
Compensation: $120000 to $190000 annually depending on experience plus annual bonus opportunity.
WHO YOU ARE
Youre the person teams call when Postgres is misbehaving in production. You understand whats 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. Youre calm during incidents rigorous in root cause analysis and confident communicating findings and recommendations to both engineers and stakeholders.
Youll 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) pgstatstatements and the pgstat* 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 postgresexporter 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 pghba 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 YOULL 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 well always do our best to work with your schedule.
Teach. Well 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.
Required Experience:
Senior IC
About Company
Digital product consultants who care as much as you do about your success. Partner with us for expert project management, design, development, and DevOps.