PostgreSQL Database Administrator (Production DBA)

Centric Software

Toronto

Remote

CAD 160,000 - 217,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Centric Software is seeking a PostgreSQL Database Administrator (Production DBA) to join its R&D Customer Support team. The role focuses on in-house Postgres expertise to analyze, troubleshoot, and improve production database environments, ensuring health, performance, and reliability across customer deployments.

Responsibilities include RCA on incidents, query tuning, index strategy, and collaboration with engineering on fixes and product improvements.

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 replication: streaming replication, logical replication, Patroni, or equivalent.
  • Experience with backup and recovery tooling such as pgBackRest, WAL-G, pg_basebackup, or Barman.
  • Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).
  • Strong written and verbal communication skills, with the ability to explain complex database concepts to both technical and non-technical audiences.
  • Located in North America with the ability to work core hours that overlap with the team.

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.

Skills

PostgreSQL
Database administration
SQL tuning
Performance optimization
RCA analysis
Linux scripting
Team collaboration

Tools

PgBouncer
pgBackRest
WAL-G
pg_basebackup

Job description

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 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 replication: streaming replication, logical replication, Patroni, or equivalent.
  • Experience with backup and recovery tooling such as pgBackRest, WAL-G, pg_basebackup, or Barman.
  • Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).
  • Strong written and verbal communication skills, with the ability to explain complex database concepts to both technical and non-technical audiences.
  • Located in North America with the ability to work core hours that overlap with the team.

Preferred Qualifications

  • Experience supporting PostgreSQL on AWS RDS, Aurora Postgres, Azure Database for PostgreSQL, or Google Cloud SQL.
  • Scripting or automation experience in Python, PowerShell, or similar.
  • Familiarity with monitoring/observability tooling (Datadog, New Relic, Prometheus, pganalyze, Sentry).
  • Experience working in a customer-facing or customer-support-adjacent role.
  • Exposure to additional database platforms (Oracle, SQL Server, MySQL, MongoDB) and migration experience to/from Postgres.
  • Experience with infrastructure-as-code (Terraform, CloudFormation) and containerized workloads (Kubernetes).

What Success Looks Like

In the first 90 days, the successful candidate will have ramped up on our product and support workflows, taken ownership of escalated Postgres cases, and begun contributing to internal documentation and knowledge sharing. Within six months, they will be the go-to Postgres resource for the team, materially reducing time-to-resolution on database-related customer issues and partnering with engineering on product improvements informed by field data.

Centric Software provides equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status or genetic information.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PostgreSQL Database Administrator (Production DBA)
PostgreSQL Database Administrator (Production DBA)

Centric Software • Canada

Remote
CAD 173,000 - 211,000
Product Manager - Postgres
Product Manager - Postgres

Jobgether • Canada

Remote
CAD 110,000 - 170,000
Fully Remote
Equity (ESOP)
Tech Allowance
+4
Software Engineer - Postgres Tooling
Software Engineer - Postgres Tooling

Jobgether • Canada

Remote
CAD 120,000 - 180,000
Fully remote India
WeWork allowance
ESOP
+7
Senior System Administrator
Senior System Administrator

Galent • Markham

On-site
CAD 90,000 - 120,000
Principal Software Engineer - Postgres
Principal Software Engineer - Postgres

clickhouse • Toronto

Remote
CAD 314,000 - 443,000
Flexible remote environment
Healthcare contributions
Equity in the company
+3
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Apptoza Inc. • Toronto

Hybrid
CAD 90,000 - 130,000
Database Admin - Oracle, Postgressql
Database Admin - Oracle, Postgressql

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 120,000
Staff Engineer, Datastores
Staff Engineer, Datastores

Nue.io • Toronto

Hybrid
CAD 195,000 - 259,000
Staff Site Reliability Engineer, AWS & Databases
Staff Site Reliability Engineer, AWS & Databases

Jobgether • Canada

Remote
CAD 120,000 - 180,000
Medical, dental, vision
Remote work in Canada
Flexible PTO
+2
Senior Software Engineer - Postgres
Senior Software Engineer - Postgres

clickhouse • Toronto

Remote
CAD 272,000 - 372,000
Remote-friendly
Healthcare
Equity
+3