Senior Database Consultant, PostgreSQL in Canada Creek, Nova Scotia at Jobgether
Explore Related Opportunities
Job Description
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Database Consultant, PostgreSQL based in Canada.
This role is a highly technical, client-facing consulting position focused on designing, optimizing, and maintaining mission-critical PostgreSQL database environments across diverse enterprise clients.
You will act as a trusted advisor, ensuring database reliability, performance, and scalability across cloud and hybrid infrastructures while supporting complex operational needs.
The position involves deep hands-on work with PostgreSQL architecture, including high availability, disaster recovery, migrations, and performance tuning in production environments.
You will collaborate closely with clients and internal teams to troubleshoot issues, implement best practices, and drive continuous improvement in database operations.
This role also requires strong expertise in automation, cloud platforms, and observability tools to enhance system efficiency and resilience.
You will contribute to strategic database initiatives while ensuring service excellence in a fast-paced, global managed services environment.
- Design, implement, and manage PostgreSQL database solutions, including configuration, upgrades, and ongoing administration across cloud and on-prem environments.
- Ensure high availability, disaster recovery, and data integrity through replication, failover mechanisms, backup strategies, and restoration processes.
- Analyze client database infrastructures and recommend performance, scalability, and reliability improvements aligned with best practices.
- Lead troubleshooting and problem management efforts, identifying root causes, resolving complex incidents, and preventing recurrence.
- Develop and maintain database architectures, including schema design, data modeling, and migration strategies across different database systems.
- Collaborate with clients and internal teams to deliver technical solutions, manage expectations, and ensure service quality and alignment with operational standards.
- Participate in on-call rotations and support continuous service availability for mission-critical environments.
- Strong hands-on experience administering PostgreSQL databases in production environments, including installation, configuration, upgrades, and performance tuning.
- Solid experience with cloud platforms such as AWS, Azure, or GCP, including database monitoring and operational management.
- Expertise in high availability and replication solutions (e.g., Patroni, repmgr) and disaster recovery strategies.
- Experience with database backup and recovery tools such as pgBackRest, Barman, and pg_basebackup, including PITR and WAL archiving.
- Strong scripting and automation skills (Bash, Python) with familiarity in infrastructure automation tools (Ansible, Terraform, Chef, Puppet, or Salt).
- Experience with database monitoring and observability tools such as Prometheus, Grafana, Datadog, Zabbix, or similar platforms.
- Experience with database migrations across heterogeneous systems (Oracle, MySQL, MSSQL to PostgreSQL) using tools like ora2pg or cloud migration services.
- Strong troubleshooting, analytical thinking, and documentation skills with the ability to resolve complex technical issues independently.
- Experience with Kubernetes-based PostgreSQL deployments and EDB solutions is a strong asset.
- University degree in Computer Science, Engineering, or equivalent practical experience is considered an advantage.
- Fully remote work model with flexibility to work from anywhere in Canada.
- Competitive compensation aligned with experience and market benchmarks.
- Comprehensive training and professional development support, including certification opportunities.
- Annual wellness budget to support physical and mental well-being.
- Generous paid time off, including vacation, sick leave, and volunteer days.
- Home office setup support with equipment and personalization budget.
- Opportunity to work on complex, enterprise-scale PostgreSQL environments with global clients.