SUMMARY:

• 27 yrs. experience as a DB2 DBA on both mainframe (up to v12) and midrange systems (up to v11) on Unix, Linux and z/Linux
• Experience with very large databases from a 13 - way Sysplex Data Sharing to a 128 Partition UDB DPF environment, with tables up to 100’s billions of rows (Data Warehouse)
• Experience supporting large number of systems from as high as 93 DB2 systems and 55 UDB instances
• Experience in supporting high volume, high availability, critical OLTP systems, to analytical systems with large direct user ad-hoc processing
• Extensive experience with installing DB2 & UDB, applying patches/PTF’s/fixpacks, defining databases, tablespaces, tables, triggers, Stored Procedures, etc.
• Extensive experience with database utilities and tools, IBM & other vendors: DB2 LUW Data Studio, DB2move, DB2Look, HADR, IIS/Datastage, Foglight, Toad, IBM DB2 Utilities, DB2 DataJoiner, CA/Platinum suite (Utilities, RC-Query, RC-Migrator), BMC suite (Utilities, ChangeMan, Catalog Manager, LogMaster, Apptune), Mainview, Detector, Omegamon for DB2, Candle Epilog, Xpediter, Syncsort, Fileaid, Fileaid for DB2, IBM Replication (DPROPR, QREP), Erwin, CA-7, DB2 Connect, Visual Explain
• Versions supported: DB2 z/OS from v1.3 to v12, UDB LUW from v5.1 to v10.5
• Extensive experience in project development cycle, supporting projects from DB design, application support, code reviews, SQL analysis and tuning, implementation, production support and monitoring, disaster recovery testing.
• Extensive experience in resolving performance issues, data integrity, poor application design, production failures, system crashes, tuning DB2 parms/registry.
• Extensive experience in staff, both DBA & application teams, on database concepts, designing for high performance, and best practices
• Broad experience working at various Fortune 500 companies from a technology firm (IBM), to a Wall Street brokerage (Goldman Sachs), to government agencies (Texas Comptroller, Puerto Rico Water Utility) and one of the largest banks in the U.S. ( Confidential ).
• Leadership and management expertise focused on employee engagement and sustainability for profitable company outcomes
• Strong customer service with numerous accolades for support provided

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

DB2 LUW DBA

Responsibilities:

• DBA support for multiple UDB databases (v10.5) on Unix/AIX
• Normal DBA maintenance (reorgs, runstats, rebinds) and resolving production issues

Confidential, Austin, Texas

DB2 Assessment DBA

Responsibilities:

• Contract involved evaluating and making recommendations on: Security, Database Design, Application Design, Performance Improvements, System Settings
• Major s:
• Over $475,000 in yearly CPU savings from converting applications to be ZiiP eligible, SQL tuning, Application tuning/rewrite, elimination of RID failures, table changes, etc.
• Resolved root issue causing application server crashes during height of Tax filings
• Recommended and worked on the redesign of the tables for one of their major Tax application
• Table and SQL redesign to improve customer facing search applications

Confidential, Irving, Texas

Senior DB2 DATABASE ADMINISTRATOR

Responsibilities:

• DBA support for multiple applications on Unix/AIX, and Linux. Multiple UDB DPF environments. Total of over 60 database instances supported.
• Installation of DB2 UDB (v9.7 to v10.5) on new servers, Unix file system layouts, upgrades/fixpacks, creation & configuration of new databases, backups, recoveries, application & SQL tuning, database changes & tuning, problem resolution, HADR setup, DB2 Connect installation & configuration, DB2 Federation, registry variables, etc.. Implementation/modification of scripts for backups, reorgs, monitoring and alerting.
• Resolved application performance issues through SQL tuning, DB tuning and application changes. Implemented project database changes, restoring production DB’s to lower level envs.
• Migration from group based security to role based security.
• Small DB2 z/OS environment also supported.

Confidential, Addison, Texas

Senior DB2 DATABASE ADMINISTRATOR

Responsibilities:

• DBA support for multiple applications on Unix/AIX, Linux and z/Linux platforms. Total of over 55 database instances supported.
• Lead DBA architect in the creation of the first Data Warehouse at Confidential for historical credit card data. Starting with 128 partitions in UDB EEE, upgraded to 32 partitions on Power 5 under UDB DPF v10.1 with over 100 TB’s of data. Containing 5 years history of credit card data. Older data was then migrated to Hadoop.
• Installation of DB2 UDB (v9.7) on new servers, Unix file system layouts, upgrades/fixpacks, creation & configuration of new databases, backups, recoveries, application & SQL tuning, database changes & tuning, problem resolution, HADR setup, DB2 Connect installation & configuration, DB2 Federation, registry variables, etc.. Implementation/modification of scripts for backups, reorgs, monitoring and alerting.
• Resolved application performance issues through SQL tuning, DB tuning and application changes. Implemented project database changes, restoring production DB’s to lower level envs.
• Supported QReplication from DB2 z/OS through DB2 UDB to an Oracle target DB and DPROPR from z/OS to Data Warehouse in UDB DPF.
• Setting up client connections from Unix/Linux to MF DB2.
• Supported production systems through on call rotations, resolving production & performance problems, performing disaster recovery exercises using HADR.
• Managed workload of department using on shore and off shore DBA resources.
• DBA support for Vertica databases.
• Manage DBA support for 93 DB2 sub-systems including a 13-way Sysplex Data Sharing.
• Environment included BMC tools (Catalog Mgr, Change Mgr, Log Master), Omegamon, Erwin, and IBM Replication (DPROPR, QREP).
• Managed, planned and implemented business line projects, from database design, supporting application development teams, SQL analysis, performance tuning, backup utilities and production implementation to established deliverables (schedule, budget, and functionality) in an environment of over 20,000 production tables including 40 exceeding a billion rows.
• Developed and wrote a tool (TKO) to prevent ad-hoc user queries from causing critical batch jobs to fail.
• Supported the conversion of large masterfile system of record (SOR) VSAM based applications into DB2 based applications from logical and physical design through install. Including application reviews, sql tuning, archival rules/criteria, database standards and best practices.
• Contributed 6000 MIPS to an 8000 Peak MIPS savings goal.
• Supported production systems through on call rotations, resolving production problems, monitoring performance, disaster recovery exercises, reorgs, backups, recoveries, etc.
• Managed workload of department using on shore and off shore DBA resources.

Confidential, New York, New York

Senior DB2 DATABASE ADMINISTRATOR & SYSTEMS ADMINISTRATOR

Responsibilities:

• Normal DBA support for mainframe DB2 databases for a major Wall Street brokerage firm. Application & SQL tuning. Installation of production database objects.
• Supported several Sybase databases.
• DB2 System administrator role: upgrading DB2 & related products, installing PTF’s, monitoring system performance.

Confidential

DB2 CONSULTANT

Responsibilities:

• Assigned to IBM to work on a $10 Million contract with an agency of the government of Puerto Rico to install a new data center.
• Role included DBA tasks: develop work plan and time schedule for installing vendor billing, HR, payroll and other systems, tune sql, set up maintenance jobs, define and implement db2 security, define/document dba procedures & best practices. Train government staff to take on DBA role.
• DB2 System tasks: develop work plan, time schedule for project. Install DB2 and other MVS products, set up all standards and procedures. Define and implement all MVS RACF security (with Systems Programmer). Train the local staff to be able to take over system support before contract end date.