Senior PostgreSQL Database Engineer (Hybrid)
Job Summary
Location: Toronto Canada (Hybrid Position in office 2 days per week)
With millions of diners 60000 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. Youll 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.
As a Senior PostgreSQL Database Engineer you will provide technical leadership for the reliability performance scalability security and evolution of OpenTables 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 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.
- 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.
- 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.
- 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.
- 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 youre sitting down to dinner or having coffee with a coworker. Thats 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 weekgiving employees the best of both worlds: in-person collaboration and flexibility.
The expected range of compensation for this position based in Toronto Canada is $115000-$125000 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
Required Experience:
Senior IC
About Company
Book online, read restaurant reviews from diners, and earn points towards free meals. OpenTable is a real-time online booking network for fine dining restaurants.