PostgreSQL Database Administrator

5 days ago

Ottawa ON, Ottawa Census Division, ON; Ontario, Canada Centric Software Full-time

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 solutionsto 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.

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 solutionsto 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 pro