石德揚
No intro yet.
軒昂有限公司 XUENN Pte Ltd.
國立彰化師範大學, National Changhua University of EducationTaipei City, Taiwan
Professional Background
Current status
Employed・Not open to opportunities
Profession
Back-end Engineer
Fields
Software・Information Services
Work experience
2-4 years (2-4 years relevant)
Management
-
Skills
GolangC#SQL ServerRedis
Languages
English・Intermediate
Highest level of education
Bachelor
Job search preferences
Desired job type
Full time・Interested in working remotely
Desired positions
後端工程師
Desired work locations
台灣台北・台灣新北市
Freelance
Non-freelancer
Work Experience
後端工程師
軒昂有限公司 XUENN Pte Ltd.・Full-Time
August 2020 - November 20222 yrs4 mos
台灣台北
Used: C#, ASP.NET MVC, Microsoft SQL Server, Redis, Elastic Stack, Jenkins Global Online Gaming Web Application Development • Developed two large-scale products (B2B2C/B2C) • Built high-concurrent transactional system (multi-thread programming) • Troubleshooting on production/urgent issues for 24/7 service • Refactored code for generating reports to save 70% of development time • Established partitioner to make parallel executions more chunky to increase 30% efficiency Database Implementation and Design • Designed and deployed data table structures, stored procedures, functions, and queries • Achieved performance tuning via applying DB execution plan and index • Developed a tree data structure in DB to reduce 50% of the searching time (Nested Set Model) • Implemented T-SQL job scheduling using SQL Server Agent to perform maintenance • Planned and implemented data migrations and version upgrades from 2016 to 2019 Monitoring • Established dashboards on Kibana to visualize the logs data • Implemented Kibana Watcher for monitoring production health and exception • Database monitor (Extended Events, DMO, Query Store) CI/CD • Enhanced and maintained CI/CD workflow with Jenkins • Reduced 70% development time by refactoring build flow and steps with the groovy script Statistics • Applied goodness of fit test to verify the randomness of game result • Detected unusual members by analyzing data and helped to reduce up to 30% company's loss
Education
Build Your Professional Network
Click icon on the company page or under talent search engine to start the conversation.