Senior Data Warehouse DBA Resume Vermont - Hire IT People

SUMMARY:

More than 20 years of experience in designing, building, managing, and continually improving database systems within large organizations.
Highly effective team leader with ability to deliver results within high - pressure environments. Able to communicate complicated technical information in clear, well-organized manner to technical and non-technical team members.
Collaborated with IBM to customize the database environment for HACMP in a Mutual Takeover configuration for Disaster Recovery. DB2 Database Administration for LUW. DB2 Workload Manager, IBM Certified Advanced Technical Expert - DB2 for Clusters. IBM Certified Solutions Expert in DB2 UDB Database Administration for Linux, UNIX/AIX and Windows. Expertise in Backup and Recovery solutions using TSM, NetBackup and CommVault. Shell scripting. Experience in DB2 SQL performance tuning using tools such as db2advis, db2expln, db2batch and db2exfmt.
UNIX/AIX, UNIX/HP-UX, Linux Red Hat, Windows
IBM UDB DB2 DWE V10.5, JDBC Support on Linux, Symantec NetBackup for DB2, Embarcadero DBArtisan and RapidSQL

PROFESSIONAL EXPERIENCE:

Confidential, Vermont

Senior Data Warehouse DBA

Responsibilities:

In order to reconcile differences in datatypes between DB2 UDB and the AS400 iSeries, I created, maintained and executed Data Transformations using IBM InfoSphere Data Replication to move data from AS400 online system into DB2 UDB Data Warehouse on a daily basis.
Data was then used to build derived tables for use by analysts and extract creation.
Partnered with System Administrator to created and maintain a Backup and Recovery plan using Simpana CommVault Backup and Recovery Solutions Suite.

Confidential

Data Warehouse DBA

Responsibilities:

Production DBA experienced with IBM DB2 UDB DPF on AIX and Linux SUSE and Red Hat.
Virtual Server Architecture supporting Production and Acceptance databases.
ETL processing using IBM's DataStage and Transformation Server.
Collaborated with IBM’s BCU Implementation Team to build a Data Warehouse to store historic claims and member data using IBM DB2 DWE V9.7 on Linux Red Hat 6.3.
Wrote shell scripts to perform database maintenance tasks, including Backup and Recovery, Data Reorganization and Statistics Collection.
Partnered with IBM consultants to load initial data and establish data maintenance routines.

Confidential, Somers, NY

Senior Data Base Administrator

Responsibilities:

Migration of Confidential ’s (PBG) Enterprise Data Warehouse from UDB DB2 v8.2 to DWE v9.1, following IBM’s established DB2 DW Balanced Configuration Unit for AIX.
Partnered with IBM’s BCU Implementation Team to establish performance benchmarks for the migration of PBG’s Sales, Customer and Delivery Data Warehouse to IBM DB2 DWE V9.1 on AIX 5.3.
Migrated PBG’s backup and recovery scripts and processes from IBM Tivoli Storage Manager to Symantec’s NetBackup.
Transitioned from System managed tablespace storage to Database managed tablespace storage.
Managed the transition to production support by baseline support personnel.
Led database object privileges and runtime client installation and configuration for Windows, UNIX and Linux client servers.
Collaborated with IBM to customize the database environment for HACMP in a Mutual Takeover configuration.