← All work
Backend · Performance · 2024

Caching & reliability

I added Redis caching and session persistence to a Node.js backend to cut redundant database queries, and built MSSQL audit logging so every data change is traceable.

Role
Backend · Integrella
Year
2024
Stack
Node.jsExpressRedisSQL Server
Links

The problem

The intranet’s Node.js backend kept asking SQL Server for the same data, sessions didn’t survive restarts, and when something went wrong in production there was no reliable trail of who changed what.

What I built

  • Redis-based caching in the Node.js (Express) backend for frequently requested data, significantly reducing redundant database queries and improving API response times
  • Session persistence in Redis, so users stay signed in across server restarts
  • Custom MSSQL audit logging that records data changes and supports traceable, audit-friendly workflows
  • Investigated and resolved production issues through PM2 and Apache logs, shortening the time from incident to fix

How it landed

Faster API responses, less load on the database, and a system that is easier to trust, and easier to debug when something does go wrong.