Lead On-Prem Data Architect - ClickHouse HBase & PostgreSQL

Pop-Up Talent; Santa Clara (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

Pop-Up Talent is seeking an experienced Database Architect to lead the design, optimization, and governance of an on‑premise database ecosystem across NoSQL and relational platforms. The role demands deep database engineering and strong systems architecture across computing, storage, networking, virtualization, and security.

The candidate will architect ClickHouse for analytics, operate HBase, design SQL Server/PostgreSQL deployments, and ensure governance and auditing.

Qualifications

• At least 8 years of architecture/engineering experience in on‑prem environments.
• Proven experience architecting and operating ClickHouse at scale.
• Deep expertise with MS SQL Server and PostgreSQL including HA/DR and replication.
• Hands‑on with HBase internals: HDFS, region servers, ZooKeeper, compactions.
• Strong Linux (RHEL) and Windows Server systems engineering background.
• Proficiency with VMware and Hyper‑V virtualization and enterprise storage.
• Scripting/automation skills: PowerShell, Bash, Python or Ansible.

Responsibilities

• Architect and maintain scalable ClickHouse clusters for analytics workloads.
• Design and operate robust HBase clusters.
• Implement ingestion and streaming patterns for NoSQL analytics (Kafka pipelines).
• Deploy highly available SQL Server or PostgreSQL on physical/virtual servers.
• Lead schema and data modeling (OLTP/analytical) including partitioning and indexing.
• Implement database access governance, least privilege and auditing.
• Collaborate with networking to design low‑latency, high‑bandwidth architectures.

Skills

Database architecture

Systems engineering

Scripting/automation

High‑availability design

Performance tuning

Education

Bachelor of Computer Science or related technical discipline

Tools

ClickHouse

HBase

SQL Server

PostgreSQL

Linux (RHEL)

Windows Server

VMware

Hyper‑V

Ansible

PowerShell

Bash

Python

Job description

Pop-Up Talent is seeking an experienced Database Architect to lead the design, optimization, and governance of an on‑premise database ecosystem across NoSQL and relational platforms. The role demands deep database engineering and strong systems architecture across computing, storage, networking, virtualization, and security.

The candidate will architect ClickHouse for analytics, operate HBase, design SQL Server/PostgreSQL deployments, and ensure governance and auditing.