DEBBIE LE TRAN

714-***-**** acopor@r.postjobfree.com

Profile

Database administrator (DBA) with experience in Disaster Recovery,

Oracle version 11g, 10g, 9i, 8i,

UNIX, LINUX Rhel, Suse, Windows, Access, Sybase, JDBC, Visio, Apache

Web Server

. Twelve years of supporting 24/7OLTP, OLAP, DSS, Datawarehose

production and development environments for Oracle databases, in-

house and COTS applications

. Managed and monitored the day-to-day operations of the database

systems, database management

. Depth performance tuning of SQL tuning, instance and objects

level tuning

. Capacity Planning Experience for new initiated projects and disk

pace growth estimate and calculation

. Expert in system integration, server, application migration of

in-house and COTS applications

. Installing, upgrading, patching, migrating Oracle databases and

applications

. Database Refreshes using Datapump and Schema Migrations

. Deep understanding on table/index partitioning on 11g, parallelism

. Ability to work with different teams, coordinating with the server

engineering team on installations. Patches, Backups

. Implemented SAP Upgrade from 4.6B PeopleSoft HR 8.9 and Financials

8.4

. Supported SAP, PeopleSoft enterprise applications

. Installing, configuring Weblogic, BEA Tuxedo, Jolt, SQR,

Application Designer, Peoplecode, Component Interfaces

Integration Brokers, Internet Architecture

. Disaster Recovery planning and practice, system capacity

projection

. Worked effectively in both strategic and tactical areas by

balancing long term objectives with short term needs and

demonstrates strong diagnosis and problem solving skills along

with exceptional judgment and decisiveness.

. Experienced in pharmaceutical and medical industries to comply

with GMP, SOX and FDA regulations

. Strong organizational and analytical skills, project management

and planning

. Excellent verbal, written communication and collaboration skills,

ambitious and self motivated

Software and Application

. Oracle version 7x, 8i, 9i, 10g, 11g AIX, HP, Sun, Data Guard,

Oracle Standby, Spatial and Context

. Datapump, OEM, BMC, Remedy, SQL Server 2000, SQL Server 7.0

. SAN, NAS, EMC, Hitachi, NetApps, Veritas

. SAP 4.6 B, PeopleSoft FS 8.4, HR 8.9

. BEA Tuxedo, Apache, Jolt, Application Server, App Designer, People

Tools, Integration

. Brokers, DataMover, DMS Scripts, PL/SQL, ABAP, Korn shell

. Oracle Grid, Oracle Enterprise Manager, Spotlight, Foglight, TOAD,

Embarcadero, Erwin, Oracle Designer 2000, Developer 2000, Database

Monitoring Tools:

. SAP R/3, IXOS, CRM, GENTRAN, Remedy, Documentum, Oracle Clinical,

Clintrace,Watson, LIMS, Activity Base

EXPERIENCE

Consultant, Database Administrator (remote)

January

2014- present

AMK Consulting Group - Malaysia

. Provided a thorough business and technical impact analysis for

software integration

. Refreshed databases from production environment to development,

training, QA servers

. Migrated of changed codes of applications from development, QA

environments to production servers

. Performed tuning for slow performance of applications, queries and

databases

. Troubleshot database and application bugs, supplied application

patches and fixed bugs

.

Consultant, Database Administrator

August 2013 -

November 2013

Sempra Energy / San Diego Gas and Electrics Company

. Supported the implementation of the upgrade of SAP modules

. Support production, QA and test databases, large Business Warehouse

on AIX p-series servers

. Provided a thorough business and technical impact analysis for new

software evaluation

. Migrated, installed, upgraded, patched and maintained various Oracle

database version from 8i to 11g to AIX platform

. Presented to upper management and business user communities the

technical and impact analysis of customer issues

Consultant, Database Design and Software Integration

January 2013-Jul 2013

Ho Chi minh City, Vietnam

Engage in software design consulting business and established a

consulting and training services.

Sr. Consultant, Database Administrator

February 2008 - December 2012

IBM Clients: AMGEN Company (Thousand Oaks, CA), Servicemaster(Memphis, TN),

Barclay Bank (NJ), PayPal (San Jose, CA), County of Riverside (Riverside,

CA)

Achievement: Data Center migration, database, application and server

migration

. Developed, tested and performed Disaster Recovery for critical

databases

. Supported production, QA and test corporate databases in various

sizes from 300G to 2 Terabytes in multiple platforms and operating

systems HP, Sun, AIX, Linux, Windows, SQL Server

. Provided a thorough business and technical impact analysis for new

software evaluation

. Migrated, installed, upgraded, patched and maintained various Oracle

database version from 8i to 11g

. Presented to upper management and business user communities the

technical and impact analysis of customer issues

. Enforced user security in various audit features to comply with FDA

and SOX compliances

. Resolved users tickets for various application/database issues

. Worked with developers in database design, tuned SQL coding and

configured job scheduling

. Assisted users in installing client software, ODBC connection, TNS

names and client security problems

. Investigated and implemented for security violation from audit

reports

Volt Information Sciences, Orange, CA / Sr. Database Administrator

July 2006 - February 2008

. Achievement: Upgraded PeopleSoft Human Resources to 8.9 and

Financials to 8.4

. Supported production, QA, training and test servers for Oracle

databases version 8i,9i and 10g running Peoplesoft ERP for Financial

8.4 and HR version 8.9

. Refreshed databases from production environment to development,

training, QA servers

. Migrated of changed codes of applications from development, QA

environments to production servers

. Performed tuning for slow performance of applications, queries and

databases

. Troubleshot database and application bugs, supplied application

patches and fixed bugs

. Installed, updated, configured and applied annual Tax Advantages

software

. Upgraded HR and Financials, database disaster recovery, backup

strategy and database reorganization

. Installed and configured PeopleSoft Process Schedulers, Application

Servers and Web applications.

. Supported developers in application design and modifications, object

creation. coding and program migration

. Performed Oracle installation, upgrade and patching

. Developed scripts to automate data backup and restoration procedures

. Provided technical support for database maintenance

. Tested and performed Disaster Recovery for critical databases

Orange County Register, Santa Ana, CA / Database Consultant

October 2005 - May 2006

. Supported Great Plains payroll systems and in-house daily

advertisement application on Oracle database version 8i and 9i of Unix

and Linux operating systems

. Maintained old legacy systems running on DB2

. Configured Tivoli software for monitoring databases and applications

. Configured and implemented Data Guard and Logical Standby databases

for failover and disaster recovery

Allergan- Advanced Medical Optics Irvine, CA/ Sr. DBA, Systems Consultant

April 1998- February 2005

. Achievement: Implemented and upgraded Lead in server and SAP

application

. Achievement: Project Lead in server and SAP migration when the company

spun off from Allergan

. Supported daily production corporate databases and worked closely with

users with daily administrative tasks such as disk space monitoring,

database objects creation.

. Developed, tested and performed database disaster recovery, backup

strategy, database reorganization, upgrade scheduling, software

installation and configuration.

. SAP /IXOS archiving, GENTRAN for EDI and IDOCS

. ABAP coding for SAP reports, configured for SD, MM, FI modules and jog

scheduling

. Installed, updated QUANTUM tax software for SAP application on MS SQL

Servers 7.0

. Extensive training courses on SAP R/3, CCMS. IXOS, MM, SD, BOM modules

. Remedy installation, coding and patching

EDUCATION

B.S. Computer Science, University of Florida

MS Florida International University- Management Information

Systems

Contact this candidate