Relevant Experience:

Senior DB2 DBA offering an extensive background including database design and engineering, conversion , tuning and administration, migration, implementation, and on call support within multiple enterprise level AIX/LINUX systems. Excellent working experience in Data Warehouse applications, RDBMS such as DB2, Oracle 8i, Netezza, MS SQL Server. Related technical expertise includes UDB, PeopleSoft HRMS, Informatica, Rational, Network Monitoring, Tivoli, Data Warehousing, IMS administration, DB2 adminstration and MQ Series. Proven leadership abilities including team leading, training, and project management. Excellent communication and interpersonal skills.

Hardware Experience:

• Software Experience:

Confidential

• reviewed PL/SQL code in DB2 for coding deficiencies in Online store applications to improve access and tuning of the Database
• Provided technical reports as to the needs

Confidential

• Applied 3 years of Maint on DB2 Z/os across 6 DB2 sub systems.
• Installed DB2 V10 in a user test environment and copied over the 3tb database from v9.7
• Resolved user problems .

Confidential

• Upgrade DB2 V9.1 to V9.7 on 800 AIX servers in the branches ,
• Installed V9.7 on the 100 Headquarters AIX servers..
• Data Integrity: - Ensure recoverability of data through the design, implementation, and practice of defined database disaster recovery strategies
• Monitoring and Maintenance: - Monitor database performance to identify database configuration, hardware, and SQL query tuning opportunities - Monitor database resource usage and recommend hardware/software changes as needed - Monitor database utilities to ensure maintenance policies are being achieved

Confidential

• Upgrade DB2 from V7.1 to DB2 LUW V8.2 on a 16 node platform with a 10tb database. Upgrade DB2 LUW V8.2 to DB2 LUW V9.5 on a 16 node platform with a 14tb database Production, DR, QA, Test and development Systems Provided primary DBA design and support services for establishing, upgrading and maintaining the DB2 UDB LUW environments. Implemented backup and recovery procedures for DB2 UDB LUW databases . Created, maintained and refreshed required DB2 UDB LUW instances/databases for development, test and production environments. Helped to resolve application problems. Acted as liaison between application programmers and DBMS vendor to report and resolve problems. Monitored security breaches, error log s , database and log space, user activity and resource utilization of production environment. Worked with application programmers to insure that application problems do not adversely affect production operations.
• Analyze and correlate the events that occurs across the organization every login, logoff, file access, database query, etc. to deliver accurate prioritization of security risks and compliance violations to all systems using IBM security QRadar SIEM or HP ArchSight Enterprise Security Manager ESM . Monitored system resources of database servers to assure production systems meet performance availability requirements and hardware enhancements are scheduled in a timely fashion. Provided after hours on-call support for critical database issues. Provided expert assistance in database and SQL statement tuning to improve performance. Rational Performance Tester to simulate work loads after modifications of code and or Database. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes. Used software packages and/or local scripts, monitor performance, space, DB2 UDB LUW database parameters and tune as required. Acted as project liaison and coordinate with AIX system administrators for application of OS patches and maintenance required for database servers. DB2 UDB LUW database administration on servers for mission critical applications. Installation and upgrades of multiple DB2 UDB software products/versions for DBMS, server software and various tools software. Confidential
• Upgrade all DB2 ZOS systems from DB2 V7.1 to DB2 LUW V8.1 both standalone and data warehouse database. Created a plan to do the migration of Development, Staging and Production of 20 databases over 16 different servers. Data warehouse with a 3.5TB database. Set up backup procedures Have a plan that can be used to complete all the upgrades. Confidential
• Z/OS DBA Erwin for 2-3 months do design, development and implementation of application databases to support a scanner project. Data modeling using Erwin. Standard logical / physical database design, interface with programming and project mgmt staff Confidential
• Reviewed the current installation of UDB on various Windows 2000 Servers of several Production QA and Development Databases Tuning of System Configuration and SQL. Documented the need to increase the capabilities of the system which would lead to a change in direction of servers to Unix in order to have the current systems grow at the rate they are and still be able to give the users a respectively reasonable response time. Confidential
• Implemented the following PeopleSoft modules: General Ledger v8.4 with Commitment Control , Contracts, Grants, Projects, Accounts Payable, Billing, Asset Management, Expenses, Accounts Receivable and Cash Management, HRMS v8.8, Position Management, Recruitment, Base Benefits, Ben Admin, Time and Labor, Commitment Accounting, Payroll, eComp, ePay, eRecruit, eProfile, eBenefits. At present Production QA and Development Databases Tuning of System Configuration and SQL. In a IBM AIX/UDB environment on IBM P-series hardware Confidential
• Perform Installation of UDB 8,1 FixPac 1 and apply up to FixPac 3 on combined system with AIX and HPUX with HP 9000 Superdome, sixteen processors in Production, four processors within Development, and test lpars. Work also included handling of PeopleSoft HRMS interface to Data Warehouse. Handle installation of client on team member PC's. Set up full backup procedures, name conventions and serve as Lead DBA on project. Create development, test, and production databases in support of Enterprise Server Edition 8.1 Instances on HP-UX 11i. Create Data Warehouse Data Marts varying in size from 500G to 5.2TB. Perform Tuning of Database configuration. Work with interface to Database through Abinitio for ETL and Cognos for reporting. Confidential
• Led Project Team and communicated across functional teams with respect of logical and physical design of very high profile financial DB2 mainframe consisting of twelve databases with sixty five tables and Server database consisting of five databases with thirty tables. System operated across mainly an AIX platform, with mixed OS390 and NT platforms. System had varying size from 30G to 5.2TB. Completed all logical and physical design changes while communicating with key teams across several business areas. Supported all development of several ongoing designs of physical databases. Worked with various teams to ensure all aspects and standards were followed. Purpose of effort was to reduce number of RDBM's. Tuned SQL in various programs, along with data propagator us sync databases. Environment included UDB DB2 7.3 AIX, Mainframe, and NT. Confidential
• Worked with UDB EEE 7.2 on AIX servers with over thirty databases. Performed PeopleSoft HRMS administration and installation. Tuned SQL and Databases. Handled backup, recoveries, and tuning. Performed installation and upgrade of DataProp and DB2-Connect. Served as UDB administrator of all phases of UDB in performance of System and applications. Handled backup scripts across several nodes, as well as remote connections at several cities with WebSphere and Oracle 9I. Confidential
• Utilized UDB EEE 7.1 on AIX servers with over twenty databases. Tuned SQL and Databases. Performed backup, recoveries, and tuning of WebSphere with Oracle 8I. Handled replacement of Rational Rose Database design tools with Erwin Design Tools. Installed and configured CA tool RC/Secure. Served as UDB administrator in all phases of UDB for performance of System and applications. Performed data warehouse set up in test environment system. Confidential
• Worked with UDB 6.1 on Sun/AIX servers Design of sixteen inter linked databases. Utilized Java, WebSphere, Erwin, Patrol, and Unix scripts. Handled Conversion of Design to Mainframe to utilize DB2 Connect. Performed backup, recoveries, and tuning WebSphere with Oracle8I. Installed MQ series in test Environment. Installed and configured CA tools for DB2 consisting of RC/Secure, and OS/390 Database Performance management Suite. Utilized Rational Rose Database for database design modifications. Performed installation of UDB on various platforms, along with DB2 Connect WebSphere. Served as UDB administrator within all phases from Development to Production, Applications, and System. Was Development DBA within large multiple database system. Confidential
• Tuned UDB 6.1 on AIX over a distributed system. Handled multi-site installation utilizing OS390 AIX Servers. Installed and administered PeopleSoft HRMS and WebSphere with Oracle8I. Confidential
• Tuned Z/OS DB2 database and SQL using Omegamon. Installed and configured CA tools for DB2 consisting of RC/Secure and OS/390 Database Administration Suite. Reviewed CICS related hardware and software. Planed and implemented strategies for next release of CICS. Provided future strategies and planning suggestions. Provided suggestions and replacements for third-party packages WebSphere with Oracle8i Confidential
• Performed DB2 and UDB administration on AIX and Z/OS platform. Installed and customized CICS/TS, and set up MRO's for terminal region, multiple production, and test region. Installed MQ Series and set up environment with CICS and DB2 in a Development and test environment. Tested and handled production implementation of technology solutions to employ MQSeries family of products. Defined new CICS VSAM system files to better utilize space and tune temporary storage, interpartition transient data, restart, and configuration files. Converted obsolete PCT and PPT definitions to Resource Definition Online facility to bimprove maintainability. Review, clean up, and delete unnecessary CICS definitions to increase storage availability. Converted TCT terminal definitions to Resource Definition Online facility RDO . Performed PeopleSoft installation and administration in UDB on AIX. Confidential
• Performed logical and physical design, on Z/OS DB2 and IMS backup and recovery utilities, DB2 tuning and performance monitoring. PlatHandled DB2 catalog and directory recovery, DB2 subsystem and application error diagnosis using DB2 EXPLAINS to decipher changes in access paths. Developed database backup strategy, DB2 application recovery tool development, DB2 SQL efficiency reviews, and operational maintenance of DB2 objects. Confidential
• Installed DB2 in conjunction with CICS on OS/360. Assisted with systems in functional set up of complete new environment using DB2, CICS, Fileaid, and COBOL. Designed two new database systems using Silverrun to create RDM and complete normalization of database. Worked with other members of both Franklin Templeton and other consultants in methods of coding efficient DB2/CICS programs. Worked on removing the normal problems of a new to the Mainframe Software packages such as SDFII, Expeditor, Fileaid and Changeman in combination with DB2/CICS. Wrote over twenty CICS and DB2 programs requiring efficient and complex code. Worked with EXPLAINS and TUNING and all other aspects of efficient DB2 programs. Confidential
• Team member on a project developing outage information system to extract premium outage information from INFOMAN. Provided technical support for other team members in design of system running on IBM TSO/ISPF interactive system with an interface to Unix, INFORMIX C and C . Environment included work on AIX system. Confidential
• Supported production ad test systems as DBA. Provided technical support for various departments in GTE Data Services as to the optimization of DB2 systems. Confidential
• Provided technical support and tuning procedures for larger IMS/DB2 on line system Confidential
• Served as team member on project developing Mechanized Uncollectable Treatment System MUTS , a large and complex MICROFOCUS COBOL II/DB2 system. Originated solutions for business and technical problems such as involvement creating nested DB2 programs within Cobol II programs to eliminate redundant code and improve run time. Provided technical expertise on DB2 access methods, revised and developed highly CPU/DB2 intensive programming, and modified indexes and the database structure in order to enhance efficiency and improve run times of both main programs and submodules. Devised short programs to analyze system development and ensure performance as intended. Some programs were permanently incorporated into system. Utilized Strobe, Omegamon, and various Platinum utilities to monitor system performance. Confidential
• Installed DB2 2.3 and tuned DB2. Created Backup and recovery procedures. Performed forward and reverse engineering of database using Bachman tools. Worked extensively supporting
• companies programmers and analysts. Set up disaster recovery procedures. Confidential
• Installed INTEGRAL payroll system using DB2. Wrote conversion programs. Confidential
• Designed, wrote, and implemented large-scale automobile inventory tracking system. System was comprised of CICS, DB2, and ADABASE Cobol CICS programs. Wrote user manuals on system usage for car dealerships. Confidential
• Created DB2 Database for welfare system. Evaluated databases, produced unit functional specifications, and assisted in data admin role, system architecture and data modeling. Designed database system to interface with OS/2 presentation manager and other government systems. Performed and documented functional testing and user acceptance. Confidential
• Served as Team member in development of aircraft parts tracking system. Worked with Batch online CICS Natural/DB2 programs. Confidential
• Provided 7 X 24 online support of systems. Managed on installed TELON software. Performed Installation of DB2.1, ADABAS, and IMS DB/DC software. Confidential
• Installed Oracle on IBM 3081. Installed interface, security access and other misc. items. Installed compilers and init DASD Confidential
• Created Black box enabling users to access DB2, ADABASE, IDMS, S2K and VSAM from COBOL/CICS and Natural. Developed Motor Vehicle Tax System Cobol/DB2. Managed conversion of a SYSTEM 4 to IBM mainframe.