Senior Database Consultant, PostgreSQL
New
Fully remote work model with flexibility to work from anywhere in Canada.Full-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- AWSPostgreSQLPythonBashGCPKubernetesAzureTerraformAnsible
Requirements
- 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.
Responsibilities
- 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.
View Full Description & ApplyYou'll be redirected to the employer's site
