Senior Database Consultant, PostgreSQL

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