PostgreSQL Database Administrator (Production DBA)

免费注册后解锁"你的匹配分 vs 高分画像"与个人技能缺口。

About Centric Software: Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes. We equip retail, fashion, luxury, footwear, outdoor, home and consumer goods brands with pioneering best-of-breed solutions to plan, design, develop, source, comply, buy, make, price, allocate, sell and replenish products. Our technology powers brands to streamline processes, drive efficiency and operate with confidence in an ever-changing market. Our story is one of rapid growth, bold ideas and extraordinary opportunities. We’re here to challenge the status quo—and we’re looking for brilliant people who want to do the same. No matter where you are in the world, this is your chance to be part of something exceptional. Position Summary We are seeking a PostgreSQL expert to join our R D Customer Support team as a Production DBA. This role is focused on bringing deep Postgres expertise in-house to analyze, troubleshoot, and improve production database environments, perform root cause analysis on issues ranging from long-running queries to hosting environment problems and heavy traffic scenarios, and ensure our customers’ PostgreSQL deployments remain healthy, performant, and reliable. While the primary focus is production operations, the DBA will also work across development environments as needed to trace issues to their source and collaborate with engineering on fixes. Position Details Job title: PostgreSQL Database Administrator (Production DBA) Team: R D – Customer Support Location: Remote (US/Canada) Employment Type: Full-time Compensation: $136K USD Key Responsibilities Serve as the PostgreSQL expert and primary Production DBA within the R D Customer Support team, driving the stability, performance, and reliability of customer-facing database environments. Perform root cause analysis (RCA) on production incidents spanning query performance, database configuration, infrastructure-level bottlenecks, and traffic/load conditions. Diagnose and resolve complex PostgreSQL performance, availability, and data-integrity issues, including query tuning, index strategy, vacuum/auto vacuum behavior, and lock contention. Troubleshoot and analyze production PostgreSQL systems across diverse hosting environments, ensuring performance, availability, and data integrity. Review execution plans, analyze slow queries, and recommend configuration, schema, or indexing changes to optimize production workloads. Support customers running PostgreSQL across on-premises, cloud (AWS RDS/Aurora, Azure, GCP), and self-managed deployments. Work across development and production environments to trace issues to their source and collaborate with engineering on fixes and product improvements. Advise on high-availability and disaster-recovery architectures including streaming replication, logical replication, failover, backup/restore (pg_basebackup, pgBackRest, WAL-G), and point-in-time recovery. Create and maintain internal knowledge-based articles, runbooks, and best-practice documentation for the support team. Mentor support engineers and developers on Postgres internals, SQL tuning, and operational best practices. Participate in on-call rotation for critical customer escalations as needed. Required Qualifications Minimum 5 years of hands-on experience as a PostgreSQL DBA, with deep knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices. Proven track record managing PostgreSQL in production environments, including incident response, root cause analysis, and performance optimization under heavy traffic. Strong SQL skills, including query optimization and execution-plan analysis (EXPLAIN / EXPLAIN ANALYZE). Experience with PostgreSQL performance tuning: indexing strategies, autovacuum, connection pooling (PgBouncer), and configuration tuning (postgresql.conf). Experience with high availability and repl

关于Centric Software：Centric Software® 是全球领导者，为各种规模的零售商、品牌和制造商提供创新的、支持AI的产品从概念到商业化的平台。我们为零售、时尚、奢侈品、鞋类、户外、家居和消费品品牌提供业界领先的先锋解决方案，用于规划、设计、开发、采购、合规、购买、制造、定价、分配、销售和补货产品。我们的技术赋能品牌简化流程、提升效率，并在不断变化的市场中自信运营。我们的故事是一个快速增长、大胆创意和非凡机遇的故事。我们在这里挑战现状——我们正在寻找同样想要挑战现状的优秀人才。无论你身处世界何处，这都是你参与非凡事业的机会。

职位概述

我们正在寻找一位PostgreSQL专家加入我们的研发客户支持团队，担任生产DBA。该职位专注于将深厚的Postgres专业知识引入内部，以分析、排查和改进生产数据库环境，对从长时间运行的查询到托管环境问题和 heavy traffic 场景等问题进行根因分析，并确保我们客户的PostgreSQL部署保持健康、高性能和可靠。虽然主要关注点是生产运营，但DBA也会根据需要跨开发环境工作，以追溯问题根源并与工程团队协作修复。

职位详情

职位名称：PostgreSQL数据库管理员（生产DBA）
团队：研发 – 客户支持
地点：远程（美国/加拿大）
雇佣类型：全职
薪酬：136K美元

主要职责

在研发客户支持团队中担任PostgreSQL专家和主要生产DBA，推动面向客户的数据库环境的稳定性、性能和可靠性。
对生产事件进行根因分析（RCA），涵盖查询性能、数据库配置、基础设施层面的瓶颈以及流量/负载状况。
诊断和解决复杂的PostgreSQL性能、可用性和数据完整性问题，包括查询调优、索引策略、vacuum/auto vacuum行为和锁争用。
排查和分析跨多种托管环境的生产PostgreSQL系统，确保性能、可用性和数据完整性。
审查执行计划，分析慢查询，并建议配置、模式或索引变更以优化生产工作负载。
支持客户在本地部署、云环境（AWS RDS/Aurora、Azure、GCP）和自管理部署中运行PostgreSQL。
跨开发和生产环境工作，追溯问题根源，并与工程团队协作进行修复和产品改进。
就高可用性和灾难恢复架构提供建议，包括流复制、逻辑复制、故障转移、备份/恢复（pg_basebackup、pgBackRest、WAL-G）和时间点恢复。
为支持团队创建和维护内部知识库文章、运行手册和最佳实践文档。
在Postgres内部机制、SQL调优和运营最佳实践方面指导支持工程师和开发人员。
根据需要参与关键客户升级的on-call轮值。

必备资格

至少5年作为PostgreSQL DBA的实操经验，深入了解Postgres内部机制（MVCC、WAL、查询规划器、锁、缓冲区管理）和运营最佳实践。
具有在生产环境中管理PostgreSQL的可靠业绩记录，包括事件响应、根因分析和重负载下的性能优化。
强大的SQL技能，包括查询优化和执行计划分析（EXPLAIN / EXPLAIN ANALYZE）。
具有PostgreSQL性能调优经验：索引策略、autovacuum、连接池（PgBouncer）和配置调优（postgresql.conf）。
具有高可用性和复制经验

⚑ 岗位信息收录自公开招聘页（Himalayas），以雇主官网为准