SUMMARY

• Certified Professional Database Administrator with over 20 years application development and 12 plus years database management systems experience with DB2 distributed client server open systems platforms and mainframe.
• 13 years of experience with DB2 z/OS and DB2(UDB LUW - v8.x,v9.1, v9.5, v9.7) environment developing and maintaining database backup and recovery systems, Installing, configuring, upgrading, maintaining, monitoring and tuning DB2 databases, providing 24x7 production support services.
• 12 years of experience in Physical DB2 Database Analysis, design and implementation including DB2 database administration.
• 9 years of experience with DB2, CICS, COBOL, JCL and mainframe-centric toolsets on z/OS, OS/390 mainframe environment. (versions 7, 8, and 9)
• 8 years of experience in performance tuning for a large DB2 LUW/AIX Data Warehouse System and DB2 OS/390 and z/OS.
• Experienced as Lead DB2 Consultant supporting DB2 9.7 LUW for a Siebel CRM Install/Upgrade project. In addition, also assisted in supporting Oracle and SQL Server environments.
• 4.7 years of experience planning and implementing HADR (High Availability Disaster Recovery) environment,
• 4 years of experience in Korn Shell script writing for AIX and Linux UDB LUW database systems.
• 1 year of experience in SAP.
• 3 years of experience in Oracle and 3 years of experience in PeopleSoft.
• Good communication and interpersonal skills. Over 7 years prior experience as DB2 Programmer Analyst supporting 24/7 production systems; database programming including stored procedure/triggers development, mainframe COBOL, SQL rewrites and Explain deployment, CICS, JCL, ISPF/TSO, CLIST, REXX.
• Excellent working knowledge of DB2 UDBv8.x, thru 9.7 on LUW operating systems in addition to deep knowledge of DB2v8 and v9 on Unix/AIX and Red Hat Linux.
• Experience and ability to tune complex database systems at the application design, operational database and system levels.
• Thorough knowledge of and experience with database security, backup, recovery and archiving, data and system conversion and migration, third-party product installation and experienced in DB2 version 7 to DB2v9 upgrades. Demonstrated collaboration, facilitation and cross functional team skills. Has performed SAP/z-OS DB2 DBA tasks required to support on-going development and DBA activities required to meet the performance objectives.
• Serve as Production DB2 DBA/Software Developer for PeopleSoft ERP, Customer Order System and Customer Accounting System major enhancement in a DB2v8 and Oracle 10G environment. Assisted with planning, testing and implementation of DB2 PeopleSoft
• Application and Tools upgrades and patches in PeopleSoft Version 8. Monitored and managed database backups, system status, performance, capacity and growth and the middle-ware between PeopleSoft and DB2. Experienced technologist with strengths in problem determination and technical support in a high volume production database systems. Possesses strong written and verbal communication skills.

TECHNICAL SKILLS

• Databases: DB2 for OS/390,Z/OS V5, V6, V7, V8 (Sysplex, Data Sharing) DB2 UDB for LUW V8,V9.x (DPF), Teradata V2.4, V2.5, Oracle 8i, 9i, 10G, SQLServer, MySQL
• DBA/Connectivity/System Toolset: Quest Central, Quest Spotlight on DB2 LUW, Toad for DB2, DBI Brother Panther and Brother Thoroughbred, DB/Artisan, HADR, HACMP, Control Center, Event and Snapshot Monitors, Federated Links, DB2 Connect (DRDA), NDM, Connect: Direct for Mainframe, Unix(AIX) and Windows, and IBM DB2 Performance Expert (DB2PE)Sybase Direct Connect for UNIX/AIX, Mainframe and Windows, BMC Change/Catalog Manager, MainView, BMC Patrol, BM Rational Quality Manager, IBM Rational Test Lab Manager. QAHiperstation and QAdirector from Compuware, WinRunner, CA-Platinum, IBM DB2AdminToolset (Omegamon, TMON, DB2PE, CICSPA), DBA-Xpert
• Database Utilities: Reorg, Image Copy, QMF, FileAid for DB2, Restore, Redirect restore, Log Recovery, Replication (SQL, Q-Replication), Teradata utilities (MLOAD, FastExport and FastLoad/Multiload)
• Data Modeling Tools: Erwin, Design Advisor, Bachman Data Analyst/Designer, ER/Studio, Power Designer, Logical/Physical DB modeling and Design, ISMF, ISPF/TSO, JCL, IDCAMS, VSAM, PROCS and CNTL TMONDB2, Omegamon, PMON (Teradata), SMP/E
• Operating Systems: MVS XA, VM/CMS, OS/390, Z/OS, AIX/UNIX (4.3, 5.2), NCR MP-RAS UNIX Sun Solaris, Linux (Red Hat, Ubuntu, SuSe, Fedora), Windows XP/2000/NT/VISTA/Win2003 Sever, VMware ESX server and VMware Workstation
• Languages: SQL, BTEQ, Korn Shell, Perl, Crontab, Smitty, x-windows, REXX, CLIST. Stored Procedures, UDFs, Java, C/370, C, C++, 370 Assembler, COBOL 370, Microfocus COBOLII, COBOL LE, CICS/TS, XPEDITER, FILE-AID, VSAM, ISPF Dialogs, ABEND-AID, PeopleCode, PeopleTools, SQR
• Application/ETL tools/other: WebSphere Application Server, WebLogic, MQ Series, MQT, MDC, PeopleSoft Financial, HRMS V6, V7, V8, PeopleSoft EPM v8, SPSS, Strata SAP R/3, Ab Initio, MicroStrategy, Informatica, Business Object BODI

