Ruchir Raj

Software Engineer

Bengaluru, Karnataka, India2 yrs 10 mos experience

Key Highlights

Built a UDF system outperforming Snowflake by 2x.
Expert in query optimization and database internals.
Passionate about game development and system architecture.

Stackforce AI infers this person is a Database Technology Specialist with a strong focus on performance engineering and optimization.

Contact

Skills

Core Skills

Query OptimizationDatabase InternalsDistributed SystemsPerformance Engineering

Other Skills

JavaPython (Programming Language)Apache CalciteSQLPlanning SystemsSystem ArchitectureDeadline OrientedSQL*PlusArchitecture FrameworksData TransferProgramming LanguagesSQL PLConfiguration ManagementCompiler OptimizationRust (Programming Language)

About

Database engineer at e6data working on query optimization and Apache Calcite. Recently graduated from BITS Pilani with dual degrees in Electrical Engineering and Physics. At 24, I've built a complete UDF system from scratch that outperforms Snowflake's implementation by 2x. My work spans implementing Recursive CTEs, writing optimizer rules, and solving complex query planning challenges that directly impact how enterprises process their data. I love diving deep into database internals and turning research papers into production code that scales. Outside of databases, I'm passionate about game development and have experience with Unity and game engine architecture. There's something satisfying about creating these frameworks from scratch whether it's for query execution or games. Both require thinking about systems at a fundamental level, which is where I thrive.

Experience

2 yrs 10 mos

Total Experience

1 yr 3 mos

Average Tenure

3 mos

Current Experience

Paradedb

Database Internals Engineer

Feb 2026 – Present · 3 mos

JavaPython (Programming Language)Query OptimizationDatabase Internals

Career break

Health and well-being

Nov 2025 – Feb 2026 · 3 mos

E6data

Database Internals engineer

Jul 2023 – Nov 2025 · 2 yrs 4 mos · Hybrid

Building high-performance database systems with a focus on query optimization and Apache Calcite.
I've architected and implemented a complete UDF system from scratch that outperforms Snowflake's implementation by 2x. My work spans the entire query engine stack - from implementing Recursive CTEs and optimizer rules to resolving critical planning bugs that impact production workloads.
Recent projects include:
Complete UDF framework integrated into Apache Calcite with advanced query inlining
20+ end-to-end function implementations in distributed query engine
TPC-DS benchmark optimizations and performance improvements
Core contributions to query planner/optimizer affecting enterprise customers
I specialize in turning complex database theory into production systems that scale. Particularly interested in compiler optimization techniques, OLAP systems, and the intersection of performance engineering with distributed computing.