Cary Hanks

314-***-****

j8789w@r.postjobfree.com

Career Summary & Objective

I am a Senior Database Manager with 12+ years of proven results in full lifecycle support of RDBMS, from requirements analysis and logical design to physical

design and implementation to DB2 release installation and maintenance. I have experience in complex organizational IT infrastructures such as AT&T, USDA and

IBM. I have provided successful leadership in disaster recovery exercises, maintenance and storage/management of 10+ Terabytes RDBMS involving diversified

batch and on-line processing. Expertise in BMC and IBM tools for the z/OS platform. I am seeking position involving full lifecycle support of RDBMS including

database administration, data architecture, logical and physical database design, data modeling and structural implementation and I am very interested in

learning other RDBMS platforms.

Professional History

Database Tech, Saint Louis, MO October 07 – Present

Independent Database Management Consultant

For clients including AT&T, IBM and UniGroup, Inc., provided application lifecycle support and storage management support to multiple projects in DB2 mainframe environments.

Scope includes:

Design, implement, and maintain complex database systems, activities including data modeling, system access, storage allocations, validity checks, security, performance tuning, data migrations, data replication, disaster recovery planning/support and procedure/process documentation.

Leverage business process knowledge to transform data requirements into business solutions.

Perform logical data modeling and physical design tasks on relational databases and provide application lifecycle support in DB2 environments with the ERwin Data Modeling tool.

Perform release upgrade installations.

Generating Crystal Reports.

Perform data replication across multiple production sites with IBM Data Propagator.

Deliver PowerPoint presentations of DB2 new application functionality to business unit executives and their software development teams.

Facilitate ERwin data modeling functional learning sessions with software development teams and management.

Maintain OLTP database objects for operational system data.

Maintain OLAP database objects for data warehouse / data mart.

Proficient with JCL.

Monitor DASD allocation growth; Resize VSAM datasets; Order DASD disk packs to accommodate the estimated DASD allocation for new database objects.

Amdocs, Saint Louis, MO May 07 – October 07

Technical Architect (outsourced from AT&T)

Performed application lifecycle support to multi-year, post-merger billing consolidation effort, growing one application from three to 300+ tables.

Key functions performed:

Designed, implemented, and maintained complex database systems, activities including data modeling, system access, storage allocations, validity checks, security, performance tuning, data migrations, data replication, disaster recovery planning/support and procedure/process documentation.

Performed logical data modeling and physical design tasks on relational databases and provided application lifecycle support in DB2 environments with the ERwin Data Modeling tool.

Performed release upgrade installations.

Conducted executive overviews of DB2 application functionality and business impact for business unit executives and their software development teams.

Provided ERwin data modeling functional update presentations to software development teams and management.

Created prototype databases for benchmark testing.

Performed data replication across multiple production sites with IBM Data Propagator.

Created and maintained storage procedures.

Proficient with JCL.

Performed key DB2 Utility jobs: data restore, REORG, Loads, Unloads, DSN1Copy utility, RUNSTATS, Image Copy, Quiesce, Table Conversion.

Conducted SQL performance tuning.

Used SQL to insert and modify DB2 table data in test and production environments.

Actively monitored DASD allocation growth; Resized VSAM datasets; Ordered DASD disk packs to accommodate the estimated DASD allocation for new database objects.

Provided bi-annual projected DASD allocation growth for existing databases.

Used MS Access to link to and load DB2 application database tables.

Managed data replication via IBM’s Data Propagator.

Served as project lead, managing projects from initial kick-off stage including test and production installations in a tri-annual release environment.

Applied business process knowledge to analyze data requirements for tri-annual project implementations; Led tri-annual enterprise-wide project-driven software releases, including testing, production implementation executed by applications development and DBA teams.

AT&T Services, Inc., Saint Louis, MO July 02 – May 07

Technical Architect

Performed application lifecycle support to multi-year, post-merger billing consolidation efforts involving development and design of several applications from the ERD(i.e. Entity Relationship Diagram) to 100+ tables.

Key functions performed:

Designed, implemented, and maintained complex database systems, activities including data modeling, system access, storage allocations, validity checks, security, performance tuning, data migrations, data replication, disaster recovery planning/support and procedure/process documentation.

Performed logical data modeling and physical design tasks on relational databases and provided application lifecycle support in DB2 environments with the ERwin Data Modeling tool.

Performed release upgrade installations.

