Database Engineer at Jobgether – Canada Creek, Nova Scotia

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Database Engineer in Canada.

This role is ideal for an experienced database professional who thrives in high-volume, mission-critical environments. You will be responsible for designing, operating, and optimizing PostgreSQL clusters at scale, ensuring high availability, performance, and operational excellence. The position requires hands-on expertise in database architecture, automation, and incident response, with a focus on building resilient and scalable systems. You will collaborate closely with engineering, SRE, and platform teams to implement best practices, improve workflows, and enhance the overall reliability of the data infrastructure. This role combines deep technical ownership with opportunities to shape database strategy, drive automation, and influence the design of critical systems across the organization.

• Design, implement, and maintain highly available PostgreSQL clusters with sharding, replication, partitioning, and failover automation.
• Optimize database performance through query tuning, indexing, workload analysis, and schema design improvements.
• Develop and maintain automation for provisioning, backups, recovery, failovers, and schema management using tools like Terraform, Ansible, Python, and Bash.
• Lead database incident response, perform root-cause analysis, and implement long-term reliability improvements.
• Build monitoring, alerting, and observability systems for PostgreSQL clusters, ensuring operational visibility and proactive issue resolution.
• Collaborate with software engineers on query optimization, migrations, schema design, and implementation of database best practices.
• Evaluate emerging tools, AI-assisted solutions, and processes to continuously enhance database infrastructure reliability and efficiency.

• 7+ years of hands-on PostgreSQL experience in high-volume, production-critical environments.
• Deep understanding of PostgreSQL internals, including MVCC, WAL processing, vacuum behavior, query planning, replication, and indexing strategies.
• Strong SQL skills and experience designing schemas and optimizing complex queries.
• Proven expertise in Linux systems, performance tuning, and resource management.
• Experience with automation and infrastructure-as-code tools (Terraform, Ansible, Python, Go, Bash).
• Familiarity with monitoring and observability tools such as Prometheus, Grafana, Datadog, or pg_stat_statements.
• Knowledge of distributed systems concepts, high-availability solutions, backup/recovery strategies, and security/compliance standards.
• Strong troubleshooting, problem-solving, and production incident management skills.
• Preferred: experience with connection pooling, load balancing (PgBouncer, HAProxy), event streaming (Kafka, Debezium), Patroni, and PostgreSQL backup tools (Barman, pgBackRest).

• Competitive salary range of CAD $126,100–$140,100, with variations based on experience and location.
• Comprehensive healthcare benefits, including medical, dental, vision, and wellness programs.
• Remote-first work environment with flexibility to work from anywhere in Canada.
• Professional development opportunities and support for ongoing learning.
• Collaborative, inclusive, and diverse work culture that values innovation and multiple perspectives.
• Employee engagement programs, recognition initiatives, and access to company-wide events.
• Support for AI-assisted tooling and modern infrastructure technologies.