Sql Server Oracle

LUCY ZHANG (Citizen of USA)

abmrim@r.postjobfree.com

OBJECTIVE

Seeking a DBA position that effectively utilizes years of strong DBA

experience in Oracle, Sybase, and SQL Server databases on a variety of

platforms. Only considering positions in the Arizona vicinity.

EXPERIENCE

Feb. 2009 - Present: Oracle DBA, ATS

. Migrated 24 stand alone databases to Oracle 10g RAC. Created new

databases on RAC. Updated Oracle databases from 9i to 10g.

. Developed daily RMan process to duplicate test databases from production

databases. Maintained and monitored database RMAN backups.

. Supported applications development cycle and new release. Developed SQL

code and supported daily requests.

. Used Grid control and TOAD to monitor and tune Oracle databases and SQL

statement performance.

. Managed and monitored disk usage and allocated tablespaces.

. Performed very minimum MS SQL Server DBA work.

Oct. 2006 - Feb. 2009: Sr. Oracle DBA, Coventry Health Care, Phoenix

. Managed and administrated 9i and 10g Oracle databases up to 1.8 TB.

Upgraded and migrated several Oracle 9i databases and First Rx

applications to 10g RAC. Created and cloned 9i and 10g databases.

. Upgraded Data Guard databases to 10g. Created physical standby database.

Monitored the standby databases refresh.

. Used RMAN to backup databases, and restored databases. Performed extract

data, export and import as needed.

. Worked with core development to tune databases and queries by using AWR,

Statspack, and Explain Plan.

. Created application users and managed security auditing.

. Administrated, installed, configured, migrated, upgraded and patched

First Rx applications.

Nov. 1999 - Jan. 2006: Sr. Client/Server DBA, Alverno Information Services,

Indianapolis

. As principal senior DBA on Oracle 7.x/8i/9i/10g, Sybase ASE

11.03/11.5/12.0/12.5 and MS SQL Server 6.5/7/2000 on Unix, Windows and NT

platforms, led the support of major Oracle and Sybase databases in the

organization (Peoplesoft HR Payroll System, Physician Management System,

Cost Accounting, Pay Roll, Patient Management System, Database Warehouse,

etc.).

. Performed database administration, including installing, migrating,

upgrading, cloning, exporting and importing, tuning up, backing up and

recovering databases; controlling user privileges; making disaster

recovery strategy plans; allocating disk space and planning and

estimating disk growth on Unix, Windows and NT systems; developing Unix

shell and NT scripts (for backing up, monitoring, and maintaining

databases, creating Unix raw partitions and data load)

. Monitored and maintained Oracle databases by writing shell scripts and

using OEM, DBArtisan and Patrol; Monitored and maintained Sybase

databases by writing shell scripts and using Sybase Century and Sybase

Advantage and Patrol; Monitored, maintained and tuned SQL Server

databases by using performance monitor, query analyzer, enterprise

manager Patrol.

. Upgraded Oracle, Sybase and SQL server databases. Also upgraded vendor-

supported databases by using vendor-provided procedures. Configured

multiple applications that talk with databases.

. Performed SQL and PL/SQL programming to manage and manipulate data. Used

SQL*Loader, BCP and ftp to write shell scripts to transfer data.

. Managed and upgraded Oracle OLAP express server.

. Used Veritas-Netbackup (3.4/4.5) to back up, restore and monitor

databases. Wrote shell scripts for Oracle, Sybase and SQL sever database

back up.

. Tuned Oracle databases and SQL scripts by using Explain Plan, generating

trace files, TKprof and Statspack. Wrote and re-wrote SQL and PL/SQL

scripts. Partitioned large tables by writing shell scripts. Trouble

shooting with errors from databases and Unix system.

. Supported development team for databases, applications and SQL scripts

issues. Performed PL/SQL and T-SQL and programming, migrated database

objects cross different database sever or different database version.

. Interacted with end users, developers, database administrators, network

administrators, technology teams and other IT staff as needed.

Aug. 1998 - Nov. 1999: Senior DBA (Database Administrator), ITT Educational

Services, Indianapolis

. Administrated Sybase ASE (11.5.1/12.0) Server - Installed, migrated,

upgraded, created, monitored Sybase database server and allocated and

managed disk space. Tuned up, backed up and recovered databases.

. Administrated and installed Oracle 8i databases and Oracle applications

11i (Oracle Finance, HR, Pay Roll).

. Developed Unix scripts and Sybase bcp to transfer and manipulate data

between different systems. Wrote Unix scripts to maintain and monitor

databases. Monitored and controlled user access.

