Wan Lim
CTO at OneWill.ai
San Francisco Bay Area United States
Summary
🤩
Rockstar🎓
Top SchoolWan Lim is a PhD candidate and systems-focused software engineer with nine years of experience building and optimizing database engines, benchmarking frameworks, and CI tooling, including substantial contributions to CMU's NoisePage and BusTub projects. His work spans low-level memory and index structures, query processing features, and cross-platform build/test automation, and he has interned twice in Microsoft's Data Systems Group and at Amazon Aurora. A former cybersecurity competitor with national CTF experience and responsible disclosure credits, he brings a security-minded perspective to systems design. Based in Pittsburgh, he combines academic teaching across undergraduate and graduate database courses with practical engineering that improves reproducibility and performance in widely used open-source DBMS research tooling. An avid capybara fan, he balances deep technical rigor with an approachable, community-oriented presence.
9 years of coding experience
1 year of employment as a software developer
Doctor of Philosophy (PhD), Computer Science, Doctor of Philosophy (PhD), Computer Science at Carnegie Mellon UniversityDiploma (High Distinction), Diploma (High Distinction) at NUS High School of Mathematics & Science
English, Malay
Github Skills (30)
algorithms10
benchmark10
docker10
c-language10
databases10
bash10
benchmarking10
indexing10
dockers10
data-structure10
java10
cicd10
javas10
sql10
data-structures10
Programming languages (9)
Github contributions (5)
cmu-db/benchbase
Aug 2021 - Dec 2021
Multi-DBMS SQL Benchmarking Framework via JDBC
Role in this project:
Back-end Developer
Back-end DeveloperContributions:23 reviews, 48 commits, 52 PRs in 4 months
Contributions summary:Wan primarily contributes to the core of the multi-DBMS benchmarking framework, as evidenced by changes to the `DBWorkload.java` file, which is central to the framework's functionality. These commits address issues related to benchmark execution, including fixing the execution of the NoOp benchmark and addressing connection leaks within the application. The user also made changes to testing and database interaction.
benchmarkingdbmsjdbcsqldatabase
cmu-db/noisepage
Jul 2018 - Jul 2021
Self-Driving Database Management System from Carnegie Mellon University
Role in this project:Back-end & Database Engineer
Back-end & Database EngineerContributions:474 reviews, 142 commits, 298 PRs in 3 years
Contributions summary:Wan contributed to the development and maintenance of the database management system, specifically focusing on low-level memory management, data storage, and index structures. Their commits included addressing memory allocation issues in the RawConcurrentBitmap implementation, fixing a bug in RawConcurrentBitmap::Allocate and refactoring of B+ Tree operations. The user also worked on extending the parser to support features like DISTINCT in aggregate functions, and implementing the SQL IN operator in WHERE clauses, highlighting involvement in core query processing and optimization.
database-managementdatabasedbms
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.