PostgreSQL Database Consultant
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
PostgreSQL Database Consultant stabilizing and tuning enterprise databases for Bitovi, a software and applications consultancy. Improving reliability, performance, monitoring, and recovery for critical client data platforms.
Responsibilities:
- 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
Similar Jobs
M365 Technical-Functional Consultant
Consultant technico-fonctionnel M365 chez Experteam, partenaire Microsoft accélérant la transformation digitale des organisations. Conception, déploiement et adoption de solutions Teams, SharePoint et Power Platform.
Senior Workday Integration Consultant
Consultant Workday Integration modernisant les interfaces SIRH d’HELPLINE, spécialiste du support utilisateur et des services numériques augmentés par l’IA. Conception, support L3 et déploiement d’intégrations Workday.
ITSM Consultant
Consultant ITSM chez Synapsys, ESN française spécialisée en infrastructure, cloud et systèmes. Pilotage de CMDB, ITIL, ServiceNow et POC ITOM pour des clients grands comptes.
Consultant, Digital Process Excellence
KPMG Digital Process Excellence consultant improving client processes through AI, Process Mining, Low-Code, and RPA. Translating business needs into implemented technology solutions.
Senior Consultant, Early Childhood Programs
Senior Consultant supporting Guidehouse’s federal early childhood programs initiatives. Analyzing programs, managing stakeholders, and developing client deliverables and implementation strategies.
Senior EHR Data Integration Consultant
Senior EHR data integration consultant extracting and validating Epic or Cerner data for Siemens Healthineers. Advising healthcare clients and optimizing SQL-driven EHR pipelines.
Small Business Consultant
Small Business Consultant advising Mississippi startups and small businesses on cash flow, growth, and operations. Developing workshops, financial projections, and community partnerships.
Senior Atlassian Consultant
Senior Atlassian Consultant designing and delivering Jira and Confluence solutions for Valiantys, an Atlassian Platinum Solution Partner. Leading customer projects, presales, technical consulting, and team mentoring.
Senior Consultant – Aerospace & Defense
Senior Aerospace & Defense Consultant guiding IFS enterprise software implementations for Australian customers. Defining solutions, training users, and supporting testing and Go Live across global teams.
Lead Consultant, Data Modeler
Lead Data Modeler designing enterprise data models for financial reporting, analytics, and data products. Driving 3NF, dimensional modeling, warehousing, and SQL architecture for a client organization.
Senior Education Consultant
Senior Educational Consultant helping institutions implement Blackboard’s LMS and improve digital learning. Delivering implementation consulting, training, instructional design, and customer success services.
Executive Talent Partner Consultant
Executive recruiter leading Director- and VP-level searches for Intuit, a global financial technology platform. Managing sourcing, stakeholder advising, negotiations, onboarding, and diverse leadership pipelines.
Senior Entertainment Travel Consultant
Senior entertainment travel consultant coordinating VIP, production, group, and international travel for Netflix. Delivering high-touch service through BCD Travel’s global travel-management operation.
Quote to Cash (Q2C) Techno Functional Consultant
Quote-to-cash consultant delivering end-to-end Monetize360 implementations for IT services customers. Configuring pricing, billing, integrations, go-live, and post-launch adoption.
Cortex Domain Consultant
Cortex cybersecurity consultant architecting SOC transformation solutions for Palo Alto Networks customers. Leading technical demonstrations, Proof of Value projects, and customer security architecture.
Wellness and Personal Development Consultant
Wellness consultant introducing clients to premium online personal development programs. Supporting meaningful personal and professional outcomes through guided digital systems and virtual events.
Senior Transformation Consultant
Senior AI transformation consultant helping Thomson Reuters clients adopt CoCounsel Legal, Tax, and Trade workflows. Leading discovery, responsible-use design, adoption, and measured transformation outcomes.
Travel Consultant III
Travel Consultant III managing complex international reservations, fares, policies, and regulatory requirements. Supporting BCD Travel’s global business-travel technology and human expertise services.
Part Time Workshop Consultant
Part-time Workshop Consultant supporting Starkey Hearing Technologies’ patient outreach events. Consulting with hearing providers and selling advanced hearing products through workshops and one-on-one consultations.
Mulesoft Consultant
MuleSoft Consultant designing APIs and integrations on Anypoint Platform. Connecting SAP S/4HANA with mission-critical systems for federal and DoD clients.