PostgreSQL DBA

Join to apply for the Postgre

SQL DBA role at Open Table
.

This will be a remote role to start, with plans to transition to hybrid in‑office 2x/week located in downtown Toronto. With millions of diners, 60,000+ restaurant partners and 25+ years of experience, Open Table, 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 Open Table 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.

We are seeking a Postgre

SQL Database Administrator to join our data platform team. In this role, you will be responsible for the build, stability and maintenance of our Postgre

SQL database systems, ensuring their performance, reliability, and security. You will be a key contributor to our data strategy and play a critical role in scaling our infrastructure to support our rapid growth.

• Database Management:
  Install, configure, and maintain Postgre
  
  SQL database servers and related components.
• Performance Tuning:
  Monitor and optimize database performance using tools such as _statements, EXPLAIN, and other Postgre
  
  SQL‑specific utilities. Troubleshoot and resolve performance bottlenecks.
• High Availability & Disaster Recovery:
  Implement and manage high‑availability solutions (e.g., streaming replication, logical replication, failover clusters) and disaster recovery plans.
• Backup & Recovery:
  Develop, test, and maintain robust backup and recovery strategies to ensure data integrity and minimize downtime.
• Security:
  Enforce database security policies, manage user roles and permissions, and perform regular security audits.
• Schema Design & Migration:
  Collaborate with development teams on database schema design, normalization, and managing schema migrations.
• Automation:
  Develop scripts and automation tools for database management tasks, including provisioning, monitoring, and scaling.
• Monitoring & Alerting:
  Set up and manage monitoring and alerting systems to proactively identify and address potential issues.
• Documentation:
  Maintain comprehensive documentation for all database systems, processes, and procedures.

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
• 3 years of experience as a Postgre
  
  SQL DBA, with a deep understanding of Postgre
  
  SQL architecture and internals.
• Proven experience with performance tuning and optimization of large‑scale Postgre
  
  SQL databases.
• Hands‑on experience with high‑availability and disaster recovery solutions (e.g., Patroni, Repmgr, or similar).
• Solid understanding of backup and recovery strategies.
• Proficiency in SQL, shell scripting, and at least one other programming language (e.g., Python, Go).
• Experience with cloud platforms (AWS, GCP, or Azure) and managing databases in a cloud environment.
• Familiarity with containerization and orchestration technologies (Docker, Kubernetes) is a plus.
• Excellent problem‑solving skills and a proactive, "can‑do" attitude.
• Strong communication and collaboration skills to work effectively with cross‑functional teams.

• Experience with other database systems (e.g., Redis, Mongo
  
  DB, MSSQL).
• Experience with infrastructure‑as‑code tools such as Puppet.

• Generous paid vacation + time off for your birthday
• Work from (almost) anywhere for up to 20 days per year
• Focus on mental health and well‑being:
• Company‑paid therapy sessions through Spring Health
• 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
• 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
• Private health and dental…