Oracle Manager

JIMMY OU, B.SC., M.SC.

Sayreville NJ *****

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

Phone: 732-***-****

PROFESSIONAL PROFILE

More than ten years experience working on both system and database

Development and administration, with focus on large-scale databases

Quick learner with keen interest in new technologies, and demonstrated ability

to grasp new ideas and methods

Good team player with a track record of successfully applying database administration, data warehouse development and operating system skills to consistently achieve ambitious targets

Known for creative and effective problem solving skills; able to resolve a wide range of technical problems

An individual with flexibility and high work ethics

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris 2.x, 2.9, 2.10), HP-UX10, 11, AIX 5L

5.3,NT4.0, Windows95/98/2000/2003/xp, Linux(Redhat 4/5)and MS-DOS

Database Oracle 7.x, 8i(8.1.7.4), 9i(9.2.0.7), 10g(10.2.0.4), 11g , MS SQL Server 6.5, 7,2000 and PostgreSQL(Enterprise DB)

Computer Languages: SQL, PL/SQL, psql, vsql, C, C++, Unix shell script, and scheduling cron job

Software Packages: Oracle server Enterprise Edition32bit/64bit, Oracle OEM, SQL* loader, Recovery Manager (RMAN),Veritas NetBackup5.0, Oracle Data Guard and standby database, SQL*plus, SQL Navigator, TOAD, Erwin, Oracle Forms4.5/5.0, Oracle Report2.5/3.0, MS Office97/98, visio, Veritas Quick I/O file system, LVM, Quest Spotlight, STATSPACK, TKPROFF, AWR, ASH, SQL Server Enterprise Manager, T-SQL,

Networking: TCP/IP, Oracle SQL*net (listener configuration), IIS configuration, proxy server and printer server configurations, LAN administration and troubleshooting

PROFESSIONAL EXPERIENCE

Vonage New Jersey, USA November, 1, 2007 ~ Present

Oracle Database Administrator

Primary DBA for REGEVENTS, CQM, GW_CALLS, DMM_REQUESTLOG and DTCs (for Call Quality Management project) using Oracle 10g R2

Installed, configured and supporting NetcoolReporterDB in Oracle 10g R2.

Primary DBA for NetcoolReporterDB production.

Supporting PostgreSQL environments.

Supporting Dev, QA and Prod Oracle environments

Supporting primary/standby Oracle environment

Implemented the deployments of DB objects changes

Rman backup and recovery

Performance tuning

Logical backup with Oracle Data Pump

Designed and reviewing data loading strategy and supported the loaders

Installed, configured and supporting Oracle 9i, 10g and 11g

Primary DBA for a 10TB DW

Supporting applications by using the ticketing system

Providing 24 x 7 on call production Databases support

Merrill Lynch New Jersey, USA February, 2006 ~ October,31, 2007

Senior Oracle Database Consultant

Supported all FRT (Finance Reporting Technology) DBs as a primary DBA.

Supported HR database systems as well.

Responsible for all Development, QA environments, as well as supporting all production systems

Supported Oracle HA production system (VCS)

Implemented DBs performance tuning

Provided on call 24x7 DBA support

Supported backup & recovery with RMAN and logical export

Installed Oracle and configuring database in windows, Linux, and AIX

Database migration between different OS platform and upgrading from 8I to 9I,and 9I to 10g

Applied Oracle patch, and implemented database security

Supported application team with release management system ( including ticketing system )

World Kitchen Inc., Corning, New York USA January, 2005 ~ January, 2006

Senior Oracle Database Administrator (Consultant)

Responsible for supporting 44 databases on development, testing and production, environments at data center of WKI using Solaris 2.X and linux/Oracle 8I, 9I and 10g, Windows 2000/ Oracle and SQL Server 2000 which is including 2TB production,

Implementing database backup and recovery using legato and DB recovery skills.

Learned some SAP transaction codes.

Implementing Oracle DB servers performance tuning.

Monitoring and implementing database space management using SAPDBA, BRTools for SAP environments

Providing and implementing database disaster recovery procedure,

Implementing DB upgrading, applying bug fix using Opatch and changing management.

Scripting for database monitoring using UNIX shell, PL/SQL and TSQL,

ROYAL BANK OF CANADA Toronto, ON June 2001 ~ December 2003

Senior Oracle Database Administrator / Senior System Analyst

Nominated for the 2002 royal investment services award of excellence

Succeeded in building databases from the beginning of the project through to completion.

Provided full support for all databases, which included 1.5TB production, development and testing databases on Solaris 2.8 for RBC ClientLink three tiers wealth management system.

