SUMMARY:

• 15+ years of working as Oracle Apps DBA since Oracle Version 6 Oracle Financial up to 12i E - business Suite (CRM/ERP) and Oracle Financial of all versions from Financial version 7,8, the up to 11i and 12i on all modules such as MRP, I-Procurement, Work Flows, Project Accounting, AP, GL, AR, PO, Hr, etc..
• Strong experience on Apps Sys Admin Functional roles of setup program, forms, reports, responsibilities, menus, load-balance concurrent managers, etc. Database and Application installing, cloning, patching.
• Oracle Rman and System backup/recover. Disaster recovery implementation, security.
• Forms and Report Developer and Oracle Fusion, Frame Work, APEX.
• Worked with Oracle on UNIX clusters, RAC, ASM, OEM, Data Guard, and Stream Replication.
• 5+ years of system administrator on variety RAC environment on UNIX server and cluster such as HP(UX), SUN (Solaris), IBM(IAX), Linux, window 2003, and windows 2008 enterprise servers
• Some practical and on Sybase, SQL Server R2 for SAP, & PeopleSoft HR Development People Codes.
• Knowledge of Sybase System 10/11
• Experience of using Unix LVM, VXVA(SUN/SOLARIS), SMIT(IBM/AIX) SAM(HP/UIX).
• Proficiency UNIX shell programming such as Born, Korn, Bash, and C shell.
• Experience of using UNIX backup tool Networker, OMNI, Veritas.
• Strongly experienced on variety UNIX / RDBMS platforms such as: HP 0/T520/T600, H, K, and M, V Series (HP UX R110 and R11), Sun Micro System from workstation to enterprise servers 4500/6500/10000 (Solaris 2.6), Sun Server 7000, IBM RISC 6000/8500 (AIX 4.2), Compaq True 64 bits (Cluster), DG-AVION (UX).

TECHNICAL SKILLS:

Software/Hardware: Oracle 5 to 9i/10g/11G, Oracle Financial (AP, GL, AR, PO, PA, HR), RAC, Sybase, SQL Server R2 for SAP, People Soft Human Resources, Java, C, C++, SQL, PLSQL, BAT, UNIX Shell, People Soft (People Code, Processes schedule, SQR) release 4/5/6/7, Sybase System 10/11, Oracle Developer, Oracle Report Writer, Oracle Forms designer, Oracle Exchange APEX, Portal development, SiteScape, Noetix, Oracle Discover, Crystal Report, Remedy Help Desk, Oracle Database Warehouse, Stream Replication, Oracle Enterprise Manager, Veritas - Net-backup and VXVA and Database Edition for Oracle, Legato - Networker, Omni-Back, Clear Orbit, Informix ESQL, I4GL, ESQLC Version 2.xx and 4.xx. HP 0/T520/T600, H, K, M, V Series (HP UX R110 and R11), Sun Micro System from workstation to enterprise servers 4500/6500/10000 (Solaris 2.6), Sun Server 7000, IBM RISC 6000/8500 (AIX 4.2), HP True 64 bits Cluster, DG-AVION (UX), EMC storage. Honeywell Bull DPX2/200/300, Sequent cluster (DYNIX/PTX) Clusters, Sperry 5000/6000, Novell 3.2 /4.0, Linux Red Hat, SCO UNIX, Windows Server 2003/2008

PROFESSIONAL EXPERIENCE:

Confidential, TX

Senior Oracle Apps DBA

Responsibilities:

