Rock-Paper-Scissors Tournament DB

Designed and implemented a relational base schema for a multiplayer gaming platform using OracleDB, normalizing 10+ tables and defining 20+ functional dependencies to guarantee data integrity and scalability as leaderboards, match history, and in-game transactions were layered on top.

Developed a RESTful API using Node.js, Express, and OracleDB capable of handling 5000+ queries per second at 99.9% uptime, delivering fast retrieval of match history, leaderboards, and user transactions.

Built a dynamic web frontend using vanilla JavaScript, HTML, and CSS with real-time leaderboard updates, in-game store transactions, and direct messaging, increasing user engagement by 40% in usability testing.

Optimized complex SQL queries for ranked leaderboards and match histories through efficient indexing and query restructuring, reducing execution time by 50%.

Engineered a secure authentication system with SHA-256 password hashing, parameterized queries to prevent SQL injection, and session-based authentication to maintain data security for active players.