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

    Dba • Toronto, ON, CA

    Offres similaires
    Data Analyst - iTeckSoft Inc.

    Data Analyst - iTeckSoft Inc.

    iTeckSoft Inc. • newmarket, on, ca
    Temps plein
    Its a CANADA requirement and the candidate has to be local to Canada.The ideal candidate will have strong SQL expertise, experience with data warehousing, and proficiency in handling complex data s...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Bioinformatician - BugSeq

    Bioinformatician - BugSeq

    BugSeq • newmarket, on, ca
    Temps plein
    BugSeq Bioinformatics is empowering clinical and public health microbiology laboratories to adopt DNA / RNA sequencing and transform diagnostic microbiology. We build BugSeq (https : / / bugseq.BugSeq ser...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Database and Solution Architect

    Database and Solution Architect

    freelance.ca • Toronto, Canada
    Temps plein
    We are looking for a versatile database and solution architecture professional with expertise across data modeling, SQL development, data architecture, database administration, and solution archite...Voir plus
    Dernière mise à jour : il y a 17 jours • Offre sponsorisée
    AI & Data Platform Architect

    AI & Data Platform Architect

    GEI Consultants • Markham, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 1 jour • Offre sponsorisée
    Technical Business System Analyst - richmond hill

    Technical Business System Analyst - richmond hill

    Signature IT World Inc • richmond hill, on, ca
    Temporaire
    Required Skills & Qualifications.Technical Business Systems Analyst.Oracle PLSQL DB and Java-based enterprise applications. Strong SQL skills for data analysis and validation.Experience with REST AP...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Microsoft Dynamics 365 Architect

    Microsoft Dynamics 365 Architect

    Evolvous Limited • richmond hill, on, ca
    Temps plein
    Title : Senior Microsoft D365 Solution Architect (Pre-Sales exp needed).Must be legally eligible to work in Canada.Interview Process : Will have to attend an interview in-person (Total 3 rounds of In...Voir plus
    Dernière mise à jour : il y a 13 heures • Offre sponsorisée • Nouvelle offre
    Senior SQL Server DBA - On-Prem to Azure Platform Lead

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

    RBC • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Senior DB Engineer - PostgreSQL & SQLite (Innovation Lab)

    Senior DB Engineer - PostgreSQL & SQLite (Innovation Lab)

    PIXOMONDO STUDIOS GmbH & Co KG • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 23 jours • Offre sponsorisée
    Senior SQL Database Administrator (Sr. SQL DBA)

    Senior SQL Database Administrator (Sr. SQL DBA)

    freelance.ca • Toronto, Canada
    Temps plein
    Our client, a leading provider in the technology sector, is seeking a Senior SQL Database Administrator (Sr.SQL DBA, you will be part of the Platform Shared Services supporting cross-functional tea...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Technical Business System Analyst - newmarket

    Technical Business System Analyst - newmarket

    Signature IT World Inc • newmarket, on, ca
    Temporaire
    Required Skills & Qualifications.Technical Business Systems Analyst.Oracle PLSQL DB and Java-based enterprise applications. Strong SQL skills for data analysis and validation.Experience with REST AP...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Senior MSSQL DB Architect / Developer - Data & ETL Leader

    Senior MSSQL DB Architect / Developer - Data & ETL Leader

    CI Financial • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 23 jours • Offre sponsorisée
    AML Data Controls Lead — SQL & Python

    AML Data Controls Lead — SQL & Python

    TD Bank • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Senior Azure Cloud Architect (MSP)

    Senior Azure Cloud Architect (MSP)

    Venture Computers of Canada Inc. • Markham, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 21 jours • Offre sponsorisée
    Data Processor - Insurance Brokerage

    Data Processor - Insurance Brokerage

    CHAT Insurance • Markham, ON, Canada
    Temps plein +1
    Town Centre Blvd, Suite 101, Markham, ON L3R 0Y6.Competitive, Based on Experience, a competitive compensation plan including salary, full benefits including extended health and dental plans, paid v...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Oracle DBA

    Oracle DBA

    Astra North Infoteck Inc. • Toronto, ON, ca
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours
    Senior DBA : Oracle GoldenGate & Azure SQL Specialist

    Senior DBA : Oracle GoldenGate & Azure SQL Specialist

    Apex Systems • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    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 23 jours • Offre sponsorisée
    Business Intelligence Architect Developer - EXL

    Business Intelligence Architect Developer - EXL

    EXL • newmarket, on, ca
    Temps plein
    We are seeking a highly skilled.Business Intelligence Architect / Developer.The ideal candidate will have strong expertise in. Design, develop, and maintain BI reports, dashboards, and visualizations ...Voir plus
    Dernière mise à jour : il y a 20 heures • Offre sponsorisée • Nouvelle offre