SUMMARY:

• 30 years of DB2 database architecture and administration on AIX, RHEL, SLES, Solaris, Windows, and z/OS platforms. Confidential Certified DB2 for LUW Administration.
• 19 years of DB2 for LUW distributed architecture, administration, and production support of V11, V10, V9.7, V9.5, and V9.1 ESE, SQL Replication, HADR, DPF distributed systems - V8.2 and V8.1 ESE, WSE, and ESE DPF on AIX utilizing HADR/HACMP and VCS clusters, RS/6000 64 and 32 bit clusters - V8.1 ESE Sun/Solaris VCS clusters, V7.2 EEE on a sixteen-partition SP2 - V7.2 & V7.1 EE on Solaris 7, 8 - UDB V7.1 & V6.1 EE on RS/6000 clusters, Windows Server, XP / NT 4.0 Intel clusters - V6.1 & V5.2 EE on NT 4.0 Intel clusters - EMC Symmetrix - ESS - FastT - DSx SAN storage systems - VCS - EMC BCVs - Quest Foglight / Spotlight - BMC SmartDBA - Embarcadero.
• DB2 LUW V11, V10.5, V9.7, and V5.2 - V9.5 on AIX BCUs utilizing Table and Hash partitioning, SQL Replication, MDCs, MQTs, Temporal Tables, BLU Adaptive Compression as well as the DB2 utilities suite including db2dvisor, db2expln, db2pd; performed partitioning and index analysis; assisted Datastage and Informatica analysts with ETL, Staging, and load SQL; supporting Business Objects and Microstrategy BI analysts with tuning complex SQL report queries; many, many years of DB2 installation, configuration, and tuning.
• 27 years of SQL, DDL, DML, SPL, PL/SQL ( DB2 LUW; DB2 z/OS, Oracle, Xdb, and INFORMIX-SQL ) including SQL SPL stored procedures, triggers, and UDF's. 6 months each of IDMS & IMS.
• 19 years of AIX, Linux, Solaris, and HP-UX KSH and BASH scripting, AWK/SED, Perl, cron; server monitoring via shell scripts, DB2TOP, DSMTOP, NMON, TOPAS.
• 10 years of z/OS database development and administration using Platinum for DB2 including RC/Query, RC/Update, RC/Migrator, Database Analyzer, Plan Analyzer, and Platinum Utilities; BMC Catalog and Change Managers, Mastermind Suite, and BMC Utilities; DB2 Utilities; FileAid for DB2, Insight, and Omegamon for DB2.
• 5 years of Logical, Physical, and Dimensional Modeling using Toad Data Modeler, Erwin V3-V7, and Embarcadero's ER/Studio.
• 10 years of DB2 COBOL/CICS design and development on z/OS, including several years with CA-Realia Cobol & MicroFocus COBOL with CICS option and xDB.
• 1 year of Oracle 9i, 8i SQLPlus, PL/SQL PL/SQL Developer, SQL Explorer; physical database creation and support; SQL functions, triggers, and stored procedures. Converted two Oracle V8 Systems DB2 V7 & V8.

SOFTWARE SUMMARY:

DBMS: DB2 LUW V11.1, V10.5, V9.7, V9.1 ESE DPF - V8.2 ESE, V8.2 Workgroup Edition, V8.1 ESE - V7.2 EEE - V7.2 EE - V6.2 EE, V5.2 EE - DB2 z/OS V2.3 thru V5 - Oracle 9i, 8i - IDMS - IMS - Informix - System 2000 - Total.

Utilities/DBA Tools: DB2 Data Studio - Confidential Data Server - Toad for DB2 - Quest Central for DB2 - Quest Foglight and Spotlight - Embarcadero DBArtisan - BMC’s SmartDBA - Platinum RC Suite - BMC Catalog Mgr., Alter, Load, Unload, & Reorg Plus - Insight - Optimizer - SQL Explain - Omegamon for DB2 - QMF - Intertest - Xpediter/TSO - Xpediter/CICS – Syncsort – DFSort - JESMaster IOF – SDF – Comparex – FileAid - AbendAid.

Modeling Tools: Toad Data Modeler, ERWin V3 to 7.1; ER/Studio; Visio; Power Designer.

OS: Suse Linux, AIX 6, 5, and 4; Solaris 7 & 8; RHEL Linux 4, 5, 6 & 7; and Suse SLES 6; MVS XA/ESA; MVS; MVT; VS1; VS2; DEC VAX & RSX; Primos; Data General Eclipse and AOS; NT/2000/XPPro;

