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

    PostgreSQL DBA • Toronto, ON, CA

    Similar jobs
    Integration Developer

    Integration Developer

    freelance.ca • Markham, Canada
    Full-time
    We’re currently hiring for the position of.Senior Data Integration Developer (Informatica & Snowflake) and.If you have relevant experience, we’d love to hear from you. Job Title : Senior Data Integra...Show more
    Last updated: 8 days ago • Promoted
    Java Integration Architect- OptaPlanner Open source - richmond hill

    Java Integration Architect- OptaPlanner Open source - richmond hill

    Galent • richmond hill, on, ca
    Full-time
    Top 3 skills required for this role : .Core Technologies : Java 8+, SpringBoot, RESTful APIs, Microservices.Cloud Expertise : AWS (EC2, Lambda, RDS, S3, CloudWatch). Optimization : OptaPlanner for constr...Show more
    Last updated: 13 hours ago • Promoted • New!
    Senior Java Developer (Trading Systems) - richmond hill

    Senior Java Developer (Trading Systems) - richmond hill

    Luxoft • richmond hill, on, ca
    Full-time
    Building a risk applications and tools for innovative international top-tier hedge fund from the ground up, comprising the systems for traders, pre-trade checks and analysis, risks and limits manag...Show more
    Last updated: 5 days ago • Promoted
    Business Systems Analyst - newmarket

    Business Systems Analyst - newmarket

    Experis • newmarket, on, ca
    Full-time
    Business Systems Analyst (BSA).Proven ability to gather and analyze requirements from multiple stakeholder groups and translate them into well‑structured user stories. Business Systems Analyst exper...Show more
    Last updated: 13 hours ago • Promoted • New!
    Senior PostgreSQL DBA — High Availability & Performance

    Senior PostgreSQL DBA — High Availability & Performance

    Aarorn Technologies Inc • Markham
    Full-time
    A technology solutions provider is seeking a Senior PostgreSQL System Administrator in Markham, ON.The candidate will be responsible for managing large-scale PostgreSQL environments, optimizing dat...Show more
    Last updated: 21 days ago • Promoted
    Développeur / configurateur Documentum - newmarket

    Développeur / configurateur Documentum - newmarket

    Chrome Technologies • newmarket, on, ca
    Permanent
    Nous recherchons un Développeur / configurateur.Ce poste est en mode 100% télétravail et peut être réalisé depuis l'extérieur du Canada. La maîtrise parfaite du français est toutefois obligatoire.La...Show more
    Last updated: 13 hours ago • Promoted • New!
    OFSAA Developer / BSA

    OFSAA Developer / BSA

    Smart IT Frame LLC • Greater Toronto Area, Canada
    Full-time
    Location : Toronto, ON | Vancouver, BC | Halifax, NS.Work Model : Hybrid – 4 days onsite.Domain : Banking & Financial Services. At Smart IT Frame, we connect top talent with leading organizations acros...Show more
    Last updated: 16 hours ago • Promoted • New!
    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: 30+ days ago • Promoted
    Azure Cloud Engineer (Databases & DevOps Focus)- 4 days a week Onsite at Toronto, ON- MUST

    Azure Cloud Engineer (Databases & DevOps Focus)- 4 days a week Onsite at Toronto, ON- MUST

    Q1 Technologies, Inc. • toronto, on, ca
    Full-time
    Job Description : Azure Cloud Engineer (Databases & DevOps Focus).Toronto, ON- 3- 4 days a week Onsite.Long Term Contract(6 Months to start with). We are seeking an experienced Azure Cloud Engineer w...Show more
    Last updated: 13 hours ago • Promoted • New!
    PostgreSQL DBA

    PostgreSQL DBA

    OpenTable • Toronto
    Full-time
    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, OpenTab...Show more
    Last updated: 7 days ago • Promoted
    Business System Analyst - TechDoQuest

    Business System Analyst - TechDoQuest

    TechDoQuest • markham, on, ca
    Full-time
    Document Authoring Business Systems Analyst II.We are currently recruiting for a positive and collaborative Document Authoring Business Systems Analyst II for our Markham office.You will work close...Show more
    Last updated: 13 hours ago • Promoted • New!
    Strategic Solutions Architect — Enterprise Cloud & Data

    Strategic Solutions Architect — Enterprise Cloud & Data

    Beanfield • Toronto C6A, ON, Canada
    Full-time
    A leading telecommunications company in Toronto is looking for a Solutions Architect to design end-to-end solutions that align technology with business goals. The role involves managing solution des...Show more
    Last updated: 8 days ago • Promoted
    Senior Salesforce SPIFF and Territory Management Consultant (Canada - Remote) - newmarket

    Senior Salesforce SPIFF and Territory Management Consultant (Canada - Remote) - newmarket

    CloudLabs Inc • newmarket, on, ca
    Remote
    Full-time
    CloudLabs Inc was founded in 2014 with the mission to provide exceptional IT & Business consulting services at a competitive price, to help clients realize the best value from their investments.Wit...Show more
    Last updated: 13 hours ago • Promoted • New!
    AWS AI Developer - AIDEV 26-00838

    AWS AI Developer - AIDEV 26-00838

    NavitasPartners • Markham, ON, Canada
    Full-time
    Onshore Canada (preferably Greater Toronto Area) – Hybrid (2–3 days onsite).A leading organization is seeking an AWS AI Developer to support a conversational AI solution built on Amazon...Show more
    Last updated: 9 days ago • Promoted
    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: 18 days ago • Promoted
    Business System Analyst

    Business System Analyst

    HISH IT SERVICES • newmarket, on, ca
    Full-time
    Job type : Contract(6 Months) - High possibility of Extention.The Data Product Analyst serves as a critical bridge between business stakeholders, analytics teams, and data management groups.This rol...Show more
    Last updated: 13 hours ago • Promoted • New!
    Senior Information Technology Business Analyst

    Senior Information Technology Business Analyst

    StafinGo • Greater Toronto Area, Canada
    Temporary
    Hiring : Senior IT Business Analyst with Public Sector.Contract Duration : 9 months to start with potential of additional 7 months extension. Hybrid – up to 3 days per week onsite.This role will provi...Show more
    Last updated: 16 hours ago • Promoted • New!
    Senior Portfolio Data Architect – Hybrid (FinServ)

    Senior Portfolio Data Architect – Hybrid (FinServ)

    Brainhunter Systems Ltd • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading consulting firm is seeking a Senior Portfolio Architect to support a financial services client in Toronto.This hybrid role requires on-site work 3 days a week. The successful candidate wil...Show more
    Last updated: 12 days ago • Promoted