PostgreSQL

Designed a distributed order-processing system using Java, Spring Boot, and Apache Kafka, decoupling order creation, inventory reservation, and payment processing through asynchronous event-driven workflows. Implemented a Transactional Outbox pattern with PostgreSQL to prevent database updates and event publishing from becoming inconsistent, with idempotent consumers to safely handle duplicate message delivery. Built Saga-based failure recovery with retry policies, dead-letter topics, and compensating transactions to handle partial failures across distributed services without relying on a global database transaction....

Implemented a Real Time Chatroom with Next.js for seamless server-side rendering, and Clerk for authentication. Enhanced styling consistency through the application of styles with TailwindCSS. Integrated UploadThing as a robust big data server, supporting file uploads up to 2GB. Ensured effective CRUD operations and server communication using the promise-based HTTP library Axios. Facilitated real-time bidirectional communication across platforms using Socket.IO.