Senior PostgreSQL Database Engineer (Hybrid)

OpenTable; Toronto; On-site; CAD 115,000 - 125,000; Full time

Benefits offered by this job

Work from anywhere (20 days/yr)

Mental health support

Headspace subscription

Annual week off

Paid parental leave

Paid vacation & birthday leave

Travel discounts

Employee resource groups

Paid time off (20 days)

Private health and dental insurance

Life and Disability insurance

Job summary

OpenTable in Toronto is seeking a Senior PostgreSQL Database Engineer to lead reliability, performance, and evolution of OpenTable’s PostgreSQL platform in a hybrid role based in Toronto.

You will own complex database initiatives end-to-end, partner with cross-functional engineering teams to build an automated and cloud-native data platform, and serve as a senior escalation point for production systems.

Qualifications

• 7+ years of experience administering, engineering, and operating PostgreSQL or equivalent complex database systems in production environments.
• Deep knowledge of PostgreSQL architecture and internals, including query planning, locking, write-ahead logging, replication, vacuuming, and connection management.
• Proven experience designing, implementing, and operating high-availability, disaster-recovery, and failover solutions for critical database infrastructure.
• Proficiency in SQL and at least one programming or automation language such as Python, Go, or Bash.
• Hands-on experience building database automation using infrastructure-as-code or configuration management tools.

Responsibilities

• 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.
• Drive cloud database strategy across multi-region environments, balancing performance, security, cost efficiency, and operational excellence.
• Serve as a senior technical escalation point during production incidents, conducting root-cause analysis and implementing long-term reliability improvements.
• Mentor engineers, establish reusable operational patterns, and raise technical standards through clear documentation and cross-team collaboration.

Skills

PostgreSQL

SQL

Python

Go

Bash

IaC

Tools

Grafana

Prometheus

OpenTelemetry

Job description

Toronto, Canada

Location: Toronto, Canada (Hybrid Position, in office 2 days per week)

With millions of diners, 60,000+ restaurant partners and 25+ years of experience, OpenTable, part of Booking Holdings, Inc. (NASDAQ: BKNG), is an industry leader with a passion for helping restaurants thrive. Our world-class technology empowers restaurants to focus on what matters most – their team, their guests, and their bottom line – while enabling diners to discover and book the perfect restaurant for every occasion.

Every employee at OpenTable has a tangible impact on what we do and how we do it. You’ll also be part of a global team and its portfolio of metasearch brands. Hospitality is all about taking care of others, and it defines our culture.

About the Job

As a Senior PostgreSQL Database Engineer, you will provide technical leadership for the reliability, performance, scalability, security, and evolution of OpenTable’s PostgreSQL platform. You will own complex database initiatives end-to-end, partner with cross-functional engineering teams to build an automated and cloud-native data platform, and serve as a senior escalation point for production systems. In this hybrid role based in Toronto, you will establish modern database practices and ensure database infrastructure supports business growth while maintaining high availability. Your work will directly empower engineering teams and ensure a seamless, reliable experience for millions of diners and restaurants worldwide.

Responsibilities

• 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.
• Drive cloud database strategy across multi-region environments, balancing performance, security, cost efficiency, and operational excellence.
• Serve as a senior technical escalation point during production incidents, conducting root-cause analysis and implementing long-term reliability improvements.
• Mentor engineers, establish reusable operational patterns, and raise technical standards through clear documentation and cross-team collaboration.

Minimum Qualifications

• 7+ years of experience administering, engineering, and operating PostgreSQL or equivalent complex database systems in production environments.
• Deep knowledge of PostgreSQL architecture and internals, including query planning, locking, write-ahead logging, replication, vacuuming, and connection management.
• Proven experience designing, implementing, and operating high-availability, disaster-recovery, and failover solutions for critical database infrastructure.
• Proficiency in SQL and at least one programming or automation language such as Python, Go, or Bash.
• Hands-on experience building database automation using infrastructure-as-code or configuration management tools.

Preferred Qualifications

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

Benefits and Perks

• Work from (almost) anywhere for up to 20 days per year
• Focus on mental health and well-being:
• Company-paid therapy sessions through SpringHealth
• Company-paid subscription to Headspace
• Annual company-wide week off a year - the whole team fully recharges (and returns without a pile-up of work!)
• Paid parental leave
• Generous paid vacation + time off for your birthday
• Focus on your career growth:
• Access to thousands of on-demand e-learnings
• Travel Discounts
• Employee Resource Groups
• 20 days of paid time off
• Private health and dental insurance
• Life and Disability insurance

The best connections happen face-to-face, whether you’re sitting down to dinner or having coffee with a coworker. That’s why OpenTable has adopted a hybrid workplace model. This role aligns with that approach, with an expectation of coming into the office two days a week—giving employees the best of both worlds: in-person collaboration and flexibility.

The expected range of compensation for this position based in Toronto, Canada, is $115,000-$125,000 CAD.There are a variety of factors that go into determining a compensation range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required.

We offer a competitive base salary and benefits including: health benefits; flexible spending account; retirement benefits; life insurance; paid time off (including PTO, paid sick leave, medical leave, bereavement leave, floating holidays and paid holidays); and parental leave benefits. This role is eligible to be considered for an annual bonus and equity grant.

#LI-Hybrid

#LI-BR1