SUMMARY:

• Confidential is a DB2 UDB DBA with 12+ years of experience in LUW, 9+ years of experience in z/OS, 3 years as an AS/400 (I series) DBA, and 2 years of SQL Server development experience, and lesser amounts of
• Teradata and Oracle, and with deep roots in both Data Warehousing (OLAP) and OLTP. Confidential is a well - rounded DBA with 4+ years of experience in the installation and operation of DB2 databases, not only in large-scale insurance environments (up to 11 TBs) at Confidential,
• LINUX servers, but other industries such as banking, railroading/logistics, retail distribution, and software. Confidential is looking to continue his career and is immediately open for the opportunity.

TECHNICAL SKILLS:

Technology and Tools: DB2 DBA for UNIX/Windows, OS/390, and AS/400; UNIX (AIX) administration; AS/400 DB2; SQL Server 2000 DTS; XML; Brio; Cognos; Oracle 8i; CASE Tools; IEF data modeling; ADW full life cycle; ADW GUI; ERwin; HOGAN; Access 2.0; IBM Mainframe; JCL; CICS; Assembler; APS; MS DOS 6.2; OS/2 2.1; Windows; IMS; Telon; DB2; DB2/2; SAS; SQL; Mantis; Dialog Manager; EDI; SUPRA; TSO; CLIST; COBOL and COBOL II; Excel; dBase III.

PROFESSIONAL EXPERIENCE:

Interactive Business Systems

Confidential, Vernon Hills, IL

Responsibilities:

• Working in a R7V1 AS400 OLTP environment with Navigator and Data Studio solving DB2 database-related RPG IV program problems, tuning queries via Visual EXPLAIN, doing Index Advise to create new indexes to help queries run better in large databases (often approaching a billion rows in some tables).
• Using Implementer as an AS400 tool to move changes in tables, indexes, constraints, and Stored Procedures in test to QA to Production.
• Using SYNON a.k.a. COOL 2E as the data modeling tool.
• Dealing with multiple environments in test, QA, and HA for the schema design of our moves to production using Agile Methodology for Bid Request and other business areas.

Confidential, Rensselaer NY

DB2 UDB LUW on Linux

Responsibilities:

• Working in a V10.1 large database (10 TB database in production alone with tables often in the hundreds of millions of rows) OLTP environment, running DML and DDL for corrections to NY State of Health Affordable Care database using both Data Studio and native LINUX server command line commands.
• Doing security updates and investigations
• Reviewed changes to Erwin data modeling tool
• Testing out, debugging, and moving to production Stored Procedures and Materialized Query Tables.
• Dealing with numerous schema types for our overall schema design on each server and between servers for eventual moves to production.
• Doing analysis of performance for test versus production using db2top, EXPLAIN, db2advis, Optim, etc.
• Reformed the Research Requests process for security violations.
• Solving production problems on call (e.g., Production transaction log full, failing back servers via HADR aka HA).
• Space planning for backups and for scp-ing of backups to standby boxes, test boxes for restores.
• Maintained and expanded Korn Shell scripts on both autosys and native crontab in LINUX.
• Aided in software selection for test data masking/de-identification by interviewing vendors via demos, etc.
• Submitted standards for foreign keys in relation to our primary keys.

Confidential, Amarillo TX

DB2 UDB LUW, AS400 iSeries, and SQL Server DBA

Responsibilities:

