Architect Nue's PostgreSQL and ClickHouse systems while guiding migrations, analytics, and multi-tenant scaling from a remote or hybrid Canadian setting. Own the data layer's future.
This Staff Engineer, Datastores role combines deep database engineering with company-wide architectural leadership. You will determine workload placement across transactional, analytical, caching, and streaming systems. Your scope includes AWS managed PostgreSQL, ClickHouse architecture, schema design, replication, capacity planning, and standards that product teams follow.
Key Responsibilities:
Guide datastore choices for OLTP, OLAP, cache, and queue workloads
Lead ClickHouse tables, ingestion pipelines, and analytical performance
Design partitioning, read scaling, sharding, and tenant isolation
Define migration testing and zero-downtime rollout strategies
Review schemas, queries, design documents, and team standards
Requirements:
Staff-level impact across teams and multi-quarter technical initiatives
Expert PostgreSQL internals, indexing, partitioning, and EXPLAIN analysis
Columnar datastore experience with schema, ingestion, and tuning
Production experience operating horizontally scaled database architectures
Solid Terraform, scripting, pooling, migration tooling, and observability foundations
Apply database architecture, ClickHouse analytics, PostgreSQL depth, and cross-team technical leadership to Nue's company-wide data systems.
J-18808-Ljbffr
📌 Staff Postgresql And Clickhouse Architect Toronto
🏢 Nue
📍 Toronto