Senior Database Consultant, PostgreSQL

Why Pythian At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Pythian, a multinational company founded in 1997, has a history of ensuring the reliability and performance of mission‑critical databases. We quickly earned a reputation for solving tough data challenges and were there when the industry moved from on‑premises to cloud environments. As enterprises sought more from their data, we expanded our competencies to include advanced analytics. Today, we empower organizations to embrace transformation and leverage advanced technologies, including AI, to stay competitive. Senior Database Consultant Location: Canada | Remote | - Remote What You Will Be Doing 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 and ensure maximum uptime and recoverability for all databases. Backup & Disaster Recovery: Administer backup procedures and disaster recovery plans, proactively monitoring to prevent issues 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 and maintaining a thorough understanding of client information, including warnings, handoffs, and briefing notes. Data Architecture: Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation), performing 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: Manage client commitments in collaboration with team members, preparing status and incident reports, reviewing reports regularly, and responding 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: 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 (e.g., Initial Reviews, Performance Reviews, Audits) focused on increasing the value Pythian provides to clients. What We Need From You Knowledge and experience in installing, configuring and upgrading PostgreSQL databases & tools relevant to 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) and automation technologies such as Ansible, Terraform, Puppet, Chef, SALT. Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, thinking outside the box to resolve complex issues. Very good documentation skills. Nice-to-haves include ITIL service standards, contributions to PostgreSQL projects, and hands‑on monitoring using Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Nagios, Datadog, or cloud-native monitoring tools such as AWS CloudWatch, Google Cloud Operations (Stackdriver), and Azure Monitor. Experience setting up, configuring, and administering PostgreSQL on Kubernetes. Experience with HA solutions for PostgreSQL, including Patroni and repmgr, managing automated failover, replication, and cluster health monitoring. Experience with EnterpriseDB solutions, such as EDB Postgres Distributed (PGD) and EDB Biganimal. Experience with PostgreSQL backup tools (Barman, pgBackRest, pg_basebackup) and managing Point‑in‑Time Recovery and WAL archiving. Experience migrating from Oracle, MySQL, and MSSQL to PostgreSQL using tools like ora2pg, AWS/GCP/Azure Database Migration Services, and CDC‑based techniques. Experience with Debezium and Striim is not mandatory but beneficial. What You Get In Return Competitive total rewards package and generous paid vacation, sick days, and a day off to volunteer for your favorite charity. Flexibly remote work with no daily travel requirement and a laptop with your choice of OS plus an annual budget to personalize your workspace. Opportunities for professional development, training allowance, and certification support. Support for health and well‑being with an annual wellness budget for gym memberships, massages, fitness, etc. Collaborate with some of the best and brightest in the industry. 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. Seniority level Mid‑Senior level Employment type Full-time Job function Information Technology Industries IT Services and IT Consulting #J-18808-Ljbffr