Principal Database Engineer (ClickHouse)

Location: Hyderabad, India (3 days per week in office)

Role Overview

Nasuni is expanding its data intelligence and governance capabilities following the acquisition of DryvIQ. As we integrate DryvIQ’s technology into the Nasuni platform, we’re looking for a Principal Database Engineer with deep ClickHouse expertise to architect and scale the analytical database infrastructure powering customer reporting and data intelligence.

Our customers rely on flexible, self-service reporting to analyze their data, applying their own filters, groupings, and queries. As data volumes grow from hundreds of millions to billions—and potentially tens of billions—of records, delivering fast, reliable reporting becomes an increasingly complex engineering challenge. We need someone who can design ClickHouse architectures that perform at scale, not simply optimize individual queries.

Our architecture uses PostgreSQL as the transactional system of record, with data replicated into ClickHouse to power customer-facing analytics and reporting. While PostgreSQL is well established, ClickHouse represents our greatest opportunity to improve performance, scalability, and the customer experience. The challenge is designing efficient data models, ingestion pipelines, and query strategies that deliver responsive reporting even as data volumes and query complexity increase.

In this hands-on, design-focused role, you’ll take technical ownership of ClickHouse architecture, data modeling, ingestion, replication, and query performance. You’ll work closely with application, platform, and infrastructure engineers to make critical architectural decisions, solve complex performance challenges, and build a scalable foundation for future growth.

This is not a traditional DBA maintenance role or an application development position.About the role

Nasuni acquired DryvIQ to expand its data intelligence and governance capabilities, and we're now integrating the DryvIQ platform into Nasuni. PostgreSQL is the system of record, holding the state of every item. That data is replicated into ClickHouse, which powers all customer reporting through a flexible web UI where customers build their own queries.

PostgreSQL runs well today. ClickHouse is where the biggest challenge, and the biggest opportunity, lives. You'll take technical ownership of how data is modeled, laid out, and queried across the whole system, working side by side with application, platform, and infrastructure engineers. This is a design-first, hands-on role.

What you'll do

Design, implement, and optimize ClickHouse databases supporting billions to tens of billions of rows of analytical data.
Make architectural decisions involving ClickHouse table engines, MergeTree-family configurations, materialized views, projections, partitioning, sorting keys, and data layout.
Design efficient schemas for high-dimensional reporting workloads, including exceptionally wide tables approaching 1,000 columns.
Optimize analytical SQL queries, query execution, and customer-facing reporting performance.
Engineer and improve data ingestion, replication, and log collection workflows.
Evaluate tradeoffs among query latency, ingestion throughput, data freshness, storage efficiency, and cost.
Diagnose bottlenecks across databases, ingestion pipelines, and application-generated SQL.
Collaborate with application engineers to understand ORM-generated queries and improve database access patterns without requiring application coding.
Establish performance benchmarks, monitoring, capacity planning, and scale-testing practices.
Use approved AI-assisted tools for investigation and analysis, validating recommendations for correctness, security, and performance.

What you'll bring

Must-Have Qualifications

Deep hands-on experience designing, implementing, tuning, and operating ClickHouse in production.
Strong knowledge of ClickHouse table engines, particularly MergeTree-family engines, materialized views, and projections.
Demonstrated experience designing analytical databases for billions of rows, with ownership of architectural and performance decisions.