Centric Software

Centric Software

PostgreSQL Database Administrator (Production DBA)

Toronto, ON · Full-time

Sponsorship not specifiedDetected 30 days ago
PythonBashPowerShellSQLPostgreSQLMySQLMongoDBAWSGCPAzureKubernetesTerraformLinuxPrometheusDatadogIncident ResponseCustomer SupportCommunication

Stay score

odds of building a lasting career here

37Risky
Cap-exempt (no lottery)0
Sponsors this role80
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70

Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Employer immigration record

from this employer's Department of Labor filings

Files H-1B transfers

1 transfer filing in the last year, covering 1 worker. Median labor-condition decision: 7 days. An employer that already files transfers is one that can take over an existing H-1B.

Sourced from Department of Labor LCA, PERM and prevailing-wage disclosure data. Employer matching is by name, so figures may be split across an employer's legal entities. Absence of a filing means none appears in our copy of the data, not that none exists.

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • Job title: PostgreSQL Database Administrator (Production DBA)

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.
  • 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.
  • 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.
  • Team: R&D - Customer Support
  • 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.

Requirements

  • 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

Nice to have

  • 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

Skills

  • Centric Software:
  • Our story is one of rapid growth, bold ideas and extraordinary opportunities.
  • Position Details
  • PostgreSQL Database Administrator (Production DBA)
  • R&D - Customer Support

Compensation

  • Compensation: $136K USD

Company info

  • We're here to challenge the status quo-and we're looking for brilliant people who want to do the same.
  • We are seeking a PostgreSQL expert to join our R&D Customer Support team as a Production DBA.
Apply directly at Centric Software →Create a free account for alerts like thisView Centric Software immigration profile

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