ClickHouse Operations Engineer
Core
Automate, manage, and maintain ClickHouse infrastructure to ingest, store, and query trillions of events per year for PostHog's products.
Role type
Senior IC ClickHouse Operations Engineer
Builds
Automated provisioning and scaling systems for large ClickHouse clusters handling 100+ PB of data
Domain
Big Data Infrastructure / OLAP Databases
Deliverable
infrastructure
Required skills
ClickHouse internals, OLAP database architecture, Terraform, Ansible, Kubernetes, Python, high-scale data storage optimization
Preferred skills
Query optimizer development, cloud provider hardware experimentation, Zookeeper
Technologies
ClickHouse, Terraform, Ansible, Kubernetes, Python, AWS, Zookeeper
Responsibilities
Automate dynamic provisioning of ClickHouse instances, optimize node and instance-level performance, investigate and experiment with latest hardware for optimal setup, build systems for cluster scaling, work on query performance tooling
Seniority
Senior, hands-on IC
