Senior Consultant Db2/dba (codeworks) Resume
Madison, WI
SUMMARY:
- Seeking an opportunity within a progressive, innovative and challenging organization that will allow me to utilize and exploit my past technical and leadership experiences.
PROFESSIONAL EXPERIENCE:
Confidential, Madison WI
Senior Consultant DB2/DBA (Codeworks)
Responsibilities:
- Provided support for all DB2 related requests.
- Provided solutions for performance problems.
- Participated in DR exercises.
- Senior Consultant DB2/DBA (QAT)
- Performed a DB2 for Z/OS Release upgrade from Version 10 to Version 11.
- Administored IBM’s ITOM product.
- Upgraded QMF to current PUT Level
- Upgrade SQLPA to current PUT Level
- Provided general support. (problem resolution, on call, performance etc.)
Confidential, Albany, NY
Senior Consultant DB2/DBA (Infopeoplecorp)
Responsibilities:
- Performed a DB2 for Z/OS Release upgrade from Version 9 to Version 10.
- Installed CA DETECTOR in test and production.
- Instituted online reorganizations.
- Benchmarked Flashcopy versus conventional image copies.
- Provided general DBA support in test and production.
- Improved online performance by 20 percent.
Confidential, Quincy, MA
Senior Consultant DB2/DBA
Responsibilities:
- Assisted with the migration from Datacom DB to DB2 using Tiburon coding. easured programs to ensure that release changes would meet CPU consumptions goals.
- Worked with end user to test and tune applications.
- Investigated using Threadsafe techniques in CICS to reduce CICS performance.
- Created metrics to measure the performance of CICS and DB2.
Confidential, Weehawken, NJ
Senior Consultant DB2/DBA
Responsibilities:
- Assisted in the design of DB2 financial management system for broker compensation.
- Developed 100 plus access routines using stored procedure builder.
- Ensured that transactions and access met or exceed corporate guidelines.
- Wrote various programs that were used in the conversions of data.
- Assisted with the backup and recovery procedures for the system.
Confidential, Trenton, NJ
Senior Consultant DB2/DBA
Responsibilities:
- Performed Risk Analysis for a major DB2 application conversion.
- Produced reviews, made recommendations and oversaw implementation of approved infrastructure changes.
- Reviewed and implemented performance processes for the DB2 production environment.
Confidential, Philadelphia, PA
Senior Consultant DB2/DBA
Responsibilities:
- Performed Risk Analysis for a major DB2 application conversion.
- Produced reviews, made recommendations and oversaw implementation of approved infrastructure changes.
- Reviewed and implemented performance processes for the DB2 production environment.
- Benchmarked the DB2 conversion effort and the future resource needs for the ongoing
- DB2 environment.
- Reviewed scheduling and SLA requirements and make appropriate recommendations.
Confidential, Princeton Junction, NJ
Principal Consultant
Responsibilities:
- Directed the efforts of 7 database administrators in three countries.
- Responsible for the day to day availability of the Confidential DB2 systems.
- Charged with revamping weekend efforts with new and innovated approaches.
- Instituted new hardware approaches that have significantly improved productivity.
- Major contribution was creating a stable DB2 production environment.
- Key implementations were:
- Version 7 of DB2BMC Software Suite
- Catalogue ReorganizationStored Procedure Builder
- SMS Storage (Mod3 thru 27)IBM OnDemand
- Routine responsibilities included the following:
- 24 by 7 Production support Object creation
- Performance monitoring Backup, recovery and disaster recovery
- SQL analysis Creation and enforcement of standards
- DB2 production environment had over 150 databases and 3000 tables. Additionallya test, QA and user acceptance environment were maintained.
Confidential, Jersey City, NJ
Senior Director (DB2 Database Administration)
Responsibilities:
- Directed the efforts of 14 database administrators.
- Responsible for physical and logical database designs of new and reengineered applications.
- Directly responsible for the administration of mainframe databases. (DB2 and IDMS)
- Coordinated deployment to distributed platforms using UDB, DB2 Connect and Data Proprogator.
- Major contribution was creating a DB2 production environment that could be available 24 by 7met current and anticipated transaction volumes, ensured data integrity and could be recovered within 4 hours period once a disaster was declared.
- Key implementations were:
- Version 6 and 7 of DB2Installation of DB2 data sharing into z/OS 7 - way sysplex
- Work Load Manager (WLM)Stored Procedure Builder
- WebsphereUDB 7.2 with DB2 Connect
- SMS Storage
- Systems included:
- MSD (Master Securities Database) Tax Lots
- Automated Order Management Transaction Switch
- Corporate Action
- DB2 related product also administered:
- DB2 Connect DB2 Performance Monitor
- Stored Procedure Builder Platinum Utilities for DB2
- Omegamon for DB2 IBM Utilities for DB2
- Routine responsibilities included the following:
- 24 by 7 Production support Object creation
- Performance monitoring Backup, recovery and disaster recovery
- Physical database design Programming support
- SQL analysis Creation and enforcement of standards
- DB2 production environment had over 40 databases and 1000 tables. Additionally, a test and
- QA environment of similar size.
- IDMS environment spanned 16 production regions and processed in excess of 700 billion dollars on a daily basis.
Confidential, New York, NY
Independent Consultant-Project Manager/DBA
Responsibilities:
- DB2 DBA in charge of the logical and physical design of Merrill-Lynch’s Global Collateral System.
- Created all objects and the coordination from the test, integration testing, and user acceptance through production implementation. This system had more than 240 tables.
- The DB2 performance, backups, recoverability and DR process were also part of my responsibilities.
- Third party software products that were integrated in the system were Neon’s Formatter, BMC and
Confidential, Hopewell,NJ
Database Administrator
Responsibilities:
- DB2 database administrator for year 2000 conversion.
- Daily programming and development support.
- On call and production support.
Confidential, New Brunswick, NJ
Director of Technical Services
Responsibilities:
- Designed, trained, staffed and implemented logical activities for the organization.
- Design, creation, support, performance and recovery of over 1500 tables that spanned 3 address spaces and are service by 5 CICS and DB2 regions.
- Provided database, and technical support for up to 70 computer professionals n the usage of DB2.
- Introduced database technology on the mainframe (DB2) and midrange computing platforms (RS6000).
- All technical aspects of a 52 million dollar strategic project.
- Creation, usage, and administration of the Production and Test TSO environments.
- Designed and supported an interactive development environment. Including the acquisitionadministration, and support of a suite of purchased and developed productivity tools.
- Developed and designed an ad-hoc computing environment, which utilizes SPF and Dialogue management, Services.
- Provided a stable production CICS environment.
- Designed, created and supported an asynchronous computing environment, which facilitates rder entry, electronic data interchange and inventory updating.
Confidential, East Brunswick, NJ
Senior Data Base Administrator
Responsibilities:
- As the senior Technician within the corporation, was the lead DBA for all Data and
- Database Management software.
- During this time, the following software products were implemented:
- Cincom’s Total DBMS, Environ1 and T-ASK
- Infodata’s Inquire DBMSAston Tate’s dBASE
- MSP’s DatamanagerIBM’s SQL/DS and QMF
- IBM’s IMS/DB IBM’s DB2, QMF and DXT
- Additionally, assisted hiring personnel, the writing of standards, promotion of Data and
- Database functions within the SDLC and the setting of direction/goals for the corporation’s
Confidential, East Brunswick, NJ
Project Leader / DBA
Responsibilities:
- Designed and developed both Financial and Manufacturing Systems. The systems were developed using Cobol, TOTAL and CICS (Taskmaster).
Confidential, Valley Forge, PA
Programmer / Analyst
Responsibilities:
- Designed and wrote a Confidential t tracking system using Cobol.
Confidential, Alfred, NY
Programmer
Responsibilities:
- Started professional career as a programmer utilizing FORTRAN to develop business applications.