OBJECTIVE:

• A position within Information Technology which will utilize my past experience and permits further growth and creativity.

TECHNICAL SKILLS

Hardware: IBM RS/6000/p680 AIX V4.3/V5, ESS Shark, Sun Solaris 8, HP - UX, UNIX System 5, Linux Redhat Intel, Windows Server 2008/2012, MSCS, Raid, TCP/IP,IBM z900,z/OS,OS/390,MVS/ESA, TSO/ISPF

Software: DB2 UDB ESE V10, DB2 z/OS V10, SQL Server 2012, Oracle10g, Informix V9, Kornshell, Bash Peoplesoft 8, PeopleTools, SQR, PeopleCode, SAP R/3, Siebel 8, C++, SQL, XML, Java, Perl, HTML MQ Series, Websphere, WebLogic, Tuxedo, Crystal, DBArtisan, QMF, DB2 Connect, COBOL, CICS DataStage, Cognos, Informatica, Business Objects, Assembler, IMS DB, VSAM, IDMS, SMP/E, Rexx DB2 Admin,Quest Central,BMC Change/Catalog Manager,BMC Patrol,Tivoli,Omegamon,Strobe, Visio

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Lead Enterprise Data Base Administrator

Responsibilities:

• Performed logical and physical database design for the Confidential Student Information Systems using DB2 UDB LUW (Linux/Unix/Windows).
• Installed and configured DB2 ESE V9.5 in a UNIX and MSCS Windows (clustered/fail-over) environments for 24 by 7 High Availability (HADR).
• Implemented and tested failover and Disaster Recovery using SANs drives and replication. Databases are partitioned using DPF under UDB ESE V9.5. Administered Security using Windows domain groups and DB2 security.
• DB2 UDB database servers are running Linux/UNIX/AIX and Windows 2003 Server operating systems. Performed DBA tasks for Image Gateway and Vault 21 Item Processing applications. Installed and configured DB2 9.5 pureXMF, Label Based Access Control (LBAC), automatic runstats, automatic memory management, and automatic compression dictionary.
• Implemented Backup Recovery through Online Split Mirroring and Suspended I/O.
• Assisted application staff with diagnosing deadlocks, timeouts, and SQL errors using db2diag logs. Performed performance tuning using Explain, Snapshots, and Health Moniter. Trained other DBA staff in the everyday administration of DB2 Window/Linux database server machines.
• Performed data base administration, data base design and table creation for SQL Server 2005. Loaded SQL Server databases using DTS (2000) and SSIS Integration Services (2005), ActiveX, and T-SQL stored procedures. Used other SQL Server 2005 features such as MDX, SS Reporting Services, and SS Analysis Services. Reorganized databases using Defrag utility and Index Builder utility. Designed and implemented Data Warehouse using all ETL techniques for extract, transform, load, and cleansing corporate information. Resume of J. PallaPage 2.
• Designed and developed Data Marts including Star Schema and Cube models. Target system is SQL Server 2005. Sources include DB2 UDB AIX/UNIX, Oracle, and DB2 z/OS. Used Tivoli Storage Manager for backup and recovery.

Confidential, Irvine, CA

Sr Enterprise Data Base Administrator

Responsibilities:

• Performed data base administration, data base design and table creation for SQL Server 2005. Loaded SQL Server databases using DTS and SSIS Integration Services (2005), ActiveX, and T-SQL stored procedures.
• Reorganized databases using Defrag utility and Index Builder utility. Performed diagnostics of SQL errors using @@ Global Variables, Try … Catch blocks, SQL Profiler, snapshot, and SQL Trace.
• Designed tables using new features of SQL Server 2005 such as GUID unique identifiers, schemas, MDX, and pivot tables.
• Developed data warehouse, data marts using SQL Server and Cognos. Designed and implementated data warehouses including DW/BI concepts such as multi-dimensional, star, snow flake schemes, and fact and dimension tables.
• Used Websphere Information Integrator to Extract, Transform, Load data. Provided security administration. Defined SQL Server login IDs, database user IDs, and server roles and permissions.
• Provided DB2 z/OS DBA support to Siebel applications in upgrading Siebel from release 7.7 to release 8.0. Served as a DBA for Oracle 10g and Oracle E-Business Suite 11.

Confidential, Los Angeles, CA

Lead Enterprise Data Base Administrator

