PROFESSIONAL SUMMARY

An experienced Oracle Certified Professional (DBA track) with more than 15 years in IT industry with more than 10 years as Oracle DBA in high volume and high transactional OLTP environment. Strong background in UNIX/LINUX shell scripting and system administration. Strong analytical and troubleshooting skills in resolving production databases issues. Years of experiences in capacity planning, maintenance, monitor user access, security, data integrity and performance tuning of databases. Expert level working knowledge at SQL Plus, PL/SQL, RMAN, TOAD, Oracle Grid Control (OEM), DATAGUARD, UNIX/LINUX shell scripting, Oracle Streams, and ETL.

ORACLE:

• Model, design and implement multiple databases in OLTP environment.
• Partition tales and indexes and materialized views for better performance.
• Install and administer multiple VLDB Oracle 8i, 9i, 10g and 11g databases.
• Migrate and upgrade various Oracle versions and patches.
• Cloning single or multiple production databases for testing.
• Implement Oracle Optimal Flexible Architecture on various platforms.
• Implemented Oracle HA with Data Guard.
• Implement various enterprise database backup and recovery using RMAN.
• Administer user security, data consistency and integrity of Oracle databases.
• Establish system and database performance baseline using Grid Control.
• Tuning system and database queries for better performance.
• Ensure on-time with high quality delivery of Oracle databases.
• Using OEM or Grid Control to manage multiple Oracle databases.
• Using data move utilities such as Data Pump, Export/import and SQL Loader.
• Implementing LogMiner and database auditing.
• Successfully implemented ASM and Oracle streams replication.

UNIX:

• Install and configure SUN, HP, AIX Unix.
• Upgrade and migrate UNIX versions and apply patches.
• Partition raw and cooked devices and configure network file systems.
• Reorganize file systems and reallocate disk spaces for better performance.
• Implementing RAID technology using Veritas LVM and Solstice.
• Schedule at and cron jobs to automate system administration routines.
• Administer user accounts, file system security and user auditing.
• Plan and perform system backup and recovery, both local and remote.
• System administration, monitoring and performance tuning.

EDUCATION
Master in Computer Information Systems

2006 to now Senior Oracle/SQL Server DBA, Confidential,Hillside, IL

• Successfully setup and configure and maintain DR (Data Guard) for all production databases.
• Successfully data model, design and implemented multiple OLTP databases.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases.
• Successfully tuning system and database queries for better performance.
• Successfully implemented ASM and streams replication.
• Successfully implemented enterprise RMAN backup and recovery strategy.
• Developing high quality ETL PL/SQL procedures, functions, triggers.

1999 to 2006 Oracle DBA Lead,Confidential, Schaumburg, IL

• Modeling, designing and implemented Oracle databases with high quality to clients from release to release.
• Effectively managed the full development cycle of Oracle database from release to release, including requirements gathering, design, code, prototyping, testing, delivery and post production support.
• Conducted post release analysis for process improvement.
• Created system and database performance guidelines after each release.
• Design and implement effective space management, disaster recovery strategy.
• Proactive monitor and profile client system and database performance.
• Successfully upgraded and migrated Oracle databases from release to release.
• Make constructive proposals for system and database performance tuning.
• Significantly reduced client production database downtime and crashes.
• Mentored junior DBAs to become more productive in handling DBA routines.
• Actively involved in hardware and software selection and purchase.
• Actively involved in architecture and box reviews from release to release.
• Developed internal web site for Oracle performance guidelines.
• Support more than 100 developers with all kinds of programming issues.
• Develop high quality PL/SQL programs ETL and other applications.

1998 to 1999 Principal DBA, Confidential,Chicago, IL

• Successfully converted Informix databases into Oracle databases.
• Successfully model, design and implemented central data warehouse.
• Effectively applied Oracle advanced replication strategy for three data marts.
• Develop ETL (extract-transfer-load) tools with UNIX shell and PL/SQL.
• Implemented effective disaster recovery strategy for company wide Oracle databases.
• Support development teams (about 50 developers) with database installation and configuration and with expertise on SQL and PL/SQL coding guidelines, database testing methodology and performance tuning issues.
• Proactively monitor and troubleshoot system and database issues in a timely manner.
• Mentored junior DBA to become more productive in handling DBA routines.

1997 to 1998 Oracle DBA Manger, Confidential,Hoffman Estate, IL

• Successfully accomplished a marketing promotion information system from scratch.
• Responsible for developing the full development cycle of Oracle database from data modeling, creating and maintaining ER diagrams with Erwin all the way to the testing, prototyping, delivery to production and post production services.
• Actively support development teams (about 20 developers) with database installation and configuration and with expertise on SQL and PL/SQL coding guidelines, database testing methodology and performance tuning issues.
• Proactively monitor and troubleshoot system and database issues in a timely manner.
• Responsible for UNIX system administration routines such as user security, disk space allocation, RAID configuration and system backup and recovery.

1994 to 1997 Consultant, Confidential,Oak Brook, IL

• Accomplished various Oracle DBA and UNIX system administration projects assigned.
• Successfully designed and developed a law case management information system with MS Access for a government agency.

RELATED EXPERIENCE

Part-time Instructor, Confidential,Des Plaines, IL

• Successfully designed and instructed Oracle DBA Certification and Oracle Forms and Reports classes. Many of my students got Oracle certified after classes.
• Successfully designed and instructed UNIX system administration class.
• Effectively administer UNIX system and Oracle databases for teaching.
• Effectively managed and accomplished various small Oracle projects.