• Refactored database for an employee hours tracking app to Third Normal Form using SQL to improve query performance in the web application• Documented production database schema using extended properties in SQL Server to provide comprehensive metadata for future management• Prepared implementation of OAuth 2.0 flow to automatically fetch JWTs for API test execution, leveraging the Microsoft Authentication Library for Node.js• Developed a test logger using the Winston logging library in JavaScript to ensure that public logs from the app were properly recorded in Azure Application Insights.