Database Defenders Capstone
A Design-Based Research capstone building a multi-layer automated data loss prevention system for Flask/Aurora — protecting against data corruption, enabling fast recovery, and helping operators make confident decisions under pressure.
Database Defenders Capstone
A Design-Based Research capstone building a multi-layer automated data loss prevention system for Flask/Aurora — protecting against data corruption, enabling fast recovery, and helping operators make confident decisions under pressure.
Database Defenders
Preventing Data Loss Before It Happens
About
A multi-layer protection system built on top of Flask and Amazon Aurora to prevent, detect, and recover from data loss incidents. Parses Docker logs in real-time using LLM-based analysis to catch mass password resets, bulk user changes, and suspicious migration executions before they cause harm. Automated Aurora snapshots run on configurable schedules with defined RPO/RTO targets. A static GitHub Pages frontend lets operators trigger on-demand backups, approve migrations, and monitor system health — all without increasing cognitive load or introducing new failure modes.
Impact
Security Fix Plan
Hardening the Spring Split-Brain Auth System
About
A focused security hardening plan targeting the Spring backend's split-brain auth drift, over-permissive MVC endpoints, and embedded secrets. Unifies JWT cookie and session logout, normalizes all roles to ROLE_ prefix, restricts permitAll routes to a minimal whitelist, replaces the in-memory password reset system with signed short-lived tokens, and moves all credentials to environment secrets. Complementary to the database protection layer — together they form a full-stack security posture.