Adam Machanic
Head Of Data
Melrose, Massachusetts, United States
Summary
🤩
Rockstar🎓
Top SchoolAdam Machanic is a technology leader and data architect with over 20 years of experience building high-performance, enterprise-scale data systems and teams. As Head of Data he combines deep SQL Server expertise and performance tuning with cloud-native architecture — having designed ARIES, a scalable ingestion and API platform used across 200+ trading, research, and risk teams. He is the author of sp_whoisactive, an award-winning monitoring stored procedure adopted by tens of thousands of DBAs, and continues to refine its diagnostics and reliability on GitHub. Known for mentoring engineers into leadership and solving thorny database challenges, he blends hands-on coding (Python, Rust extensions, Postgres, Redis) with strategic product ownership. Based in Melrose, MA, he brings uncommon depth in both low-level database performance and large-scale data platform design.
7 years of coding experience
5 years of employment as a software developer
BS Computer Science Philosophy, BS Computer Science Philosophy at Tufts University
Github Skills (6)
stored-procedures10
monitoring10
sql-server10
database-administration10
sql10
performance-tuning9
Programming languages (6)
Github contributions (5)
amachanic/sp_whoisactive
Jul 2019 - Nov 2021
sp_whoisactive
Role in this project:
Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:5 releases, 20 reviews, 41 commits in 2 years 3 months
Contributions summary:Adam's contributions primarily focus on modifying the `sp_whoisactive` stored procedure, which is designed for monitoring SQL Server activity. The commits involve code changes to the SQL script, including the initial creation, re-adding of a deleted copyright notice, and several fixes to enhance functionality. These changes encompass fixes for typos and XML characters, as well as improvements to memory grant information, and delta output for performance monitoring. This indicates a focus on enhancing the stored procedure's reliability and diagnostic capabilities.
sqlmonitoringsqlserver
amachanic/sqlglot
Feb 2025 - Feb 2025
Python SQL Parser and Transpiler
Contributions:4 pushes, 3 branches in 2 days
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.