Database Administrator (PostgreSQL)

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

The Role

We are seeking a PostgreSQL Database Administrator to join our data platform 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 pgstatstatements 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

Bonus Points (Optional)

Benefits :

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 $100000-$110000 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

Were 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 were building a team as dynamic as the diners and restaurants we serveand fostering a culture where everyone feels welcome to be themselves.

If you need accommodations during the application or interview process or on the job were here to support you. Please reach out to your recruiter to request any accommodations.

Required Experience :

Unclear Seniority

Key Skills

Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 100000 - 110000