Junjae Lee Email & Phone Number

Vancouver, Canada Area

Vancouver, British Columbia, Canada

 Maintaining more than 30 database servers of SQL Server 2005–2019, MySQL 5.5–5.7, and Solr Parsing/importing/customizing raw data from various types of files, and normalizing/storing them onto well-structured databases Manipulating, exporting, and providing informative data along customers’ various requirements Planned and executed more than 100 migration projects between different applications, versions, DBMSs, and infrastructures Handled performance tuning achieved by index changes, normalization/denormalization, and database/table diagram changes Built monitoring systems that support intuitive error/failure detection and troubleshot issues with the monitoring system that resulted in a more stable systemProject: Data Center migration to Amazon Web ServicesAbout 70 servers were running on Data Center. This project was for migrating them to Amazon Web Services. Designed/built the whole infrastructure with AWS EC2, VPC, RDS, Route53, S3, IAM, SES, SNS, etc. Migrated SQL Server, MySQL, and Solr by using backup/restore, replication, and export/import Migrated Windows and Linux servers used for IIS, SMTP, FTP, DC, etc.Project: Integration servicesSome customers requested data to be imported to their systems such as Salesforce and MS Dynamics CRM. This project was for exporting data to their systems directly or via FTP server. Co-operated with other teams to clarify customer requirements such as what information/templates they want, how/when they want to obtain and so on Designed and implemented a unified process to fulfill more than 100 customers' various demands Used stored procedures and PowerShell scripts to automate the process

Vancouver, Canada Area

 Managed over 30 database servers to ensure all of them are up and running efficiently and consistently Transferred, installed, and upgraded various versions of SQL Server, Oracle, and MySQL on various versions of Windows Servers and Linux Created and designed over 500 stored procedures per year for 8 game operation teams by liaising with other departments and/or developers Planned and performed backup & recovery strategies to prepare for disaster situations Monitored and implemented various database-related activities such as error log, lock, deadlock, scheduled job, and database backup verification, performance, and system utilization such as disk usage, memory usage, CPU usage, and network usageProject: OGP Tool - a web tool providing real-time key performance indicator (KPI) and statisticsGame departments spent a lot of time to obtain KPI statistics. This project was for providing real-time KPI and statistics immediately by a web tool. Defined, analyzed, documented, validated, and managed requirements from other departments with active communication and investigated inefficient work process that required improvements Handled data modeling to integrate, store, and manage data transferred from other database servers Developed “OGPlanet Statistics Tool” by using ASP.NET MVC for the transformation of raw data into meaningful and useful information for business analysis purposes OGPlanet Statistics Tool was used to report and analyze business trend, to obtain more accurate prediction results measured by KPIs (including CCU, retention rates, UB, UV, and sales), and to take necessary actions interactively for customers Consequently, OGPlanet Statistics Tool improved business decision making and planning

Korea

 Managed confidential documents and communication equipments, while maintaining facilities Trained privates, private first classes, corporals, and sergeants in communication skills

Bachelor Of Engineering - Be, Computer Science And Engineering

Education record

Oracle Expert Certificate (400 Hours Completion) Oracle Database Professional Certificate Oracle Database Professional Certificate