We provide IT Staff Augmentation Services!

Senior Consultant Db2/dba (codeworks) Resume

0/5 (Submit Your Rating)

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.

We'd love your feedback!