Senior Database Consultant, PostgreSQLPythian • Ottawa, ON, CA
Senior Database Consultant, PostgreSQL
Pythian • Ottawa, ON, CA
30+ days ago
Job type
- Full-time
Job descriptionDatabase 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. 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. 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. Seniority level : Mid‑Senior level Employment type : Full‑time Job function : Information Technology Industries : IT Services and IT Consulting
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
Qualifications
Benefits
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
#J-18808-Ljbffr
Create a job alert for this search
Senior Database • Ottawa, ON, CA
Similar jobs
A public service organization is seeking an experienced Database Architect for a future opportunity in Ottawa.You will lead the assessment and modernization of the enterprise data ecosystem, focusi...Show more
A leading technology firm in Ontario is seeking an experienced Enterprise Architect to visualize and design data-centric systems.
The role entails significant responsibilities in developing system a...Show more
Hybrid work from home and the Ottawa office.At Pythian we are experts in strategic database and analytics services driving digital transformation and operational excellence.Pythian a multinational ...Show more
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...Show more
A leading business intelligence firm is seeking an Intermediate or Senior Technical Consultant to architect, design, and develop BI applications for clients.
The ideal candidate will have at least 3...Show more
Cloud Database Solution Architect.Location : Ottawa or Calgary preferred | Working Hours : EST.Clearance : Secret (must have resided in Canada for 10+ years).
As a Cloud Database Solution Architect, yo...Show more
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...Show more
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...Show more
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...Show more
Oracle OCM Senior Consulting Manager.Join a global consulting team that helps organizations reimagine the way they work, innovate, and grow.
As a Senior Manager of Organizational Change & Transforma...Show more A public service organization is seeking an experienced Database Architect for a future opportunity.This role focuses on leading assessments and modernizing the enterprise data ecosystem.Candidates...Show more 
A consulting firm seeks a Data Architect to support web portal applications for the Government of Canada.The successful candidate will design high-performing database applications and work closely ...Show more
A startup focused on employee benefits is looking for a Software Engineer in Ottawa, Canada.You will be responsible for designing and scaling backend systems, leading development efforts, and colla...Show more
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 ...Show more A multinational database consulting firm located in Ottawa is seeking a MongoDB Database Consultant.The ideal candidate should have extensive experience with MongoDB and a solid understanding of cl...Show more 
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...Show more
A global technology leader in Canada is looking for a Technical Architect to design and govern complex enterprise solutions.
The successful candidate will have significant experience in Azure Cloud ...Show more A leading business intelligence firm is seeking an Intermediate or Senior Technical Consultant to architect, design, and develop BI applications for clients.
The ideal candidate will have at least 3...Show more
Enterprise Data Architect - Modernization & Strategy Lead
Orangutech • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 18 hours ago • Promoted • New!
Hybrid Enterprise Architect : Data‑Driven Systems & Cloud
Thales • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 5 days ago • Promoted
MongoDB Database Consultant
Pythian • Ottawa
Full-time
Last updated: 14 hours ago • Promoted • New!
Database Team Lead – SQL Server, Data Warehouses & Cloud
Canadian Bank Note Company, Limited • Ottawa
Full-time
Last updated: 6 days ago • Promoted
Data Warehouse & BI Architect
ROSS • Ottawa H2B, ON, Canada
Remote
Full-time +1
Last updated: 18 hours ago • Promoted • New!
Cloud Database Solution Architect
CGI • Ottawa
Full-time
Last updated: 14 hours ago • Promoted • New!
Senior Enterprise Architect — AI, Cloud & ERP Solutions
MNP • Ottawa
Full-time
Last updated: 10 days ago • Promoted
Database Administrator, Oracle E-Business Suite
Stantec • Ottawa
Full-time
Last updated: 30+ days ago • Promoted
Senior Oracle Database Administrator
Donna Cona Inc. • Ottawa
Full-time
Last updated: 10 days ago • Promoted
Oracle OCM Senior Consulting Manager
Codex • Ottawa, Ontario, Canada
Full-time
Last updated: 2 days ago • Promoted
Remote Data Architect - Modernize Enterprise Data
Orangutech • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 30+ days ago • Promoted
Secure Data Architect - Hybrid, High-Performance DB
TV2 Consulting • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 18 hours ago • Promoted • New!
Senior Backend Architect - Remote
Atomic HR • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 2 days ago • Promoted
Senior Database Architect : Data Integrity & Migrations
Kinaxis • Ottawa
Full-time
Last updated: 10 days ago • Promoted
Senior MongoDB DBA & Automation Engineer (Hybrid Ottawa)
Pythian • Ottawa
Full-time
Last updated: 14 hours ago • Promoted • New!
Senior Solutions Architect – Cloud, Networking & Enterprise
Rogers Communications • Ottawa H2B, ON, Canada
Remote
Full-time
Last updated: 18 hours ago • Promoted • New!
Azure Cloud Enterprise Architect - Transformation Leader
Fujitsu Limited • Ottawa H2B, ON, Canada
Full-time
Last updated: 18 hours ago • Promoted • New!
Remote BI Architect : Data Warehouse & Analytics Solutions
ROSS • Ottawa H2B, ON, Canada
Remote
Full-time +1
Last updated: 18 hours ago • Promoted • New!