04/2022 - Sekarang
• Spearheaded the creation of Web APIs and a robust back-end Admin Portal for Funday's Online Learning Platform using ASP.Net Core 5/6, Dapper, and SSMS. Adopted a microservices architecture, improving scalability, and facilitated team-wide comprehension through detailed database schema diagrams and comprehensive documentation, enhancing productivity and collaboration.
• Designing, migrating and developing MS SQL Server Databases
• Database Design and Development: Designed schemas for SQL Server and MongoDB in support of 10+ Web APIs development, while consulting on schemas and queries for another 5 colleagues' projects, which bolstered overall team efficiency.
• Boosted data retrieval by 40% in legacy systems through query optimization and implemented system upgrades that reduced execution time by 60%, enhancing overall database performance by 25% using SQL Profiler and Database Tuning Advisor.
• Evaluate requirements while following through on project deliverables and performance of applications.
• Transitioned application deployments from Windows Server to GCP Compute Linux VMs using Docker, Nginx, and Docker Compose, improving load balancing and caching. Managed Cloud DNS subdomain configurations and implemented SSL certificates, boosting security and performance. Additionally, established CI/CD pipelines with GitLab Runner.
• Regularly mentoring my team of 6 in the use of Gitlab, Docker, Serilog, Elasticsearch, and MS SQL query optimization techniques, improving overall team capabilities.
• Leveraged Serilog, ElasticSearch, Kibana, Prometheus, and Grafana, enhancing exception tracking and performance monitoring. Identified bottlenecks via K6 load testing, increasing system throughput by 3-4x through strategic code and query optimizations.