Staff Postgresql And Clickhouse Architect

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 workloadsLead ClickHouse tables, ingestion pipelines, and analytical performanceDesign partitioning, read scaling, sharding, and tenant isolationDefine migration testing and zero-downtime rollout strategiesReview schemas, queries, design documents, and team standardsRequirements:
Staff-level impact across teams and multi-quarter technical initiativesExpert PostgreSQL internals, indexing, partitioning, and EXPLAIN analysisColumnar datastore experience with schema, ingestion, and tuningProduction experience operating horizontally scaled database architecturesStrong Terraform, scripting, pooling, migration tooling, and observability foundationsApply database architecture, ClickHouse analytics, PostgreSQL depth, and cross-team technical leadership to Nue's company-wide data systems.
#J-18808-Ljbffr