Senior Database Consultant, PostgreSQL

Pythian; Ontario; Remote; CAD 90,000 - 120,000; Full time

Job summary

A leading company in strategic database and analytics services is seeking a Senior Database Consultant specializing in PostgreSQL. This remote role involves managing database infrastructure, providing technical oversight, and ensuring high availability solutions. Join a collaborative environment with opportunities for professional development and flexible work arrangements.

Benefits

Competitive rewards

Flexible remote work

Training budget

Home office equipment

Wellness benefits

Qualifications

• Experience installing, configuring, and upgrading PostgreSQL.
• Knowledge of monitoring tools and cloud-native monitoring.
• Understanding of database resilience and disaster recovery strategies.

Responsibilities

• Provide support for PostgreSQL databases, including configuration and optimization.
• Design and implement complex data architectures.
• Participate in client communication and pre-sales activities.

Skills

PostgreSQL

Problem Management

Scripting

Tools

Ansible

Terraform

Python

Java

Go

Prometheus

Grafana

Job description

Join to apply for the Senior Database Consultant, PostgreSQL role at Pythian

About Pythian

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Founded in 1997, we have a reputation for solving tough data challenges and have expanded our expertise from on-premises to cloud environments, including advanced analytics.

Role : Senior Database Consultant

Location : EST / GMT | Remote

Why Join Us

We empower organizations to leverage advanced technologies, including AI, and have strong partnerships with major cloud providers. Our expertise in data and cloud technologies makes us a trusted partner for business transformation.

Responsibilities

• Provide support across all aspects of database and application infrastructure, including configuration, administration, and optimization of PostgreSQL databases.
• Manage backup procedures, disaster recovery, proactive monitoring, and troubleshooting.
• Oversee backup, clustering, replication, failover, and recovery processes; develop action plans and client documentation.
• Design and implement complex data architectures, including data migration and transformation.
• Own Problem Management, assess incidents, and develop technical procedures.
• Provide technical oversight and mentorship to team members.
• Participate in client communication, reporting, and pre-sales activities as needed.
• Contribute to process improvements and team training.
• Be available for 24 / 7 escalations.
• Experience installing, configuring, and upgrading PostgreSQL, including in cloud environments (AWS, GCP, Azure).
• Scripting and development skills (bash, python, C++, Java, Go).
• Experience with automation tools (Ansible, Terraform, Puppet, Chef, SALT).
• Knowledge of monitoring tools (Prometheus, Grafana, Zabbix, Nagios, Datadog) and cloud-native monitoring (CloudWatch, Stackdriver, Azure Monitor).
• Experience with high availability solutions (Patroni, repmgr), backup tools (pgBackRest, Barman), and migration techniques.
• Understanding of database resilience, replication, and disaster recovery strategies.
• Optional but beneficial : experience with Kubernetes, EnterpriseDB solutions, and performance tuning.

What You Will Gain

• Competitive rewards, flexible remote work, and a collaborative environment.
• Training budget and professional development opportunities.
• Home office equipment and wellness benefits.

Additional Information

This position is active and open; background checks are required. Accommodations available upon request.