Manager Oracle

Susan Wang

Phone: 973-***-**** Email: ***********@*****.***

Summary

Accomplished senior database administrator with over fourteen years of IT

experience in multiple databases and operating systems. Demonstrated the

ability to successfully implement and administer Oracle, MS SQL Server,

Sybase databases. Experience as both a DBA and developer enables me to

design and administer efficient databases as well as to remain focused on

the application requirements. Have experience in full project life cycle.

Possess project domain knowledge in Human Capital Management, Finance &

Account System, and eAcurial System. Project responsibilities have included

database administration and optimization, production support, data

modeling, software design, and code implementation.

Operating Systems: AIX, HP-UX, Solaris, Sun OS, Linux, Windows

Database: Oracle 7.x/8.x/8i/9i/10g/11i, MS SQL Server 7/2000/2005, Sybase

/12

Languages: SQL, PL/SQL, T-SQL, Shell programming, Pro*C, C++/C, Sybase Open

Client/Server, Visual Basic

Software Technologies: TOAD, DBArtisan, OEM, Erwin.

Employment

Affiliated Computer Services (ACS)

05/1999- 11/2009

Case, Inc

05/1998- 04/1999

Net Tech Solution

02/1997- 04/1998

Select Group, Inc.

04/1996-01/1997

Work Experience

Affiliated Computer Services, Secaucus, NJ as full time employee

05/1999- 11/2009

As an Oracle, SQL Server, Sybase DBA leader to support production in

Corporate multiple applications and oversee all technical aspects of

database systems.

. Member of team providing 24x7 supports for production databases.

. Rescued a major software project from imminent failure less than two

days before launch. As a result, I received a letter of commendation

from my manager stating, "You are my life saver."

. Created and implemented <Developer and Database Administrator

Guidelines> for four international divisions from different countries to

increase team productivity and prevent interruption of service to

clients.

. Created more than 70 shell scripts to automate our daily database

functions in less than three months using my personal time. Although I

transferred to a different group years ago, most of my legacy is

currently used.

. Redesigned a key procedure to increase the application's performance

from 15 minutes runtime to 3 seconds. Although I assumed writing SQL

code was not part of my responsibilities, but when we had a system

timeout error that no one could solve, I identified the bottleneck and I

re-wrote the procedure and expedited the performance.

. Writing, Implementing and testing of backup procedures for the

development, testing and production environment using Recovery Manager

(RMAN) on ORACLE and DR procedures for SQLserver

. Install, configure and manage all Oracle and SQL servers' databases

. Configured, implemented and maintained the Oracle Standby, Implemented

transparent

. Configured, implemented and maintained cluster databases and log

shipping on SQLserver 2000 Servers.

. Migrated and upgraded database servers. Performed Oracle and SQLserver

database migration

. Troubleshooting Oracle performance issues and applied patches.

Mellon Bank, Secaucus, NJ (Onsite consultant thru Case)

12/1998-04/1999

As an Oracle DBA, I worked on an Integrated Benefits Administration System

project.

. Enhanced and modified the existing data model using Power Designer and

implemented the data model into Oracle database 7.3 in AIX environment.

. Planned and built Oracle databases. Maintained database and application

security monitored and optimized database performance.

. Helped other divisions of the company to maintain and troubleshoot Oracle

databases.

Ernst Yong, Secaucus, NJ (Onsite consultant thru Case)

05/1998-11/1998

As a Oracle development DBA working for variety application

. Managed and maintained development and test oracle servers in HP-UX.

. Created database objects, such as tables, views, triggers, and stored

procedures etc.

. Setup dumps, load procedures, and transferred data using Sybase

utilities.

. Set up Oracle standby databases and log transfer processes for database

recovery.

. Efficiently refresh development/test/staging databases using production

logic backups.

Net Tech Solution, Rockaway NJ

02/1997-04/1998

. As a developer, I worked in the full life cycle of State ticked system

project using Oracle, C and Visual Basic.

Select Group, Inc. long island NY

04/1996-01/1997

. As a developer, I worked in a house accounting system using, C and

Visual Basic.

Education

B.S., Mechanics Engineering Gansu University.

Contact this candidate