Jayant Anand

Software Engineer

Pune, Maharashtra, India3 yrs 9 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Expert in designing scalable distributed systems.
Proven track record in performance optimization.
Strong background in database internals and query execution.

Stackforce AI infers this person is a SaaS expert specializing in distributed systems and database performance.

Contact

Skills

Core Skills

Distributed SystemsDatabase InternalsPerformance OptimizationDatabase ManagementScalabilityQuery Optimization

Other Skills

C++AI-assisted debuggingC/C++Performance TuningC (Programming Language)GitNetwork protocol managementIntegration technologiesPandas (Software)MultithreadingData analysisComputer NetworkingGoogle Cloud SQLAmazon AuroraYugabyteDB

About

Software Engineer (SDE-2) at SingleStore, working on high-performance distributed systems and database infrastructure. I build low-latency, horizontally scalable systems with a focus on concurrency, memory efficiency, and production reliability. Graduated from IIT Dhanbad. My work spans distributed databases, query execution, columnar storage, and large-scale ingestion systems. I’ve worked on scaling systems handling millions of records per second and tens of thousands of concurrent connections, while improving observability and debuggability. At SingleStore, I work on pipeline execution, metadata systems, and cross-node scalability, including concurrency models and production debugging. Previously at Yugabyte, I worked on PostgreSQL-compatible systems, connection pooling, and protocol-level optimizations, including PgBouncer performance and prepared statements. I’m primarily interested in systems problems involving low latency, high throughput, and fault-tolerant design. Core Areas: Distributed Systems • Low-Latency Systems • Database Internals • Concurrency • Memory Management • Performance Optimization • Networking • Scalability • C/C++ • Go • Python • PostgreSQL • Kafka

Experience

3 yrs 9 mos

Total Experience

1 yr 10 mos

Average Tenure

2 yrs 1 mo

Current Experience

Singlestore

Software Developer

May 2024 – Present · 2 yrs 1 mo · Hyderabad, Telangana, India · Remote

Designed and implemented core changes to make data pipelines horizontally scalable by offloading batch and error metadata to columnstore storage, eliminating aggregator bottlenecks.
Built and integrated an activity_tracking_id for pipelines, enabling end-to-end aggregation of CPU and memory metrics and significantly improving observability and diagnostics.
Improved pipeline debuggability by introducing an AI-assisted debugging workflow using a LangChain-based LLM agent to analyze pipeline errors and performance regressions.
Led the migration of the pipelines test suite from Python 2 to Python 3, improving reliability and long-term maintainability.
Work closely with low-level database internals, query execution, and distributed systems.

Distributed SystemsC++Database Internals

Yugabyte

2 roles

Software Engineer

Aug 2022 – Apr 2024 · 1 yr 8 mos

Scaled number of connection per node from 100 to 30,000!
As a Lead Software Developer at YugabyteDB, I took ownership of the Ysql connection manager layer and made significant improvements in performance and scalability. I extended the number of database connections per node from 100 to an impressive 30,000, enhancing the system's capabilities.
I also implemented support for Protocol-level Prepared Statements in PgBouncer, a critical enhancement for database management. This came at the cost of a minor increase in average delay but delivered substantial benefits in terms of query optimization and security.
Throughout this role, I leveraged a range of critical hard skills, including:
C/C++: I applied my deep knowledge of C/C++ to optimize and extend the connection manager layer, ensuring the high performance of YugabyteDB.
Database Management: My work involved intricate details of database management, contributing to improved database connection capabilities.
Scalability: I demonstrated my expertise in scalability, extending the number of database connections significantly.
Query Optimization: Implementing Protocol-level Prepared Statements in PgBouncer required a deep understanding of query optimization techniques.
Performance Tuning: I tuned and enhanced the performance of YugabyteDB, ensuring it met the demands of a high-load environment.
Problem-Solving: Overcoming the challenges of increased delay while implementing Prepared Statements was a complex problem-solving task.

Distributed SystemsC++Database ManagementScalability

Intern

Jan 2022 – Aug 2022 · 7 mos

During my internship at YugabyteDB, I was presented with the opportunity to work on challenging projects, making significant contributions to the platform's functionality and integration capabilities.
Key Achievements:
Enhanced YSQL C Driver with Load Balancing and Topology-Aware Features: As an intern, I played a pivotal role in enhancing the YSQL C driver by implementing load balancing and topology-aware features. This endeavor demanded an in-depth understanding of network protocols, load distribution algorithms, and connection management.
Implemented HashiCorp Vault Dynamic Secrets and Storage Plugin: I successfully integrated the HashiCorp Vault Dynamic Secrets and storage plugin into YugabyteDB, bolstering security and access control. This achievement required expertise in security protocols and plugin development.
Research and Development on Camunda and Supabase Integration: During my internship, I conducted extensive research and development on the integration of Camunda and Supabase with YugabyteDB, expanding the platform's capabilities. This involved in-depth knowledge of integration technologies, databases, and application workflow management.
Throughout these internship projects, I skillfully applied a range of hard skills, including:
Network protocol management.
Security protocol and plugin development.
Integration technologies and database systems.
Research and development in software integration and workflow management.
This internship experience allowed me to leverage these hard skills and gain practical insights into software development and integration, contributing to the advancement of YugabyteDB's capabilities.

C (Programming Language)Git

Samsung india

Software Developer Internship

May 2021 – Jul 2021 · 2 mos · Bangalore Urban, Karnataka, India · Remote

During my internship at Samsung, I embarked on a project that involved designing and implementing a log data processing and analysis tool. The task required me to tackle a significant challenge in optimizing data handling and analysis.
Key Achievements:
Log Data Processing Tool Design and Implementation: I spearheaded the development of a robust tool for the efficient processing and analysis of log data. This entailed the creation of intricate algorithms for data extraction, transformation, and analysis.
Performance Enhancement through Multithreading: Recognizing the time-consuming nature of I/O operations in log data processing, I introduced multithreading into the tool's architecture. This innovative approach resulted in a remarkable 23.7% improvement in performance, making the tool significantly faster.
My internship at Samsung not only provided me with hands-on experience in software development but also honed my expertise in threading and performance optimization. This practical exposure allowed me to leverage my technical skills and creative problem-solving abilities, contributing to more streamlined and efficient log data analysis processes.

Pandas (Software)C (Programming Language)