ClickHouse & Analytics Infrastructure Expert

I’m Prathyusha, a DevOps & Data Infrastructure Engineer with hands-on experience building and managing analytics infrastructure around ClickHouse, PostgreSQL, PeerDB, and modern data platforms.

Over the past 4 + years, I’ve worked across DevOps, database infrastructure, data migration, replication, and analytics engineering, with a strong focus on building reliable and scalable data systems.

My hands-on experience includes:

• ClickHouse on-premises and open-source deployments

• PeerDB for PostgreSQL-to-ClickHouse replication and CDC

• ClickPipes for scalable data ingestion

• PostgreSQL administration, optimization, and migration

• ClickHouse query and performance optimization

• Data replication and CDC architectures

• Linux, Docker, Git/GitHub, and CI/CD

• Analytics infrastructure and database troubleshooting

• Cloud and server infrastructure

I’ve worked on projects involving:

→ Migrating analytics workloads from PostgreSQL to ClickHouse

→ Building PostgreSQL → ClickHouse replication using PeerDB and ClickPipes

→ Designing and troubleshooting CDC pipelines

→ Optimizing ClickHouse queries and analytical workloads

→ Working with AggregatingMergeTree, Materialized Views, and MergeTree-based architectures

→ Setting up and troubleshooting ClickHouse infrastructure in on-premises environments

→ Improving reliability, scalability, and resource utilization of data platforms

I’m particularly interested in ClickHouse, Data Engineering, Database Infrastructure, CDC, Real-Time Analytics, and Cloud/On-Prem Data Platforms.

My approach: Build reliable foundations, understand the data flow end-to-end, optimize where it matters, and automate what can be automated.

If you're working with ClickHouse, PostgreSQL, PeerDB, ClickPipes, or modern analytics infrastructure, let’s connect.