SUMMARY

• Highly skilled Oracle DBA with more than ten years experiences.
• Extensive experiences in database architecture, design, installation, tuning, upgrade, capacity planning, troubleshooting, backup recovery procedure and life cycle projects implementation.
• Capable to work effectively both independently and in a team environment with strong analytic, problem - solving and decision-making capabilities.

SKILLS

Databases: Oracle (7.x, 8.0.x, 8i, 9i, 10g, 11g and RAC), PostgreSQL (7.x).

Operating System: Sun Solaris, Linux, HP-UNIX IBM AIX, MS Windows NT, 2003/XP

Languages/Tools: SQL, PL/SQL, Oracle OEM, Oracle10g EM Grid Control, DBA Studio, SQL Navigator, TOAD, Oracle Designer, ERWin, Power Designer, OAS (2.1-4.0.8), Exp/Imp, Data pump, SQL*Loader, Unix shell script and Windows NT Shell script.

EXPERIENCE

Senior Consultant (Senior Oracle DBA) Confidential New York, NY

• Work for Production & Infrastructure MG department to support and maintain of production databases (on Oracle9i, 10g and 11g RAC) on Linux and UNIX servers. Monitoring databases with Grid Control. Troubleshooting database issues.
• Work on Data Center Decommission/migration project. Wrote Linux/Unix shell scripts for RAC pre-installation OS checking. Built RAC databases environments, which including: Installed and patched Oracle 11g CRS software and installed RAC databases software and patches, configured ASM disks, created ASM instances, created/configured RAC databases and Data Guard (setup standby database), configured DGMGRL, created services for application users. Installed Setup RMAN backup. Migrated database from current production to new built production with data pump or RMAN restore.
• Grid Control Agent and configure databases with Grid Control. Configured the Grid Control Agent to point new 11g OMS from old 10g OMS.
• Setup Oracle Cluster Health Monitor (IPD/OS ), the Services stabilization script, auto-start configuration for stand alone host and CRS stop and startup scripts for RAC.

Senior Oracle DBA, Confidential New York, NY

NYMEX is the world\'s largest physical commodity futures exchange and the preeminent trading forum for energy and precious metals.

• Responsible for mission critical production databases supports such as Trading Management System (TMS), Enterprise Massage Agent (EMA), Clearport Clearing (CPC), Clearport Trading (CPT), Wireless Trading Platform (WTP), Settlement System (ESS), eBilling System and data warehousing.
• Project planning and coordinating with different teams to perform Oracle Clusterware, Oracle database and ASM installations, Oracle database, RAC database and ASM instance creations, Oracle databases upgrades from version 8i to 9i, 9i to 10g, 10g RAC, and 10g to 11g and to apply Oracle security patches, perform database regular maintenance or production rollouts. Implement database support documentation and its standards.
• Setup and maintain high availability databases using Oracle Data Guard, Oracle FailSafe (OFS), Oracle Real Application Cluster (RAC), Materialized view replication, Oracle Stream, ASM, Flashback Recovery Area, Flashback database and all other database new features.
• Design, develop, testing and implement database backup and media recover strategies and procedures such as hot/cold backup, RMAN backup, and logical backup (export and data pump). Recover databases from media failure and logic block corrupted.
• Sharing 24x7x365 rotational on-call and day time shifts responsibility.
• Worked on Data Modeling from design conceptual/logical/physical to implement into databases

using ErWin.

• Develop centralized monitor database activities scripts such as capacity planning, space management, alert log, replication synchronize between primary and standby databases, invalid objects, data corruption, replication/materialized views refresh, data guard apply logs, backup/recovery status and database refresh status, etc.
• Troubleshoot all database Client/Server related problems. Provide database expertise and consultancy services to other Oracle DBAs and developers.
• Designed and developed processes for data upload, data load and data migration with SQL*Loader, PL/SQL stored procedures and triggers, and Unix shell scripts for the data warehouse database. Implement table partition in data warehouse database. Maintain and monitor the data loading processes and database.
• Support Development, QA databases and help developers tuning scripts, production change requests and involved in house projects and its implementation.

