Senior Database Consultant, PostgreSQL

Why Pythian At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Founded in 1997, we quickly earned a reputation for solving tough data challenges and have been at the forefront of moving enterprise data from on‑premises to the cloud. We now provide advanced analytics and cloud‑native database solutions to help organizations stay competitive. Our partners include Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake. Location Canada | Remote – Remote Why You The Senior Database Consultant will provide comprehensive support for all database and application infrastructure aspects to a diverse client base, delivering and consulting on services, implementing improvements, and optimizing managed‑service customers. What You Will Be Doing Database Management & Technical Expertise. Solution Design & Implementation: coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance. Infrastructure Analysis & Improvement: analyze client infrastructure and processes, recommending best practices to enhance operations and ensure maximum uptime and recoverability for all databases. Backup & Disaster Recovery: administer backup procedures and disaster recovery plans, proactively monitor to prevent issues, respond to alerts, and troubleshoot operational problems. Data Integrity & Recovery: oversee backup, clustering, mirroring, replication, failover, and restoration of corrupted databases. Action Plan Development: develop and review action plans for maintenance, deployment, and upgrades, ensuring all relevant client documentation is completed. Data Architecture: develop, implement, and maintain complex data architectures, perform data transformation and migration using scripts or stored procedures. Problem Management: lead problem management efforts by assessing incidents for recurring patterns, designing technical procedures for regular requests and changes, and developing action plans and associated documentation. On‑call: participate equally 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. Technical Client Affinity: take on technical client affinity as assigned by the Team Manager. Process Improvement: lead efforts to suggest, recommend, and potentially design/implement new monitoring checks, enhancements to DBC toolkits, and other process improvements. What We Need From You Knowledge and experience installing, configuring, and upgrading PostgreSQL databases and relevant tools. Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP, or Azure. Experience with scripting (bash/python) and software development (C++, Java, Go), plus automation technologies (Ansible, Terraform, Puppet, Chef, SALT). Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors. Very good documentation skills. Nice to haves: ITIL knowledge, contributions to PostgreSQL or other database projects, hands‑on experience monitoring PostgreSQL with Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Nagios, Datadog; cloud‑native and managed database monitoring tools; PostgreSQL on Kubernetes; Prometheus and Grafana monitoring; HA solutions (Patroni, repmgr) with automated failover and cluster health monitoring; EnterpriseDB solutions such as EDB PG Distributed and EDB BigAnimal; backup tools (Barman, pgBackRest, pg_basebackup); migration experience from Oracle, MySQL, MSSQL to PostgreSQL using ora2pg or cloud database migration services; and Debezium or Striim (optional). Experience configuring and managing automated failover, replication, and cluster health monitoring to ensure database resilience and minimal downtime. Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post‑migration. Experience migrating between on‑premises and cloud‑based databases. What You Get In Return Competitive total rewards package and generous paid vacation and sick days. Remote work with a stable internet connection – no daily office travel required. Collaboration with talented professionals and strong industry partnerships. Professional development allowance for training, certifications, and conferences. All equipment needed for remote work, including a laptop and personalized workspace budget. Annual wellness budget covering gym memberships, massages, fitness, and more. Disclaimer The successful applicant will need to fulfill the requirements necessary to obtain a background check.Accommodations are available upon request for candidates taking part in any aspect of the selection process.We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us. Job Details Location: Canada | Remote – Remote Seniority level: Mid-Senior level Employment type: Full‑time Job function: Information Technology Industries: IT Services and IT Consulting #J-18808-Ljbffr