PostgreSQL Database Consultant

πŸ•’ October 29

Where this job comes from

Posted on Bitovi's careers page β†—Bitovi's careers page, not through a job board

First seen by Remote Rocketship October 29

Still open on Bitovi's site. Checked 1 hour ago.

Apply Now
Logo of Bitovi

Bitovi

51 - 200 employees

Founded 2005

πŸ’Ό Consulting

πŸ“£ Marketing

πŸ“¦ Logistics

Consulting β€’ Marketing β€’ Logistics

Bitovi is a collaborative team of experts dedicated to helping clients swiftly deliver exceptional applications. They provide a comprehensive range of services, including consulting, training, strategy, project management, product design, frontend and backend development, and DevOps engineering. With a focus on validation-driven development, Bitovi has partnered with notable clients like Yum! Brands and Sam's Club to build robust ecommerce platforms and innovative solutions tailored to their needs.

πŸ“‹ Description

β€’ Audit configuration, maintenance, and indexing across enterprise PostgreSQL environments β€’ Identify root causes of instability and deliver fixes that measurably reduce incidents β€’ Optimize vacuum strategy, indexing, queries, and configuration for production workloads β€’ Implement monitoring, alerting, and runbooks so problems are caught early and client teams know how to respond β€’ Consult with clients to build outcome-driven platforms β€’ Guide clients through processes, identify potential problems and unknowns, and tackle challenges β€’ Travel approximately 3 to 5 days every quarter β€’ Present at conferences, attend and give training, plan and run meetups or local groups, and create content in areas of expertise β€’ Collaborate with teams designing and building applications, infrastructure, and data platforms β€’ Discuss and design architectures, review code, research new technologies, and develop documentation and deployment processes

🎯 Requirements

β€’ Deep, production experience administering PostgreSQL on self-managed, on-premise infrastructure β€’ Expert knowledge of vacuum and autovacuum, including tuning thresholds and cost limits, diagnosing and remediating table and index bloat, and preventing transaction ID wraparound β€’ Strong indexing expertise across B-tree, GIN, GiST, BRIN, partial, and covering indexes β€’ 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 β€’ Experience with replication and high availability, including streaming and logical replication, Patroni, repmgr, or similar, and failover testing β€’ Backup, restore, and point-in-time recovery experience using pgBackRest, Barman, or similar β€’ Connection pooling with PgBouncer or Pgpool-II β€’ Monitoring and alerting for PostgreSQL using Prometheus postgres_exporter, pgwatch, Datadog, or similar β€’ Solid Linux administration skills related to database hosts β€’ Incident response and root cause analysis experience, including writing postmortems and remediation plans β€’ Ability to travel an average of 3 to 5 days every quarter β€’ Configuration management using Ansible or similar β€’ Writing runbooks and maintenance procedures β€’ Capacity planning and performance baselining β€’ Major version upgrades and schema migrations with minimal downtime β€’ Experience working within change management processes in large, regulated enterprises β€’ Security hardening involving roles and privileges, pg_hba configuration, TLS, and pgAudit β€’ Experience running PostgreSQL on Kubernetes using CloudNativePG, Crunchy Postgres Operator, or similar β€’ Scripting and automation in Python, Bash, or Go β€’ Experience with other relational databases such as Oracle, SQL Server, or MySQL β€’ Must be located in and authorized to work in the United States β€’ Must pass a background check β€’ Visa sponsorship is unavailable

πŸ–οΈ Benefits

β€’ 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 β€’ Opportunities to present at conferences, attend and give training, plan and run meetups or local groups, and create content in your expertise

Apply Now

πŸ“Š Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

πŸ•’ October 29

STARLIMS

201 - 500

🍽️ Food & Beverage

πŸ“¦ Logistics

🏭 Manufacturing

Business Consultant supporting STARLIMS sales of laboratory information management solutions. Developing technical solutions, demonstrations, and RFI/RFP responses for laboratory customers.

πŸ•’ October 29

FoodChain ID

501 - 1000

πŸ’Ό Consulting

πŸ“¦ Logistics

πŸ₯ Healthcare

Principal Consultant designing Oracle Cloud PLM and F4PLM solutions for food and beverage manufacturers. Leading complex implementations, integrations, executive stakeholders, and consultant mentorship.

πŸ•’ October 29

ClinDCast

51 - 200

πŸ₯ Healthcare

πŸ’Ό Consulting

πŸ”Œ API

Oracle Learning Cloud Functional Lead designing and implementing learning systems. Advising healthcare organizations on HCM transformation, compliance, integrations, reporting, and delivery.

πŸ•’ October 29

Primrose Schools

10,000+ employees

πŸ“š Education

🀲 Charity

🀝 Non-profit

School Acquisition Consultant guiding Primrose franchise owners through acquired-school transitions. Leading brand conversion, licensing, enrollment growth and operational readiness for an early-learning provider.

πŸ•’ October 29

Pondurance

51 - 200

πŸ’Ό Consulting

πŸ₯ Healthcare

πŸ›‘οΈ Insurance

Senior Incident Response Consultant conducting forensic investigations and leading incident response for Pondurance, a cybersecurity resilience company. Advising clients on threat containment, remediation, and detection.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $110k - $136k / year

πŸ’° Private Equity Round on 2020-10

⏰ Full Time

🟑 Mid-level

🟠 Senior

πŸ’Ό Consultant

Built byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok