Centric Software

PostgreSQL Database Administrator (Production DBA)

Toronto, ON · Full-time

Sponsorship not specifiedDetected 30 days ago

PythonBashPowerShellSQLPostgreSQLMySQLMongoDBAWSGCPAzureKubernetesTerraformLinuxPrometheusDatadogIncident ResponseCustomer SupportCommunication

About the role

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.

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.
Review execution plans, analyze slow queries, and recommend configuration, schema, or indexing changes to optimize production workloads.
Work across development and production environments to trace issues to their source and collaborate with engineering on fixes and product improvements.
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.
R&D - Customer Support
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.
Support customers running PostgreSQL across on-premises, cloud (AWS RDS/Aurora, Azure, GCP), and self-managed deployments.
Experience working in a customer-facing or customer-support-adjacent role.

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.
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.
Required 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).
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

We are seeking a PostgreSQL expert to join our R&D Customer Support team as a Production DBA.

This listing is sourced directly from Centric Software's careers page and normalized into a canonical job model.