Responsibilities:

• Managed a team of five DBA’s. Responsible for budgets. Implemented DB2 Version 7 Real Time Statistics. Conducted a study to reduce the number of DB2 Subsystems from 10 to 3.
• Served as Project Leader to this effort. Installed and implemented the reduction of DB2 Subsystems from 10 to 3.
• Designed and implemented Data Warehouse using all ETL techniques for extract, transform, load, and cleansing corporate information. Designed and developed Data Marts including Star Schema and Cube models.
• Target system is Oracle 10g UNIX. Sources include DB2 UDB AIX/UNIX, SQL Server, and DB2 z/OS, and other legacy applications. Used DataStage, Cognos, Informatica, and Business Objects.
• Performed PeopleSoft DBA roles for the implementation of PeopleSoft 7.5 to 8.0 for the applications HRMS, Financials, and Portal in a DB2 OS/390 environment. Installed and implemented DB2 Connect Version 7 using TCP/IP. Determined number of DB2 subsystems, Large versus Extra Large, and the
• Parameters, ZPARMS, bufferpools. Implemented DFSMS and wrote ACS routines. Wrote 5 COBOL programs that generate the DB2 Utility JCL for Image Copy, Recovery, Unload, Load, Reorg
• Runstats, Modify, and Fileaid jobs that are used for cloning 8 PeopleSoft Instances (DMO, SYS, DEV, TST, CNV, QAT, PRD, and TRN). Ran PS Installation jobs. Provided technical support related to SQR, PeopleTools
• PeopleCode, and the Application Engine to application staff. Used DB2 Admin Tool for DBA activities.

Confidential, New York, NY

Sr Data Base Administrator

Responsibilities:

• Serving as consultant to Merrill Lynch in the Centralized Bookeeping System (CBS) designed, analyzed, coded, documented, tested, installed, and enhanced several subsystems of CBS. Developed CICS, DB2, COBOL2 online programs and batch programs.
• Performed Logical and Physical database design for DB2 and Oracle8i databases. Performanced tuned application and DB2 using Explain, Strobe, Insight resulting in 75 % CPU reduction. Developed backup and recovery jobs.
• Serving as consultant to Chase Bank (now JP Morgan) performed data base administration tasks for the installation and implementation of Peoplesoft HRMS, Payroll, and Benefits using releases 7.5. Customized modules using PeopleCode. Developed reports using SQR. Used Peoplesoft Tools to create DDL and load tables using DB2 Version 6 on an OS/390. Developed Data Warehouse using Brio. Performed performance tuning. Developed DB2 utility jobs: backup, recovery, check data, reorg, load, runstats, quiese, stospaceDB2 data compression, stored procedures, and triggers.
• Performed database administration (DBA) tasks for SQL Server 6.5/7.0 applications.
• Serving NYNEX on an Andersen Consulting project for the Carrier Access Billing System (CABS) in the installation of the IABS IMS/DC/DB2 package from US West. Conducted Capacity Planning study using Best/1. Tuned DB2 ZPARM parameters and Version 3 bufferpools.
• Implemented DB2 ESA hardware compression. Designed and developed the front end CAFE Service Order system that utilizes RS 6000 AIX, Visual Basic, Visual C++, Oracle7, and Oracle Transparency Gateway.
• Serving as consultant on an IBM project for UPS performed logical and physical data base design for the international package carrier system (HFCS) using DB2 UDB, case tool technology, Bachman and Excelerator software. The HFCS system was a dual platform system using PC/UNIX client/servers and CICS/DB2 mainframe in a distributed data base environment. Designed and programmed CICS/DB2 command level programs.
• Serving as consultant Chemical Bank performed a feasibility study for converting the WBS CICS online system from IMS to DB2. Feasibility included the new DB2 2.1 features such as Referential Integrity, increased Governor facilities, and the DB2 performance improvements related to the MVS/ESA operating system and 3090E processor. Designed transactions using Entity Relationship Mapping documented using ERWin and Visio. Programmed CICS/DB2 COBOL2 programs. Performed DB2 database design including Partitioned Table spaces, Clustering Indexes, Views, Storage Groups, Plan grouping, RCT entries and CICS/DB2 threads. Performance tuned Explain and DB2PM. Designed and implemented IMS databases for the Security Movement and Control (SMNC) and Automated Cash Entry (ACES) CICS systems.