Talent.com
Postgresql DBA
Postgresql DBAOpenTable • Toronto, ON, CA
Postgresql DBA

Postgresql DBA

OpenTable • Toronto, ON, CA
30+ days ago
Job type
  • Full-time
Job description

This will be a remote role to start, with plans to transition to hybrid in-office2x / week located in 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. 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.
  • 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.
  • 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
  • Focus on your career growth :

  • 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 $75,000-$85,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.

    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.

    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.

    OpenTable, Inc. and its respective subsidiaries (together, ‘OpenTable’, ‘our / we / us’, or ‘Company’) will process your personal data in accordance with applicable data protection laws for the purposes described in our privacy notice (OpenTable (Germany) and OpenTable (All Other Locations)). As part of the application process OpenTable may share your personal data across our group of companies, subject to our privacy notice and applicable laws. In order to consider you for new positions, OpenTable may keep your personal data for 6 months (within the EU) and 2 years (in all other regions), unless otherwise required by applicable law.

    #J-18808-Ljbffr

    Create a job alert for this search

    Dba • Toronto, ON, CA

    Similar jobs
    Senior SQL Database / Data Modelling Developer

    Senior SQL Database / Data Modelling Developer

    Synechron • Toronto
    Full-time
    This range is provided by Synechron.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Direct message the job poster from Synechron.At Synechron, w...Show more
    Last updated: 23 days ago • Promoted
    Senior Database Architect & Data Modeling Lead

    Senior Database Architect & Data Modeling Lead

    Scotiabank • Toronto
    Full-time
    A leading bank in the Americas is seeking a Database Architect in Toronto.This role involves designing and maintaining scalable database solutions and data modeling to enhance business performance....Show more
    Last updated: 17 days ago • Promoted
    Bilingual DBA for SQL, Power BI & Azure

    Bilingual DBA for SQL, Power BI & Azure

    Largeton Group • Toronto
    Full-time +1
    A prominent consulting firm is seeking a Database Administrator (DBA) for a short-term contract in Toronto, Ontario.The ideal candidate will possess strong SQL skills, experience with data manageme...Show more
    Last updated: 23 days ago • Promoted
    Senior SQL Server DBA - On-Prem to Azure Platform Lead

    Senior SQL Server DBA - On-Prem to Azure Platform Lead

    RBC • Toronto
    Full-time
    A leading financial institution in Toronto is seeking an experienced SQL Server DBA Specialist to ensure seamless database operations. The ideal candidate will have over 10 years of experience and a...Show more
    Last updated: 3 days ago • Promoted
    BI Data Architect & Analyst - SQL, ETL, Netezza

    BI Data Architect & Analyst - SQL, ETL, Netezza

    Virtusa • Toronto
    Full-time
    A leading technology services company in Toronto is seeking an experienced Business Analyst to analyze requirements and provide data transformations. The role involves converting business needs into...Show more
    Last updated: 20 hours ago • Promoted • New!
    Senior DB Engineer - PostgreSQL & SQLite (Innovation Lab)

    Senior DB Engineer - PostgreSQL & SQLite (Innovation Lab)

    PIXOMONDO STUDIOS GmbH & Co KG • Toronto
    Full-time
    A leading visual effects company in Toronto is seeking an experienced Database Engineer to join their Innovation Lab.This role involves building and optimizing a web platform with PostgreSQL and SQ...Show more
    Last updated: 23 days ago • Promoted
    Senior MSSQL DB Architect / Developer - Data & ETL Leader

    Senior MSSQL DB Architect / Developer - Data & ETL Leader

    CI Financial • Toronto
    Full-time
    A financial services provider in Toronto is seeking a skilled Senior Database Architect / Developer (MSSQL) to manage and optimize SQL databases. Responsibilities include data purging, index optimiz...Show more
    Last updated: 23 days ago • Promoted
    AML Data Controls Lead — SQL & Python

    AML Data Controls Lead — SQL & Python

    TD Bank • Toronto
    Full-time
    Une banque internationale à Toronto recherche un développeur AML Data Controls pour son équipe de gestion des crimes financiers. Vous serez responsable de concevoir et de maintenir des systèmes de c...Show more
    Last updated: 3 days ago • Promoted
    Platform DBA

    Platform DBA

    Intact • Toronto
    Full-time +1
    We are looking for a forward thinking Oracle DBA who will contribute to the evolution of the current database platforms and who understands both business and overall IT frameworks within a financia...Show more
    Last updated: 3 days ago • Promoted
    Oracle DBA

    Oracle DBA

    Astra North Infoteck Inc. • Toronto, ON, ca
    Full-time
    Quick Apply
    Required Skill : Digital : EAS : Oracle Cloud Infrastructure~Oracle DBA.TD BANK- Oracle DBA - JD • Minimum 8 years of DBA working experience building, deploying and administering distributed Oracle D...Show more
    Last updated: 30+ days ago
    Senior DBA : Oracle GoldenGate & Azure SQL Specialist

    Senior DBA : Oracle GoldenGate & Azure SQL Specialist

    Apex Systems • Toronto
    Full-time
    A leading technology consulting firm in Toronto is seeking a Database Administrator (DBA) with expertise in Oracle GoldenGate and SQL Azure. The role involves optimizing database performance, implem...Show more
    Last updated: 3 days ago • Promoted
    PL / SQL Developer

    PL / SQL Developer

    CMiC • Toronto
    Full-time +1
    Are you looking to work for a growing software company? How about a socially responsible company that cares about its employee? If so, keep reading! CMiC has been awarded one of Canada's Best Manag...Show more
    Last updated: 17 days ago • Promoted
    DBA - Oracle

    DBA - Oracle

    Nexus Systems Group Inc. • Toronto
    Full-time +1
    Database Administrator – Senior.Fully Onsite - 5 days per week - downtown Toronto.Oracle E-Business Suite installation and configuration experience. Experience and expert knowledge of Oracle E-Busin...Show more
    Last updated: 23 days ago • Promoted
    Database Administrator (DBA / SQL)

    Database Administrator (DBA / SQL)

    Onico Solutions • Richmond Hill
    Full-time +1
    The Database Administrator (DBA / SQL) will manage and support a corporate SQL database environment in addition to managing and executing software implementations. Responsible for administering SQL se...Show more
    Last updated: 2 days ago • Promoted
    Oracle 11g DBA

    Oracle 11g DBA

    ROSS • Markham
    Full-time +1
    Our client is a medium sized software vendor.They are located in Markham and looking for an Oracle 11g DBA for a three month contract to ideally start immediately. Part of your work will be onsite a...Show more
    Last updated: 2 days ago • Promoted
    Senior ETL Architect : Azure Data Factory & Oracle PL / SQL

    Senior ETL Architect : Azure Data Factory & Oracle PL / SQL

    Maarut Inc • Toronto
    Full-time
    An innovative IT services firm is seeking a talented data integration specialist to join their dynamic team.In this mid-senior level role, you will leverage your extensive experience in ETL process...Show more
    Last updated: 23 days ago • Promoted
    Senior DB Platform Engineer : PostgreSQL & Oracle Cloud

    Senior DB Platform Engineer : PostgreSQL & Oracle Cloud

    Canadian Imperial Bank of Commerce • Toronto
    Full-time
    A leading financial institution in Ontario is seeking a Senior Consultant, Database Infrastructure & Cloud Platforms to join their Cloud Engineering and Transformation team.This role involves provi...Show more
    Last updated: 1 day ago • Promoted
    Agile Database Developer : SQL, ETL & Power Platform

    Agile Database Developer : SQL, ETL & Power Platform

    Monex Canada • Toronto
    Full-time
    A leading financial solutions provider in Ontario, Canada, seeks a skilled Database Developer to enhance their internal application development. This role involves designing and implementing databas...Show more
    Last updated: 23 days ago • Promoted