Previous Job
Mainframe DB2 DBA
Ref No.: 18-07093
Location: Worcester, Massachusetts
Job Title: Mainframe DB2 DBA
Job Location: Worecester, MA
Duration: 12 Months

Strong working knowledge of the mainframe environment, including proficiency and skill in z/OS, TSO/ISPF, JCL, COBOL, CICS, VSAM, REXX
Mainframe DBA - Database creation and Maintenance along with backups and DB2 support
Review and evaluate current installation of DB2.
Review Hold Data
Evaluate Upgrade Prerequisites
Develop Implementation Plan
Configure Sandbox Database for use by staff (including configuration of test CICS region)
Review and remediate known upgrade requirements such as: converting DBRM based plans, and plans not using DRDA protocol, etc)
Create JCL needed to perform DB2 migration, failback, and verification for each DB2 instance
Experience managing and tuning static SQL and dynamic SQL environments
Analyze subsystem performance using Omegamon
Optimize current poorly performing DB2 components
Optimize CICS region performance for all CICS regions
DB2 for z/OS performance monitoring and tuning.
Hands on experience on DB2 V10 and above
Strong working knowledge in z/OS. Be responsible for the integrity of Production, Test and QA database environments.
Completes specific team task activities as outlined in the project work plan and other job-related duties as assigned.
Maintains close coordination with the Analysts at various geo locations with respect to the status of tickets, issues etc
Experience in supporting large RDBMS systems
Mainframe System administration : Environment – MVS, TSO, OS/400 o Language – COBOL, RPG, PL/I,ASSEMBLER, Natural, COOLGEN o File Management – DB2, VSAM, o TP – CICS o Standard Tools
3 to 5 years of experience in:-

NTT DATA Services is a leading IT services provider and global innovation partner with 130,000 professionals based in over 50 countries. NTT DATA recently acquired Dell Services. NTT DATA Services emphasizes long-term commitment and combines global reach and local intimacy to provide premier professional services, including consulting, application services, business process, IT outsourcing, and cloud-based solutions. We are a part of NTT Group, one of the world's largest technology services companies, generating more than $100 billion in annual revenues and partner to 80% of the Fortune 100. Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a wide range of businesses and government agencies.

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.