Experience

Software Developer (Contract) & System Administrator

Faculty Leave Management System — Cambridge Institute of Technology, Bangalore

Paid Contract · Production
Oct 2025 – Present
  • Designed, developed, and deployed lms.cambridge.edu.in — a production-grade faculty leave management system using Node.js, Express, MySQL & React, serving 300+ institutional users (200+ WAU) at 99%+ uptime on Hostinger VPS (Nginx + PM2).
  • Used MySQL transactions (BEGIN/COMMIT/ROLLBACK) to design an ACID-compliant approval workflow (Faculty → Substitute → HOD → Principal) with RBAC and substitute locking — eliminating race conditions and ensuring data integrity under concurrent requests.
  • Built a resilient async mail queue using Nodemailer + MySQL with a background worker, UUID claim tokens, and exponential backoff retry — solving email delivery failures without blocking the main request lifecycle.
  • Applied database indexing, query optimization, and connection pooling (mysql2) to achieve ~35% reduction in API response latency — validated under concurrent load testing with Autocannon.
  • Automated infrastructure using GitHub Actions CI/CD, cron + shell scripts for daily DB & app backups, zero-downtime deploys, and tested disaster recovery — reducing manual ops to near zero.
Node.js Express React MySQL Nginx PM2 GitHub Actions Linux VPS RBAC ACID Transactions