Technical Essays

Engineering Blog & Architecture Insights

No shallow listicles. Deep, battle-tested engineering notes covering production microservices, query tuning, zero-trust security, and distributed concurrency.

Chandan Chakrobortty — Senior Software Architect discussing system design
Engineering Author
Technical Essays
August 2026 • Security & Distributed Systems

Designing Zero-Trust mTLS Microservices for Enterprise Banking APIs

How we transitioned internal microservice communications to mutual TLS with automated certificate rotation and ECDSA signing, eliminating perimeter trust assumptions and replay vulnerabilities.

Zero-Trust mTLS Node.js
July 2026 • Database Optimization

PostgreSQL Composite Indexing: Eliminating Full Table Scans Under Concurrency

A practical guide to analyzing `EXPLAIN (ANALYZE, BUFFERS)` execution plans, designing multi-column B-tree indexes, and preventing index bloat on tables exceeding 50 million records.

PostgreSQL B-Tree Query Tuning
June 2026 • High-Frequency Systems

Building a Sub-15ms WebSocket Event Bus with Redis Streams

Architecting an event-driven broadcast cluster capable of fanning out financial market ticks and telemetry alerts to 100,000+ connected clients without CPU saturation.

WebSockets Redis Streams Concurrency
May 2026 • DevOps & Infrastructure

Containerizing Stateful Distributed Applications with Kubernetes & Terraform

Lessons learned managing StatefulSets, dynamic PersistentVolumeClaims, and automated GitOps rollbacks for multi-region cloud microservices.

Kubernetes Terraform GitOps