Version Control and Management/EAM: Helix ALM/Core; ClearCase & ClearQuest; PVCS Version Manager/Tracker; SCLM; MS Source Safe; Star Team, Maximo; Panvalet; BMC Remedy; Manage Now; MKS

Project Management: MS Project; Project WorkBench; Semantic Timeline.

PROFESSIONAL EXPERIENCE:

Manager, Database Technology

Confidential, Reno, NV

Responsibilities:

• NV State Operations and Database Technology representative with oversight for the NVKIDS project to modernize the existing z/OS DB2/CICS legacy system to DB2 V11.1 AESE Suse Linux VM’s on Dell VxRail hardware with Replication and HADR.
• Used Helix Core/ALM CM & Tracking, exposure to Solarwinds PSA/Ticketing & Monitoring.
• Performed POC’s of V11.1 features BLU column organized, data skipping, compression, InfoSphere CDC, MQ, cloud implementation of DB2 V11.1 using AWS/AWS Marketplace S3, EBS, and DB2 V11.1 EC2 Linux VMs.

DB2/UDB DBA

Confidential, Nashville, TN

Responsibilities:

• Install, configure, monitor, upgrade and maintain DB2 in production and test environments.
• Deployment and real time production troubleshooting; backup & recovery; replication support.
• Provide 24x7 on call support for production environment on rotation and need basis.
• Diagnose and address database performance issues using performance monitors, snapshot data, database constructs, various tuning aids including explain, db2advisor, db2top utility.
• Planned and implemented strategies and procedures for physical disaster/recovery and contingency planning. \Interact with Storage and Systems administrators on Linix/Unix/VM operating systems issues related to databases.
• Create database maintenance and automation scripts.
• Configure and maintain Database High availability using HADR and log shipping.
• Troubleshoot database production problems and database connectivity issues.
• Planned and implemented strategies and procedures for physical disaster/recovery and contingency planning.
• Established mechanisms for replicating production databases including SQL replication, Log-Shipping, and HADR.
• Utilized Jira w/Scrum & Kanban

DB2 DBA

Confidential, Poughkeepsie, NY

Responsibilities:

• Production DBA in the steady-state support of DB2/UDB DBA V9x, V8x, & V7x including dedicated LUW support to Confidential and their Worldwide Web Portal and corporate databases.
• One of two Confidential team members in support of 125+ DB2 prod, QA, Dev, and DR databases on 30 VCS clustered and standalone servers running AIX 5.2 5.3, 5L, 6.1 RedHat 3, 4, & 5, and Solaris 8, & 9.
• Performed system, instance, and database monitoring and tuning, production implementation, fixpack and remediation upgrades, database conversions, and AIX, Linux and Solaris administration.
• Utilized Maximo.
• Performed Korn and Bash shell scripting.
• Provided Level-3 support for DB2 as well as level-1 support for Oracle, Sybase, and SQL Server.

Confidential, Armonk, NY

Responsibilities:

• One of two team members in support of 125+ DB2 prod, QA, Dev, and DR databases on 30 VCS clustered and standalone servers running AIX 5.2.5.3, RedHat 3, 4, & 5, & Solaris 8, & 9.
• Performed system, instance, and database monitoring and tuning, production implementation, fixpack and remediation upgrades, database conversions, and AIX, Linux, and Solaris administration (as needed) and Korn and Bash shell scripting.
• Provided Level-3 on-call support for DB2 as well as level-1 support for Oracle, Sybase, and SQL Server databases.

Confidential, Roanoke, VA

Responsibilities:

• Responsible for all database physical design and construction, DB2 installation and configuration, ETL, data staging schema, and BO SQL, data loads and retrieval.
• Utilized Erwin for physical database design and DDL generation; designed DB2 configuration; responsible for SQL and environment performance tuning using native DB2 monitors, snapshots. advisor, explain; created and wrote stored procedures and UDFs to assist in Datastage ETL; wrote abundant shell scripting.

Confidential, Sterling Forest, NY

DB2 / UDB DBA

Responsibilities:

• utilizing SQL replication, HACMP / HADR clustering and failover, DB2 utilities, snapshot & event monitors, and extensive AIX shell scripting of database monitoring and utility scripts.
• Provided Level-3 DB2 and SQL performance tuning and Level-2 SQL replication support.

Confidential, Vienna, VA

Manager, Database Administration, Datatrax Services

Responsibilities:

