Performance and infrastructure work for ProCamps, the athlete-led youth sports camps platform: the slowest queries traced and fixed, and AWS run in production.
The problem
The slowest parts of the platform came down to the database: queries doing full-table scans.
ProCamps' public website as it is today.
Built for
Cinnova
Role
Team Lead / Senior Software Engineer — query tuning and AWS
Period
2022 — 2025
Stack
AWS EC2
AWS Lambda
SQL
Indexing
Status
Client platform at Cinnova. No public source.
What I built
Traced the slowest queries to full-table scans and fixed them with indexing and query rewrites.
Looked after the AWS infrastructure across EC2 and Lambda.
Looked after deployments and production monitoring.