Peningo Systems, Inc.
Over 20 years in the profession the previous 13 years as a database administrator. My experience as a database administrator is with DB2, UDB, and IMS spanning multiple platforms (i.e. Mainframe, Windows, and Unix).
Duties on the various platforms have included software installation, configuration, performance tuning, data placement, SQL review, backup/restore implementation, recovery, problem determination, knowledge transfer, data modeling, physical design, and data warehousing design and implementation.
IBM MAINFRAMES, SUN, HP, NCR 3600,TERADATA 1012/DBC, SP2/RS6000, SP2/S80, SP2/S90, P690, IBM X series
Unix / Windows Software-
DB2 UDB EE/EEE V7, UDB ESE V8, AIX V4.3, AIX V5, DB2 CONNECT, DPROPR, TIVOLI STORAGE MANAGER, QUERY PATROLLER, AT&T UNIX, SUN UNIX, X-WINDOWS, COBOL, MICRO FOCUS WORKBENCH, CODEVIEW IEW-ADW, PC-IMS, SAGE APS, SQL, XDB, ORACLE, DB2/PC, WINDOWS NT, WINDOWS 2000, QUEST
DB2 UDB/OS390, OS/390, Z/OS,PL/1, COBOL, COBOLII CLIST, REXX, SEQUEL/DS, IMS DB/DC, CICS, BMC UTIL., PLATINUM UTILITIES, PANVALET, IMF, EXPEDITER, NDM, SDSF, DIALOG MGR.TSO/ISPF, FILE-AID, IMS DBD/PSB/ACB GENS, IMS EXPERT
BS in Computer Science from Cleary College
IBM Certified Advanced Database Administrator - DB2 Universal Database v7.2 for
Unix, Windows, and Linux
IBM Certified Solutions Expert - DB2 UDB v7.1for OS/390 and z/OS
IBM Certified Advanced Technical Expert - DB2 Data Replication
IBM Certified Advanced Technical Expert - DB2 Clusters
SunTrust Bank, Inc. - May 2004 to Present
Primary UDB v8.1 ESE-DPF DBA for a 12 TB Basel 2 warehouse
implementation on four IBM P655 clustered BPUs, each IBM P655 has 32 GB memory
and 8 processors attached to a
· Primary DB2 EE/EEE DBA engaged to review existing hardware and software implementation. Hardware consists of 2 P670s with 8 processors and 16 GB of memory and FAST-T 100 with 2.8 TB disk. Software installed is AIX 5.1, DB2 UDB v7.2 FixPak 10, Cognos, and Informatica. Duties include reviewing and recommending optimization modifications for FAST-T array definition, DB2 database configurations, query performance, and stored procedures. Additional duties included support and training of DBA personnel and assisting in the implementation of a regional healthcare data warehouse and several client based data marts.
Management Technologies – March 2003 to September 2003
Raleigh, North Carolina - Assisted IBM, at a m
IBM – September 1997 to July 2002
Primary IBM DBA in the conversion of a 3 terabyte Distribution Data
Warehouse, for a m
Lead IBM DBA in converting CA-DATACOM database to DB2 UDB v6 for OS/390
at a m
Primary IBM DBA in the implementation of a 3 Terabyte Retail Sales
Warehouse, for a m
Principal IBM DBA responsible for in the installation of a Retail
Shipment Warehouse on a 5-node SP2/RS6000 system using DB2 UDB v5.2 Extended
Edition. Certified DB2 UDB DBA directing
the design and implementation of the physical database model taking into
consideration the requirements needed by the Information Advantage query tool.
Assisted client team in the publication of standards, database design, database
implementation, database performance, problem determination, SQ
· Evaluated an application utilizing Micro Strategy DSS Agent on a 100-node MPP SP/2 system running UDB v5.0 EEE. Evaluation included user written application and database parameter settings. Duties included interviewing appropriate personnel, conducting discussions, and documentation of suggestions and recommendations.
National Bank of Detroit/First Chicago Bank – June 1995 to September 1997
· Primary DBA in development and maintenance of banking data warehouse on a 17-node MPP environment using IBM SP2/RS6000 hardware with AIX 4.2 operating system. Provided system administration, software installation and upgrades of DB2 UDB v5.0 EEE and AIX. Provided DB2 UDB technical support for the FCNBD Disaster Recovery System and Oracle support for Artemis Time Tracking System. I am certified in Oracle Database Administration and Oracle Backup/Recovery. Additional duties included SQL tuning, database design, database monitoring and provide mainframe backup production support for DB2 v4.1 application systems.
DPM Consulting Services - February 1989 to June 1995
· Ford Motor Company
DB2 DBA, at a m
· Medstat Corporation
DBA for a Mainframe and
AIX/RS6000 medical data warehouse software system. RS6000 duties included installation and
maintenance of DB2/6000, v2.1, file systems, and DB2/6000 databases. Mainframe duties included design, maintain,
and implement DB2 databases. Wrote and
implemented backup and restore processes fo
· Blue Cross Blue Shield
DBA for Client Server, IMS,
and DB2 systems, providing client server support. Designed tables for a short-term NCCM system
using Paradox in a LAN serve
· Kmart Corporation
As an application DBA for
Teradata Corporation, I assisted on database design, and performance
improvement for Teradata databases.
· Ford Motor Company
Designed and implemented client server programming environment for mainframe using Micro Focus Workbench and Stingray IMS. Assisted in writing mainframe IMS on-line and batch programs for Part Cost and Weight (PCW) system. PCW system integrated into Worldwide Engineering Release System.
REFERENCES PROVIDED UPON REQUEST