Staff PostgreSQL and ClickHouse Engineer

Shape Nue.io’s PostgreSQL and ClickHouse architecture, using database expertise, migration leadership, and observability to strengthen the company-wide data layer.

This Staff Engineer, Datastores role leads transactional and analytical data systems across Nue.io. You will guide PostgreSQL on AWS, ClickHouse, caching, streaming, and the standards product teams use. Your work includes migrations, query performance, replication, capacity planning, disaster recovery, and architecture for multi-tenant growth.

Key Responsibilities:

• Lead ClickHouse schema, ingestion, CDC, and analytical performance
• Define PostgreSQL migration testing, rollout, and availability strategy
• Guide datastore choices for OLTP, OLAP, cache, and queue workloads
• Build monitoring, load testing, and capacity models
• Review designs, mentor engineers, and align technical stakeholders

Requirements:

• Staff-level impact across teams and multi-quarter technical initiatives
• Expert PostgreSQL knowledge including MVCC, WAL, vacuum, and planner
• Columnar datastore experience with schema and ingestion design
• Large-scale migrations delivering zero data loss and minimal downtime
• Strong observability, Terraform, pooling, migration tooling, and scripting

Use deep database engineering judgment to connect PostgreSQL, ClickHouse, and dependable delivery practices at Nue.io.