• Independent consulting short-term and long-term projects, Last short project was in Vietnam to Install Oracle E-Business Release 12
• Responsible for design, setup, install development system, test system, and production system
• Installed and setup Oracle Apps 12i - E Business on Linux 2 tiers servers
• Involved in setting up AP, GL, and AR modules for demonstration to potential clients
• Involved in setting up Multi Org, set of book on financial system
• Defined Customized Concurrent Programs, Customized Reports, maintain load balance on Concurrent Managers
• Defined setup and configure printer for Oracle Report Writer
• Cloned Oracle Apps database from development to test environment and production environment
• Involved in maintenance patching Oracle patches on all environments
• Performed tuning, trouble-shooting, and support both developers and end users
• Involved in setting up 11G grid control database for Oracle Stream Data Replication and monitor transaction
• Install Oracle middle wares such as Oracle Fusion, OBIEE Web-Logic and trouble-shoot installation issue for interface with Oracle Application database.
• Installed and setup Oracle Web Logic and Developer package for development node
• Supported team member on troubled shoot apache on both http and https
• Involved in setting up Oracle RMAN Backup/Recovery on DB server’s nodes plus fail-over servers and standby database, Data Guard setup and implementation.
• Responsible for apply and maintenance all Oracle patches on all Oracle environment

Environment: Oracle E-Business Release 12, Oracle Apps 12i - E Business, Middleware Fusion, Web Logic OBIEE of 11g, Setup AP, GL, AR, RMAN, Apps Sysadmin Functional, Oracle Report, Sun Solaris, Linux, Windows 2008, Rman, Data Guard.

Confidential, TX

Sr. Oracle DBA

Responsibilities:

• Involved in installing, setup, configuration of all database instances of multiple applications such as IDEF, ERWIN, AFMII, SSTI, AGAM, IPDS, etc. Trouble problem base on Oracle trace files and log files
• Daily tasks included performance monitor, applying code change, trouble-shooting application problems combined with operation system or configuration related issues
• Followed AFMA Air force security guide lines to setup security on all application servers and database servers
• Maintained Data Extraction from Oracle to MS-SQL in and out of AFGAM application
• Maintained Erwin Revert Engineering Module of some AF application
• Designed daily backup/recovery for all instances by RMAN combined with Batch Programming and Task Schedules - The code should transfer the daily backup to a remote site for Disaster Recovery
• Involved in research analysis on every monthly Oracle TCNO for Oracle Patch Requirement if it needs
• Upgraded Oracle from 9iAS to 10G then to 11G
• Migrated IPDS application from Sun-OS to Windows Server
• Maintained support Remedy Helpdesk Oracle database
• Installed setup Oracle APEX and Oracle Developer, Web Logic for developer team.
• Install Forms Report Developer, Fusion, OBIEE Web Logic. Trouble-shoot connection all issued related to Oracle Middleware for AFMA Developer team.
• Passed certified examination Security Plus - That requires by US Government
• Involved in setting up Test environment by using Data Pump and Replication 10G Feature for testing environment
• Setup standby database Oracle data guard.
• Used 11G Cluster AS server to monitor database and setup Logs Miner Session for production databases

Environment: Oracle 9iAS/10G/11G, RMAN, MS-SQL, Erwin, IDEF, AFMII, SSTI, AGAM, IPDS, DMZ Zone, Oracle APEX, Oracle Developer, Middleware Fusion, OBIEE Web Logic, Sun-OS, Windows Servers.

Confidential, TX

Senior Oracle Apps DBA

Responsibilities:

• Involved in performing tuning database instances and reviewing code promoting to all environments such as staging and production.
• Involved in daily monitoring system and databases, following tar on Metalink and Oracle patches impacting analysis, recommendation upgrading path, defining concurrent manager queues and balancing the entire queue and work shifts all instances.
• Involved in Performance tuning slow running and high LIO SQL statements.
• Trouble problem base on Oracle trace files and log files.
• As application DBA supported all version instances on 11.5.10 on Sun platform, data-warehouse instance, patching Oracle patches, and contribute idea and experience on upgrade Oracle Apps on to 12i E business

Environment: Oracle, Oracle Apps 11.5.10 and 12.0.4 E business, SQL, Sun(Solaris 2.6)

Confidential, TX

Senior Oracle Application DBA

Responsibilities:

• Maintained production databases of Oracle Application - both ERP and CRM, Internet Procurement (SSP5) 115.2, and Oracle 9iAS Portal combined with SiteScapes
• Completed upgrade of Oracle Application 11i from 11.5.2 to 11.5.6, to 11.5.9
• Completed installation and set up 9iAS IFS to replace company shared drives
• Involved in new software install, trouble shoots both production and development problems, and daily DBA work such as performance tuning, backup and recovery, and patching
• Involved in heavy cloning jobs on 11i up to 11.5.9
• Cloned database from multiple tiers apps server to single tier apps server and the other ways
• Helped other Junior DBA’s to complete Rman backup scripts
• Designed a technique to produce the barcode (Code39) reports then printing report output files on variety printers like HP models and Xerox model
• Provided experience ideas in system architecture on Compaq True 64 bits clusters and stand alone nodes
• Provided configuration, setup, and support of warehouse mobilization
• Provided installation of Clear-orbit software on Unix True 64 bits Cluster environment

Environment: Oracle 9iAS Portal, ERP, CRM, Internet Procurement (SSP5) 115.2, Oracle Apps 11.9.5, 11.5.9,11.5.10, Rman, SiteScapes, HP Linux Red Hat, HP True 64 Cluster.

Confidential

Oracle Apps Consultant

Responsibilities:

• Installed Oracle Financial E Business Suite on Sun platform. Constantly apply and trouble shoot problem after applying Oracle patches on both database server and form server (Oracle Application 11.5.0 to 11.5.4)
• Involved in setting up backup recover using RMAN and Veritas Net Backup. Add more physical disks to database server and using VXVA /LVM to build additional file system
• Built test,, and refresh development environment by cloning production database.
• Audited codes before register to Oracle Application
• Corrected registration procedure with Oracle Financial
• Heavily trouble shoot http, apache, Java packages, and oajinit on UNIX platforms
• Installed set up 11i and SSP5, I-Procurement on Compact True 64 Bits
• Involved in installation and setup Clear Orbit on 11i, upgrade 11.5.2 to 11.5.5

Environment: Oracle Application 11.5.0 to 11.5.4 11.5.9 , 1.5.10, RMAN, Oracle Financial, Java, VXVA, Veritas Net Backup, SSP5, I-Procurement, UINX, Compact True 64 Bits

Confidential, TX

Sr. Oracle DBA / UNIX SA

Responsibilities:

• Maintained and trouble-shoot Oracle Financial 10.7 that includes AP, GL, AR, OE, WIP, INV, Etc
• Primary duty is to correct production database to handle more than one thousand of concurrent sessions, mostly concerning on performance on DG-UX and Sun Solaris that includes OS Kernel tuning, Oracle kernel tuning, install OS patches and Oracle patches
• Corrected the initial setup and design of OE and AP
• Tuned Citrix Win-frame, Sun Micro System-Solaris Kernel, LVM, Cook File Systems, Oracle Kernel, Database Package Procedures
• Involved in installing, setting up, and maintaining Legato Backup for Oracle and UNIX on DG (UX) environment
• Involved in installation, setup, and maintaining Veritas Net- Backup on Sun Solaris 2.6 that includes Net Backup for Oracle
• Installed and setup hardware such as DLT tapes (arrays), Disk arrays (Sun storages and EMC Storages)
• Installed Oracle Apps on Sun platform, and constantly apply patches
• Corrected major problems in 1099 of AR module due to PL/SQL logic error
• Corrected problem relate to SQL*Net and Order Entry Transaction Manager
• Corrected problem with Discover and Noetix and Advice Company about data warehouse architecture. Install setup UNIX printers
• Wrote Pro C, Shell scripts, RMAN scripts for the environment
• Recovered database crash due to corruption of online redo log file
• Sometime work perform take more than 24 hours continuously
• Supported Oracle Discovery and its security layers for in and out data manipulation on the requirement reports

Environment: Oracle Apps, Oracle Kernel, PL/SQL, RMAN, Oracle Discovery, SQL*Net, Order Entry Transaction Manager, Pro C, Shell scripts, Veritas Net- Backup, Legato Backup, Order Entry Transaction Manager, Citrix Win-frame, DG-UX, Sun Solaris, UNIX

Confidential, Miami, Florida

Oracle DBA / UNIX SA

Responsibilities:

• Involved in installing setup and maintaining Oracle Financial 10.7 (NCA) and 11 (GUI and Web Application)
• Installed and setup OMNI Back to backup Oracle and UNIX on HP (UX 10.2 and 11), DNS for Corporation, Unix Mail to CC Mail on Unix and window NT
• Installed and maintained Financial Patches on both database servers and form servers
• Wrote a lot of Shell scripts and Pro C for SA to monitor Oracle and Power Builder

Environment: Oracle Financial 10.7, GUI, Shell scripts, Pro C, DNS, Power Builder, UNIX on HP (UX 10.2 and 11), Window NT

Confidential, KY

Oracle DBA / UNIX SA

Responsibilities:

• Responsible for production support as an UNIX system administrator on Sun 10000 and maintaining Lawson financial database on Oracle base
• Involved in setting up Legato backup Oracle databases for all Unix nodes
• Installed Sun OS and Solaris Patches for 2.5 and 2.6
• Installed both hardware and software for DG Clarion Disk Arrays

Environment: Oracle, Legato backup, DG Clarion Disk Arrays, Sun OS, Solaris 2.5/2.6

Confidential

Senior Oracle DBA

Responsibilities:

• Responsible as primary DBA to handle three different environment of Oracle Financial 10.5 with Multiple Organization and Human Resource / People Soft Oracle Database. Those includes database replication, maintain database objects, register and maintain concurrent programs, performing tuning
• Implemented modules are AP, GL, AR, OE, INV, and MRP, Advice Unix SA on Unix Kernel tuning to handle high volume of Oracle databases and implementing Unix system scripts to support the entire environment
• Successfully trained junior DBA to become expert of Oracle Financial DBA

Environment: Oracle Financial 10.5 AP, GL, AR, OE, INV, MRP, Sun Solaris UNIX, Kernel Tuning

Independent Oracle DBA Contractor

Responsibilities Managed:

• As a Oracle DBA at Confidential, responsibilities included maintaining Oracle base applications such as MAPS, Deltek-Cost Point, and Oracle Financial
• Upgraded Oracle Financial 9.4 to 10.6
• Trained other employees to become Oracle DBA
• Responsible for fresh installation and upgrading Oracle Kernel, Oracle Financial up to 10.6 on variety platform such as Sun (Solaris 2.4 and 2.5) and HP-UX 9 and 10 for many company such as Confidential, County of Baltimore, National Senior Citizen Council ( NSCC), Journal Newspaper, and Confidential

Environment: Oracle Financial 9.4 to 10.6, Oracle Kernel, Oracle Financial, Solaris 2.4/2.5, HP-UX 9/10

Confidential, Alexandria, VA

Independent Oracle Consultant DBA

Responsibilities:

• Provided technical support for ISM project that included trouble-shut problems, review Oracle function package procedure, Pro C's Makefile, Oracle Kernel configuration, tuning database
• Reviewed Pro C programs to investigate Oracle deadlock on Confidential 's DIAL applications
• Ben mark Sybase System 10 vs. Oracle version 6.
• Rewrite NetBackup Scripts to handle Oracle Hot Backup.

Environment: Oracle, Sybase, NetBackup, Pro C. HP/UX.

Confidential, Mc Lean, VA

Senior Database Administrator Engineer

Responsibilities:

• Involved in database installation, tuning databases and applications, and provided technical support. Assists Confidential 's internal DBA in maintenance and planning of internal production database issues. Install Oracle Financial 10.6 on Sun Sparc and HP-UX
• Provided Technical Support to Oracle Financial Sale Team that include configuration, trouble-shut problems, and customization as customer requirement
• Supported setup and implementation of AR Oracle Financial production 14 at GE information Systems at Rockville, Maryland
• Upgraded customer Financial System from Oracle V6 to V7 on Novell 3.2 and 4.0. Trouble-shoot Sql*forms and Sql*Menu problems
• Provided technical support on both HP-UX and Oracle DBA on migration and upgrade Oracle on a Clients/Server environment.
• Provided systems analysis, systems and databases trouble shoot, software and hardware upgrades, and one to one customer DBA to maintain HP-9000 UX, Silicon Graphic (SGI), Window-NT, Oracle, and Power Builder and Erwin in clients / server environment
• For Natural of Resource-Government of Belize, Central America, provided trouble shoot, bugs fix, correct the original design of Oracle Base Application on most of Oracle's tools such as Sql*Menu 5.0, Sql*Forms3.0, ProC, Sql*Report. Finally tuning UNIX kernel, Oracle kernel, and application to make the entire system to get better performance
• Provided one to one experience to client's DBA and application developers.
• Provided trouble shoot and fixed database corruption on Novell Netware and Sun (Sun-OS)
• Provided shoot Oracle Kernel and Sql*Net on IBM-RISC 6000. One to one client DBA. Develop system program for operator and system administrator to maintain UNIX / Oracle on Token Ring Network
• For Forsyth Hospital, North Carolina, Provided trouble shoot Oracle Kernel and Network on IBM-RISC6000 to handle multiple databases in clients/server environment. Provided program and trained client’s DBA and system administrator for maintenance Oracle on AIX environment
• Provided setup a conversion project from mainframe to Sparc-1000 (Solaris 2.4). Trained 5 client's DBA. on setup and backup/recover Oracle on Sun Solaris
• provided technical support on Sequent Dynix PTX, Oracle Financial version 9.3, 10.40, 10.41, 10.42. Those included application upgrade, trouble shoot problems, client's DBAs and System Administrators

Environment: Oracle Financial 9.3/10.40/10.41/10.42 , SQL.NET, SQL*Menu 5.0, SQL*Forms3.0, Pro C, SQL*Report, Sparc-1000, Novell Netware, Sun Solaris, UNIX, Sun OS, HP-UX

Confidential, Rockville, MD

DBA Leader

Responsibilities:

• Responsible for maintenance and support of multiple large Oracle Databases (180 Giga Bytes) on the Sequent Dynix/PTX Cluster environment. Those include in-house design applications by IEF client / server architecture, TUXEDO based applications, People Soft Financial and Human Resource Client / Server Systems and supervise junior dba. Primary duty is specialist support TI/IEF CASE environment and financial system
• Daily performed heavily DBA work such as upgrading software, creating databases, performance tuning system, tuning databases, maintenance daily export, hot backup, and cold backup of all existing databases

Environment: Oracle, People Soft Financial, TUXEDO, HP-UX, SUN, Sequent Dynix/PTX VCluster.

Confidential, Mc Lean, VA

Database Administrator / Technical Consultant

Responsibilities:

• Responsible for system and database administration on two IBM-RISC 6000/8500 (AIX), two Sun 690MP, two Sun Sparc-2000, and fifteen Honeywell Bull DPX 2/200/300 (UNIX), and a Sequent
• Involved in setting up the entire systems on the same LAN segment from the beginning. The entire system was a distributed architecture and UNIX-to-UNIX client / server model. It was internally used for corporation business
• Major projects and tasks completed were:
• Primarily trained mainframe programmers to UNIX and Open Systems
• Trained other dedicated employees to become both system and database administrator
• Involved in setting up system administration procedures and develop several programs use to control, monitor, and maintain the systems effectively
• Installed and setup Corporation Financial System by using Oracle Financial MPL6 on Bull DPX2 then upgrading and migrating to IBM/RISC-6000 (AIX)
• Involved in setting up then introduced Oracle*CASE Version 4 then Version 5 to MIS group, continue maintenance and support it
• Supported programmers in all phase such as software, hardware, and communications through Ethernet TCP/IP and XNS LAN
• Wrote several C and ProC programs to provide for Oracle programmers friendly utilities
• Responsible for UNIX kernel tuning and Oracle kernel tuning for better performing on entire systems
• Constantly technical support both front end users and programmers in several sophisticated Oracle based software like Applications Foundation (AP, GL, AR, INV, Etc..), Just In Time (JIT Manufacturing), Prestige (Project Management), Holos, Etc
• Constantly migrated and upgraded systems to latest versions of Operating System and Oracle kernel
• Evaluated Sybase, Oracle V7, X Windows Terminal Products (both hardware & software) NCD, Tektronix, Visual, NCD Xview, Xvision, Etc
• Ported ORABK remote backup, remote restore, remote printing from a particular platform to a heterogeneous platform such as from RISC 6000 (AIX) to Sun OS to save company hardware