Supervised and trained team members, programmers and end users using Oracle products to build strong ClientLink technical team.

Advised recommendations for SQL statements optimization to help programmers debugged, tuned application code.

Coded procedures, functions, triggers and packages using PL/SQL.

Developed data loading procedure using SQL*load.

Successfully done data modeling using Erwin for data warehouse schema.

Installed and configured Oracle9iRAC with two nodes on testing environment successfully.

Configured data files on RAW using Veritas Quick I/O; achieved significant improvement of system performance.

Provided 24x7 on-call system support to ensure proper operation of all database systems.

Successfully upgraded database instances from Oracle 8.1.6.3 to Oracle 8.1.7.4 and migrated Oracle 8i to Oracle 9i.

Consistently and effectively managed large-scale databases including table space management using OEM or Spotlight.

Developed and implemented database backup and recovery using RMAN.

Oversaw all aspects of system change management including policies and procedures for project software version control; promoted application (XEYE build, RBC build and all EBF codes) from development to testing and then from testing onto production environment.

Installed and configured Oracle Data Guard and Oracle standby database for system disaster recovery.

Effectively tuned databases using Quest Spotlight and Oracle utilities (STATSPACK, TKPROFF).

Managed database objects: tables partitioning, analyzing, indexing and data replicating resulted in significant improvement of system performance.

Created and maintained user id and its roles for database security.

Performed Oracle installation and upgrading on Unix.

Reverse engineering and modifying an existing database using Erwin.

ONX.COM INC., Toronto, ON April 2000 ~ June 2001

Data Base Administrator / Oracle Consultant

Responsible for installing, configuring, performance tuning, migrating and cloning a range of databases (Oracle and SQL server2000) for Health Canada, Canada Helps, Harlequin Oracle databases on Solaris, AIX, Linux and Windows NT.

Ensured the smooth day-to-day operation of Oracle database, including back-up status check, database growth capacity, and performance improvement.

Effectively tuned the database performance and its application.

Successfully completed database migration for Canada Help organization

Created and maintained user identification and its roles for database security

Oversaw databases logical model updates and design for Harlequin and Canada Helps databases using Erwin.

Managed HP Data Center (HPDC) and Purolator Optical Scanning Project (POSP) application through the use of Oracle 7.3 and HP-UX system administration.

Created databases on RAW using LVM(Logical Volume Manager); Skilled in RAW device management.

Successfully created Unix shell script for large size database backup and recovery with RMAN.

Managed storage system for HP Sure Store Optical 1200ex Jukebox, (5.2GBx238, 10 drives) and HPDLT Jukebox (four drives 80GB 2@, tape system).

Developed stored procedures, packages and scripts using PL/SQL and Unix shell for data retrieved and databases management.

Limited downtime on databases and systems by effectively and timely troubleshooting databases and its applications.

ABSTRACT SOLUTIONS LIMITED, Ottawa, ON September 1998 ~ April 2000

Oracle Data Base Administrator (Contract Consultant)

Migrated Oracle database from version 7.3 to version 8i on Sun Solaris 2.6 as well as Windows NT4.0 for CTC (Canadian Tourism Commission).

Successfully converted stored data between English and French.

Developed disk capacity plan and provided its information to management team.

Coded Unix shell script for backup and recovery; created cron job to schedule backup procedures.

Provided technical support to two development groups located in Ottawa and Toronto.

Worked closely with programmers and developed stored procedures, functions, triggers and packages using PL/SQL.

Developed data loading procedure using SQL*load for data management team.

Responsible for databases promotion from acceptance environment to production environment.

Working with business analyst completed a physical and logical model for CTC new project using Erwin.

VERSUS TECHNOLOGIES INC (E*TRADE CANADA), Toronto, ON

August 1997 ~ July 1998

LAN System Administrator/ Help Desk

Effectively maintained and supported a TCP/IP base LAN consisting of PCs, Sun workstations and servers, printers and modems.

Installed and configured Sun servers and workstations (Solaris 2.x).

Provided help desk assistance and timely, responsive support for over 200 users which included on-call technical system support.

UP TECHNOLOGY INC., Stanford, CT September 1996 ~ July 1997

Oracle Database Administrator /LAN System Administrator

Installed, configured and supported numerous Oracle databases on Unix and SQL server on WindowsNT4.0 platforms.

Supported 1000 database end users; provided timely and responsive on-call technical support.

Coded stored procedures (used PL/SQL) and Unix shell scripts.

EDUCATION

Oracle Certified Professional Database Administrator, Oracle Corporation, 1998

Master Degree of Computer Science, City University of New York, NY, USA 1996

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate