Senior Database Consultant, PostgreSQL - Ottawa - Pythian

    Pythian
    Pythian Ottawa

    1 week ago

    Description

    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
  • Work in company

    Python Developer

    Only for registered members

    Akkodis is seeking the services of an experienced Software Developer (Python) consultant to focus on designing, developing, and maintaining robust server-side applications and infrastructure using a variety of technologies. · ...

    Ottawa, Ontario

    1 month ago

  • Work in company

    Infrastructure Developer

    Only for registered members

    Develop and deploy systems for hosting Halogen's Cloud Management System and solutions. · ...

    Ottawa, Canada

    1 week ago

  • Work in company Remote job

    Senior Database Administrator (34775)

    Only for registered members

    Our Ottawa based client in the Finance industry is looking for Senior SECRET security Cleared Database Administrator to support enterprise storage and database services across on-prem and Azure cloud environments. The Consultant will install configure maintain secure and optimize ...

    Ottawa, Ontario

    1 month ago

  • Work in company

    Database Administrator

    Only for registered members

    The Consultant should have the following qualifications and skills: · A minimum of five (5) years demonstrated experience as a Database Administrator (as a DBA or similar role) with recent demonstrated experience in the following: · ...

    Ottawa, Ontario

    1 month ago

  • Work in company

    DevOps Engineer

    Only for registered members

    InkBridge Networks builds and deploys mission-critical network authentication systems for ISPs and enterprises worldwide. · Support the deployment of highly available infrastructure across single-site and multi-site environments · Help build and configure databases, replication, ...

    Ottawa, Ontario, Canada

    1 week ago

  • Work in company

    Solution Architect

    Only for registered members

    You will be responsible for working with our clients on deployments and solutions with our technology. A high-growth software company that has developed a sensitive information intelligence platform that helps businesses to identify, inventory, categorize, track and trace sensiti ...

    Ottawa, ON

    1 week ago

  • Work in company

    DevOps Engineer

    Only for registered members

    InkBridge Networks está contratando a un Ingeniero DevOps para apoyar el diseño, construcción y despliegue de infraestructura altamente disponible utilizada por millones de usuarios globalmente. · Este rol es ideal para un ingeniero con 1–5 años de experiencia que quiere tener ex ...

    Ottawa $75,000 - $125,000 (CAD) per year

    3 hours ago

  • Work in company

    Python Developer

    Only for registered members

    Akkodis is seeking an experienced Software Developer (Python) consultant to design, develop and maintain robust server-side applications and infrastructure using various technologies. · ...

    Ottawa

    1 month ago

  • Work in company

    Python Developer

    Only for registered members

    Akkodis is seeking the services of an experienced Software Developer (Python) consultant to focus on designing, developing and maintaining robust server-side applications and infrastructure using a variety of technologies. · ...

    Ottawa

    1 month ago

  • Work in company

    DevOps Engineer

    Only for registered members

    InkBridge Networks is hiring a DevOps Engineer to support the design, build, and deployment of highly available infrastructure used by millions of users globally. · ...

    Ottawa, Ontario

    2 weeks ago

  • Work in company

    Senior Full Stack Integrations Developer

    Only for registered members

    We're seeking an experienced Senior Full Stack Developer with a strong integrations and data-platform background to join our team at Pluvo. · Build and maintain integrations with accounting systems such as QuickBooks, Xero, and NetSuite. · Design robust data pipelines connecting ...

    Ottawa

    3 hours ago

  • Work in company

    Senior Full Stack Integrations Developer

    Only for registered members

    We are seeking an experienced Senior Full Stack Developer with a strong integrations and data-platform background to join the team at a critical stage of scale. · ...

    Ottawa, Ontario, Canada

    1 week ago

  • Work in company

    Full-Stack Engineer

    Only for registered members

    We are hiring a Full-Stack Engineer (backend-leaning) who can take ownership of features end to end. This role involves designing, building, and maintaining backend services using Python. · The ideal candidate will have 4+ years of experience in Full-Stack or Backend Engineering, ...

    Ottawa

    2 weeks ago

  • Work in company

    Database Administrator

    Only for registered members

    ++LeverageTek is seeking a Database Administrator for a 12-month contract. · ++Install, configure and maintain all supported database software... · ...

    Ottawa, Ontario

    1 month ago

  • Work in company

    Senior Database Administrator (34775)

    Only for registered members

    Our Ottawa based client in the Finance industry is looking for Senior SECRET security Cleared Database Administrator to support enterprise storage and database services across on-prem and Azure cloud environments. · The Consultant will install configure maintain secure optimize d ...

    Ottawa

    1 month ago

  • Work in company

    Senior Database Administrator (34775)

    Only for registered members

    The client in the Finance industry is looking for Senior Database Administrator to support enterprise storage and database services across on-prem and Azure cloud environments. · ...

    Ottawa

    1 month ago

  • Work in company

    Senior Database Administrator (33988)

    Only for registered members

    · ...

    Ottawa

    1 week ago

  • Work in company

    Intermediate Full Stack Developer

    Only for registered members

    We are seeking a skilled and motivated Intermediate Full Stack Developer to join our growing technical team.In this role, you'll play a crucial part in designing, developing, and maintaining full stack web applications for high-impact government modernization initiatives. · Devel ...

    Ottawa $65,000 - $75,000 (CAD)

    2 weeks ago

  • Work in company

    Full Stack Developer

    Only for registered members

    +Job summary · We are seeking a skilled Intermediate Full Stack Developer to join our growing technical team. · +ResponsibilitiesDevelop and scale software applications using modern full stack technologies. · Prototype and implement new features to address evolving project needs. ...

    Ottawa $65,000 - $75,000 (CAD)

    1 week ago

  • Work in company

    Database Administrator

    Only for registered members

    Install, configure and maintain all supported database software (Oracle Database and Microsoft SQL Server) in High Availability environments. · ...

    Ottawa

    1 month ago

  • Work in company

    Business Data Scientist

    Only for registered members

    About Kinaxis Elevate your career journey by embracing a new challenge with Kinaxis We are experts in tech but it's really our people who give us passion to always seek ways to do things better As such we're serious about your career growth and professional development because Pe ...

    Ottawa, Ontario

    1 month ago

Jobs
>
Ottawa