Sr. Db2 Dba Udb Luw, Resume
3.00/5 (Submit Your Rating)
Braintree, MA
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,
- 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
Sr. DB2 DBA UDB LUW,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.
- 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.
- 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, Rochester, MN
Responsibilities:
- 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
- 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, IALead,
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,
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.
- 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 97 to 500 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., 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.