Ki Hyuk Kwon Email & Phone Number

South Korea

Principal Cloud, Database Engineer / Team leader.Onestore provide mobile No. 2 app store service in Korea. Provide various content like game, movie/video, music to more than 6M users on Andriod. Built/Configured global cloud service based on Azure Cloud. - Designed and Build Global Cloud service using CDN, AGW/LB, Redis, MySQL/Cosmos, Func, WAF/NSG/ASG etc - Optimized service performance and troubleshooting for issue  Built Aurora database at Singapore region for global service - Installed and configure aws aurora database for version 5.6 - Migrated to the data from my datacenter to aws region. Upgraded and Migrated all oracle database from 11g to 18c - Installed and configured oracle real cluster database for 18.8 - Migrated to about 30TB from 11g databases to 18c databases - Switched the services through 1 hours downtime using ogg - No failure or interrupt services at that time Built monitoring service for mysql and oracle based on grafana. - Collected status for system and db using telegraf and influxdb - Collected custom status of db using python and go - Displayed that information using grafana as viewer Built and optimized cache service based on Redis Designed and Built the Hadoop server called onecluster for marketing purposes of customers. - Built and optimized the Hadoop echo system based on CDH 5.8/5.9 - Hadoop S/W : Hadoop, Hive, Spark, Impala, Oozie, Hue. - Hadoop Security : Sentry, Kerberos, SSSD, Data Encrypt/Decrypt - Provided the developer guide of data collection using sqoop/oozie. Automated configuration/install and operation using ansible Migrated and integrated approximately 25 TB of user data to Hadoop file system. Designed and built Onestore Database - Designed and built high availability and scalability for database - Oracle : RAC (real application clusters), OGG, Data Guard - MySQL : MMM(multi master manager), Replication - Optimized sql of bad performance

판교

Principal Database Engineer / General ManagerI mainly focused on Tstore database refactoring to rewrite existing source code in order to improve its readability, reusability or multitenant application.Also, i supported to solve issue of service due to database in Hoppin / TmapThe Hoppin/Tmap provided the No.1 mobile vod/map navigation service in korea Operated and configured Tstore database for refactoring service Designed and changed database structure for supporting multitenant service in order to add telecommunication company easily Merged KT, U+ App Service and user data into Tstore  Optimized and analyzed service issue related to database Analyzed and solved migration issue between different charectset databases in oracle 2 node rac and optimized slow response time of mysql query due to large capacity change. Operated and optimized database performance with oracle rac 3node. Review to replace commercial database to open source database Analyzed difference and similarity between oracle and mysql. Executed migration test from mysql to oracle using sqoop based on hadoop. Compared ROI (return on investment) when it replace to open source.

서울

Principal Infra Architect and Database Engineer Led a group of database engineers to provide several and various service such as Samsung apps, Samsung Account, ChatOn, Samsung Cloud etc.I have experienced so many open source and cloud based service regarding to design, build, configuration, optimization, troubleshooting. Built and Operated Samsung Electronics mobile service  Under the partnership with Samsung Electronics, provided more than 5 mobile service to global users such as Samsung Apps, ChatOn, Scloud etc which are running on cloude instances and dedicated servers as well.  Pioneered the usage of Amazon Web Services(AWS) such as ec2, rds, s3, vpc for the content services of Samsung mobile devices. Designed and built Cassandra cluster which are running 49 nodes as Samsung Scloud service. The Scloud provide to service for storing user data in order to restore in the future. Optimized performance of oracle rac 5 node through system parameter and bad sql tunning and reduced cost of system operation due to decrese number of database from 5 servers to 3 servers.The Chaton-V service provide a mobile voip service. Provided an integrated monitoring service using python and perl. Provided reliable 24 X 7 services of all service through a detailed and incorporated software/system operation based on polished operation techniques and processes. As self service of Samsung SDS, it provided an integrated messaging service (Google/MS/Yahoo) used by more than 20M global smartphone users in 120 countries worldwide.The Social hub service is built in service in Samsung smartphone. Designed and built the social hub service and system located in Germany and China in cooperation with the US company Seven Inc. Built data warehouse for charging cost by integrating data into an oracle instance of 30. Archieved 100% service availability rate from 2010 to 2014 with well-designed high availability architecture and effective/efficient capacity planning.