SUMMARY

• Certified Professional Database Administrator wif over 25 years application development and database management systems experience wif DB2 distributed client server open systems platforms in addition to MVS and z/OS mainframe environment.
• 13 years of experience wif DB2 MVS and z/OS and 11 years 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 databases
• 9 years of experience wif DB2, CICS, COBOL, JCL and mainframe-centric toolsets on z/OS, OS/390 mainframe environment. (versions5,6, 7, and 8)
• 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 noledge of DB2 UDBv8.x, thru 9.7 on LUW operating systems in addition to deep noledge of DB2v8 and v9 on Unix/AIX and Red Hat Linux.
• Experience and ability to tune complex database systems at teh application design, operational database and system levels.
• Thorough noledge of and experience wif 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. TEMPHas performed SAP/z-OS DB2 DBA tasks required to support on-going development and DBA activities required to meet teh 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 wif 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 teh middle-ware between PeopleSoft and DB2. Experienced technologist wif 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, Jacksonville, FL

Sr. Consultant - DB2 DBA

Responsibilities:

• Testing and implementing different physical and logical backup and recovery methods like point in time, cross node recovery, media recovery, full/partial and export/import, Incremental delta backup, online reorgs, compression (data, index)
• Tricare clearance for handling federal Databases.
• Performance tuning of teh SQL, DBM and DB configurations.
• Setting up teh HADR.
• Opening/working wif IBM on teh PMR’s.
• Monitoring of teh activities in teh databases wif Snapshots and Event Monitors and recommending measures for optimizing teh db performance.
• Designing databases and database layout, automating teh process by writing shell scripts.
• Recommendations/suggestions on physical database design.
• Annual database storage management (Capacity planning).
• Analyzing and implementing new features of 10.5.
• Working wif teh application team and resolving SRs, PRs and planned/unplanned issues.
• Level 2 supports for any production support.
• Implementing teh Avamar backup and recovery scripts.
• Versatile team player wif excellent analytical, communication and inter personal skills

Environment: DB2 UDB 9.1/9.5/9.7/10.1 UDB LUW, Toad, SAN, AIX, LINUX, Remedy, HADR, HACMP, EMC Avamar storage

Confidential, Braintree, MA

Sr. DB2 DBA UDB

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 teh production environment and make recommendations to address performance bottlenecks. Assist development teams in tuning long running process that support critical business reporting. Automate teh identification of unused database objects that could potential free up system capacity/resources.
• Install and Configure DB2v10.5 LUW in teh 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 teh 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

DB2v8 & v9 DBA

Responsibilities:

• DBA responsible for teh design, creation and maintenance of all DB2 Objects and database support for teh ONGARD (Oil & GAS) Service Center.
• Recovered plan and HADR design, implementation, procedures, noledge 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 wif developers on teh database design/architecture and schema optimization and other DB2 aspects.
• Experienced huge successes in performance tuning of struggling application systems.

Confidential, Plano, TX

Lead Consultant DB2 DBA v9.7 Unix/AIX

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 teh reorgck, reorg, runstats and db2rbind commands.
• Reshaped teh 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 teh 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 teh primary database to Standby.

Confidential, Rochester, MN

DB2 DBA

Responsibilities:

• Participate in teh main DPF/Multi-node design, hashing-keys, number of nodes, storage and cpu-memory allocation per node partition using teh latest AIX V6.1 on P570's.
• Responsible for teh 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 wif system architects to design teh databases, data sharing operation in Parallel Sysplex environment.
• Instrumental in teh 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 teh reorgck, reorg, runstats and db2rbind commands.
• Reshaped teh 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 teh 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 teh primary database to Standby.

Confidential

Lead DB2 DBA

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 wif business analysts and developers wif 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 wif database administrators to determine indexes, statistics and partitioning to add to tables to teh 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 teh 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 teh planning and implemented disaster recovery (DB2 UDB HADR) and standard recovery testing using established documentation and teh High Availability Instance Configuration Utility (db2haicu).
• Responsible for ongoing operational support and monitoring teh 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 teh database server.
• Migrate and/or coordinate teh 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.