• Saved $25,000 a year for Anderson Merchandising by compressingV9.1 and V9.5 server databases using db2dart and REORG along with COMPRESS YESto eliminate 1 TB of wasted space.
• Reduced query time by at least 30% and up to as much as 90% by range partitioning for fact tables in Cognos Data Warehouse.
• Cataloged and established connectivity tovarious AS400 servers for Business Objects reporting both via standard DB2 connections and ODBC connections.
• Used Navigator Explain to add suggested indexes on AS400 tables (physical files) for speeding difficult queries.
• Created and managed WMS tables and returns tablesData Warehouse and associated Korn Shell Scripts and TSM backup for music vendors EMI, UMG, and SME on a DB2 V9.7 AIX platform for Business Objects reporting. Established federation between DB2 UDB V9.7 on AIX and AS400 servers. Large database had tables approaching a billion rows.
• Aided AIX administrator indealing with IBM on various fixes.
• Added file systems for Automatic Storage to databases.
• Upgraded numerous DB2 UDB servers from V9.1 or V9.5 to V9.7 and installed Data Studio.
• Did extensive backup and restores of databases including redirects from one server to another.
• Implemented incremental TSM database backups for previously mentioned database system for WMS and returns.
• Did reorgs and runstats for large database (tables in 600 million row range).
• Did traces on AS400 in coordination with IBM to fix problems with AS400 extracts.
• Implemented databases for data warehouse returns system that uses Business Objects.
• Using SQL Server Management Studio, created data model using Visio data modeling tool and SQL Server 2008 R database for EDI system.

Confidential, Las Vegas NV

DB2 UDB LUW DBA

Responsibilities:

• Installed Fixpacks for DB2 V9.7 for both AIX and LINUX.
• Fixed LOAD process to use DATA BUFFER and SORT BUFFER to avoid hanging loads.
• Fixed refreshes (including Korn shell scripts) of test servers from production data.
• Developed"timing"chart for production server script versus refresh server script.
• Worked with data modeler to create a true data warehouse and to begin having an E-RD for production (though with no foreign key enforcement - they only had 17 foreign keys for over 500 tables and wished to keep itthat way).
• Added space to tablespace containers to fix Operational Data Store HADR or HA failover issues.
• Created documentation for our team on setting up connectivity on TOAD as well as adding subscription and modifying subscriptions for Change Data Capture replication tool for our Operational Data Store.
• Developed Korn shell scripts to show any GRANTs which violated our GRANT to ROLE AISUSER framework.

Confidential, Irving TX

DB2 UDB LUW DBA/Data Modeler

Responsibilities:

• Worked as DB2 DBA on V9.7 for CSC Confidential for their Early Resolution project dealing with troubled mortgages.
• Created system topology charts for database servers using Visio.
• Created E-RD with Erwin, doing all the data modeling to take a system which only had two foreign keys for almost 150 tables (referential integrity was done thus far programmatically) and gave them a diagram with almost 180 proposed foreign keys for those tables.
• Quantified the considerable number of orphan rows for child tables.
• Also handled various questions concerning DB2 of a technical nature.

Confidential, Greenville SC

DB2 UDB LUW and zOS DBA

Responsibilities:

