Senior PostgreSQL Database Engineer (Hybrid)

OpenTable; Toronto (OH); Hybrid; USD 83,000 - 90,000; Full time

Benefits offered by this job

Work from almost anywhere

Hybrid workplace

Health benefits

Paid time off

Retirement benefits

Parental leave

Life and disability insurance

Professional development funds

Travel discounts

Job summary

OpenTable in Toronto is seeking a Senior PostgreSQL Database Engineer to lead reliability, performance, and scalability of our PostgreSQL platform. This hybrid role blends on-site collaboration with remote flexibility and centers on building a cloud-native data platform for millions of diners and restaurants worldwide.

You'll own complex database initiatives end-to-end, mentor engineers, and partner with Product and Data Engineering teams to optimize schemas, automate provisioning, and ensure

Qualifications

• 7+ years of PostgreSQL administration, engineering, and production operations.
• Deep knowledge of PostgreSQL architecture, query planning, replication, vacuuming, and WAL.
• Experience designing high-availability, disaster-recovery, and failover for critical DB infra.
• Proficiency in SQL and at least one programming/automation language (Python/Go/Bash).
• Hands-on experience with infrastructure-as-code or config management for DB automation.

Responsibilities

• Lead design, architecture, and lifecycle management of PostgreSQL environments for high availability and performance.
• Automate provisioning, upgrades, monitoring, and credential rotation across DB infrastructure.
• Review DB designs with Product/Data Engineering; optimize schemas and migrations.
• Drive cloud DB strategy across multi-region envs balancing cost, security, and reliability.
• Serve as escalation point during incidents, perform root-cause analysis, implement fixes.
• Mentor engineers and raise standards with reusable operational patterns.

Skills

PostgreSQL expertise

SQL

Python

Go

Bash

Automation

Infrastructure as Code

Kubernetes

Observability

OpenTelemetry

Tools

Terraform

Docker

Kubernetes

Grafana

Prometheus

OpenTelemetry

OpenSearch

Redis

MongoDB

Job description

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
• Paid volunteer time
• Focus on your career growth:
• Development Dollars
• Leadership development
• 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