About
JACK YOON
Cell-Phone: 917-698-5813
Email : jackyoon89@yahoo.com or jackyoon89@gmail.com
Certified Oracle DBA with 13 years of experience in Oracle Database Administration. In-depth experience in latest releases of ORACLE. Other experiences include Server and Database Capacity Planning, Installation of Oracle and setting up of Databases on Unix(Linux) and Windows NT. Designing and implementing high availability systems. Very good experience in Physical and Logical design of the database, performance tuning at SGA level as well as at application level, testing and implementing backup strategies. In addition to these very good experience in Internet technologies which includes installation and configuration of Web servers and Application servers.
TOOLS AND METHODOLOGIES USED
Hardware(O/S)
Sun Solaris, AIX (SP2), HP-UX, Digital Unix, Sequent, NCR, Pyramid, NT, Linux AS2/3
Software
HACMP, PowerBuilder, Developer 2k, Veritas HA Cluster, SharePlex, Live Reorg, Legato Networker, Veritas NetBackup. Tuxedo , Encina
Languages/Tools Used
PL/SQL , Designer 2K, Designer 6i , ER*Win, Oracle Enterprise Manager, SiteScope, Precise, Spotlight, Java, Java Servlet (jhtml/jsp), Shell Script ,
AWK , Pro*C , Perl, PHP
Application Server
Oracle Application Server 10g, 9iAS/Portal (Release 1, 2) , OAS, ATG Dynamo, NetScape iPlanet, WebLogic , Apache , mod_plsql , mod_jserv , mod_jdk , Oracle Internet Directory server(OID)
Database
Oracle (Version 10g,9i, 8i, 8.X, 7.X), Oracle RAC, Oracle Streams, Replication, Dataguard, RMAN , SQL Server
Professional Experience
Informa Global Market 06/2003 ~ 06/2006
Title : Sr. Oracle DBA Specialist
Responsibilities :
Oracle Replication Configuration and Monitoring
o Setup multi-master replication environment
o Setup master definition site and master site instance
o Monitoring replication environment
o Monitoring job queue
Oracle Application Server 10g/Oracle 9iAS Installation & Configuration
o Install and configure 10g/9iAS infrastructure and it’s Metadata Repository
o Install and configure HTTP Server , 10g/9iAS Container for J2EE
o Install and configure 10g/9iAS instance
o Implement 10g/9iAS clustering
- Install and Configure Oracle Internet Directory Server. (OID)
o Install Oracle directory Server
o Configure OID
o Bulk Load directory data to the directory server.
o Implement and Configure OID Replication
o Monitor OID Replication and Resolving Conflict.
- Integrate RMAN with ArcServer Networker
o Install Oracle Binary
o Create RMAN Repository
o Integrate ArcServer Library with RMAN Binary
o Schedule Backup plan using ArcServer GUI Manager
- Database and Application Tuning and Performance Monitoring
o 9i database Parameter tuning.
o Tuning database using utlbstat/utlestat and statpack.
o Trace SQL Statements and tune them using tkprof.
o System wide tuning (OS, Network, Memory, Database)
- Physical / Logical design Database Design
o Draw ERD and Table Diagram
o Create tables and indexes DDL
o Capacity plan for tables and indexes
- Monitoring Production System and Problem tracking.
o Monitoring User session.
o Monitoring session idle time.
o Monitoring system wait and event.
o Monitoring performance problem.
o Table, index and tablespace capacity plan.
- Operating system monitoring and tuning for oracle database.
o Monitoring Memory utilization.
o Monitoring Paging and Swapping.
o Monitoring Disk utilization.
o Monitoring network utilization.
o Tuning Memory parameter for oracle database.
o Tuning TCP parameter for Oracle Sql*Net.
Cintra Software and Services 07/1999 – 05/2003
Title : Sr. DBA
Client List :
Priceline.Com, Freeride.Com, MamMedia.Com, Xanboo.Com, Tokenzone.Com, Proxy.Com, Vencast.Com, Forest Lab(pharmaceutical Laboratory), Vertical crossing, InterdeanInterconex co , KDDI America , UPOC , Realty Data , Iron Workers Union Fund Inc
Responsibilities :
· Oracle 9iAS/Portal Configuration and Development
o Install and configure 9iAS infrastructure and it’s Metadata Repository
o Install and configure HTTP Server , 9iAS Container for J2EE and Enterprise Manager
Website
o Install and configure 9iAS instance
o Test and develop 9iAS Web application
o Integrate Forms and Reports
o Configure SSL(Secure Socket Layer) and Apache directives
- Integrate RMAN with solstice(Legato) Networker
o Install Oracle Binary
o Create RMAN Repository
o Integrate solstice Library with RMAN Binary
o Schedule Backup plan using solstice networker
- Evaluate Oracle features and Oracle related products
o Test Oracle8 , Oracle8i and Oracle9i new feature (Partition Table, LOG Minor,
Sql*Net load balancing etc.)
o Test SharePlex and write monitoring script.
o Test SiteScope Monitoring tool and make a script for monitoring component.
- Execute disaster recovery
o Make Automatic backup script for the clients.
o Disaster recovery.
o Test backup and restore script for the clients.
- Database and Application Tuning and Performance Monitoring
o Verify database parameters for Clients.
o Tuning database using utlbstat/utlestat.
o Trace SQL Statements and tune them using tkprof.
o System wide tuning (OS, Network, Memory, Database)
- Database Design (Physical / Logical design )
o Draw ERD and Table Diagram
o Create tables and indexes DDL
o Capacity plan for tables and indexes
- Monitoring Production System and Problem tracking.
o Monitoring User session.
o Monitoring session idle time.
o Monitoring system wait and event.
o Monitoring performance problem.
o Table, index and tablespace capacity plan.
- Operating system monitoring and tuning for oracle database.
o Monitoring Memory utilization.
o Monitoring Paging and Swapping.
o Monitoring Disk utilization.
o Monitoring network utilization.
o Tuning Memory parameter for oracle database.
o Tuning TCP parameter for Oracle Sql*Net.
- Web environment and system related.
o Install and configure Oracle Application Server
o Install JDK and apply required OS patches.
o Install and configure Netscape Web Server.
o Install and configure Dynamo ATG Application Server.
o Integrate Netscape Web Server and Dynamo application server and Oracle database.
o Simulating and Testing Load Balancing, Session Fail over and Virtual Servers.
o Problem tracking
o Configure network configuration (DNS, ROUTER).
- Install and Configure Oracle Internet Directory Server. (OID)
o Install Oracle directory Server
o Configure OID
o Load directory data to the directory server.
Oracle Corporation 01/1996 – 03/1999
Title :
Database Support Engineer – 2 years and 3 months
Database Analyst – 1 year
Client List
Korean Bank , Woori Bank , Korea Exchange Bank , Daehan Investment Bank , Korea Investment Trust Management & Securities , Sejong Securities , LG Securities , Samsung Securities , Daewoo Securities , Sun-kyoung Securities , KOSCOM ( Korean Securities Computer Corp ) , Korean Financial supervisory service , Korean Stock Exchange , Jadin Flaming Securities, Korean Telecommunication
Responsibilities
o Oracle database New Feature and characteristic presentation
o Education Service for industry DBAs.
o Support different system Configuration for different clients including OPS, Hot
Standby, HACMP, 3 Tier.
o Install, Upgrade, Migrate Oracle Databases (From 7.X to 8.X)
o Support customer’s Logical, Physical database design and modeling
o Database Engine Performance tuning using utlbstat / utlestat .
o Application and SQL Tuning
o Support database Re-Organization of different clients.
o Problem tracking and debugging.
o Support many financial corporations. Especially Securities and Banks with Terra
Bytes of data.
o Support customers to establish their Backup and Recovery strategy and test them.
o Configure EBU (Enterprise Backup utility) and RMAN (Recovery Manager) for VLDB.
o Execute Disaster recovery services
o Support clients to develop their systems using ORACLE 8.X Partition Table and
Object Feature and design index strategies for Oracle 8.X Partition Tables.
o Develop Demo Program using new feature of different Oracle Products for ORACLE
ROAD SHOW
o Developed Cyber Stock System using Des2K, Dev2k, PL/SQL and Oracle Web Server.
It enabled clients’ to stock trade across networks without trading system in any
securities. This system enabled clients’ customer registration, sale order, purchase
order and trading/price status search function.
o Developed Cyber Shopping mall by using C , PL/SQL , JAVA and Oracle Internet
commercial server(ICS)
Education : BS in Computer Science.
SOONGSIL University, seoul korea – (FEB-1996)
