Database Developer Recovery Manager

YOON SOK LIM

Senior Database Developer

Email: ******@*****.***

Phone: 972-***-****

Summary

•A Senior Database Developer with 20+ years of experience - Responsibilities: Gathering, analyzing the requirements and preparing functional/design document.

•Playing a technical leadership role in architecting, developing, and deploying enterprise solutions with AWS RDS.

•Testing, tuning and deploying the application to other environments.

•Invoking Shell script form application to move the validated files to destination directory.

•Successfully performed database migration from on premise SQL.

•Analyzing and troubleshooting the existing code to resolve critical issues.

Specialties

•Databases: Postgresql, MySQL, MS-SQL Server (SSRS/Data-Driven Subscriptions), Oracle, Sybase

•Languages: Java, C++, C, C#, Python, XML, JavaScript, HTML, SQL, Transact-SQL, UML, PHP

•JAVA/Web: Multithreading, RMI, Sockets, Applets, SWING, J2EE, EJB, RMI, JTA, JMS, JNDI, LDAP, JSP, Servlets, AJAX, CSS, FLEX, JMS, jQuery, JDBC, JUnit, log4j, ant, JavaBeans, Struts, Spring

•Modeling/Development Tools: Rational Rose, TAU, Eclipse, JDeveloper, JBuilder Enterprise Edition, Matlab

•Configuration Management: ClearCase, ClearQuest, CVS

•Cloud Computing: AWS (EC2, RDS, DMS), VMWare

Experience

Senior Database Developer, Administrator at Phoenixdarts

February 2017 - August 2022

•Design and model database structure to support business needs using Postgresql, MySql, and Oracle.

•Perform database performance analysis, system sizing, capacity planning and tuning to ensure maximum performance.

•Manage index statistics, tables, views, cursors and optimizing queries by using execution plan for tuning the database.

•Create stored procedure, indexes, and views using complex queries and scripting.

•Develop database system for Online Software Dart Game System such as 01 games, Cricket games, Count-Up games, and Fun Zone games (more than 70 games) in 32 countries.

•Create complex stored procedures to handle data of all games.

•Develop database system for Dart Special Event games (more than 80 events) and Dart tournament and online league games through global

•Perform database migration with shell programs in Linux system.

•Analyze business requirements, create specification documents, data mapping, working in conjunction as the data warehouse team.

•Provide thought leadership and problem solving skills to address current and future Business Analytic issues.

•Engage Business Analytic stakeholders to understand business and operational needs to plan and align current and future data warehousing capabilities to support enterprise and business priorities and initiatives.

•Develop data warehouse system for Dart game information and financial information.

•Support international Dart tournament games in Las Vegas every year.

Database Developer, Administrator / Senior Software Programmer at HCPA, Reston, VA

June 2010 - January 2017 (8 years 8 months)

•Performed application enhancements and server side utility automation. Developed Auto-billing system for clients using SQL Reporting Service (Data-Driven), Transact-SQL and JAVA.

•Developed Room Reservation system – Spring framework

•Conducted Database mining for the law firm. Performed the tasks of modifying existing software to correct errors, upgrade interfaces and improve performance.

•Developed site architecture and infrastructure, backend development using PHP, MS-SQL, Apache, front end development with CSS and HTML/XHTML, organic search engine optimization and strategy, web systems administration, technical writing, marketing communications and online business consulting.

•Developed Software Automation with updating System Log to the main DB with JAVA, Transact –SQL.

•Developed Software Automation for Billing, Weekly report, and Cases status using SQL, Reporting Services, and MS Visual Studio. Developed searching and reporting system to each client (Automation) using SQL, Windows Server, JAVA.

•Developed Invoice system for clients (Automation system) - Searching and Generating client information and invoice.

•Conducted full software development life cycle, writing functional specs, design documents, code, unit testing, and setting up lab equipment for tests as a project leader of the development team.

•Implemented and managed VMware vSphere ESXi platform, and vCenter. Working on Host Profiles, Resource Pools, Storage Profiles, VMFS data store and templates for client VMs. Working on VMware Site Recovery Manager (SRM) for maintaining business continuity and performing disaster recovery (DR) activity. Monitoring of VM's & ESXi server components (CPU, Memory, Disk, Network Utilization) and security hardening for Security Compliance.

Senior Software Engineer, System Manager at The Mirae Foundation

July 2007 - June 2010 (3 years)

•Supervised Computer Network System for the foundation and maintain extensive Database System which encompasses networking of over 100 college students and alumni.

•Conducted software analysis, software review, system risks analysis, identifying code metrics and analysis of software reliability. Designed and coded an automated mechanism for integrating the custom widgets into the GUI builder.

•Mentored junior JAVA developers.

Software Architect, Senior Software programmer at Samsung Electronics

October 2001 - June 2007 (5 years 9 months)

•Designed Object oriented software. • Designed and Developed Home Network System(Home Automation) for Server and Embedded System (Pocket PC) Development - JAVA, C#, MS SQL, Struts framework, Windows Server/Embedded. Defined protocols for Home Network communication between servers and clients, created algorithms for cryptographic communication, and developed modules.

•Developed Use Cases, UML diagrams such as Sequence Diagrams and Class Diagrams, for an application that manages projects, people and documents for an enterprise wide intranet/extranet application across multiple sites.

•Developed and maintained Samsung Computer Main Home Page - PHP, SYBASE, LINUX, ASP, Oracle, Database Design, query optimization, PHP development, overall project management. Strategically planned and programmed applications that collected business minded intelligence. Set up and maintained online game portal site.

•Designed and implemented an internal customer management solution using JAVA, J2EE, XML, BEA Weblogic, and Oracle. Implemented the control, coordination and data storage for shipment of products at Client s facility to the distribution centers and customers using Java, SQL, PL/SQL, JSP, Servlets, JDBC, JBuilder, Rational Rose, WebLogic, Oracle.

•Built and implemented a single sign-on project - Unified the User accounts for Samsung Electronic home pages using PHP, JAVA, Weblogic, LDAP, Oracle, Sybase.

•Handled the tasks of developing high-end software packages. Created installation programs for all packaging variations and administered version control systems. Managed and maintained the production environment, including software release strategies.

•Worked with external companies and partners to continually develop B2B application and service offerings.

Languages

English (bilingual proficiency)

Korean (Native)

Japanese (Native or bilingual proficiency)

Education

Hosei University, Tokyo, Japan

Bachelor of Engineering, System Control Engineering, 1992 - 1997

• Classes included System Control Theory, Electronic Circuit, Fuzzy Control, Information Theory and Digital Circuit. • Rank: Top 5%

Columbia University, New York, NY, USA

Master of Science, Electrical Engineering, 1997 - 1999

• Concentrated in Image Processing and Computer Network • Classes included Wireless and Mobile Network, Computer Communication Network, DSP, DIP, Visual Interfaces to Computer and Speech Recognition

University of Southern California, Los Angeles, CA, USA

Ph.D Candidate, Electrical Engineering, 1999

• Concentrated in Fast Gigabit Ethernet and Computer Network • Classes included

Gigabit Ethernet, Mobile Network, Data and Computer Communication, Computer Network.

Honors and Awards

•Honor Scholarship for Academic Excellence, Hosei University, 1994~1997

•Honor Scholarship – Foreign Student, Hosei University, 1994~1997

•Awarded first prize in an Japanese Language Proficiency Certificate, Samsung Electronics, Co. 2002

Interests

•Fluent in Korean, English and Japanese

•Interests include table tennis, Taekwondo, and cutting-edge environmental issue

Contact this candidate