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 2003/2008, MSCS, Raid, TCP/IP, IBM z900, z/OS Mainframe, 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, Omegamon, Strobe, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Peachtree City, GA

Lead Enterprise Data Base Administrator

Responsibilities:

• Installed and configured DB2 ESE V10.5 in a UNIX and MSCS Windows (clustered/fail-over) environments for 24 by 7 High Availability (HADR). Performance tuning and monitoring for the DB2 subsystems using Foglight.

Confidential, San Diego, CA

Lead Enterprise Data Base Administrator

Responsibilities:

• Installed DB2 z/OS (IBM Mainframe) Version 8 in a four way Data Sharing/Parallel Sysplex environment for 24 by 7 High Availability using DB2 High Availability Disaster Recovery (HADR). Applied DB2 maintenance, temporary fixes, PTF's, APARS, to DB2 OS/390 Version 7 using SMP/E.
• Configured DB2 Version 7 and version 8 ZPARMS. Installed 12 DB2 Subsystems under Version 10. Provided performance tuning and monitoring for the DB2 subsystems using BMC Patrol, Omegamon, and Foglight. Provided backup and recovery for the DB2 subsystems. Installed and administered RACF and security.
• Performed logical and physical database design for the Confidential Student Information Systems using DB2 UDB LUW (Linux/Unix/Windows). Installed and configured DB2 ESE V10.1 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 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.

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 (IBM Mainframe) 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.

Confidential, New York, NY

Sr Data Base Administrator

Responsibilities:

• Serving as consultant to Confidential 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 tned application and DB2 using Explain, Strobe, Insight resulting in 75 % CPU reduction. Developed backup and recovery jobs.
• Serving as consultant to Confidential (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, stospace, DB2 data compression, stored procedures, and triggers. Performed database administration (DBA) tasks for SQL Server 6.5/7.0 applications.

Confidential, NY

Lead Data Base Analyst

Responsibilities:

• Supervised five data base analysts. Performed logical and physical data base design for the Securities, Tracking and Reporting (STAR), Securities Information and Processing (SIP)
• Federal Book Entry (FBE), Automated Teller Machines (ATM), Demand Deposit Account Reconcilement (DAR), and Nonsufficient