Staff Database Engineer, ClickHouse
EnterpretBengaluru, OnsiteOn-Site
Estimated salary, not published by the employer: Est. ₹17–25 LPA
Needs a free Superjobs account. You'll finish on Enterpret's Greenhouse page.
Skill score
Summary
This person runs and redesigns Enterpret's ClickHouse production database on AWS, scaling customer data storage to 10x while tuning queries, writing Go and Python data-access and ETL code, and leading incidents. It suits a senior database engineer with deep ClickHouse experience who can work through ambiguity at an early-stage startup.
- Function
- Development
- Estimated salary
- Est. ₹17–25 LPA
- Estimated for a staff-level role, ~7 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Bengaluru, Onsite
- Experience
- 7+ yrs
Job description
Overview
- Complex Challenges: Work on a multi-tenant ClickHouse platform with thousands of wide tables, real-time analytics, and the data model changes needed to make it scale.
Roles and responsibilities
- Run ClickHouse in production on AWS EC2 end to end, covering performance, capacity, replication, Keeper, upgrades, backups and cost.
- Redesign how we store customer data so the database grows with data volume, not with the number of customers. Today each customer has its own set of tables, some with 1,000+ custom columns, which puts us at tens of thousands of tables and climbing toward 10x.
- Make queries fast and writes safe. Tune schemas, partitions and queries, and make 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 it.
- 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 the follow-up fixes through so the same problem doesn’t come back.
Skills required
Top skills
- ClickHouse
- Replication and sharding
- ClickHouse Keeper
- Query performance tuning
All skills (8)
- SQL database design
- Postgres
- Redis
- Go
- Python
- ETL/ELT pipelines
- AWS EC2
- Linux
Qualifications
- 7+ years in software engineering, including 3+ years hands-on with ClickHouse in production. Depth matters more than the number of years.
- 3+ years at one organization where you’ve 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), plus hands-on experience with Postgres and Redis.
- Proficient in Go and Python, with a solid understanding of ETL/ELT pipelines and comfort working on AWS (especially EC2) and Linux.
- AI-native: you use AI tools daily for coding and debugging, and you check 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 isn’t fully mapped out.
Other details
- Benefits: Competitive salary, equity, hybrid work setup, premium healthcare, and more.
Company info
About Enterpret
Enterpret is a customer context platform that analyzes customer feedback to surface blind spots and passes the resulting fixes to product teams and coding agents. Its users are AI-native product teams.