Senior Database Consultant, PostgreSQL

Senior Database Consultant, PostgreSQL Apply for the Senior Database Consultant, PostgreSQL role at Pythian . Location: Canada | Remote Why Pythian At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Founded in 1997, Pythian has earned a reputation for solving tough data challenges and enabling enterprises to move from on‑premises to cloud environments. Today we empower organizations to embrace transformation and leverage advanced technologies, including AI, to stay competitive. Why You The Senior Database Consultant will provide comprehensive support for all database and application infrastructure aspects to a diverse client base. This role is crucial for delivering and consulting on services, as well as for implementing improvements and optimizations for managed services 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 current operational procedures. This includes ensuring maximum uptime and recoverability for all databases. Backup & Disaster Recovery: Administer backup procedures and disaster recovery plans. This involves proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems. Data Integrity & Recovery: Oversee backup, clustering, mirroring, replication, failover, and the 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/reviewing action plans and associated documentation. Oncall: Participate equally in the team’s on call rotation, typically one weekend per month. Client Engagement & Communication: Client Commitments: Make, manage, and meet client commitments in collaboration with team members. Reporting & Communication: Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries. Client Alignment: Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any pacing concerns. Technical Client Affinity: Take on technical client affinity as assigned by the Team Manager. Process Improvement: Innovation & Improvement: Participate in and, at times, 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 in installing, configuring, and upgrading PostgreSQL databases & tools relevant in PostgreSQL Administration. Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP or Azure. Experience with scripting (bash/python) and software development (C++, Java, Go) Automation technologies such as 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: Understanding of ITIL, contributions to PostgreSQL projects, monitoring using Prometheus, Grafana, NAGIOS, pgAdmin, Zabbix, Datadog, and cloud monitoring tools. Experience with PostgreSQL HA solutions (Patroni, repmgr) and failover, replication, cluster health monitoring. Experience with enterprise PostgreSQL solutions such as EDB Postgres Distributed and EDB BigAnimal. Proficiency in PostgreSQL backup tools (Barman, pgBackRest, pg_basebackup) and point‑in‑time recovery. Experience migrating from Oracle, MySQL, MSSQL to PostgreSQL and optimizing schema conversions. Experience migrating between on‑premises and cloud‑based databases. Experience with Debezium or Striim is beneficial but not mandatory. What You Get In Return Competitive total rewards package. Remote work with flexible hours and no daily travel. Collaboration with a world‑class team. Training allowance and professional development days. All equipment needed to work from home, including an annual workspace budget. Annual wellness budget, generous vacation and sick days, and a paid day to volunteer for a charity. 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. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Information Technology #J-18808-Ljbffr