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 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

• 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.
• 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

• Assigned to the Revenue Cycle Data Warehouse which houses historical data pertaining to Mayos revenue cycle activities. Data is extracted nightly from the source systems, primarily Healthquest and MRIS and is loaded into a DB2 database, which has traditionally been used by Patient Financial Services as the source for IBI Focus reporting. This data is used for daily transactional reporting such as patient billing operations and claims/remittance processing. Metrics such as Days Revenue Outstanding DRO and A/R Aging are captured for analysis and monitoring. Specific responsibilities are:
• 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

• eDBTS, Inc. is a privately held provider of data center automation software, offering a complete range of solutions for enterprises, government agencies and service providers. Working as DB2 UDB administrator, supporting a DSS database system for mortgage application and maintenance. Primary responsibility was to support development teams and projects. The role include work as a data architect data modeling, database design , database developer stored procedures, SQL development and database administrator for both the mainframe z/OS and DB2 UDB distributed environments data loading, optimization, support, etc . Project support included:
• 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

DB2 DBA/Developer - z/OS, DB2v8.2, DB2v9.5 Linux and Windows

• Engagement: State Government-Children and Families Services:
• Primary responsibilities are to perform CICS DB2 z/OS and DB2 for LUW database development and administration in support State Automated Child Welfare Information System SACWIS project and various DB2 LUW supporting TANF, Food Stamps SNAP and Medical Assistance systems. 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

DB2 DBA/PeopleSoft Upgrade Support

• 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

Remote DB2 DBA DB2 Parallel Edition - early DPF implementation

• 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.

Confidential

DB2 DBA

• Project Summary: 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.
• 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
• Manager WLM environment, avoiding requirements for extra program compiles and links
• Modified DSNTIAUL to: use CAF for its database connection, access tables via DDF, allow load statement syntax customization,
• improve blocking of output file, support DB2 identity columns.
• Developed a TSO/ISPF front end for maintenance of DB2 stored procedure definitions, utilizing Rexx and DB2 Rexx/SQL support
• Acquired SAS skills to maintain DB2 instrumentation data in SAS datasets, for trend monitoring purposes.
• Assist with installation/configuration of DB2 Connect on Windows NT platforms
• Continued application support and enhancements to Data Warehouse environment for Marketing, Operations and Accounting. Provide 24hr support of the DWH IBM DB2 and Data-mart environments RISC/Oracle . Identified and documented procedure for data corrections.
• Actively participate in the system development process including a review of database requirements for new and existing programs. Assist application developers by creating and implementing physical database designs to best-fit corporate application requirements.
• Monitor and report resource utilization on all Database systems. Participate in weekly on-call rotation with other Database Administrators.

Confidential

Team Lead - Teradata Data Warehouse Developer/DB2 DBA z/OS

• 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 training 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.
• Worked with database administrators to determine indexes, statistics and partitioning to add to tables in 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. Designed data feeds to load Teradata from DB2 and vice-versa, using Fastload/Multiload and FastExport.
• Provided technical expertise in the area of data quality, data integration from many business sources, data validation and data staging into the data warehouse.
• Worked extensively with ETL developers using tools such as Ab Initio and MicroStrategy to access Teradata data warehouse.
• Provided a very high-level technical support/data extraction and exporting functionality to Oracle8i DB. Worked closely with applications groups to identify areas for application and PL/SQL performance improvements. Assist in maintenance of Oracle database system backup and Recovery procedures. Document processes and cross train with other database administrators.
• Additionally tasked with replication of production Oracle databases to create fresh test environments. Developed software to monitor Oracle database storage usage and warn of impending issues.
• Provided technical support adding or modifying enterprise data warehouse model that result from continuing business development and changing requirements.
• Provided technical assistance in developing and maintaining corporate processes and data security procedures and policies while performing as a backup to the RACF administrator creating and modifying all RACF resources and auditing security related activities on the system. Monitor and perform routine maintenance to RACF and DB2, CICS and Omegamon.
• Worked extensively with internal/external auditors to validate mainframe DB2 assets access security environment for compliance with various regulatory requirements such as Payment Card Industry PCI Data Security Standards, HIPAA, GLBA, Sarbanes Oxley and others.

Confidential

DB2 DBA/Developer

• Participated in the PeopleSoft ERP upgrade project HCM 8.0 SP1 to 8.9 MP2, FMS 7.5 - 8.8 for the following services: HR, Benefits, Payroll, Time and Labor, Self Service, Enterprise Portal, INV, PO, AP, GL, AR, Commitment Control.
• Established and maintained all PeopleSoft Development, Product Test, System Test, QA and Production environments. Assist in applying all PeopleSoft patches and fixes.
• Developed Daily Backup and Recovery/Disaster Recovery procedures. Manage Process Scheduler and scheduling of processes for batch window. Manage COBOL, CICS, Crystal Reports and SQR environments. Provide 24 x 7 database support.
• Manage day-to-day activities such as SQL and program reviews to enhance performance.
• Index design and tuning for dynamic SQL query optimization and query performance.
• Conducted workshops on embedded SQL programming, access paths and optimization.
• Performed performance tuning for critical Batch programs and online transactions.
• Perform data mover exports and imports to various databases.

Confidential

DB2 DBA

• Sole DBA responsible for the design, creation and maintenance of all DB2 Objects and database support for the ONGARD Oil GAS Service Center. Later, went on to provided DB2 support for Commercial and Motor Vehicle, Personal and Corporate Income Tax and the Combine Revenue Information CRS Systems. Major responsibilities included:
• Instrumental in re-design and implementation of logical and physical database models, data analysis, mapping and Schema design, Performed extensive normalization and de-normalization activities for various database development and modification projects, analyze database process and access requirements, assist development staff for application design and development, specifically for Data Warehouse transaction design and efficient SQL and stored procedure development. Supported ERwin Data Modeling activities.
• Lead database developer in the implementation of a SQLServer ETL application for Tax and financial reporting and revenue forecasting data warehouse. Designed and developed databases and ETL of a single fact table, 24 aggregate tables, 6 range tables and 107 dimension tables. Processing environment updates on a quarterly basis, building approximately 80 Gigabytes in 4 hours.
• Plan/coordinate system storage requirements for SQLServer 2000 server farm. Coordinate DB2 to SQLServer data replication processes, Design and implement backup methods and disaster recovery strategy for project.
• Managed DB2 dataset maintenance and security using RACF and Vanguard Advisor to accumulate and report on selected security events such as Security Server RACF command activity, job/logon violations and resource access violations.
• Perform tuning of the DB2 systems and related application databases, monitor database efficiency and ensure optimal performance.
• Responsible for Oracle7/8i logical and physical databases design, implementation and maintenance on UNIX and NT. Installed upgraded and patched Oracle software. Managed and resolved design issues during development. Moved database Schema changes to stage or production. Migrated and upgraded databases from version 7 to 8i.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Design and implement security access infrastructure, Develop and implement data dictionary and database related standards, procedures and guidelines for DB2, Coordinate testing activities within and outside the department.
• Utilized MainView, Detector, DB2 performance statistics and accounting reports to improve application and database performance. Track, analyze various performance data and perform proactive maintenance on DB2 datasets and objects space utilization. Monitoring and analysis of buffer pool hit ratios, I/O, elapsed times, CPU utilization and other statistics and accounting data for performance tuning and historical trending.