AcademicRecord Core: Java Backend API
High-throughput academic management API with optimized SQL queries, Hibernate ORM, and connection pooling.
Overview
Engineered during the ThrivesUp Consultancy internship, AcademicRecord Core provides 12+ RESTful endpoints for student records, enrollment workflows, grading matrices, and transcript generation with strict data consistency.
My role
Backend Engineer — Designed relational database schemas, developed RESTful API endpoints, and optimized SQL execution bottlenecks.
Key features
Query Optimization (500ms → 80ms)
Analyzed MySQL execution plans (EXPLAIN), added composite indexes on student enrollment tables, and eliminated N+1 query bottlenecks.
12+ RESTful API Endpoints
Engineered endpoints covering student onboarding, grade audit logs, course registrations, and automated semester GPA calculation.
Transactional ACID Guarantees
Implemented database transaction boundaries with rollback mechanisms to prevent partial updates during batch record ingestion.
Comprehensive Postman Test Suites
Built automated Postman test scripts validating HTTP status codes, payload schemas, and response latency across all 12+ endpoints.
Engineering decisions
Employed connection pooling (HikariCP) and prepared statements across all JDBC data access layers to minimize database connection overhead and prevent SQL injection vulnerabilities.
Learnings
- Profiling database bottlenecks using MySQL slow query logs and query execution trees.
- Designing normalized 3NF schemas with appropriate foreign key constraints without hurting read throughput.
Results
Achieved an 84% reduction in query execution latency (500ms → 80ms) and maintained 100% data integrity across 1,000+ academic records.