Senior Consultant (Oracle DBA), Confidential Long Island City, NY

• Supported and maintained of OLTP production databases (on Oracle9i RAC), UAT and development databases from multiple applications on UNIX server. Installed and patched Oracle9i, create databases and application objects. Document production support processes and change management procedures. Maintained logical and physical data models, and generated DDL scripts using ERWin.

Oracle Database Administrator, Confidential New York, NY

Major responsibilities include:

• Supported and maintained of OLTP production databases as well as for the development and testing databases.
• Installed, upgraded and patched Oracle Database servers 8.0/8i/9i, Oracle Application Server (OAS) 4.0, iStore(ICS 3.2), Oracle ConText Server 2.4/Oracle8i InterMedia Text, Oname Server on Unix/NT servers.
• Designed and implemented logical/physical data modeling and generated DDL scripts using ERWin and Oracle Designer.
• Redesigned and tested a thorough backup and recovery strategy for all major production system. Developed Unix scripts for the database online/offline backup, and logical backup (Export). Used RMAN to perform backup/restore/recover databases. Performed complete or incomplete recovery of database due to media and user failure.
• Designed and developed processes for data load and data migration with SQL*Loader, PL/SQL stored procedures and triggers, and Unix shell scripts for the data extraction, transform, and load (ETL) process from OLTP databases to data warehouse databases and populated summary tables for data warehouse databases.
• Created, moved, cloned and restored Oracle databases with all databases objects and data populated to provide various databases environments for development and testing with different application’s versions.
• Managed system resource and space allocation, system security, user access control, and server auditing, monitoring and troubleshooting all kinds of database problems.
• Monitored, troubleshooted and optimized database performance and response time by tuning the instance (configuration, memory, processes and I/O), application design, SQL statements and table structures.
• Established and wrote the Database Administrator Procedures documents for DBA Team to standardize the procedures for installing/upgrading Oracle, creating databases, monitoring/problem logs, on-call logs and naming convention.
• Configured Multi-Thread Server with failover and load balance on multiple listeners.

Oracle Database Administrator Confidential Jersey City, NJ

Managed multiple Oracle 7.3, 8.0.5 - 8i database servers and Sybase SQL server 11 database for supporting ePayment management system on a networked of UNIX/NT server environment for Merrill Lynch. (Fundtech develops software and provides services for banks and financial institutions. E.g. Global PAYplus is the enterprise-wide payments management solution for global financial institutions).

Major responsibilities include:

Installed and configured the Oracle Servers, client software, and application tools.

• Designed and implement of data models for the ePayment system using ERWin.
• Provided scripts for scheduled job to back up the database daily online (hot) and daily logical backup (Export), weekly offline (cold) backup. Performed the complete or incomplete recovery of database as needed.
• Tuned the applications with SQL Trace, TKPROF, Explain Plan, Autotrace and tools. Performed workload analysis, collected various database statistics for optimizing database performance.
• Migrated Oracle 7 database to Oracle 8 database by using the Migration utility and Export/Import.
• Developed reports for the applications with Oracle Developer/2000.
• Developed the processes for packing the Database Server and Application Server using Unix Package utility. Packaged Web Server using MS Installshield.

Consultant / Oracle Developer and DBA 9, Confidential (through YHL International Corp., Warren, NJ)

Developed and managed multiple Oracle 7.3 to 8.0.5 databases servers supporting applications such as online mutual fund inquiry system, online retirement fund management systems on a networked Unix/NT server environment. (YHL is a consultant company, which develops applications and provides services for banks, financial institutions and insurance companies).

Major responsibilities include:

• Designed and implement of data models for the online mutual fund inquiry system using ERWin.
• Responsible for the day-to-day support and Oracle database administration activities.
• Installed and configured Oracle 7.3.4 server and applications tools on Windows NT and UNIX servers.
• Developed the reports for applications and databases with SQL, Pl/SQL, Oracle Report and Crystal Report.
• Developed the tools (with Unix shell programs, PL/SQL stored procedures and triggers) for easy monitoring and administrating database server and application server.