Peningo Systems, Inc.
Contact:
info@peningo.com
PEN24
Technical
Areas:
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
CAREER ACHIEVEMENTS
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.
Additional dutie
·
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