• Worked as DB2 DBA for Confidential, the world's third largest ERP software vendor.
• Worked primarily on the Workbrain product (human resources) doing fixes and enhancements via SVN and Test Tracker for existing and new releases for DB2 LUW, DB2 zOS, Oracle, and SQL Server.
• Installed DB2 V9.5 LUW for AIX and LINUX servers.
• Document uninstalling previous DB2 V9 versions and installing DB2 V9.5 for laptops for our programmers.
• Did tuning on queries (in one example, unpinning a server's CPU from 100% to 5% by adding two new indexes).
• Loaded zip files of DDL and data for zOS testing for various test and QA schemas
• Updated Java Property or JNDI files for new versions for zOS testing.
• Created data model ERDs and physical ERDs of Workbrain using Erwin for data modeling.
• Updated manuals for new versions of our software.
• Used RECOVER in zOS and RESTORE REDIRECT in LUW for databases that needed it.
• Investigated advantages of DB2 9 zOS over 8 as well as DB2 V9.7 LUW over V9.5.

Confidential, Bloomington IL

DB2 UDB DBA

Responsibilities:

• Worked at an insurance company in Bloomington, IL on a variety of projects simultaneously (10 to 15 at any one time, usually OLTP); created large (11 TB) DPF Data Warehouse OLAP systems such as Enterprise Claims Solution as well as much smaller applications (though often crucial, such as Customer Response Center and Interactive Voice Response) all under AIX 5.3 with DB2 V9.7, V9.5 or DB2 V8.2.
• Implemented interconnectivity between UNIX DB2 and zOS DB2 (both ways).
• Aided in Java property file parameters.
• Created databasesand estimated needed space as well as SAN space for UNIX servers.
• Proposed a system of SAN requests (using calculus and inventory modeling) which saved the client $5130 a year per server (millions of dollars) due to lower labor costs dominating interest costs
• Maintained Korn Shell Scripts
• Performed mass moves via Quest and performance tuning via Quest Spotlight, db2top
• Used Visual Explain, db2advis, and reorgchk for vastly improving query performance (in just one example, saving $943,644 in CPU costs).
• Performed restore and recovery work (online and offline) from backups and logs.
• Worked on Rational Build Forge, ClearQuest, RequisitePro and TestManager setting up servers and databases
• Worked on IBM Tivoli Identity Manager (ITIM) implementation including useof snapshots and event monitors to resolve contention issues.
• Led Joint Application Design work and logical data modeling and physical transformation via ER/Studio, as well as some production support.
• Set up db2ts text search indexes.
• Used HP Service Desk for documenting change.
• Used Lotus Notes for documenting projects.

Confidential, Richardson TX

Database Administrator

Responsibilities:

• Used DB2 UDB V8 non-partitioned on Windows 2003 from data FTPed from Teradata sources.
• Did data modeling using ER/win, created database objects, load, reorg and runstats utilities, and did performance tuning on long-running queries.
• Also did SQL Server 2000 work on Dynamic SQL and DTS loads for a reporting application.

Confidential, Temple Terrace FL

Database Administrator

Responsibilities:

• Working at a major telecom company in Temple Terrace on production support for dozens of DB2 UDB platforms, both V7 and V8, partitioned and non-partitioned, failover and standalone, OLTP and Data Warehouse, on AIX, Solaris, HP UX and Linux.
• Created and modified Korn Shell Scripts, maintained entity relationship diagrams for our data models, estimated space for establishing new databases, supported problems dealing with TSM and netbackup, set up jobs via cron or aided autosys and ESP-x staff in doing so via those tools.

Confidential, Dallas TX

Database Administrator

Responsibilities:

• Built comprehensive Entity-Relationship Diagram model using ER/winand previous System Architect and Visio diagrams, and tested other possible products such as Rational Rose.
• Worked on proof-of-concept for converting shop from OS/390 DB2 V6 and VSAM platform under CICS to an AS/400 V5.1 platform in order to save about $12 million per year.
• Established test environment using BMC and Operations Navigator to port DDL and data before tailoring it to the AS/400, and used Strobe and Omegamon on OS/390 to compare speeds with AS/400 via Database Performance Monitor.
• Established CICS connectivity to AS/400 DB2 tables using DRDA.Performed production support, monitored DASD for production Storage Groups.
• Analyzed AS/400 and OS/390 CPU statistics using Cognos Impromptu and Powerplay.
• Aided in implementing DB2 V7 and Metadata repository.
• Some SQL Server 2000 exposure.
• Completed all Oracle 8i-Certified Classes (Oracle programming, Architecture, Backup and Recovery Performance Tuning, Networking).
• Completed Six Sigma class and The Leadership Discussion Series.
• Completed 2 NETg courses in HTML, 3 in SQL Server Database Administration, 3 in Data Warehousing, 2 in XML, 2 in JavaScript, 1 in Korn Shell.
• Received $19,128 bonus for:
• Improved BMC REORGPLUS efficiency, saving $15,000 a year.
• Saved $130,000 by implementing QMFfor OS/390 V7 six months early.

Confidential, Irving TX

Database Administrator

Responsibilities:

• Worked at Confidential installing UDB V7 EEE on a Sun E3500 with Solaris 2.6 as the operating system, later benchmarking UDB vs. Oracle 8i for their www.superpages.comPeople Pages for speed on queries using db2batch vs. SQLPLUS, speed for loads, etc.

Confidential, Irving TX

Database Administrator

Responsibilities:

• Worked at IBM to implement the new version of their PartnerWorld s Data Warehouse for their business Confidential .
• Used XML for data model generation, implemented database loads using Java code as well as exports and imports into UDB V6 tables on an AIX box as well as managing and querying UDB objects using a Windows NT Client.
• Aided users with creatingviews involving rollups and cubes using Brio Designer.
• Had root authority on AIX box and did some elementary Unix administration tasks including creation of ids, group ids, and administration of cron jobs.

Confidential, Southlake TX

Database Administrator

Responsibilities:

• Moved a Data Warehouse for UDB EE system (a Unix version of DB2) from AIX box to a Solaris E540 box for the client Canadian Airlines, doing object creation, loads, queries, solving production problems, using Cognos, etc.
• Altered mainframe FTP cards, created Platinum unloads on mainframe DB2 Version 5 system to load data to the E450 after FTP, etc.
• Did performance tuning with OMEGAMON for mainframe online and batch jobs.

Confidential, Dallas TX

Database Administrator

Responsibilities:

• Through a nationally recognized computer resource provider, worked first at Litton Enterprise Solutions for client Hilton Hotels as the on-call 24X7 Production Support DB2 DBA with SYSADM authority helping to implement changes in DB2 tables in test and production as well as solving problemsin production.Worked with version 3 of DB2 using standard IBM utilities.
• Worked with ERwin for data modeling.Worked with SYBASE under IBMs version of UNIX (AIX) on RS/6000 models J40, R20, and S70 to convert portions of Hilton Hotels DB2-based system to an AIX/SYBASE client server system.
• Did elementary System Administration for AIX using smit, ed, vi, etc. to create logon ids for users in various test regions, did tar commands for tape backup, allocated disk space, defined space for SYBASE, and created and dropped SYBASE databases and calculated space estimates in Excel spreadsheets.
• Used DBArtisan to aid in this process.
• Later worked as DB2 DBA with SYSADM authority, using Version 5, using BMC utilities such as Change Manager and Catalog Manager, as well as BMC loads, unloads, recovers, reorgs, imagecopies, etc.
• Tested newest release of BMC utilities to make sure they were Y2K compliant, created numerous test environments using Change Manager migration, compare, and import features and used these features to move changes to production for Canada issuer number Credit Card project.
• Did DASD estimation for databases as well as production utility datasets.

Confidential, Dallas TX

Database Administrator

Responsibilities:

• Worked at Alliance Data Systems as DB2DBA with SYSADM authority helping to implement changes in DB2 tables in test and production for various application projects.
• Worked with Version 3 of DB2 at first, then Version 4, helping to implement such V4-related changes as Type 2 Indexes, new options for DEFAULT in SYSCOLUMNS and UNIQUERULE for SYSINDEXES.
• Converted plan-based batch system to packages connected to a collection id for each environment.Used various Platinum utilities such as Quick Explain in Plan Analyzer for performance tuning issues and wrote a manual on using Quick Explain for programmers.
• Used RC/Migrator for doing alters to DB2 objects (including foreign keys for RI and DASD management for STOGROUPS), comparisons between objects in different environments, and for actual migration between different environments and TSO regions such as the Quality Assurance environment and the Y2K TSO region.
• Aided Y2K project for utilities, security, testing Platinum utilities for Y2K problems.
• Used Fast Unload, Fast Load, Rapid Reorg, etc., and aided programmers in resolving problems with bad loads, etc.
• Did research and implementation on running simultaneous jobs for different tablespace partitions, archiving rows based on age.
• Maintained System Architect (Popkin) for Entity Relationship Diagrams, occasional OMEGAMON usage, etc.

Confidential, Minneapolis MN

Database Administrator

Responsibilities:

• Used BMC Catalog Manager and Alter Change Manager.
• Issued security GRANTs, did migrations across databases and across systems.
• Performed space estimates on Excel spreadsheets for migrations.
• Added volumes for STOGROUPs.
• Ran utilities (REORGs, RUNSTATS, etc.).
• Helped solve programmer problems for performance tuning via EXPLAINs for Relationship Management System.
• Used OS/2 v3 as daily platform.\

Confidential, Plano TX

Consultant

Responsibilities:

• Worked at EDS as DB2 Data Base Administrator and programmer for First Union Credit Card Project on CICS Assembler and COBOL II programs using both BMS and EDI with VSAM and DB2 databases.
• Used Microsoft Access 2.0 GUI and databases to log program edits for First Union.
• Used IEF for data modeling.
• Designed architecture for 24X7 credit card authorization processing with no down timefor coding by other programmers.
• Worked at Philip Morris in Mass Mobilization group on APS IMS/DB2 programs (both batch and online) used to target voters and legislators and on SAS programs which provided information concerning demographic brand loyalty.
• Used Macintosh as daily platform.

Confidential, Dallas TX

Consultant

Responsibilities:

• Worked at NationsBank in Dallas to create a variety of HOGAN PCDs and EFS edits for the Check Order System for download via PAS.
• Used CDMF dump/restore utility to load data.
• Performed RCS tasks needed to move work from test to .
• Created extracts of nightly changes in AIF and PCDs to be sent to Clarke American.
• Created a manual to explain HOGAN-related aspects of Check Order System.
• Trained staff in CDMF.

Confidential, Dallas TX

Data Modeler

Responsibilities:

• Normalized existing Watcom databases using ERwin E-RD tool for PowerBuilder application used for fraternity fundraising.

Confidential, Addison TX

Consultant

Responsibilities:

• Performed analysis of HOGAN IDS, CIS, FSS and ILP data needed for parameters model for Branch Automation System.
• Encyclopedia Manager and Data Modeler using ADW 2.7 Planning and Analysis to develop and manage data model.
• DBA for DB2/2 tables (transitioned from data model) for client server system.
• Fine-tuned performance using Design and Construction.
• Wrote ADW GUI programs for OS/2 2.1 window objects as well as ADW I/O modules to access DB2/2 tables.
• Designed SQL template used for all company and region default and effective date logic for bothCDMF format and CDMF item defaulting.
• Used MARS (a PC version of PAS) for EDI.

Confidential, King of Prussia PA

Consultant

Responsibilities:

• Worked on Analysis, Design, and Construction portions of ADW 2.7 for Martin Marietta CMS project.
• Used OS/2 2.1 in client server mode using CICS/DB2 under Microfocus Workbench.Animator.

Confidential, Dover NJ

Consultant

Responsibilities:

• Worked on Coopers and Lybrand project on both batch and online programs using PC Telon with XDB (a PC version of DB2) and OS/2 2.0 usingMicrofocus Workbench andAnimator to debug CICS in client server code.

Confidential, Cleveland OH

Consultant

Responsibilities:

• Set up, tested, and documented end-of-year HOGAN JCL for First Wachovia.
• Created new database extract model of CIS, IDS, and ILP.
• Used HOGAN, DB2, Bachman Entity-Relationship Diagramming, and SAS.

Confidential, Topeka KS

Consultant

Responsibilities:

• Used Telon to utilize DB2 and IMS DB under an IMS DC.
• Used Bachman ERD to analyze project entities.
• Managed three programmer/analysts who used my analysis and design specifications for Data Capture Process (railway car events for cycle reporting to AAR).

Confidential, Essington PA

Consultant

Responsibilities:

• Worked at a variety of projects at various clients.
• Worked on IMS-to-CICS conversion of transportation software package, using OS/2, Microfocus Workbench, COBOL II and Animator, used Oracle, COBOL II, SQL, DB2, Telon, EDI, IMS,CICS, Mantis, and SUPRA at such clients as Conrail and DuPont for logistics and materials contracts projects.
• Performed for new Telon staff and won in Oracle class for most innovative and instructive SQL-Plus examples

Confidential, Beckett NJ

Programmer/Analyst

Responsibilities:

• Wrote programs to create Positive Balance File and wrote complex SPS report on Daily Activity Statistics for banks, involving IDS and CIS.

Confidential, Chicago IL

Programmer/Analyst

Responsibilities:

• Successfully debugged 8610 Release of Confidential software package and helped install 8603 Release of IDS.