Warehouse Data

Location:

Baltimore, MD

Posted:

May 30, 2014

Contact this candidate

Resume:

Michael A. Fitch Home Phone: 410-***-****

**** **** ****** ***** **** Phone: 443-***-****

Woodbine, MD. 21797 Email: **********@***.***

Michael A. Fitch Home Phone: 410-***-****

**** **** Valley Court Cell Phone: 443-***-****

Woodbine, MD. 21797 Email: **********@***.***

SOFTWARE: DB2 UDB ESE V9.7, V9.2, V9.1with DPF, IBM ISAS, AIX 6.1, SOLARIS 9, RH Linux AS3, WINDOWS 2000 and XP, EMC Symmetrix SAN, ESS Shark SAN, NetApp SAN, Tivoli System Automation, Tivoli TSM, ERWin 4.1, COGNOS, ORACLE BUSINESS INTELLIGENCE, MICRO STRATEGY, BUSINESS OBJECTS, DATASTAGE, INFORMATICA

HARDWARE: IBM P690, P650, P640, P550, P575, IBM SP2, IBM S7A, IBM S80, Egenera Blades, SUN E420r, IBM PC

PROFESSIONAL EXPERIENCE:

DECEMBER 2013 to PRESENT – STATE OF MARYLAND

SENIOR DATABASE CONSULTANT

Performance tuned multiple DB2/AIX databases, and eliminated locking issues associated with the front-end application. Build a new Reporting Mart using DPF to eliminate the stress of the reporting being run against the production operational system. Some reports went from a runtime of 12+ hours down to 3 minutes.

SEPTEMBER 2013 to DECEMBER 2013 – HOMELAND SECURITY

Worked on enhancements to the operational databases for TSA on DB2 / AIX using HADR.

JULY 2008 to SEPTEMBER 2013 – ADVANCE STORES

SENIOR DATABASE CONSULTANT –

Built new production warehouse on IBM’s new ISAS technology consisting of a management node, admin node, and 3 data nodes and a standby node using db2 UDB v 9.7 on AIX 6.1. Previous hardware was under powered to handle 3,000 users per day with 26 Tb of data. Performed analysis and performance tuning on the existing data warehouse using DB2 UDB ESE v9.1 on AIX 5.3. Re-architected tablespaces and file systems, built MQTs, syncing the DEV and QA environments to PROD. Redistributed data when another 4 TB of disk was added to the warehouse. Assisting other DBAs with partitioning strategies, etc….

JANUARY 2007 TO JULY 2008- LEGG MASON

SENIOR DATABASE CONSULTANT-

Built a new Asset Management data warehouse using IBM’s BCU methodology, running on DB2 UDB ESE v 9.1 w/ DPF on AIX 5.3 running on a 4-way P550 (admin node), and three 8-way P575s (2 data nodes and one ETL node). This same configuration was also used for the DEV, QA, and Failover environments. Architected the file systems layout, and built the warehouse in all 4 environments. Implemented log shipping to replicate data from PROD to Failover. Assisted the developers in designing a high performance overall approach to updating the warehouse using Ab Initio as the ETL tool. Performance tuned the warehouse for the Business Objects access to the warehouse. Performed disaster recovery testing. Provided guidance for physical model changes.

NOVEMBER 2005 TO JANUARY 2007- MARRIOTT

SENIOR DATABASE CONSULTANT- Built a new Marketing Data Management Data Mart using DB2 UDB ESE v8.2. Created and maintained multiple environments for the Consolidated Inventory System. Set up Q replication across the environments.

MAY 2005 TO OCTOBER 2005 - LEGG MASON

SENIOR DATABASE CONSULTANT- The existing Brokerage data warehouse was suffering severe performance problems due to architectural issues. The warehouse is UDB 8.3 on Aix 5.3 running on clustered 4-way p650’s with 32 GB memory each and NetApp SAN. Analysis showed that the file system mapping to the volumes and the table space mapping to the file systems needed to be redone. Dropped the old warehouse (1.3 TB), re-architected and built the new warehouse. The overnight batch went from running 9-11 hours in the old warehouse to running in less than 2 hours with the new architecture.

DECEMBER 2003 TO APRIL 2005- DEUTSCHE BANK

SENIOR DATABASE CONSULTANT- Led the UDB Migration Project migrating 38 databases from the mainframe to a P650 running DB2 UDB 8.1 and AIX 5.2 64-bit. The databases were placed in a partitioned UDB environment. Architected and implemented the development, production, HA and DR, UAT and DEV environments on 3 separate P650s. Designed the storage layouts, created the instances and databases, performed partitioning analysis, performance tuning, applied fixpaks, trained resident DBAs. Performed HA and DR testing, implemented incremental backups and archival logging using TSM. Assisted application group with batch and online testing. Wrote Korn shell scripts for backups, the purge process, statistics, and many miscellaneous scripts.

MARCH 2003 TO DECEMBER 2003- KROGER

