Database Reliability Engineer - PostgreSQL
CanadaFull-TimeSenior
Salary126100 - 140100 CAD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 7+ years
- Required Skills
- PostgreSQLPythonSQLBashGoGrafanaPrometheusLinuxTerraformAnsibleDatadog
Requirements
- 7+ years of hands-on PostgreSQL experience in large-scale, high-volume production environments
- Deep understanding of PostgreSQL internals: MVCC, WAL processing, vacuum behavior, locking, query planning
- Experience designing and operating highly available database clusters with automated failover
- Strong performance tuning skills (query optimization, indexing, workload tuning)
- Ability to diagnose database and system issues (Query plans, I/O, memory usage, WAL growth, table/index bloat)
- Experience with backup and recovery strategies (Point-in-time recovery (PITR), durability planning)
- Familiarity with observability and monitoring (Metrics, alerting, performance dashboards like Grafana)
- Understanding of distributed systems concepts (Service discovery, consensus)
- Strong Linux systems knowledge (performance tuning, resource management)
- Experience with scripting and infrastructure-as-code automation
- Strong troubleshooting and problem-solving skills in production environments
- Knowledge of security, compliance, encryption, auditing, access control
- Advanced SQL and strong schema design and query optimization skills
- Solid experience with Linux systems and networking fundamentals
- Experience building automation using Go or Python
- Experience with monitoring tools such as Prometheus, Grafana, Datadog, PMM, pg_stat_statements
Responsibilities
- Design, implement, and operate highly available PostgreSQL clusters (physical/logical replication, sharding, partitioning, failover automation)
- Optimize query performance and indexing strategies
- Perform capacity planning, growth forecasting, and workload modeling
- Own high-availability strategies, including automatic failover, multi-region deployments, and disaster recovery
- Build and maintain automation for provisioning, configuration, backups, recoveries, failovers, vacuum tuning, and schema management
- Develop monitoring and alerting systems for PostgreSQL clusters
- Lead response during database incidents (e.g., performance regressions, replication lag, deadlocks, bloat, storage failures)
- Conduct root-cause analysis and implement long-term fixes
- Partner with software engineers to review SQL queries, optimize schemas, and ensure effective use of PostgreSQL features
- Provide guidance on database design patterns, migrations, version upgrades, and best practices
View Full Description & ApplyYou'll be redirected to the employer's site
