Web Application Developer
- Create API by using Go> Database: SQL Server> API Docs: Swagger> Framework: Gin> Architecture: Microservice> Return JSON as API Response- Create CRUD API using Spring Boot> Database: MySQL> API Docs: Swagger- Compare CRUD Performance between Spring Boot and Gin Go> Used Apps: JMeter (to estimate speed) & Task Manager (to estimate CPU, RAM, and Power Resource)- Create Performance Test Scenarios> Using JMeter> One test scenario will represent all APIs that required to be hit to complete a single task.- API Code Optimization> First, I looked for parts of the code that were making the API slow> Second, I changed the algorithm to faster algorithm- Create Dynamic Store Procedure> Database: SQL Server> With this SP, any simple query can be written shortly (including LIMIT, OFFSET, and ORDER keywords)- Create a system to check the differences between 2 databases> Used to double check if there are missed updates between development & test environments> Can check differences in tables, columns, views, SP, etc.- Create Decoding System> Every input to the API is encoded. Then, my task is to create a decode function to decode the encoded input- Secure API> Penetration Testing Type: SQL Injection> SQL Injection prevention is made after the vulnerability is discovered in the API- Create C/C++ Programs> Program 1: To perform large data amount editing in .txt file> Program 2: To create .txt file with a certain size as we requested- Develop Front-End with React and NextJS> Hit external API to retrieve JSON & image data> There are CRUD data operations to local storagePersonal activity while have free time:- Research Hash System for Database> Hash System: 1 table is divided into many tables by using hash function- Research Cache System for Database> Cache System: Stores frequently used data into different table (Ex: cache table)