백엔드 개발자
CurrentRoles & Responsibilities:Lead of Point System Development, Operation, and MaintenanceLed the design, launch, and maintenance of a reward mileage system for community activities and payment-based rewards.- Achievement: Achieved 0 issues post-launch, and received the top team performance evaluation.- Problem Solved: Addressed performance issues in the existing architecture by designing a non-UPDATE DB architecture.- Solution: Managed and tracked data change history accurately by avoiding UPDATEs and using INSERT-only tables.- Bulk Expiration Message Handling: Processed expiration and expiration-forecast messages through batch jobs.- Query Optimization: Optimized batch target selection and query performance to enable sending over 6 million notifications and emails per day.- Concurrency Issue Solved: Addressed concurrency issues using DB row locks, achieving performance goals.- Idempotency Key Applied: Resolved duplicate request handling using an idempotency key to ensure consistent results.API Retry Application Maintenance and Improvement- Solved memory utilization issues in a large Excel file generation API application.- Problem: Excel file generation and API retry processes caused memory usage to spike up to 90%, degrading system performance.- Root Cause Analysis: Identified memory spikes due to specific requests and monitored for OOME occurrences and root causes.- Solution: Introduced file compression during Excel generation and decoupled and distributed the application.- Result: Reduced memory usage from 90% to 40%, stabilizing the system.Project Management:- Introduced and implemented TDD and OOP practices with design patterns within our team
