Staff Engineer, Datastores (PostgreSQL)

Location: Canada; remote or hybrid within Canada

Base pay: CA$195,000–CA$259,000 per year

Company

hirify.global is an agentic, headless, composable revehirify.global platform that combines pricing, quoting, orders, metering, usage, billing, and revehirify.global operations for modern SaaS companies.

What you will do

• Set the multi-year datastore strategy across PostgreSQL, ClickHouse, caching, and streaming.
• Own reliability, availability, performance, cost, SLOs, error budgets, and operational standards for production datastores.
• Design and deliver horizontally scalable, multi-tenant architectures supporting 10x growth, including partitioning, read scaling, tenant isolation, sharding, placement, and rebalancing.
• Lead the migration to fully managed, highly available PostgreSQL with zero data loss and minimal downtime.
• Own ClickHouse architecture, schema design, ingestion, CDC pipelines, query performance, monitoring, capacity planning, resilience, backups, disaster recovery, and zero-downtime schema migrations.
• Set engineering standards, mentor engineers, support Billing, Lifecycle, Data & Integrations, and DevEx, participate in on-call and infrastructure work, and grow the datastore function.

Requirements

• 10+ years in backend, infrastructure, or data platform engineering, including 5+ years owning production databases at scale in SaaS environments.
• Staff-level impact setting technical direction across multiple teams, completing multi-quarter initiatives, and aligning engineers and leadership on difficult trade-offs.
• Expert PostgreSQL knowledge, including MVCC, vacuum, WAL, the planner, query optimization, EXPLAIN analysis, indexing, partitioning, and replication.
• Hands-on experience with a columnar or OLAP datastore, ideally ClickHouse, including schema design, ingestion, and analytical performance tuning.
• Experience designing and operating horizontally scaled, multi-tenant database architectures and production replication topologies.
• Experience leading large-scale database migrations with zero data loss and minimal downtime.
• Deep experience with managed AWS databases, including RDS, Aurora, and/or serverless PostgreSQL such as NeonDB, Aurora Serverless v2, or Supabase.
• Strong observability practice with tools such as CloudWatch, pganalyze, HyperDX, or Datadog, including defining and operating against SLOs.
• Platform engineering experience with Infrastructure as Code, connection pooling, schema migration tooling, and Python or Bash scripting.
• Hands-on fluency with AI coding agents and developer tools, plus excellent written and verbal communication, a team-first approach, and a bachelor's degree in Computer Science, Engineering, or equivalent practical experience.

Nice to have

• Experience with Redis, Memcached, Kafka, Debezium, or ClickPipes.
• Experience with MySQL/MariaDB, NoSQL datastores such as DynamoDB, internal data platforms, or self-service database tooling.
• Experience applying SOC 2, GDPR, or other compliance frameworks to data management.
• Domain knowledge in revehirify.global operations, billing, or financial systems.
• Experience with GitLab CI/CD, open-source database contributions, public talks, or technical writing.

Culture & Benefits

• Flexible remote or hybrid work arrangement within Canada.
• Full-time employment with health, vision, dental, and life insurance.
• Staff+ individual contributor growth path with company-wide technical ownership.
• Collaborative, supportive, high-energy environment focused on learning, ownership, and rapid growth.
• Work on infrastructure for SaaS, finance, payments, and revehirify.global lifecycle products.