PostgreSQL Database Consultant

🕒 Outubro 29

🇺🇸 Estados Unidos – Remoto (EUA)

💵 $120.000 - $190.000 / ano

⏰ Tempo Integral

🟡 Pleno

🟠 Sênior

💼 Consultor

🦅 Patrocina Visto H1B

Esta empresa já patrocinou vistos H1B no passado.

👻 Score fantasma 1%

O que significa: a chance de ninguém estar realmente contratando para esta vaga.Como ler: 60% ou mais significa que achamos que é uma vaga fantasma. Pontuações mais baixas preocupam menos.Como pontuamos: tempo em aberto, republicações, vagas abertas vs tamanho do time, rapidez para fechar vagas, e se o salário está divulgado.Observação: é uma estimativa de dados públicos, não um julgamento da empresa. Vagas reais podem ter pontuação alta, então use como uma dica, não como um fato.

Candidatar-se

Encontrar Vagas Remotas Similares

Bitovi

SiteLinkedInTodas as Vagas

51 - 200 funcionários

Fundada em 2005

💼 Consultoria

📣 Marketing

📦 Logística

Consulting • Marketing • Logistics

A Bitovi é uma equipe colaborativa de especialistas dedicados a ajudar os clientes a entregar rapidamente aplicativos excepcionais. Eles oferecem uma gama abrangente de serviços, incluindo consultoria, treinamento, estratégia, gerenciamento de projetos, design de produtos, desenvolvimento front-end e back-end, e engenharia DevOps. Com foco no desenvolvimento baseado em validação, a Bitovi fez parcerias com clientes notáveis como Yum! Brands e Sam's Club para construir plataformas de e-commerce robustas e soluções inovadoras adaptadas às suas necessidades.

Descrição

• 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

🎯 Requisitos

• 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

🏖️ Benefícios

• 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

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo