TECHNICAL SKILLS:

Oracle Products: Oracle RDBMS V6,V7,V8,V8i,V9i,V10g,V11g, Oracle Applications (9.x,10.6, 10.7,10.7 GUI, 10.7 NCA, 11.0.3,11i,12.0.4, 12.1.3), SQL*Plus, SQL*Net, Oracle Enterprise Backup Utility, RMAN, Oracle Designer, Oracle Developer, Oracle Server Manager, Oracle Name Server, OID/LDAP, Oracle Connection Manager, Oracle Enterprise Manager, Oracle Application Server 10g, Oracle Grid Control 10g, Oracle Grid Control 11g, Oracle Grid Control 12c, Data Guard 10g, 11g, Oracle Label Security, Oracle Discoverer 3.x., 9.x, ADI

Other Products: Microsoft Office, IBM DB2 Versions 8.2, 9.1, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Toad

Operating Systems: OPENVMS, UNIX (DYNIX, OSF, SUN OS, SUN Solaris, HP/UX,AIX), MS DOS, Windows 3.1, Windows 95, 98, XP,VISTA,NT,Windows 7, Windws 8.1, and Windows Server 2000, 2003,2005,2008, and 2012 and Mac OS.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Oracle Applications Database Administrator for 3 Oracle instances, RDBMS 10.2.0.4, 11.2.0.4 and Oracle E - Business Suite 12.0.4 and 12.1.3 (HR/Payroll, Financials), running on Sun Solaris 10 hosts and Hitachi AMS 1000 San array and Oracle ZFS Storage Appliance. Oracle DBA for 9 instances for Confidential E-Commerce web site running on Oracle RDBMS 11.1, Sun Solaris 10 hosts and Hitachi AMS 2000 San array.
• Oracle DBA for Warehouse Management system running on Oracle RDBMS 8.0.4 and Windows Server 2003. Managed Oracle instances and Data Guard using Grid Control 11g and Cloud Control 12c. SQL Server DBA for Kronos Work Force Central 6.3.7 running on SQL Server 2008 R2 SP2 and Windows Server 2008 and Machine Shop Maintenance Scheduling software running on SQL Server 2005 and Windows Server 2003. Set up log shipping on SQL Server 2012 production database to standby database for business intelligence reporting.

Confidential,

Lead Database Administrator

Responsibilities:

• Lead Database Administrator for the Cost Management System (CMS) running Oracle E-Business Suite 11.0.3 and RDBMS 8.0.5 and using the AR, FA, GL, and PA modules. The CMS instances were running on various Sun Solaris platforms including Sun E10K, E6500, and E420. Installed and tested E-Business Suite patches and RDBMS patchsets. Installed E-Business Suite 11i releases 1, 2, 4, and 5 VISION database for management testing. Acted as technical resource for other DBAs in the department in answering their Oracle questions for CMS Data warehouse, IRM, PDM, and JIT data store using RDBMS versions 7.3.4 to 10.2.0.4. Monitored and maintained over 80 databases using Oracle Enterprise Manager 9.2, and Oracle Grid Control. Monitored and maintained the Oracle Names Servers and OID/LDAP. Installed and configured Oracle Connection Manager to access Boeing Oracle databases through BSS fire wall. Led Oracle DBA team to implement and verify Boeing database security requirements, including applying Oracle security patches. DB2 DBA for ENOVIA/CATIA project in El Segundo.

Confidential,

Senior Lead Database Administrator

Responsibilities:

• Senior Oracle Applications Database Administrator for 9 Oracle instances using Oracle RDBMS 8.0.5 and
• Oracle Applications 11.0.3 running on 7 HP 9000 N Class Enterprise Servers using the HP/UX release 11.0 operating system.
• Production Oracle Applications database ran in a HP Service Guard Cluster.
• Setup Oracle Enterprise Manager (OEM) 2.1 on a Compaq Server running Windows NT 4.0 and Oracle RDBMS 8.1.6.
• Monitored and optimized the performance of the databases and Oracle Aplications using OEM. Managed Herbalife and Contractor DBAs.
• Produced weekly top 25 longest running programs and monthly tablespace statistics reports for management review.

Confidential,

Oracle Applications Database Administrator

Responsibilities:

• Oracle Applications Database Administrator for 7 Oracle instances, using V7 and V8 of the Oracle RDBMS, and
• Oracle Applications 10.7 Production 16.1 Smart Client. The Application instances were running on HP/UX platforms running UNIX operating systems 10.2 and 11. Allocated system storage and created tablespaces.
• Controlled and monitored users access to the databases.
• Monitored and optimized the performance of the databases and the servers using Oracle Enterprise Manager.
• Re-engineered Oracle Applications database into Oracle Designer and designer repository for development.

Confidential,

Senior Principal Consultant

Responsibilities:

• Installed and configured Oracle RDBMS (V7 and V8), Oracle Applications (10.7 GUI, 10.7 NCA, and 11), and other Oracle products for Oracle customers located throughout the United States.

Confidential,

Senior Database Administrator

Responsibilities:

• Senior Database Administrator for 16 Oracle Instances, V6 and V7 of the RDBMS, and R9 and R10 of Oracle Financials, running on Sequent servers and SUN Workstations.
• Installed and upgraded the Oracle server, Oracle Financials, and application tools.
• Allocated system storage and created tablespaces, and primary objects once application developers have designed an application.
• Controlled and monitored user access to the databases. Monitored and optimized the performance of the databases and the servers.

Confidential

Business Programmer-Analyst

Responsibilities:

• Database Administrator for an Oracle RDBMS V6.0 and Oracle Financials.
• Developed applications using SQL*Plus, SQL*Forms, and SQL*ReportWriter for VMS and SUN OS.
• Performed system management duties on PDA’s VAX cluster nodes and VAX and ALPHA workstations.
• Installed and upgraded DEC and third party software and hardware for the VAX cluster and VAX and ALPHA workstations.
• Designed and coded accounting and personnel systems in Structure/4 and HENCO’s INFO for PDA Engineering.
• Uploaded and downloaded data between the VAX, UNIX servers and workstations, and between PCs and MACs.