Peningo Systems, Inc.
Objective: Database Administration – Data Architect - Consulting
Overview: 23 Years quality IT experience. 15 Years as a DB2 DBA.
DB2 DBA: Mainframe – 9 years. All aspects of Database Administration (to SYSADM).
· Project Leader. DB2 Systems Programming. Largest Database 9
Terabytes. Data Profiling, Data Modeling, using ERWIN. Data
Warehouse, Data Marts, BMC, Platinum, Candle, Install,
Migration, Recovery, Backups, Restore, DB2 Utilities.
DB2 DBA: NT – 2 Years – All aspects of DB2 UDB, including Replication,
Triggers, Stored Procedures, User Defined Functions, Scripts.
Data Modeling using ERWIN Logical and Physical Modeling.
Check Constraints, and RI. To SYSADM Version 8.1.
DB2 DBA: AIX – 6 Years – All aspects of DB2 UDB to V7.2 (SYSADM). Including
EE and EEE (ESE) Performance Tuning. Largest Database 9
Terabytes. SQL Script writing and FTP between S390, NT and AIX
SP2 RS6000 Platforms and Sun Solaris (Unix) . Extensive use of
performance measuring tools. Data Warehouse and Data Marts to 9
terra bytes. Current to Version 8.1 installs on Servers and Clients.
DB2 UDB ESE Production Support.
Other: Senior Developer, Hands On Project Leader, DB2 Systems
Languages: Algol, Assembler, C, C++, COBOL, COBOL II, COBOL LE
FORTRAN, JAVA, SQL.
Databases: DB2, DB2 UDB, ORACLE, DATACOM DB, SYBASE
Operating Systems: DOS, Windows98, NT, AIX, UNIX, MVS/ESA, OS/390
Clearance: Active Secret
Experience - DB2 Specific:/p>
Development and Production Support DBA - Maintain DB2 Objects, Implement DB2 Performance
Tuning Strategies. Develop DASD Space Management Plans. DB2 installs of UDB
V50., UDB V6.1 and V7.1 and FIXPACKS, SMP/E DB2 Target Libraries, DB2
Distribution Libraries. DB2 Migrations. Set DB2 Design Standards. MQ Series.
Set up DB2 JCL to streamline DB2 Utility Jobs. Write and administer DB2 Project
Plans. Define roles and responsibilities for DBA’s. Provide technical training
and mentoring for DBAs and where necessary DB2 Developers. Proven discipline of
System Development Life Cycle. Responsible for Client Server and Mainframe DB2
Database configurations. Configuration
Management, Metrics Collection. Data Modeling and Database I/O manipulation,
Report Production, Database Design Walk Through, ERWIN DDL creation and
simulation (Logical & Physical). Platinum Fastload, Fast Unload, Fastcopy,
Migration. DB2Connect, DRDA, Webshpere and Weblogic interfaces.BMC Tools for
database manipulation.Write and test advanced SQL scripts. Wireless, Billing,
Financial, Accounting and Medical Systems. Use Kimball’s de-centralized
approach to Enterprise Data Warehouse and Data Mart design and implementations.
Participate / Lead Proof of Concept Projects. Parallel Sysp
Features:- Stored Procedures (Fenced and Not Fenced), Replication, DPROP, UDFs,
DJRA (Data Joiner), Data Propagator. IPCS for Message Queues.BMC
Catalog Manager, BMC Change Manager, Triggers. Backup and Recovery.
High Speed Loading. Advanced SQL: Groupings, IBM OLAP Server, Star
Schema, Dimension Tables, Fact Tables, Multiple Joins, Views, UDTs,
Archive Row Manger, Hands on Manager Data Marts, Hands on Manager
Data Warehousing, Program Audit. Install DB2 UDB V8.2 64 Bit.
db2bfd, db2gov, db2rbind, db2sample.Performance Tuning DB2 UDB
EE/EEE/OS-390 on RS6000 SP2, Sun Solaris, HP and Mainframe servers.
SAP (see SAP Supplement) DB2 UDB ESE V8.1. MSGGET, MSGRCV,
MSGSND. KORN, KSH and SQL Scripts. Query Patroller. User Exit,
Redirect Restore (remote and local servers), DB2AUDIT.
Warehouse Tools EVOKE, DATASTAGE, METASTAGE, COGNOS, ERWIN.
07/04 to date –IBM Classified – DBA, Specialist Performance
Tuner, DB2 Systems Programming, Database Architect, Data Modeler responsible
for Database and Systems design and for producing: Unix/Aix Ksh scripts for
restore, crontab, Offline and Online Backups, Tablespace used and available
space, Database Statistics, Reorgchk,
Reorg, and Runstats. Write sequence for comp
Hardware:- IBM Regatta P650, P670, P690, RS600 Servers, DASD on SHARK.
HACAMP Clusters with Failover. TCP/IP Protocol.
Software:- DB2 UDB V7.2 and V8.1, Erwin, Clear Case Versioning, Rational Rose,
Korn Shell, DB2AUDIT, Event Monitor, Clear Case, Clear Quest,
DB2 Performance Expert. FixPak 7a and 12.
10/03 to 7/04 CSC – Senior DBA and Specialist DBA Performance Tuner for DB2 – UDB, AIX, NT, zOS and OS/390. Responsible for increase in processing speeds, CPU and Elapsed times for COBOL, Java and C job schedules affecting the Data Warehouse (11 Terra bytes) operations. Mainframe feeds to Data Warehouse Staging platform running under AIX 5.2 on multiple RS6000 SP2 configuration and parallel Regatta Servers under AIX 5.2. Load sharing with various disk arrays including Shark.
Detailed analysis of the Operating System Parameters, Database Design, Network Traffic and Program Code. Production of detailed analysis spread sheets and SPRs (Software Problem Reports). Monitoring before and after performance across the three platforms.
Production of results. Assist developers in tuning their program code until satisfactory performance achieved in their programs. Produce Performance Related Standards for the
Installation. Check and alter JCL as necessary for OS/390 Job Streams. Achieved a reduction of 37% in elapsed run times and 40% CPU times average across the three platforms. Set up fail-over architecture for NT processors/servers. Set up and installed UNIX/AIX Environment for UDB ESE (EEE 64 bit) Version 8.1 Databases. Tune UDB jobs to achieve a 35% reduction in elapsed time processing. Increase UDB Load Speed by 100% tuning the HSBL (High Speed Bulk Loader). Produce several check lists for performance tuning for the zOS, OS/390, AIX/UDB V8.1 and Windows NT Platforms.
Conduct Benchmark tests on Stored Procedures. Alter call sequence as necessary.
Hardware:- OS/390s 9000 SYSPLEX, AIX Regatta Servers, AIX RS6000 SP2 Servers,
SHARK Disk Arrays, NT Servers
Software:- BMC, Data Stage, Evoke, APPTUNE, numerous DB2 Utilities,
Including Performance Expert, Performance Monitor, SQL Performance
Analyzer, SQL Assist, Query Monitor, DB2 Explain, DB2ADVIS,
DB2BATCH,, DB2DART, DRDA, DB2CONNECT, PARALLEL_IO,
DB2NODE, DB2COMM. AIX 5.0, DB2 UDB ESE 64 Bit. QUEST
3/03 to 10/03 - IBC – Senior DB2 UDB ESE V8.1 DBA (SYSADM) /SYSTEMS ARCHITECT, MANAGER and DATA MODELER Responsible for the implementation of a large Health Care (9 terra byte) data warehouse. Tasks and functions included:- Develop a Strategy Plan, hardware selection, data modeling, work with ETL Developers, work with infrastructure group, installation of DB2 UDB ESE V8.1 64 bit on Regatta servers using AIX 5.1. Load AIX and Install Net Backup, Data Stage 6.0 XE series, Evoke (Axio), and Metastage. Set up DB2 environments for Development, QA and Production. Create:- Instances, Databases, Node Configuration files, .rhost files, etc/svc files, all DB2 objects. Design partitioning strategy, DMS and SMS Tablespaces. Design tables using Erwin for Logical and Physical Models. Participate in the design and testing of a Disaster Recovery sub-system using modified C Program User Exit DB2UEXT2 rolling forward to the end of logs.
KSH Scripts. Command Line Processor. Client Configuration Assistant. Event Logs.
Modeling, apply referential
integrity, allocate appropriate buffer pools. Produce logical and physical
models ‘ Relation and Dimensional models and Fact Tables. Select Partitioning
Keys. Forward engineer Erwin Physical Model to produce DDLs. Edit DDLs. Run
bench mark tests for load and query retrieval. Run Load Runner to test Volume
and Stress Tests. Design and produce Dimension Tables, Fact Tables, Star
Schema. Check downstream reporting. Various Mapping exercises, sources to
targets. Install and maintain change control using PVCS. Performance Tune the
Warehouse. Use MDC (Cluster techniques) to improve performance. Data Blending,
Data Cleansing. I/O Cluste
Hardware:- P690 Regatta Server with 2 LPARS (4 & 8) CPUs each. Multiple External Storage (ESS - Shark) disk drives. SAN 9 Terra bytes of storage. 128 GB Memory, Two 64 bit Fiber Channel Storage Adapters per LPAR, One, 1 Gigabit Network adapter per LPAR. + IBM MVS/OS390 R2.10. CDW Servers AIX V5.1, Sun Server SAS02/B9. OLAP Server AIX 5.1. Concurrent Users per shift = 5000. Eight and Four Lgical partitions per LPAR.
Software:- DB2 UDB V8.1 ESE
(EEE), DB2Connect, DRDA, Erwin, AXIO, J2EE, Java, Impromptu, Data Stage XE
12/02 to 2/03 – UPS Mail
Innovations – Senior DB2 UDB DBA (SYSADM) responsible for development of a
strategy plan, environment set up of new database system connected to object
tracking, job tracking and file tracking. Data Profiling, Data Modeling, Design
and implementation of the database and all system related objects, including
table spaces, tables, indexes, buffer pools, stored procedures and triggers.
Performance tuning for table access, largest table forecast is over 10 million
rows. Use of all DB2 tools and utilities including, MS Office, Java, J2EE,
Access, DB2BATCH, EXPLAIN, EVENT MONITOR, DB2LOOK, DB2ADVIS, DB2MOVE, AUTO LO
CLP (Command Line Processor). CCA (Client Configuration Assistant). KSH Scripts.
Produced a four year forecast Capacity Plan. Produced several Knowledge Transfer (“what is” and "how to") documents and Charts of the System. Used an ACCESS database and EXCEL Spread Sheets to supplement handover documentation. Create the Data Dictionary.
08/02 to 12/02 – Deutsche Bank –
Senior DB2 DBA, UDB EEE Tuning, DB2 Systems Programming (SYSADM). Database
conversion from Adabas to DB2. Also, conversion from ADP based data to Pershing
type system. Database install DB2 V7.1. Database Migration V6.1 to V7.1. Data
Profiling and Building the Data Model. OS/390 Monitor using DB2PM. OS/390
object manipulation using BMC Catalog Manager, and Platinum Tools. Connect IMS
to DB2. Prepare IMS Applications for DB2. Build Link List. Add DD Names as
appropriate (DFSESL) .DB2 Systems Administration. Occasional use of Omegamon.
Diagnose and resolve performance problems on OS/390. SQL access path analysis.
Participate in migration of selected DB2 Systems to Sysp
Hardware:- zOS, IBM
OS/390 Parallel Sysp
RS6000 SP2 Servers, Sun Solaris, HP SP80 with Shared Nothing Architecture.
Operating Systems:- MVS/ESA, UNIX, AIX, HP-UX.
Software:- Platinum Tools, Platinum Fast Load, File Aid for DB2, Insight, BMC Catalog
Manager, Omegamon, Endevor, ERwin, TSO, ISPF, QMF/HPO, IMS, Log
Analyzer, DB2Batch, DB2expln, dynexpln, DB2Advis, db2look, C, C++,
ALC, dbdclgn, db2evmon, db2eva, db2gov, db2govlg, db2icrt, db2idrop,
db2iupdt, db2ldcfg. SAP,
V6.1(OS/390), SMART, DB2
db2support, db2dart. MS Office, BRIO Stress Tests.
01/02 to 08/02 – MetLife – Senior DB2 UDB EEE DBA (SYSADM), DATA ARCHITECT, Specialist Performance Tuner, Systems Programming and Project Leader.
The eService system provides agents and clients access to
life and annuity policy data through the Internet. eService is designed around
a Warehouse and Datamarts populated from the MetLife legacy systems. The System provides 24x7 uptime. Do an Audit of
Objectives:- Develop a Strategic
Plan, Reduce overnight batch window times from over 20 hours to under 9 hours.
Reduce e-business response times from over three seconds to under two seconds.
Analyze all pertinent objects and function
Snapshot Monitor, Event Monitor, DB2 Performance Configuration Wizard,
Explain, Visual Explain, db2batch benchmarking, set Optimization Clas
Layers:- The presentation layer serves HTML and GIFs and forwards all servlets and JSP requests to the application layer. This layer consists of a several of Cisco ArrowPoint CS-800 load balancing switches, and twenty IBM RS/6000 H80 AIX 4.3.3 servers running IBM’s HTTP server.
The application layer processes incoming requests from the
presentation layer, and assembles requested content. The application layer i
to 01/02 – ING – Senior DB2 DBA – Design, build and implement databases
for large and comp
Use of several DB2 DSN1 Type Utilities including Full and Incremental Image copies.
Work out a comprehensive disaster recovery plan with senior management utilizing User Exit DB2UEXT2. Use compression to resolve short term space allocation on OS390. Use Lempel-Ziv-Welch algorithm to compress data in all partitions of large tablespaces. Consider all options. KSH, SQL, PERL and KORN Shell scripts.
On Call rotation duties for AIX, Unix and S390 platforms. Fix problems as appropriate.
Administer DB2 Training for DB2 Developers.
Tools:- Quest Central, Embarcadero DB2 Artisan 5.4.1, Erwin 4.0. DB2 UDB Tool Set.
BMC Catalog Manager, DASD Manager for DB2, DB2 Utilities, Zeke Scheduler,
Omegamon, Autoloader, Splitter.
Hardware:- Sun Solaris, HP, IBM RS6000 S80 RAID, IBM 390 Series.
Software:- DB2 UDB EE V7.1 and V7.2, DB2 UDB EEE V7.1 and
V7.2, OS/390 UDB V6.1, Brio, Sybase, Java, J2EE, MS Office.
Operating Systems:- UNIX, HP-UX, AIX 4.3.3, MVS-ESA, zOS.
to 8/01 - Cigna – Project Leader /
Manager and Senior DB2 DBA, SYSTEMS ARCHITECT – Drive the building of a 9
terabyte Data Warehouse. Scope of the work:-
Warehouse:- Design and define the Warehouse databases. Develop the extract and transformation routines used by Informatica’s extract, transformation and load component (ETL). Edit and advise on some COBOL Programs. Check SQL code in COBOL Programs.
Analysis and Testing:- Regression, Correlation, Time-series and Impact.
and technology:- DB2 V6.1, DB2 UDB V7.1, S/390, RS6000, SP2, SUN
SOLARIS AIX/UNIX, VALITY (data Integrity), DPROP (Data Propagator), Metadata
libraries, ETI’s ET
Performance Management:- PC based caching, LAN to gateway, Tuxedo tuning, WAN to DB2, Network performance (delay parameters, buffer sizes, TCP/IP), DB2 performance on host. S/390 tuning, RS6000 tuning, DASD tuning. DB2 I/O, define Tablespaces, SQL tuning, Install EEE V7.1 using SMP/E. Online REORG, Load Partition Parallelism, Online Load Resume. Key hashing and allocation across partitions. Node Group creation and configuration. TPF Project for Medicare files. Ensure Database Security. Load the data to the database. Extensive use of REORGS and RUNSTATS, Stored Procedures and Triggers. Lead V5.2 to V7.1 Migration. SMS and DMS storage utilization. BMC Tools. DB2 Utilities/Monitors.
11/00 to 1/01 –Met Life – DB2 DBA – Participate in Performance Tuning DB2 UDB EE, EEE, S390 and NT Systems. Used ERWIN for data modeling exercises to verify/alter referential integrity relationships. Use MAESTRO for automatic scheduling of scripts. Use Explain and Visual Explain for Index and Access Path analysis.Use Websphere and Weblogic for proof of concept. Tuning efforts involved, Segmented Tablespaces, Partitioned Tablespaces, Nodegroups, Hashing, Bufferpool Tuning, Largest table tuned was 430 Million rows, and the smallest table tuned was 20 Million rows. Total size of all databases tuned was 5 terabytes. Tuned tables in both SMS and DMS Storage Modes.
Operating Systems - AIX 4.3, OS/390, zOS, RS6000 H80, RS6000 SP2 and NT
Hardware/Software – RS6000/SP2s loosely coupled multiple servers in Cluster Loops.
Also S390 and numerous PCs. SMP and
MPP. Use PERL Compile Scripts. Four m
to 10/00 – Navistar – DB2 DBA and ORACLE DBA – Participate in the building
of a Data Warehouse to facilitate the automated production of vehicles using
extensive robotics and other completely automated procedures. Data is gathered
from numerous other databases and replicated
to the table
UBD Instance Management. UDB Server Configuration Management. UDB Software Maintenance on servers. Testing. Also test the use of DJRA (Data Joiner) as an alternative replication function
DB2 UDB V6.1 using NT. Replication using
01/00 to 6/00 - CSC - Health Care – DB2 Systems Architect – Technical Project Leader - Establish system information requiremments using analysis of Information Engineers in the development of enterprise-wide large and medium scale information systems. Produce/modify 250 CICS Screens and extract data from VSAM Files. Apply CICS expertise to HIMR and make this Online Inquiry System a viable entity including the capability of displaying over 450 Claim Lines across half a dozen Inquiry Types. Program Audit. Use COBOL LE and compare to COBOL II VS in bench mark tests. CWF Trouble Shooting. Analytically and systematically evaluate problems of the HIMR Online systems across all high and low level work flows, organization and planning, and develop corrective action. Provide daily expertise and direction to staff, Business Strategy and Training support. Monitoring and tuning for all HIMR and other CICS entities and resources.
Hardware:- IBM S390s Parallel Sysp
Software:- OS/390 MVS/ESA V5.0 COBOL ALC CICS V4.1 ENDEVOR
VSAM, PLOGS, NDM, OMEGAMON, XPEDITOR, RDO.
DB2 DSN1 UTILITIES. DB2 Install V6.1 using SMP/E.
Networks:- TCP/IP SNA VTAM TOKEN RING
to 01/00 IBM/HMTC – DATA ARCHITECT, DB2
DBA, DB2 Systems Programmer, for a m
1. Database Design and Performance Tuning Considerations.
2. Database log maintenance, backups, restart, reorg, restore, disaster recovery.
3. Create Nodegroups and identify Nodes for Tablespaces, EEE. Set up db2nodes.cfg.
4. Design databases for parallel individual partitions for EEE.
5. Partition Database across multiple independent EEE processors.
6. Hash partitioning key distribution for EEE usage (Autoloader / Splitter).
7. Load balance and Redistribute data across EEE NodeGroups.
8. Identify multiple User License options for EEE.
9. Based on work load and work speed, produce a EE vs EEE cost/benefits analysis.
Hardware:- Multiple RS6000 SP2 and H80 , IBM SP POWER/POWER2 SMP processors - 512mhz.
Software:- AIX Version 220.127.116.11, ADSM, CRONTAB, HACMP,
Splitter, AutoLoader, IVP6, XTI, ISPEC, OSF, NIST, CDE, MKSYSB,
3/99 to 08/99 Intercon Inc. DB2 DBA, ORACLE DBA using DB2 V5.0 through V6.1 Universal Data Base Enterprise Edition Extended (EEE). Responsible for the design and implementation of all DB2 related objects and activities on all Client platforms for a large Telephone Billing System such as:- 1. AS400, 2. MainFrame DOS/VSE and OS/390. 3. RS6000 AIX, Responsible for the inter-connection between all platforms and the Web.
Used DDF, DRDA, TCP/IP,
SNA, DB2 Connect, ERWIN (forward and reverse engineer databases),
Participate in a SAP POC Project, manipulate SAP tables, SAP R3 Implementation. Identify
SAP resources, Validate requirements to SAP solution, use of Options Palette, Button Bar,
Status Bar, Multiple Sessions, Base Configuration, Business Navigation, SAP Table load and unload, Document Creation, SAP Report generation,SQL Server 7 POC.
Software:- VA Gen, Smalltalk, SAP R3, ABAP/4, CICS 4.1 on
12/97 - 4/99 SAIC, Inc. DB2 DBA / Project Manager/ DB2 Systems Programmer for the conversion of a large federal agency M204 application to a COBOL LE, CICS - DB2 system. Use OMEGAMON for Performance Monitoring. Used Changeman for Version Control. MVS OS/390. Install V6.1 using SMP/E. SQL. MQ series storage and queues. Migration V2.1 to V5.1. DB2 Utilities. DB2 Recovery. Use COBOL LE for Y2K file conversions. Platinum Tools. TPF debugging. Distributed Environment. Conversion of IMS for Y2K. Install IMS using SMP/E. SAP. Use DB2 datasets for IMS (share SMP/E datasets).
8/97 – 12/97 - Marriott - Project Manager and DB2
DBA engagement with m