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

PostgreSQL DBA

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

Join to apply for the PostgreSQL DBA role at OpenTable .

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

    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.

    #J-18808-Ljbffr

    Create a job alert for this search

    PostgreSQL DBA • Toronto, ON, CA

    Similar jobs
    Senior DevOps Engineer

    Senior DevOps Engineer

    Accommodations Plus International • Markham, ON, CA
    Full-time
    Quick Apply
    Senior DevOps Engineer / Senior Cloud Infrastructure Engineer (AWS / Linux) Location : Markham, Canada Employment Type : Full-Time About the Role ...Show more
    Last updated: 30+ days ago
    Senior Programmer Analyst - Amico Corporation

    Senior Programmer Analyst - Amico Corporation

    Amico • Richmond Hill, ON, Canada
    Full-time
    The Amico group of companies is looking to fill the on-site role of .To join our growing team, please review the list of responsibilities and qualifications. We look forward to reviewing your r...Show more
    Last updated: 11 days ago • Promoted
    Senior BI Analyst

    Senior BI Analyst

    Black & McDonald Limited • Markham, ON, Canada
    Full-time
    Senior Business Intelligence (BI) Analyst.Black & McDonald's Business Intelligence / IT team is growing! If you are committed and collaborative professional looking to contribute to a hard-wo...Show more
    Last updated: 30+ days ago • Promoted
    Solutions Architect : Snowflake & Cloud Data Solutions

    Solutions Architect : Snowflake & Cloud Data Solutions

    Project X Ltd. • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading data solutions provider located in Toronto is seeking a Solutions Architect to design and implement end-to-end data solutions, utilizing strong expertise in Snowflake and cloud environmen...Show more
    Last updated: 11 days ago • Promoted
    L1 Helpdesk Analyst

    L1 Helpdesk Analyst

    Vaco by Highspring • Stoufville 5 days / week, ON, CA
    Full-time +1
    Our client, a successful multi-location company in Stoufville, is looking to hire a Level 1 Helpdesk Analyst for a full time onsite position. This is a Level 1 technical support position, supporting...Show more
    Last updated: 10 hours ago • Promoted • New!
    Head of Cloud Platform & Compute (GCP / GKE)

    Head of Cloud Platform & Compute (GCP / GKE)

    Wayfair LLC • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading e-commerce company is seeking an experienced Platform Engineering Manager in Toronto.You'll lead a talented team of platform engineers, overseeing the adoption of Google Cloud Platform (G...Show more
    Last updated: 1 day ago • Promoted
    AI & Data Platform Architect

    AI & Data Platform Architect

    GEI Consultants • Markham, ON, Canada
    Full-time
    The AI & Data Platform Architect is responsible for designing and evolving GEI’s enterprise data and analytics foundations, including the platforms, shared services, architectural pattern...Show more
    Last updated: 25 days ago • Promoted
    Technical Consultant (DevOps / AI)

    Technical Consultant (DevOps / AI)

    iTmethods Inc. • GTA, ON, CA
    Full-time
    Quick Apply
    Tmethods is a dynamic leader in managed services, enterprise AI, DevOps, and cloud integration, with over 20 years of expertise supporting organizations across the US, Canada, and Europe.Combining ...Show more
    Last updated: 20 days ago
    PL / SQL Developer

    PL / SQL Developer

    CMiC • Toronto, ON, Canada
    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...Show more
    Last updated: 11 days ago • Promoted
    Azure Data Architect for Data Warehouse, Lake & BI

    Azure Data Architect for Data Warehouse, Lake & BI

    Flexstaf IT • Toronto C6A, ON, Canada
    Full-time
    A reputable IT consulting firm is looking for a Data Modeler in Toronto, Ontario.The candidate should have over 7 years of experience in data modeling, data warehouse design, and expertise in SQL, ...Show more
    Last updated: 1 day ago • Promoted
    Senior Data Architect : Hybrid Toronto, AWS & Data Governance

    Senior Data Architect : Hybrid Toronto, AWS & Data Governance

    Quantum World Technologies Inc. • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading technology firm in Toronto seeks a Data Architect to lead the design and governance of enterprise data solutions. This role involves defining data architecture standards, designing ETL pip...Show more
    Last updated: 2 days ago • Promoted
    Senior Azure Cloud Architect (MSP)

    Senior Azure Cloud Architect (MSP)

    Venture Computers of Canada Inc. • Markham, ON, Canada
    Full-time
    We are seeking a Senior Azure Architect to join our Toronto-based Managed Service Provider team.In this role, you will lead the design, implementation, and management of Azure cloud environments fo...Show more
    Last updated: 30+ days ago • Promoted
    OpenText Exstream Developer - Oracle SQL

    OpenText Exstream Developer - Oracle SQL

    Astra North Infoteck Inc. • Markham, ON, ca
    Full-time
    Quick Apply
    Essential Skills : • OpenText Exstream • Oracle SQL Experience Required : 6-8 years.Show more
    Last updated: 11 days ago
    DSP Engineer (Markham)

    DSP Engineer (Markham)

    Evertz Microsystems Limited • Markham, ON, Canada
    Full-time
    We are looking for DSP engineers responsible to work on DSP algorithm design and implementation on heterogeneous platforms, including CPU, GPU and FPGA.Architect solutions ...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator

    Database Administrator

    freelance.ca • Toronto, Canada
    Full-time
    Title : Database AdministratorLocation : Toronto, ON / Vancouver, BC / HybridContract : 6+ MonthsRequired Skill : PostgreSQL ~ ORACLE SQL ~ Microsoft SQL Server 2019Job Description-Experienced Postgres...Show more
    Last updated: 5 days ago • Promoted
    Data Lineage & Governance Architect

    Data Lineage & Governance Architect

    Compunnel, Inc. • Toronto C6A, ON, Canada
    Full-time
    A data management firm in Toronto is seeking a Data Architect.Responsibilities include collecting and managing metadata, developing data lineage documentation, and ensuring data governance practice...Show more
    Last updated: 9 days ago • Promoted
    DataBricks Architect - Now Hiring!

    DataBricks Architect - Now Hiring!

    Astellas • Markham, ON, Canada
    Full-time
    Do you want to be part of an inclusive team that works to develop innovative therapies for patients? Every day, we are driven to develop and deliver innovative and effective new medicines to patien...Show more
    Last updated: 30+ days ago
    Senior Data Center Infrastructure Engineer

    Senior Data Center Infrastructure Engineer

    Nextologies Limited • Markham, ON, Canada
    Full-time
    Senior Data Center Infrastructure Engineer.Physical infrastructure, networking, power, cooling, and video transport).Act as senior escalation point for data center infrastructure incidents, physica...Show more
    Last updated: 9 days ago • Promoted