SENIOR DATABASE CONSULTANT- The production warehouse is 48 partitions on 24 Winterhawk nodes in the SP2 complex supporting a 10 TB data warehouse on ESS Shark using HACMP with a BRIO front-end. Worked on performance and query tuning. Created new environment by installing DB2 UDB ESE V8 and fixpak2 on P690. Added partitions to the development and integration environments (which reside on an SP2) on this P690 environment. Built a new schema in the warehouse to be used for OLAP processing. Setup the DB2 Governor and the DB2 Auditor to run in test and production environments and wrote scripts to report weekly on activity. Analyzed memory configurations in the test environment for future tuning.

DECEMBER 2001 TO SEPTEMBER 2002- SEABURY & SMITH

SENIOR DATABASE CONSULTANT- This is a return engagement to Seabury (see July 1999) to redistribute the Marketing Data warehouse across new RAID 5 arrays on UDB EEE v7.2, troubleshoot performance problems, and provide direction for future growth of the warehouse.

FEBRUARY 2001 TO DECEMBER 2001- HMSA

SENIOR DATABASE CONSULTANT on the Medical Management Data Warehouse project for the Hawaiian Medical Services Association. The environment is an IBM S80 using 2 TB of ESS Shark I/O subsystem disk, running DB2 EEE v7.2 and Micro Strategy, and Warehouse Manager. Built the test and production environments. Built the first data warehouse at HMSA. Performed database tuning on the 4 partition/ 2 TB warehouse. Created the environments and supported the metadata databases for Micro Strategy, and the control databases for Warehouse manager on NT servers. Migrated to UDB v7 from v6 and installed several fixpacs. Designed and implemented the backup/ recovery strategy using Tivoli TSM. Performed knowledge transfer to the client DBAs. Troubleshot connectivity issues across the LAN.

OCTOBER 2000 TO FEBRUARY 2001- BANK OF AMERICA

SENIOR DATABASE CONSULTANT assigned to the 6 TB BACARDI data warehouse at Bank of America. This is an IBM SP complex consisting of 3 S7A’s and 14 silver nodes. There are 28 data partitions totaling 6 TB. The warehouse tracks credit card information using DB2 UDB EEE v5.2 on AIX. As DBA for this warehouse I performed performance tuning, installed and tested fix packs, and reworked the backup strategies and scripts. Performed daily problem resolution.

APRIL 2000 TO OCTOBER 2000 - UPS

SENIOR CONSULTANT assigned to the UPS Data Warehouse Project. Installed and configured Visual Warehouse 5.2 on NT platform. Visual Warehouse runs on underlying DB2 UDB databases. Designed and tested interfaces with ETI, Platinum, and BRIO. Wrote technical evaluation of VW integration into the current architecture at UPS.

JULY 1999 TO MARCH 2000 – SEABURY & SMITH

SENIOR DATABASE CONSULTANT assigned to the Seabury & Smith Marketing Data Warehouse Project. Created the production warehouse database using DB2 UDB EEE v5.2 on an IBM S7A running AIX 4.3.2. The instance was set up with 4 logical partitions and one coordinator partition containing 100 Gb of data. Configured the instance and database, and mapped file systems and raw devices for tablespace containers. Assisted with the physical modeling. Created tablespaces, bufferpools, database tables, etc… Developed and implemented a backup/ recovery strategy using ADSM. Responsible for all of the basic support of the warehouse.

Performed performance tuning to support the VALEX, COGNOS, DATASTAGE, VB and COBOL applications. This included meeting with developers to determine the best ways to utilize the DB2 engine, assisting with problem queries, tuning bufferpools and indexes, etc… Used snapshot and event monitors to assist with various problems including locking problems, access plan and concurrency problems. Supported the VALEX control database, which was DB2 UDB EE on Windows NT.

Also created a ‘System and Integration’ environment with a small copy of the warehouse on an IBM SP with 4 silver nodes. Created the DB2 instance, created the file systems and the S/I database.

JANUARY 1998 TO JUNE 1999 - NATIONSBANK

DATABASE ADMINISTRATOR assigned to the Operational Data Store (ODS) group. Implemented the Call Center ODS, the first operational data store at NationsBank, in DB2 UDB EEE. This ODS will combine very recent customer contact data from one system with customer relationship data from another to provide a timely, comprehensive view of the customer which never before existed.

Created the physical model. Estimated the database size, planned the file systems and wrote the scripts to create the raw devices. The ODS has two 8-way high nodes and one 4-way which is used as the coordinator node. Each high node is divided into four logical partitions. Each partition has 3 RAID5 arrays of 4.5 GB disks. Set up the logs and indexes on separate non-RAID5 SSA disks. Configured the DB2 UDB EEE instance, created and configured the database. Loaded data and maintained ODS.

EDUCATION:

IBM CERTIFIED SOLUTIONS EXPERT - DB2 UDB EEE DATABASE ADMINISTRATION

Earned Certificate in Client/Server Computing from Villa Julie College, 1995.