Senior PostgreSQL Database Engineer

Join OpenTable as a Senior PostgreSQL Database Engineer, where you will lead the design, architecture, and lifecycle management of PostgreSQL environments. You will automate database processes, partner with cross-functional teams, and serve as a senior technical escalation point during production incidents. This hybrid role is based in Toronto and offers generous benefits, including paid volunteer time, enriched learning opportunities, and mental health support.

Missions

• Lead the design, architecture, and lifecycle management of PostgreSQL environments to ensure high availability, disaster recovery, and scalable performance.
• Automate provisioning, major-version upgrades, monitoring, and credential rotation to reduce manual effort and operational toil across database infrastructure.
• Partner with Product and Data Engineering teams to review database designs, optimize schemas, improve query performance, and establish safe migration practices.

Profil recherché

- 7+ years of experience administering, engineering, and operating PostgreSQL or equivalent complex database systems in production environments

- Hands-on experience building database automation using infrastructure-as-code or configuration

- Proficiency in SQL and at least one programming or automation language such as Python, Go, or Bash

- Proven experience designing, implementing, and operating high-availability, disaster-recovery, and failover solutions for critical database infrastructure

- Experience operating PostgreSQL in public cloud platforms, Kubernetes, or containerized environments

- Experience with telemetry and observability platforms such as Grafana, Prometheus, or OpenTelemetry

- Familiarity with supplementary data platforms such as Redis, MongoDB, OpenSearch, or distributed databases

- Experience improving developer productivity through self-service database provisioning and platform automation