and performance. Database Management: Relational Databases : Skilled in managing MySQL databases, with a focus on optimizing database designs through efficient schema creation. Experienced in enhancing query performance using indexing strategies and ensuring data integrity via comprehensive transaction management mechanisms. NoSQL Databases : Extensive experience with NoSQL databases, especially MongoDB, leveraging its flexible schema for rapid development and scaling. Knowledgeable in utilizing document-oriented storage principles for dynamic content management. Data Modeling & Migration : Expertise in ORM tools like GORM for Go, ensuring seamless data integration and migration strategies. Competent in designing data models that effectively reflect
CI/CD; dynamic schema management systems; authorization and permission control services; high-performance ticket systems, message queues, and e-commerce systems.
Search engine migration and tuning, event-driven data loaders, auto reindex setups, and new queries.
PostgreSQL and MognoDB database tuning. Including indices and sharding.
Multi-layer cache design and control, including memory cache, Redis cache, and CDN.
Work Experience
Staff Software Engineer, AmazingTalker Mar. 2021 – present
Global Online Tutoring Matching Platform. (Website)
Responsible for system infrastructure and engineer resource planning.
Responsible for an infrastructure migration plan. Include cloud service, database, programming language, and framework research.
Providing a service template allows developers to copy the Github repository to build a new service/cronjob in our Kubernetes. Include code generator, repository structure, CI/CD, and helm-charts templates.
Contribute and lead our backend code base from 0 to 1. Include internal Golang packages that integrate with the service template. The template provides completed features like in-memory cache, Redis cache, metric integrated with NewRelic, monitoring, logger, database connection pool
Lead into IaC within pulumi, starting from our complex CDN and IAM management. Now, most of AmazingTalker's infrastructure resources are in Github code management.
Building the hiring process, start the engineer-level policy draft delivered by our CTO, interview assessment, and interview questions.
Backend developer, Dcard, Jun. 2017 – Feb. 2021
The biggest social media app in Taiwan. (App store)
This position works closely with the infrastructure team members, data scientists, and product managers. Dcard is the most popular social media app in Taiwan.
Support data-team built data pipeline and data center for our home page recommendation system.
Implemented dictionary compression utility for a high writing-load database with a 95% compression rate and 60% insert speed improvement.
Improved Elasticsearch performance and conducted new query implementation. Rewrote index mapping; as a result, the new index was reduced by 40%, allowing us to build an auto-reindex trigger.
Created the Node.js service template and CloudFlare worker’s template. Provided a quick and easy environment for developers.
Added or removed indices and materialised view for our PostgreSQL. Improved query performance. Reduced API response time to 400ms.
Analyse and optimise multi-layer cache, including service internal local cache, Redis cache, CDN, and CDN internal worker.
Constructed a dynamic server-side rule-based configuration service that now handles at least 100 different rules.
Developed a subscription feed service that handles thousands of new posts every hour and feeds to millions of subscribers.
Cooperated directly and efficiently with the sales department. Responsible for the scheduled ticketing system, check-in system, real-time participant calculations, and activity website. Developed a highly successful offline activity with the sales team, attracting over 10,000 participants.
Established a ticketing and gift delivery service, which handled 15,000 draw requests per minute at the peak time. More than ten thousands gift delivery campaigns were processed.
Responsible for advertisement system, e-commerce service (including the checkout process, in-stock management, and all web pages), and advertising post scheduling system.
Fandora Shop, Backend developer intern, 2015 Dec - 2016 Sep
Used Node.js/Express, MariaDB, AWS, and GraphQL. Directly mentored by CTO.
Worked on e-commerce back-end service. Redesigned and rewrote the entire system, with more than 60 endpoints rewritten. At least 100 admin endpoints were aggregated to GraphQL endpoint.
Built the delivery system that connected to a local delivery company and synchronised 40,000 package statuses daily.
Cooperated with a local bank to build a new subscription service.
Additional Knowledge and Interests
Education
Oriental Institute of Technology - Department of Information Management.
CI/CD; dynamic schema management systems; authorization and permission control services; high-performance ticket systems, message queues, and e-commerce systems.
Search engine migration and tuning, event-driven data loaders, auto reindex setups, and new queries.
PostgreSQL and MognoDB database tuning. Including indices and sharding.
Multi-layer cache design and control, including memory cache, Redis cache, and CDN.
Work Experience
Staff Software Engineer, AmazingTalker Mar. 2021 – present
Global Online Tutoring Matching Platform. (Website)
Responsible for system infrastructure and engineer resource planning.
Responsible for an infrastructure migration plan. Include cloud service, database, programming language, and framework research.
Providing a service template allows developers to copy the Github repository to build a new service/cronjob in our Kubernetes. Include code generator, repository structure, CI/CD, and helm-charts templates.
Contribute and lead our backend code base from 0 to 1. Include internal Golang packages that integrate with the service template. The template provides completed features like in-memory cache, Redis cache, metric integrated with NewRelic, monitoring, logger, database connection pool
Lead into IaC within pulumi, starting from our complex CDN and IAM management. Now, most of AmazingTalker's infrastructure resources are in Github code management.
Building the hiring process, start the engineer-level policy draft delivered by our CTO, interview assessment, and interview questions.
Backend developer, Dcard, Jun. 2017 – Feb. 2021
The biggest social media app in Taiwan. (App store)
This position works closely with the infrastructure team members, data scientists, and product managers. Dcard is the most popular social media app in Taiwan.
Support data-team built data pipeline and data center for our home page recommendation system.
Implemented dictionary compression utility for a high writing-load database with a 95% compression rate and 60% insert speed improvement.
Improved Elasticsearch performance and conducted new query implementation. Rewrote index mapping; as a result, the new index was reduced by 40%, allowing us to build an auto-reindex trigger.
Created the Node.js service template and CloudFlare worker’s template. Provided a quick and easy environment for developers.
Added or removed indices and materialised view for our PostgreSQL. Improved query performance. Reduced API response time to 400ms.
Analyse and optimise multi-layer cache, including service internal local cache, Redis cache, CDN, and CDN internal worker.
Constructed a dynamic server-side rule-based configuration service that now handles at least 100 different rules.
Developed a subscription feed service that handles thousands of new posts every hour and feeds to millions of subscribers.
Cooperated directly and efficiently with the sales department. Responsible for the scheduled ticketing system, check-in system, real-time participant calculations, and activity website. Developed a highly successful offline activity with the sales team, attracting over 10,000 participants.
Established a ticketing and gift delivery service, which handled 15,000 draw requests per minute at the peak time. More than ten thousands gift delivery campaigns were processed.
Responsible for advertisement system, e-commerce service (including the checkout process, in-stock management, and all web pages), and advertising post scheduling system.
Fandora Shop, Backend developer intern, 2015 Dec - 2016 Sep
Used Node.js/Express, MariaDB, AWS, and GraphQL. Directly mentored by CTO.
Worked on e-commerce back-end service. Redesigned and rewrote the entire system, with more than 60 endpoints rewritten. At least 100 admin endpoints were aggregated to GraphQL endpoint.
Built the delivery system that connected to a local delivery company and synchronised 40,000 package statuses daily.
Cooperated with a local bank to build a new subscription service.
Additional Knowledge and Interests
Education
Oriental Institute of Technology - Department of Information Management.