Jiarui Li
Software Engineer at Amazon Web Services (AWS)
Redwood City, California, United States
Summary
🤩
Rockstar🎓
Top SchoolJiarui Li is a software engineer with seven years of experience building high-performance database and storage systems, currently working on query processing for Amazon Aurora DSQL. He holds an MS in Information Networking from Carnegie Mellon and a CS degree from UC Berkeley, and specializes in C++ systems engineering with deep interest in OS internals and x86/AArch64 architectures. Jiarui has made notable open-source contributions to the TiDB/TiFlash ecosystem—adding function pushdowns, refactoring charset handling, and strengthening test automation—to improve query performance and reliability. At SingleStore he implemented cross-query reoptimization, plan pinning for cross-version stability, and hash-table based execution for complex operators, directly addressing customer-facing performance regressions. Pragmatic and detail-oriented, he blends rigorous academic training with hands-on production experience to deliver measurable improvements in distributed HTAP systems.
7 years of coding experience
3 years of employment as a software developer
Computer Science, GPA 3.97/4.0, Computer Science, GPA 3.97/4.0 at University of California, BerkeleyBachelor's degree, Software Engineering, GPA 3.81/4.0, Bachelor's degree, Software Engineering, GPA 3.81/4.0 at East China Normal UniversityMaster of Science in Information Networking, Master of Science in Information Networking at Carnegie Mellon University
Github Skills (15)
tidb10
databases10
test-framework10
c-language10
go10
cprogramming-language10
distributed-database10
sql10
relational-databases10
sql-database10
database10
test-automation10
testing10
mysql9
cloud-native8
Programming languages (12)
Github contributions (5)
pingcap/tiflash
Jul 2022 - Aug 2022
The analytical engine for TiDB and TiDB Cloud. Try free: https://tidbcloud.com/free-trial
Role in this project:
Back-end Developer & Test Automation Engineer
Back-end Developer & Test Automation EngineerContributions:34 reviews, 10 commits, 9 PRs in 1 month
Contributions summary:Jiarui primarily focused on enhancing the testing framework and implementing new test cases for the TiFlash analytical engine. Their contributions include refining existing test code, adding tests for new functions like bitShiftRight and elt, and enhancing the join executor test suite. They also addressed a bug in the test scripts related to shell character escaping, demonstrating a focus on improving test reliability and coverage.
analyticstidbbig-datadistributed-databasetikv
pingcap/tidb
Mar 2021 - Aug 2022
TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
Role in this project:Backend Developer
Backend DeveloperContributions:8 reviews, 5 commits, 5 PRs in 1 year 5 months
Contributions summary:Jiarui contributed to the TiDB database project by addressing code quality issues, specifically fixing lint warnings. They also refactored code related to character sets and binary string handling. Furthermore, the user implemented new functionalities such as `rightShift` and `elt` function pushdown capabilities to TiFlash for improved query performance.
ai-poweredtidbserverlesshtapreal-time
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.