Worked on database design and modeling using PowerDesigner.

Supported developers in writing SQL scripts, stored procedure, designing

and building up database objects.

April 1997 - Aug. 1998: Senior System Analyst/Oracle DBA, Avantec Inc.

(CRO), Indianapolis

As Oracle DBA (with Oracle 8i on Unix) in FDA-regulated environment,

created all kinds of Oracle objects, controlled user access privileges,

developed Unix scripts and utilized SQL*Loader to transfer and manipulate

data between different systems, tuned up SQL statements.

Migrated database from MS Access to Oracle, designed database model with

PowerDesigner-DataArchitecture, and developed clinical trial applications

using MS Visual Basic as front end and Oracle as back end (Wrote design

specification, test scripts and release authorization).

Performed stored procedure, SQL and PL/SQL programming on UNIX and Windows

NT.

Worked with end users in designing and creating reports and tuning up SQL

statements using MS Access as front end from Oracle databases in order to

augment business functions.

Feb. 1996 - April 1997: System Analyst / Consultant, Premier Solutions

Inc., Indianapolis

Performed Oracle, SQL Server, NT server administration - installed Oracle

on NT Server; created primary database and objects; modified database

structure; enrolled users; backed up and recovered database; administrated,

maintained and monitored Oracle Server, SQL Server; backed up databases and

NT Server daily.

Used Oracle, MS Access, MS ADT, ODBC and MS Project to develop Time

Tracking System. Migrated the database from SQL Server to Oracle, and from

MS Access to SQL Server.

Used UNIX, Oracle, Visual Basic and Entera for 3-tier Client/Server

architecture database development for Cummins Inc.'s Assembler Management

System. Created Oracle databases and schemas, wrote and modified RPC calls

and GUI.

Used ERwin to complete the Gerber FMS data model enhancement (converted the

data model from Visio to ERwin). Used Visual Basic to develop FMS system

for Gerber Products.

Designed specifications for a project management system for the Department

of the Navy

using MS Visual Basic, MS Project, ODBC, and MS Access.

May 1995 - Feb. 1996: Database Analyst / System Administrator, Bee Window,

Inc., Indianapolis

Designed and programmed a large marketing Leads System application using MS

Access, wrote user menu, and trained users.

Migrated production database from QA to Access database. Developed Unix

scripts to load data between QA, Clipper and Access. Manipulated the data

to generate reports.

Administrated NT server, Novell network server, and server backup and

recovery.

Oct. 1994 - May 1995: Database Programmer, Sagamore Health Network Inc.,

Indianapolis

Performed MS Access programming, wrote SQL statements, generated reports

against SQL Server for a health insurance management system application.

Jan. 1992 - Feb. 1994: Graduate Assistant, Eastern Michigan University

. Tutored MS DOS, Excel, Basic, Pascal, and mathematics.

. Used SAS to perform statistical analyses to support clinical trials.

Skills

Platforms

. Hp-Unix, AIX, Sun Solaris, VAX/VMS, Windows NT, XP, 98/2000, MS Dos

Software

. ORACLE RAC, Rman, Oracle 7.x/8i/9i/10g, Oracle client and all Oracle

administration tools (OEM, Oracle Studio, EXP/IMP, SQL*Plus, SQL*Loader),

Oracle applications 11i, OLAP express server 632.

. Sybase ASE11.3/11.5/11.9/12.0/12.5, bcp and Sybase Central, Sybase SQL

Advantage, BMC Sybase SQL Backtrack, SQL Anywhere

. SQL Server 6.5/7/2000, SQL server administration tools;

. Embarcadero DBArtisan, ODBC, Exceed, Extra, PowerDesigner

DataArchitecture 6, Entera 2.0/3.1, ERwin 2.5, MS Visual Basic

3.0/4.0/5.0, MS Access 98/2000, MS Project, TCP/IP, FTP, Sourcesafe, MKS

Source Integrity, Telnet, X-Windows, Heat log, Veritas 3.5/4.5, Perforce

Languages

. SQL, PL/SQL, Visual Basic

Formal Training

Peoplesoft Server Administration release 8.12

Oracle Introduction SQL and PL/SQL Using Procedure Builder

Oracle Database Administration

Oracle Backup and Recovery

Oracle Network Administration

Sybase Fast Track to Server Enterprise

Sybase System and Database Administration

Programming with Visual Basic 4.0/5.0

. Entera Fundamentals (3-tiered Client-Server software)

EDUCATION

M.S. in Mathematics, with Concentration in Computer Science

Eastern Michigan University, 1993.

Contact this candidate