Talent.com
Senior Database Consultant, PostgreSQL
Senior Database Consultant, PostgreSQLPythian • Ottawa, ON, CA
Senior Database Consultant, PostgreSQL

Senior Database Consultant, PostgreSQL

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

Senior Database Consultant, PostgreSQL – Pythian

Location : Canada, Remote

  • Employment type : Full‑time

About Pythian

Pythian is a multinational cloud‑native data company founded in 1997 that helps teams become modern data‑ and cloud‑centric. We bring expertise in strategic database and analytics services, driving digital transformation and operational excellence. We partner with leaders such as Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake.

Why Pythian

We empower organizations to embrace transformation with AI, advanced analytics, and cloud‑native database solutions. Our focus is on building and maintaining high‑performance, resilient PostgreSQL services for mid‑ and large‑sized businesses.

Role Overview

As a Senior Database Consultant, you will provide comprehensive support for all database and application infrastructure aspects to a diverse client base. This role is crucial for delivering consulting services, implementing improvements, and optimizing managed PostgreSQL services.

Responsibilities

  • Database Management : Configure, monitor, and maintain PostgreSQL servers, including installation, upgrades, and performance tuning.
  • Solution Design & Implementation : Analyze requirements, design, deploy, and administer IT solutions, especially PostgreSQL server configuration and ongoing maintenance.
  • Infrastructure Analysis & Improvement : Review client infrastructure and processes, recommend best practices, and ensure maximum uptime and recoverability.
  • Backup & Disaster Recovery : Administer backup procedures, disaster‑recovery plans, and proactive monitoring to prevent issues.
  • Data Integrity & Recovery : Oversee backup, clustering, mirroring, replication, failover, and restoration of corrupted databases.
  • Action Plan Development : Create, review, and implement action plans for maintenance, deployment, and upgrades while maintaining thorough documentation.
  • Data Architecture : Design, implement, and maintain complex data architectures (normalized and dimensional models, DDL generation), and perform data transformation and migration.
  • Problem Management : Lead incident analysis, develop technical procedures for recurring patterns, and maintain documentation for recurring issues.
  • On‑call : Participate in the team’s on‑call rotation, typically one weekend per month.
  • Client Engagement & Communication : Manage client commitments, prepare status and incident reports, and maintain alignment with client operating procedures.

    • Qualifications

  • Experience installing, configuring, and upgrading PostgreSQL databases and related tools.
  • Proficiency administering PostgreSQL in virtualized or cloud environments (AWS, GCP, Azure).
  • Strong scripting skills (bash, Python) and familiarity with automation tooling such as Ansible, Terraform, Puppet, Chef.
  • Debugging and troubleshooting skills for complex issues.
  • Excellent documentation and communication abilities.
  • Understanding of ITIL service standards and contributions to PostgreSQL projects are a plus.
  • Monitoring experience : Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Datadog, and cloud‑native monitoring tools.
  • Experience with high‑availability solutions (Patroni, repmgr) and automated failover / replication.
  • Knowledge of PostgreSQL backup tools (Barman, pgBackRest, pg_basebackup) and PITR / WAL archiving.
  • Experience migrating from Oracle, MySQL, MSSQL, or other engines to PostgreSQL using tools such as ora2pg or cloud DMS.
  • Experience with Kubernetes, Prometheus, Grafana, and cloud database resilience strategies is a nice‑to‑have.
  • Experience with EnterpriseDB solutions (PGD, BigAnimal) and disaster‑recovery planning is highly desirable.
  • Ability to work within a team, manage client expectations, and support on‑call duties.

    • Benefits

  • Competitive total rewards package and generous vacation policy.
  • Flexible remote work with provided laptop and work‑environment budget.
  • Professional development allowance, certifications, and training days.
  • Wellness and paid vacation, sick days, and a day off to volunteer for charity.
  • Collaborative culture with leading experts in the industry.

    • Disclaimer

    The successful applicant will need to pass a background check. Accommodations are available upon request for any aspect of the selection process. Pythian may use artificial intelligence tools to support portions of the hiring process, but final hiring decisions are made by humans.

    Job Details

  • Seniority level : Mid‑Senior level
  • Employment type : Full‑time
  • Job function : Information Technology
  • Industries : IT Services and IT Consulting

    • #J-18808-Ljbffr

    Créer une alerte emploi pour cette recherche

    Senior Database • Ottawa, ON, CA

    Offres similaires
    Database Team Lead – SQL Server, Data Warehouses & Cloud

    Database Team Lead – SQL Server, Data Warehouses & Cloud

    Canadian Bank Note Company, Limited • Ottawa
    Temps plein
    A leading Canadian financial services provider is seeking a Team Lead, Database Administrator in Ottawa, Ontario.The role involves overseeing the database team, managing enterprise platforms, and e...Voir plus
    Dernière mise à jour : il y a 7 jours • Offre sponsorisée
    Oracle EPM Cloud Principal Consultant - ArcLight Consulting

    Oracle EPM Cloud Principal Consultant - ArcLight Consulting

    ArcLight Consulting • gatineau, qc, ca
    Temps plein
    ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment. For over 15 years, ArcLight experts have provided guidance ...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Senior SQL Developer with Capital markets experience

    Senior SQL Developer with Capital markets experience

    Luxoft • Gatineau, Quebec, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 1 heure • Offre sponsorisée • Nouvelle offre
    Cloud Database Architect – Hybrid Azure & Exadata

    Cloud Database Architect – Hybrid Azure & Exadata

    CGI • Ottawa
    Temps plein
    A leading IT consulting firm is seeking a Cloud Database Solution Architect to drive the design of cloud database ecosystems. Responsibilities include leading architecture in hybrid models and execu...Voir plus
    Dernière mise à jour : il y a 6 heures • Offre sponsorisée • Nouvelle offre
    Senior SQL Developer with Capital markets experience - Luxoft

    Senior SQL Developer with Capital markets experience - Luxoft

    Luxoft • gatineau, qc, ca
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 6 heures • Offre sponsorisée • Nouvelle offre
    Senior Enterprise Architect — AI, Cloud & ERP Solutions

    Senior Enterprise Architect — AI, Cloud & ERP Solutions

    MNP • Ottawa
    Temps plein
    A leading consulting firm in Ottawa is looking for a Senior Microsoft Solution Architect to enhance its Digital Solutions practice. The role involves developing enterprise architecture, collaboratin...Voir plus
    Dernière mise à jour : il y a 11 jours • Offre sponsorisée
    Database Administrator, Oracle E-Business Suite

    Database Administrator, Oracle E-Business Suite

    Stantec • Ottawa
    Temps plein
    Database Administrator, Oracle E-Business Suite.Database Administrator, Oracle E-Business Suite.Database Administrator, Oracle E-Business Suite. Be among the first 25 applicants.Database Administrat...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Platform Solutions Architect - Enterprise Data & Integration

    Platform Solutions Architect - Enterprise Data & Integration

    Tech Insights • Ottawa
    Temps plein
    A leading technology firm in Ottawa is seeking a Solution Architect to optimize the platform architecture and collaborate with various stakeholders. The role requires over 6 years of experience in s...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    ERP & Data Integration Consultant - Public Sector

    ERP & Data Integration Consultant - Public Sector

    FreeBalance • Ottawa
    Temps plein
    A leading technology firm in Ottawa seeks a Technical Services Consultant to deliver high-quality implementation support for Public Financial Management solutions. The ideal candidate will leverage ...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    Donna Cona Inc. • Ottawa
    Temps plein
    Senior Oracle Database Administrator for one of our key clients.A Database and SQL performance expert whose primary responsibility will be to maintain good performance of a complex and mission crit...Voir plus
    Dernière mise à jour : il y a 11 jours • Offre sponsorisée
    Senior Database Architect : Data Integrity & Migrations

    Senior Database Architect : Data Integrity & Migrations

    Kinaxis • Ottawa
    Temps plein
    A global leader in supply chain management is seeking a Database Specialist in Ottawa.This mid-senior level role involves leading complex projects and engagements while ensuring database integrity ...Voir plus
    Dernière mise à jour : il y a 11 jours • Offre sponsorisée
    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    ArcLight Consulting • gatineau, qc, ca
    Temps plein
    ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment. For over 15 years, ArcLight experts have provided guidance ...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Solutions Architect – Cloud, Networking & Enterprise

    Senior Solutions Architect – Cloud, Networking & Enterprise

    Rogers Communications • Ottawa
    Temps plein
    A leading telecommunications company is seeking a Solution Architect to design and implement tailored solutions for large organizations and government agencies. The ideal candidate will have 5+ year...Voir plus
    Dernière mise à jour : il y a 1 jour • Offre sponsorisée
    Senior Storage Consultant

    Senior Storage Consultant

    Targeted Talent • Ottawa, ON, Canada
    Permanent
    We are looking for an experienced.Our client is a large fintech firm with a product that you've likely used many times before. You'll have the opportunity to work on an extremely large, inte...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    Targeted Talent • Ottawa, ON, Canada
    Permanent
    We are looking for an experienced.This is a permanent position that is remote to start with later relocation to.Our client is a global enterprise company with a product that you've likely used....Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Solutions Architect - Enterprise AI & Cloud

    Senior Solutions Architect - Enterprise AI & Cloud

    CMHC • Ottawa
    Temps plein
    A leading public agency in Canada is seeking a Solutions Architect to lead the evaluation, design, and analysis for IT solutions. You will manage the architecture and development of applications and...Voir plus
    Dernière mise à jour : il y a 29 jours • Offre sponsorisée
    Oracle CDM Consultant

    Oracle CDM Consultant

    Quality IT Resourcing • ottawa, on, ca
    Temps plein
    Oracle Customer Data Management (CDM) Functional Consultant.Provide Oracle functional skills / support for Customer Data Management (CDM) and Data Quality. Support Oracle CDM integration with external...Voir plus
    Dernière mise à jour : il y a 6 heures • Offre sponsorisée • Nouvelle offre
    Senior Data Analytics & Governance Consultant

    Senior Data Analytics & Governance Consultant

    KPMG LLP Canada • Ottawa
    Temps plein
    A leading consulting firm in Ottawa is seeking a Senior Consultant for Governance, Risk and Compliance Services (GRCS) focused on Data Analytics. The successful candidate will support cross-function...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée