HockeyStack
The Command Center™ for B2B Revenue Teams.
Staff Engineer, Clickhouse
Location
California
Posted
1 day ago
Salary
$200K - $300K / year
Bachelor Degree10 yrs expEnglishETLLinuxSQL
Job Description
• Manage and scale ClickHouse clusters (replication, sharding, distributed tables) to 100s of TBs.
• Maintain data consistency across replicas and shards.
• Profile and optimize heavy ETL/ELT queries and table engines.
• Tune key configs (max_threads, max_memory_usage, merge settings, I/O schedulers).
• Benchmark cluster performance (ingest throughput, query latency, merge rate).
• Proactively work with engineers to optimize schema and query patterns.
• Improve observability stack on DataDog.
• Set up alerting on query performance, merges, replicas, and disk usage.
• Own backup and restore processes (to secondary cluster and S3).
• Plan and execute upgrades with zero or minimal downtime.
• Test and document disaster recovery scenarios.
• Own security within ClickHouse, including access control, encryption where applicable, and adherence to internal and regulatory data protection requirements.
• Resolve production issues and figure ways to prevent them.
• Participate in the Architecture Review process to ensure major changes to the product portfolio have data flow and ClickHouse considerations represented at the very start.
Job Requirements
- 5+ years hands-on ClickHouse experience and 8+ years working as a DBA with distributed OLAP databases
- Have dealt with data volume at scale (i.e. 100s of TBs) & understand the challenges this brings
- Strong systems background with deep understanding of IO performance and network protocols, specifically for high-volume high-throughput analytical workloads (reads and writes!)
- Proficiency in writing and optimizing complex SQL queries
- Experience with Linux server administration and storage (i.e. RAID)
- Experience with monitoring/alerting tools is a strong plus, particularly for database metrics and observability
- Familiarity with data infrastructure, reporting systems, or analytics-heavy SaaS products
Benefits
- Equal Opportunity Employer
- Commitment to fostering an inclusive environment