• Install, configure, monitor, upgrade and maintain the entire DB2 infrastructure.
• Complex SQL tuning of SQL reports produced by the Microstrategy V7, V8 products using common table expressions, global temporary tables, large-volume data retrieval, stored procedures, triggers, check constraints, and user defined functions, MQTs & MDC’s.
• Capacity planning of FastT and DS400 SAN Storage Management of raw and file system SMS and DMS containers. Worked closely with AIX System Administrators with capacity planning.
• Worked closely with Java and Microstrategy development teams. Worked with Project Managers to review user requirements and size DB efforts.
• DB2 utilities suite including explain, dynexpl, db2advis, db2pd, db2dart, inspect, load w/cursor/pipes.
• Tivoli Storage Manager for backups, restore, and archive logging.
• Erwin 3.2-7.1 logical and physical modeling, reverse engineering, and database DDL generation and maintenance.
• Extensive UNIX (Linux, AIX 4-5, Solaris 8-9) including vi, sed, awk, ed, and Bash & Korn Shell scripting; good working knowledge of Suse Linux 2.4, 2.6 and Redhat 4 and 5.
• Created DB availability and tablespace usage monitoring shell scripts utilizing email and text-message notification.
• Prepared written technical documentation of policies, procedures, and design and architectural considerations for database development and support guidelines.
• Supported 4 dev / test instances, applying weekly DB delta fixes and upgrades.
• Modified extensive Korn shell scripting to support UDB. Installation, database creation, and monitoring.
• Converted, modified, and tuned database mining SQL

Confidential, Minneapolis, MN

Responsibilities:

• Installed and configured UDB EE V7.2 on Solaris 8 SunFire clusters for a national health group physician’s portal. Responsible for all UDB activities including client / server installation and configuration, database creation, and performance tuning.
• Supported multiple environments.
• Worked with Unix administrators to successfully implement Veritas VCS HA cluster failover and disaster recovery utilizing EMC Symmetrix.
• Produced Korn shell scripts for db monitoring and to automate installation and db creation.
• Mentored UDB DBA staff.

Database Administrator

Confidential, McLean, VA

Responsibilities:

• Responsible for physical design and implementation of Data warehouse / Data Mart structures.
• Worked with and supported 25 developers and data architects in the design, creation, and support of the Corporate Warehouse and Data Marts.
• Performed complex SQL review and optimization;
• Supported and maintained development and test instances, databases, partitioning and co-location, and security on SP2 using UDB V7.1, and V7.2 EEE utilizing DBArtisan, AIX, and Korn shell scripts.
• System utilized ETL technology (Optiload) and Executive Information System technology (Microstrategy).
• UDB DBA supporting EE V7.1 on multiple NT 4.0 Intel and Sun Solaris 5.8 platforms with Java staff of 20+.
• Responsible for database design, architecture, and all UDB database administration tasks including installation, configuration, and user group authentication, authorization, and privileges on all NT and Solaris platforms; performed regular backup/restore, Import/Export, Load, Reorg utilities.
• Performed Oracle 8i database migration to UDB. Extensive UDB command usage, Control and Command Centers; Visual Explain.
• Design and creation of database objects (table, index, table space, view, bufferpool, constraints, RI, packages); complex database objects (SQL procedures, triggers and UDFs). Produced DASD configuration using VERITAS. Performed event monitoring and snapshots (collecting information, analyzed state of applications).
• The environment utilized Weblogic, Java, and a UDB DB Server Portal. Produced performance modeling.

Confidential, Washington, DC

Database Architect and Administrator

Responsibilities:

• Performed installation, configuration, database modeling and construction.
• Used Control Center, system command level, CAE, import/export, backup/restore, database migration.
• Runstats, Reorgchks, and Reorgs. Supported development team of 12, providing SQL assistance, triggers, and stored procedures.
• Utilized WebSphere Commerce Suite, WCS, ERWin and Embarcadero ER/Studio modeling tools.
• Database Administrator and Architect for customization and implementation of a B2B commerce exchange using Websphere Commerce Suite (WCS) Market Place Edition (MPE) under AIX on RS/6000 F80s, B50s.
• Maintained 14 NT and 3 AIX development platforms.
• Reverse-engineered WCS and MPE into ERWin and ER/Studio dictionaries, DDL.
• Performed design of physical data storage, access, and security administration.
• Performed on/off-line backup and recovery, exports/imports.
• Configured database parameters.
• Assisted in writing optimum SQL, performed explains, developed triggers and SQL stored procedures.
• Performed Runstats, Reorgs.
• Utilized Event Monitors and Snapshots.