Job Related 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 the 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,
• Q-Replication, SQL replication and DB2 Federation services.
• 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

Sr. DB2 DBA UDB LUW v9.7 10.5 z/OS v9 10

• Assumed project to builds and maintains ... Show More large-scale and very high transactional Life/Health Insurance DB2 databases across multiple platforms. Solely responsible for tasks such as, the development of best practices and repeatable procedures for deploying databases, day-to-day operational activities including performance tuning, break/fix, space management, backup and recovery using Storage Manager , database replication setup and management.
• 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

DB2v8 v9 DBA

• 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

Lead Consultant DB2 DBA v9.7 Unix/AIX

• 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.
• Develop backup and recovery solutions for databases especially very large databases depending on their RTO and RPO.
• 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.

Confidential

DB2 DBA version 9.1 - z/OS, DB2v9.5 DPF and v9.7 DPF Unix/AIX

• Participate in the main DPF/Multi-node design, hashing-keys, number of nodes, storage and cpu-memory allocation per node partition using the latest AIX V6.1 on P570's.
• Responsible for the DPF/EEE backup/disaster recovery, full off-line/on-line backups, delta backups
• 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

Lead DB2 DBA v8.1 - z/OS, DB2v9.5, v9.7 DPF LUW Remote/Onsite Support

• 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

• Web Benefits Online Application System to apply for TANF, SNAP, cash or medical assistance
• 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.
• Providing DB2 z/OS support for the migration of DB2 zOS Version 8 to Version 9 for Florida ISD data warehousing system. Generated the conversion process for the code page 500 to 37 for the databases, tablespaces, views, plans and packages.
• 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.

Confidential

• 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

• 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.
• Provide application support to eliminate or avoid customer impact. Troubleshoot, diagnose and resolve problems and outages in production, UAT and QC environments by reviewing various logs.
• Address trouble tickets that were opened to reflect system and software defects. Field technical calls from help desks and individuals as relates to Production and UAT customer support, while providing general production application support to the UAT user community. Write production-monitoring scripts and assist in server build and checkouts whenever required.
• Maintain role of On-call support for 24x7 for mission critical databases in the UNIX/AIX.4.3/5.2, NT and Mainframe environment,
• Involved in documentation of all server environments including weekly reporting in addition to Systems status involving system requirement, performance and tunable aspects.