Environment: Oracle V7, Sybase, Oracle Financial MPL6, AP, GL, AR, INV, NCD, Tektronix, Visual, NCD Xview, Xvision, Ethernet TCP/IP, XNS LAN, IBM-RISC 6000/8500 (AIX), Sun 690MP, Sun Sparc-2000, Honeywell Bull DPX 2/200/300 (UNIX), Sequent, Kernel, X Windows

Confidential, Alexandria, VA

Senior Programmers / Part-time Consultant

Responsibilities:

• Used Informix - 4GL to develop and implement several complex reports of Information Configuration Management System (ICM)
• Implement Fort-Belvoir ICM system - Rewrite 4GL Breakdown Program to improve performance 60 percents
• Designed and completed coding a Two-Ways Commit Database between Fort-Belvoir and St. Louis with Oracle V5.1A on two Sperry-5000 systems
• Migration and porting ICM from Sperry 5000 to Sun 3/80 Workstation; from V5.1A on Sperry-5000 to V6.0.27 on Sun 3/60 and Sun 3/80 Workstation
• Installed and setup for customer at Fort Utis, Williamsburg, VA

Environment: Oracle V5.1A, Informix - 4GL, Sperry 5000, Sun 3/80 Workstation

Confidential, Silver Spring, MD

Systems Analyst

Responsibilities:

• Responsible for both system & database admin on both Sun 386i workstations & DOS
• Created UNIX Quick Guide. Installed & tuned Oracle V6 on Sun workstations
• Migrate Sql*Forms of version 5 to version 6
• Generated compatible CRT files for front-end users use to access to Sun from their PC by using ProComm, Crosstalk, and NFS emulators.
• Technical support for RMS team on systems analysis prototype of Budget Control Program that can run across multiple operating systems such as Xerox (View-Point), MS-DOS, UNIX, and VAX/VMS through TCP/IP and Ethernet
• Designed Oracle screens from specs. Redesigned data structure by optimizing tables, join, and views
• Wrote C codes and C Shell scripts to create windows and icons for system menu. Supported other team member on Alis review
• Use RPT, RPF, and RPT2C to automate Oracle report in Graphical Forms

Environment: Oracle V6, C, C Shell scripts, Oracle report, Graphical Forms, Sql*Forms 5/6, TCP/IP, Ethernet, MS-DOS, UNIX, VAX/VMS

Confidential

Senior Independent Contract Programmer

Responsibilities:

• Software developed and implemented for major companies including Confidential, P.E. Nelson, and Grid Systems
• Worked on variety of operating systems including UNIX, MS-DOS, and VAX/VMS
• Used Oracle to design Inventory and Sale List program
• Used Pro C to create tables and manipulate data on TOPS Project of Confidential, worked with Sql*Forms, Sql*Loader and C shell
• Re-designed & optimized triggers by replacing SELECT statement to EXEMACRO CASE

Environment: Pro C, Sql*Forms, Sql*Loader, C shell, UNIX, MS-DOS, VAX/VMS

Confidential, CA

Systems Engineer

Responsibilities:

• Responsible for C coding in a team of INCS Development that used to run on IDNX (T1- Multiplexer)
• Wrote Bugs Tracking Program on Sun 3/50 Workstation and AT&T UNIX System V
• Used Oracle to store and manipulate information on the network
• Used Pro C to design front-end user menus, create tables, generate reports, and design screens for the network operators
• Program is able to check and list systems global alias terms and files. It accepts users defined alias terms but store valid terms into database
• Attended with Network Equipment Technology on Telecom development such as TCP/IP, SNA, & practiced on EOC, IDNX, & INCS installation & operation

Environment: Oracle, C, Pro C, TCP/IP, SNA, EOC, IDNX, INCS, Sun 3/50 Workstation, AT&T 3B2 UNIX