PostgreSQL Database Consultant

🔥 2 minutes ago

🇺🇸 United States – Remote

💵 $120k - $190k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

💼 Consultant

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 4%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Bitovi

WebsiteLinkedInAll Job Openings

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

📊 Check your resume score for this job

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

Upload Resume