Staff Database Engineer, ClickHouse

Overview

Own and scale Enterpret's ClickHouse production database on AWS EC2, redesigning how customer data is stored so the database grows with data volume rather than the number of customers.

What you'll do

• Run ClickHouse in production on AWS EC2 end to end, covering performance, capacity, replication, Keeper, upgrades, backups and cost.
• Redesign how customer data is stored so the database grows with data volume, not with the number of customers.
• Make queries fast and writes safe by tuning schemas, partitions and queries, and making deletes, updates and backfills safe to run at scale.
• Write and review Go and Python code, mainly the data-access layers and the ETL pipelines that feed ClickHouse.
• Look after Postgres and Redis alongside ClickHouse.
• Partner with the founding team and platform engineers on the plan to reach 10x scale.
• Review schema and query changes before they ship and help teams scale their applications.
• Build monitoring and runbooks, lead database incidents, and see follow-up fixes through so the same problem does not come back.

What you'll need

• 7+ years in software engineering, including 3+ years hands-on with ClickHouse in production.
• 3+ years at one organization where you built systems from scratch and led projects.
• Deep expertise in ClickHouse at scale: architecture, cluster setup, replication, sharding, Keeper, performance tuning and query optimisation.
• Strong SQL and database design (schemas, partitioning, indexing, storage optimisation).
• Hands-on experience with Postgres and Redis.
• Proficient in Go and Python.
• Solid understanding of ETL/ELT pipelines.
• Comfort working on AWS (especially EC2) and Linux.
• AI-native: uses AI tools daily for coding and debugging, and checks their output.
• A track record of collaborating across teams and mentoring engineers, explaining trade-offs clearly, and making sound calls when the path to scale is not fully mapped out.

Details

• Location: Bengaluru, Onsite.
• Hybrid work setup.