Professional Experience:

Confidential, Braintree, MA,

Responsibilities:

• Develop and/or optimize automated database administration processes and procedures to reduce overall man-hours needed to support existing DB2 infrastructure.
• Performance troubleshooting and optimization . Analyze poor performing queries in the production environment and make recommendations to address performance bottlenecks. Assist development teams in tuning long running process that support critical business reporting. Automate the identification of unused database objects that could potential free up system capacity/resources.
• Install and Configure DB2v10.5 LUW in the Windows production and QA environments.
• Setup a test data management tool to help developers move data from production to development environments in a safe and consistent manner.
• Instrumental in the DB2v9.1 z/OS migration to DB2v10.1. Support regression testing and validation across all environments. Track validation and sign off from customers.
• Provided managerial support and technical direction in place of client Manager due to extended leave of absence.

Confidential, Santa Fe, NM,

Responsibilities:

• DBA responsible for the design, creation and maintenance of all DB2 Objects and database support for the ONGARD (Oil & GAS) Service Center.
• Recovered plan and HADR design, implementation, procedures, knowledge transfers and multiple internal projects.
• Monitored and conducted performance tuning in large DB2 z/OS refactoring project/production systems utilizing WLM operational measurements and statistics, DB2PM (Accounting, Statistics and performance) reports.
• Worked with developers on the database design/architecture and schema optimization and other DB2 aspects.
• Experienced huge successes in performance tuning of struggling application systems.

Confidential, Plano, TX,

Responsibilities:

• Primary role as Lead DB2 Consultant supported DB2 9.7 LUW for a Siebel CRM Install/Upgrade project. In addition, also assisted in supporting Oracle and SQL Server environments.
• Maintained data (Loading, Unloading, reorganizing data, Runstats) in z/OS environment.
• Performance Monitoring and Tuning (SQL monitoring and tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor and OS commands (topas, vmstat and iostat), in addition to using EXPLAIN and running the reorgck, reorg, runstats and db2rbind commands.
• Reshaped the physical data model to ensure optimal DB2 performance through using MDCs, MQTs, and clustering and proper data types.
• Monitored and tuned Applications, SQL statements and databases by using snapshot monitoring, Event monitoring and other monitoring utilities.
• Help developers to formulate the queries and application development team to design new and re-engineer existing applications.
• DB2 UDB v8.2 to DB2 UDB v9.7 upgrade and data migration on a Unix/AIX 5.3 environment.
• DB2 UDB v101 new install management and performance tuning.
• Planned and implemented HADR (High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter and cloning the primary database to Standby.

TAJ Technologies,

Confidential, Rochester, MN,

Responsibilities:

• Databases data conversion from mainframe z/OS systems DB2 data to DB2 Unix/AIX Environment consisting of large historical billing database, electronic commerce and miscellaneous staging tables, Medical Revenue
• Information System (MRIS) databases, HealthQuest Patient Accounting, Medical Records and Patient Management databases.
• Collaborate with system architects to design the databases, data sharing operation in Parallel Sysplex environment.
• Instrumental in the DB2 UDB 9.5 upgrade to DB2 UDB 9.7 FP3 implementation.
• Maintaining data (Loading, Unloading, reorganizing data, Runstats) in z/OS environment.
• Performance Monitoring and Tuning (SQL monitoring and tuning by rewriting SQL and using Snapshot,
• Table Function, Event Monitor and OS commands (topas, vmstat and iostat), in addition to using EXPLAIN and running the reorgck, reorg, runstats and db2rbind commands.
• Reshaped the physical data warehouse model to ensure optimal DB2 performance through using MDCs, MQTs, and clustering and proper data types.
• Monitored and tuned mainframe CICS and DB2 Applications, struggling SQL statements and databases by using various systems and applications Health Checks reports in addition to real time snapshot monitoring, Event monitoring and other monitoring tools such as Omegamon for DB2 and CICS.
• Help developers to formulate the queries and application development team to design new and re-engineer existing applications.
• Planned and implemented HADR (High Availability Disaster Recovery) in a DB2 UDBv10 environment by preparing Primary database and Standby database, configuring parameter and cloning the primary database to Standby.

Confidential, Council Bluff, IA,

Responsibilities:

• DB2 z/OS database modeling and physical design for a series of web-based applications that include DB2 Z/OS and Q-replication to SQLServer 2005 boxes. Interfaced with business analysts and developers with regards to application, logical and physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Database data conversion from mainframe systems DB2 and raw VSAM to normalized data in a distributed DB2 (Red Hat Linux) environment.
• Senior member of team migrating clients Asset Management data mart and Fixed Income data mart from
• Oracle to Teradata V2.5. Worked with database administrators to determine indexes, statistics and partitioning to add to tables to the data warehouse in order to improve performance for end-users. Used
• PMON and Explain facility to tune existing Teradata processes to optimize for performance.
• Solely responsible in the designed and data feeds to load Teradata tables from Oracle and DB2 mainframe z/OS DB2 tables, VSAM or from flat files, using Fastload, Multiload and Informatica for ETL services, in addition to RC-Migrator from Platinum toolset.
• Participated in the planning and implemented disaster recovery (DB2 UDB HADR) and standard recovery testing using established documentation and the High Availability Instance Configuration Utility (db2haicu).
• Responsible for ongoing operational support and monitoring the HADR/HACMP processes.
• Provided technical support for Z/OS application SQL Query tuning, database parameter tuning, operating system tuning, memory tuning using tools such as TMON for DB2 and CICS, and for DB2 UDB. Used CICSPA reports proactively monitor (Health check reporting), analyzes CICS reports for all aspects of CICS systems activity and resource usage, including Transaction response time, Cross-system performance, exception events that cause performance degradation, multi-region operation (MRO) and advanced program-to-program communication (APPC), Business Transaction Services (BTS), and System Logger performance.
• Setup and maintained db2 udb data replication from Linux boxes to SQLServer 2005 boxes.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Perform capacity planning and analysis and implement required changes on the database server.
• Migrate and/or coordinate the migration of application systems from test (for quality assurance) to production environments. Data migration done using CA-Platinum toolset.
• Create a library of scripts to carry out every task that was essential.
• Database design, customization and administration of WebSphere provided tables.

Confidential., Tallahassee, FL

Responsibilities:

• Evaluate Database change requests for adherence to standards and completeness.
• Perform SAP/z-OS DB2 DBA tasks required to support on-going development and DBA activities required to meet the performance objectives of the State children and family services applications.
• Provide support to in-house and offshore developers in SQL development, SQL tuning and performance issues resolution. Respond favorably to request for SQL coding assistance and SQL analysis.
• Planned, designed and implemented enterprise DB2 UDB v9.5 installation, enhancement and patches for the SACWIS project, in addition to Web Benefits Online Application System DB2 (TANF, SNAP, cash or medical assistance programs) database physical design, development and support, performance monitoring of assigned production and acceptance databases, database performance tuning including defect resolution.
• Provided DB2 UDB SQL tuning and application design support to the ETL team working with Business Object and Data Integrator (BO/DI). Familiar with db2batch, dynexplain, db2exfmt and other explain tools to analyze queries going against very large fact and dimension tables.
• Provide change control and object management support for modifications and additions to the Data Warehouse.
• Ongoing provisioning, monitoring and maintenance for all State children and family services development and Test database environment data refreshes as dictated by testing schedule.
• Implemented DB2 audit trace for critical tables and created audit reports. Maintain DB2 subsystem and database security, perform database physical design and maintain physical database objects including tables, views, indexes, triggers, stored procedures, etc. Set up and run DB2 REORGs, LOADs, UNLOADs, BINDs, etc. as required utilizing a set of tools including the CA-Platinum toolset.
• Wrote scripts to monitor activity administer security, control utilities and cycle database and helped introduce new features of DB2v9.5 for general use.

NJPeopleSoft Upgrade Support,

Confidential, Parsippany,

Responsibilities:

• Assist with planning, testing and implementation of DB2 PeopleSoft Application and Tools upgrades and patches in PeopleSoft Version 8.
• Design, Plan, Build and Implement High Availability (HA) Disaster Recovery DB2 UDB Log Shipping, PPRC-XD (Peer-to-Peer Remote copy extended distance) and FlashCopy HA solution with automated client reroute and Heartbeat (OpenSource) as the two server cluster manager. The scope of the project included moving all elements from Dell servers to Linux servers.
• Solely responsible for setup, installation, configuration, performance monitoring and issues resolution for DB2 Connect during production cut-over for PeopleSoft project.
• Participated actively in application design by suggesting where utilities should be used by applications in order to handle very large volumes of data that could not be processed in a timely manner using programs and SQL. Educated developers on how to use loads and unloads to accomplish insert and delete processing.
• Helped design and maintain a complex data bridging system to keep applications on old and new systems synchronized during application migration.
• Monitor and manage database backups, system status, performance, capacity and growth and the middle-ware between PeopleSoft and DB2. Instrumental in reducing batch-processing times for several major processes by 75%.
• Database performance tuning through database physical design, configurations and implementations of data aggregations, MQTs, MDCs, partitioning, indexing and related settings.

Confidential, Atlanta,

Responsibilities:

• Provided remote DB2v8 Unix/Windows 2003 Server and application enabling support to a fortune 500 Client account:
• Participated in the migration from DB2v7 to DB2 V8 including the completion of ENFM (enabling new function mode) and NFM (new function mode) - also included pre-requisite work such as CCSID conversion.
• Primary DBA responsible for relocating 10 multi-terabyte (2.9 TB) databases from Springfield data center to Philadelphia using RMAN clone process.
• Set up and troubleshooting of HADR feature.
• Set up Automation DB2 HADR failover/Disaster Recovery with HACMP. The focus of this project was to Design, Plan, Build and Implement High Availability Disaster Recovery Solution for a Mortgage product.
• Set up and troubleshooting of SQL Replication from SQLServer to DB2 UDBv9.1 boxes.
• Set up and troubleshooting of Federated database between Oracle9i and DB2 UDBv9.1
• Responsible for design, installation, configuration and management of Sterling Commerce suite of data movement products - Connect: Direct for Mainframe, UNIX/AIX and Windows interfaces, DB2 Connect for UNIX/AIX and Windows interfaces, Sybase Direct Connect for UNIX/AIX, Mainframe and Windows interfaces, collaborate with client personnel to define database requirement and design.
• Responsible for installation, maintenance and tuning of some z/OS-based database management software such as CA-Unicenter toolset.

Confidential,Springfield, VA,

• Participated in the PeopleSoft ERP upgrade projects HCM 7.51/FMS 7.51 to 8.8 for the following services: HR, Ben, Pay, ePay, GL, AM, AP, PO. Strong understanding of PeopleSoft tables and customized table maintenance requirements. Knowledge of PeopleSoft products, tools and skilled in a variety of PeopleSoft techniques, methods, processes and practices.
• Kept current with all PeopleSoft patches/fixes, upgrades and maintenance packs and apply them to the PS environments.
• Senior member of a team that implemented DB2 data sharing, to support High availability SLA requirements.
• Assist developers in performance and tuning Queries, SQLs and SQRs. Determine when to create or remove indices to ensure acceptable processing time for all SQRs migrated to production. Monitor system by developing and maintaining monitoring scripts. Conduct performance test and ensure performance to support a large number of users and processes.
• Installed and configured DB2 Data Replication on production database servers using replication (update anywhere) subscriptions for high availability and Microsoft Clustering Services.
• Participated in data modeling activities to produce high quality enhanced physical PS/ERP database design.
• Installed/configured TMON and Omegamon DB2 performance monitors, developed/customized reports
• Converted DB2 catalog/directory/database objects to System Managed Storage (SMS), activities: DB2 object naming conventions,
• SMS storage classes, ISMF usage, in-house tools to automate migration, ACS scripting
• Developed and implemented a scheme allowing coexistence of CAF- and RRS-attach stored procedures within the same Workload

Confidential, Cordova, TN,

Responsibilities:

• Functioned as a Data Warehouse Developer/DBA for both Teradata and DB2 with a broad skill set that include:
• Support DB2 Version 7 in a 24x7 Parallel Sysplex Data Sharing environment, plan and implement new data sharing groups, add new members to existing production Data sharing groups, use Omegamon/DB2 to monitor and tune DB2 subsystem performance, diagnose software and usage problems, improve disaster recovery procedures for DB2 subsystems and databases,
• Responsible for installation, maintenance and tuning of all z/OS-based database management software
• Provided support for DB2 V7.1.0 through V8.1.0, including: SMP/E installation, customization, internal and application testing, development of migration, backout and remigration plans
• Provided peer to junior members of the group in subject matter including, but not limited to: DB2 UDB v8.1 Database software installation/maintenance, database release upgrade/migration.
• Responsible for 6 multi-terabyte databases in production, development and testing environments hosted on NCR MP-RAS v2.4 UNIX servers. Total storage for databases: 17 terabytes. Largest database: 5 terabytes.