Created a prototype Oracle test database for a benchmarking effort.

Created a prototype Teradata test database for a benchmarking effort.

Conducted executive overviews of DB2 application functionality and business impact for business unit executives and their software development teams.

Provided ERwin data modeling functional update presentations to software development teams and management.

Created prototype databases for benchmark testing.

Perform data replication across multiple production sites with IBM Data Propagator.

Created and maintained storage procedures.

Proficient with JCL.

Performed key DB2 Utility jobs: data restore, REORG, Loads, Unloads, DSN1Copy utility, RUNSTATS, Image Copy, Quiesce, Table Conversion.

Conducted SQL performance tuning.

Used SQL to insert and modify DB2 table data in test and production environments.

Actively monitored DASD allocation growth; Resized VSAM datasets; Ordered DASD disk packs to accommodate the estimated DASD allocation for new database objects.

Provided bi-annual projected DASD allocation growth for existing databases.

Managed data replication via IBM’s Data Propagator.

Used MS Access to link to and load DB2 application database tables.

Served as project lead, managing projects from initial kick-off stage including test and production installations in a tri-annual release environment.

Applied business process knowledge to analyze data requirements for tri-annual project implementations; Led tri-annual enterprise-wide project-driven software releases, including testing, production implementation executed by applications development and DBA teams.

Electronic Data Systems, Kansas City, MO January 2000 - July 2002

Consultant DB2 Database Administrator to the USDA

Provided database administration activities and application lifecycle support for multiple projects in DB2.

Performed release upgrade installations.

Performed daily monitoring of DASD allocation growth; Resized VSAM datasets; Ordered DASD disk pack to accommodate the estimated DASD allocation for new database objects.

Provided bi-annual projected DASD allocation growth for existing databases.

Performed logical data modeling and physical design tasks via Power Designer on relational databases and provide application lifecycle support in DB2 environments.

Performed DB2 Utility jobs: data restore, REORG, Loads, Unloads, DSN1Copy utility, RUNSTATS, Image Copy, Quiesce, Table Conversion.

Managed data replication via IBM’s Data Propagator.

Used MS Access to link to and load DB2 application database tables.

Utilized Data Propagator to replicate data between DB2 boxes and AS/400 computing system.

Trained new DB2 Users on key business, functional and technical processes.

Applied business process knowledge to analyze data requirements for tri-annual project implementations.

Served as project lead, managing projects from initial kick-off stage including test and production installations in a tri-annual release environment.

Managed full scope of storage utilization.

Keane Inc., Rochester, MN December 1998 - January 2000

Senior Consultant DB2 Support

Provided resolution support for DB2 issues and failures for thousands of IBM's customers.

Provided application design consulting and implementation support to IBM’s customers.

Created conceptual, logical and physical data models to reverse engineering data models from existing DB2 OS/400 applications.

Provided remote support to customers in critical system outage situation.

United Fidelity Holding Corporation, Kansas City, MO June 1995 - December 1998

AS/400 Database Administrator Computer Operations Supervisor

Led Computer Operations staff, providing training and troubleshooting coaching.

Provided design and implementation services for AS/400 application.

Provided storage manage and storage allocation directives.

Developed ad-hoc queries for Claims users.

General American Life Insurance, St. Louis, MO June 1990 - June 1995

Technical Peripheral Hardware Support Operator

Oversaw Tape Management System (TMS) maintenance and Job scheduling components in an MVS/JES2 environment.

Scheduled and provided maintenance for AS/400 batch jobs, system backups and system IPL.

Ralston Purina, St. Louis, MO January 1988 – June 1990

Level 2 Computer Operator

Provided Tape Management System maintenance and support.

Technical Skills Inventory

Storage:

DASD, Virtual Storage

Support Technology:

Administration Tool, IBM Automation Tool, DB2 Performance Expert, Explain and Visual Explain, TMON, IBM Utilities, RACF, SDSF, STROBE, MVS, VSAM, DB2 v7 & v8

Data Management Tools:

BMC Alter, BMC Performance Manager, CA Platinum tools, CA AllFusion ERwin Data Modeling Tool, QMF for Windows, FileAid, Data Propagator

Programming Languages:

COBOL, DDL, SQL, JCL, REXX, TSO/ISPF Text Editor, CICS

Education and Professional Affiliations

Missouri Valley College

DB2 User Group, Saint Louis, MO

Contact this candidate