PostgreSQL DBA job opportunity at OpenTable.

Home Jobs In Canada Tag: Infrastructure Engineering PostgreSQL DBA position at OpenTable


bot
OpenTable PostgreSQL DBA
Experience: Highly Experienced
Pattern: full-time
Country:
apply Apply Now
Salary:
Status:

Infrastructure Engineering

Copy Link Report
degreeOND
loacation Toronto,, Canada
loacation Toronto,....Canada

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, 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. The Role We are seeking a PostgreSQL Database Administrator to join our data platform team. In this role, you will be responsible for the build, stability and maintenance of our PostgreSQL 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. Key Responsibilities Database Management: Install, configure, and maintain PostgreSQL database servers and related components. Performance Tuning: Monitor and optimize database performance using tools such as pg_stat_statements, EXPLAIN, and other PostgreSQL-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. Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience). 3 years of experience as a PostgreSQL DBA, with a deep understanding of PostgreSQL architecture and internals. Proven experience with performance tuning and optimization of large-scale PostgreSQL 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. Bonus Points (Optional) Experience with other database systems (e.g., Redis, MongoDB, MSSQL). Experience with infrastructure-as-code tools such as Puppet. Benefits: 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 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 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 insurance Life and Disability insurance There are a variety of factors that go into determining a salary range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required. The range for this Toronto, Canada based role is $100,000-$110,000 CAD. 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. Work Environment & Flexibility At OpenTable, we pride ourselves on fostering a global and dynamic work environment. As a team member with us, you will benefit from a schedule tailored to accommodate a global workforce operating across multiple time zones. While the majority of your responsibilities may align with conventional business hours, there will be instances where you are expected to manage communications - via calls, Slack messages, or emails - outside of regular working hours to effectively collaborate with international colleagues, respond to restaurant partners, and/or address urgent matters. OpenTable will always abide by and consider local laws and regulations. Inclusion We’re committed to creating a workplace where everyone feels they belong and can thrive. We know the best ideas come when we bring different voices to the table, so we're building a team as dynamic as the diners and restaurants we serve—and fostering a culture where everyone feels welcome to be themselves. If you need accommodations during the application or interview process, or on the job, we’re here to support you. Please reach out to your recruiter to request any accommodations.

Other Ai Matches

Workforce Management Supervisor (Hybrid, Mexico City) Applicants are expected to have a solid experience in handling Customer Support related tasks
Account Executive Applicants are expected to have a solid experience in handling International RSS related tasks
Senior Software Engineer - Hospitality (Frontend) Applicants are expected to have a solid experience in handling Product Engineering related tasks
Associate Account Manager Applicants are expected to have a solid experience in handling International RSS related tasks
Senior Product Designer, Restaurant Platform Applicants are expected to have a solid experience in handling Design related tasks
Account Executive Applicants are expected to have a solid experience in handling International RSS related tasks
District Director - New York City Applicants are expected to have a solid experience in handling Major Markets related tasks
Account Manager, Central Queue Applicants are expected to have a solid experience in handling Central Queue related tasks
Account Executive Applicants are expected to have a solid experience in handling International RSS related tasks
Account Executive, Hotels Applicants are expected to have a solid experience in handling International RSS related tasks
GTM Lead, Strategic Initiatives (Hybrid, Toronto) Applicants are expected to have a solid experience in handling Product Marketing related tasks
Contact Center Workforce & Scheduling Supervisor (Hybrid, Mexico City) Applicants are expected to have a solid experience in handling Customer Support related tasks
Software Engineer II - Hospitality (Frontend) Applicants are expected to have a solid experience in handling Product Engineering related tasks
Principal Product Manager, Market Expansion Applicants are expected to have a solid experience in handling Product related tasks
Staff Engineer (Front End) Applicants are expected to have a solid experience in handling Product Engineering related tasks
Associate Manager, Consolidation & Reporting Applicants are expected to have a solid experience in handling Finance OT related tasks
remote-jobserver Remote
Associate Account Manager Enterprise Applicants are expected to have a solid experience in handling Global Enterprise related tasks
Director, Product Design (TMS & Private Dining) Applicants are expected to have a solid experience in handling Design related tasks
Integrated Marketing Manager Applicants are expected to have a solid experience in handling Restaurant Marketing related tasks
Director, Risk & Controls Applicants are expected to have a solid experience in handling Controllership - OT related tasks
Content Strategy Manager Applicants are expected to have a solid experience in handling Diner Marketing related tasks
Senior Software Engineer - Tables and Experiences (Frontend) Applicants are expected to have a solid experience in handling Product Engineering related tasks
Senior Product Manager, Table Management System Applicants are expected to have a solid experience in handling Product related tasks