Database Architect

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

• Location: Santa Clara, CA - In-office at least 4 days a week
• Must be legally authorized to work in the United States for any employer without restrictions, no third-party applications
• Salary is open to discuss depending on skills and experience

We are seeking an experienced Database Architect with experience in systems engineering to lead the design, optimization, and governance of an on‑premise database ecosystem spanning NoSQL/analytic and relational platforms, combining deep database engineering expertise with strong systems architecture skills across computing, storage, networking, virtualization, and security.

RESPONSIBILITIES:

• Architect and maintain scalable ClickHouse clusters for high‑performance analytical workloads
• Design and operate robust HBase clusters
• Implement ingestion and streaming patterns for NoSQL analytics (e.g., Kafka pipelines)
• Architect highly available, scalable deployments of SQL Server or PostgreSQL on physical and virtual servers
• Lead schema and data modeling (OLTP and analytical), including normalization, partitioning, indexing, and lifecycle design
• Implement database access governance, least privilege and auditing
• Partner with networking teams to design low‑latency, high-bandwidth network architectures supporting large-scale relational and analytic workloads

REQUIRED QUALIFICATIONS:

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

PREFERRED QUALIFICATIONS:

• Bachelor of Computer Science or related technical discipline
• Familiarity with MPP/on‑premise analytics ecosystems beyond ClickHouse/HBase
• Any certifications in PostgreSQL, MSSQL, Linux, VMware, or Hadoop ecosystem

We are an equal opportunity employer, and we are an organization that values diversity. We welcome applications from all qualified candidates, including minorities and persons with disabilities.