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

PostgreSQL DBA

OpenTable • Toronto, ON, CA
Il y a plus de 30 jours
Type de contrat
  • Temps plein
Description de poste

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

    Créer une alerte emploi pour cette recherche

    PostgreSQL DBA • Toronto, ON, CA

    Offres similaires
    OIC Cloud Integrations Engineer for Oracle Fusion ERP / PPM

    OIC Cloud Integrations Engineer for Oracle Fusion ERP / PPM

    The Citco Group Limited • Toronto C6A, ON, Canada
    Temps plein
    A global financial services provider in Toronto is seeking an Oracle Integration Cloud (OIC) Developer with a bachelor’s degree in computer science. This mid-senior level role involves developing an...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Enterprise Data Architect (Hybrid / Remote)

    Enterprise Data Architect (Hybrid / Remote)

    Util-Assist Inc. • Newmarket L0G, ON, Canada
    Télétravail
    Temps plein
    A utility consulting firm is seeking a skilled Data Architect to design and implement enterprise data solutions that enable advanced analytics for utility clients. This hybrid / remote role demands pr...Voir plus
    Dernière mise à jour : il y a 13 jours • Offre sponsorisée
    Integration Developer

    Integration Developer

    freelance.ca • Markham, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 8 jours • Offre sponsorisée
    Senior PostgreSQL DBA — High Availability & Performance

    Senior PostgreSQL DBA — High Availability & Performance

    Aarorn Technologies Inc • Markham
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 21 jours • Offre sponsorisée
    GCP Data Architect

    GCP Data Architect

    Software International • Toronto C6A, ON, Canada
    Temps plein +1
    Fortune 100 / 500 / 1000 companies to small and mid‑sized organizations in Canada / US and Europe.We currently have an indefinite contract role as a. This is a 6‑month contract initially, but could be ext...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Cloud Architect — Azure & AWS (Multi-Cloud)

    Senior Cloud Architect — Azure & AWS (Multi-Cloud)

    Zurich 56 Company Ltd • Toronto C6A, ON, Canada
    Télétravail
    Temps plein
    A global insurance provider in Toronto seeks a Senior Cloud Solution Architect to lead the development of complex cloud solutions. This role involves collaborating with stakeholders to translate req...Voir plus
    Dernière mise à jour : il y a 11 jours • Offre sponsorisée
    OFSAA Developer / BSA

    OFSAA Developer / BSA

    Smart IT Frame LLC • Greater Toronto Area, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 7 heures • Offre sponsorisée • Nouvelle offre
    PostgreSQL DBA

    PostgreSQL DBA

    OpenTable • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 7 jours • Offre sponsorisée
    Contract Architect : SDN, Automation & Cloud Infra

    Contract Architect : SDN, Automation & Cloud Infra

    Akkodis group • Toronto C6A, ON, Canada
    Temps plein
    A leading technology solutions provider is seeking an Intermediate Technology Architect for a 1-year contract in Toronto. This role requires expertise in infrastructure, networking, and automation t...Voir plus
    Dernière mise à jour : il y a 19 jours • Offre sponsorisée
    Hybrid Data Architect - Cloud Data Platforms

    Hybrid Data Architect - Cloud Data Platforms

    Slalom • Toronto C6A, ON, Canada
    Télétravail
    Temps plein
    A leading consulting firm in Toronto seeks a Data Architect to work in collaborative teams.The role involves designing and delivering cloud solutions and tackling data challenges for various client...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Strategic Solutions Architect — Enterprise Cloud & Data

    Strategic Solutions Architect — Enterprise Cloud & Data

    Beanfield • Toronto C6A, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 8 jours • Offre sponsorisée
    Business System Analyst

    Business System Analyst

    Cognizant • Greater Toronto Area, Canada
    Temps plein
    Job Title - Financial Business Systems Analyst.Location - Toronto- 3 days / week.Our Data Platform is a cross‑asset pricing and risk management platform. The Data Platform team maintains the strategi...Voir plus
    Dernière mise à jour : il y a 7 heures • Offre sponsorisée • Nouvelle offre
    Business System Analyst

    Business System Analyst

    TechDoQuest • Markham, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 7 heures • Offre sponsorisée • Nouvelle offre
    Senior Database Developer

    Senior Database Developer

    Boyd Interactive • Toronto C6A, ON, Canada
    Temps plein +1
    Pala offers a full spectrum of games across all distribution channels (web, download, tablet & smartphone).In Canada, they offer sports betting and casino games. In the US, they offer casino, bingo,...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Data Lineage & Governance Architect

    Data Lineage & Governance Architect

    Compunnel, Inc. • Toronto C6A, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    freelance.ca • Toronto, Canada
    Temps plein
    Title : Database AdministratorLocation : Toronto, ON / Vancouver, BC / HybridContract : 6+ MonthsRequired Skill : PostgreSQL ~ ORACLE SQL ~ Microsoft SQL Server 2019Job Description-Experienced Postgres...Voir plus
    Dernière mise à jour : il y a 15 jours • Offre sponsorisée
    Senior Information Technology Business Analyst

    Senior Information Technology Business Analyst

    StafinGo • Greater Toronto Area, Canada
    Temporaire
    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...Voir plus
    Dernière mise à jour : il y a 7 heures • Offre sponsorisée • Nouvelle offre
    Data Architect : Snowflake & dbt Platform Leader

    Data Architect : Snowflake & dbt Platform Leader

    BlueMatrix • Toronto C6A, ON, Canada
    Temps plein
    A leading technology firm seeks a Data Architect to evolve their data platform using Snowflake and dbt.The ideal candidate has over 8 years of experience in data architecture, strong capabilities i...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée