About Me
Software engineer who loves building things that live on the internet.
I'm Samba Siva Reddy, a Member Technical Staff @ Zoho | PostgreSQL & Distributed Systems based in Chennai, India. I specialized in developing distributed database architectures and contributing to PostgreSQL internals. And also building full-stack web applications with modern technologies and best practices.
With a passion for clean code and user experience, I enjoy tackling complex problems and turning them into simple, elegant solutions. I'm particularly interested in distributed systems, developer tools, and open-source software.
When I'm not coding, you can find me writing technical articles, contributing to open-source projects, or exploring new technologies. I believe in continuous learning and sharing knowledge with the developer community.
Experience
Member Technical Staff
Working on core PostgreSQL internals including the Planner, Executor, COPY framework, and connection management to support Zoho's distributed database architecture, ensuring correctness, scalability, and performance.
- Designed and implemented a cursor-based pagination system inspired by NoSQL access patterns, eliminating OFFSET-based inefficiencies and enabling efficient, scalable pagination across distributed shards.
- Developed a PostgreSQL extension to cache join orders using queryId, reducing planning overhead for complex queries (8+ joins) while preserving cost-based optimization behavior.
- Upgraded critical database internals by migrating Planner and Executor modules from PostgreSQL 11.4 to 17.2, ensuring long-term compatibility with the evolving open-source ecosystem.
- Optimized the COPY framework for high-throughput data transfer, integrating SCP and Netcat with LZ4/Snappy compression, achieving up to 1.5× improvement in query execution performance.
- Designed and executed a zero-downtime PostgreSQL cluster migration using a Blue-Green deployment strategy, ensuring uninterrupted production traffic while transitioning between major PostgreSQL versions.