Engineer

Tata Consultancy Services; Midvale (UT); On-site; USD 115,000 - 118,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage: Health

Dental & Vision

Disability Insurance

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

401K Plan & College Fund

Job summary

Tata Consultancy Services Limited in Midvale, UT is seeking a seasoned Mainframe DB2 Engineer (DB2/DBA) to manage complex data environments and z/OS-based workflows. The role requires strong expertise in TSO, MVS, JCL, SDSF, ISPF, Rexx, and Cobol/VSAM, with a focus on data integrity and performance tuning.

The position is based on-site in Midvale, UT, offering competitive salary with employee benefits and opportunities for professional growth within a global technology services leader.

Qualifications

• DB2/DBA in Mainframe Z O/S architecture.
• TSO, MVS, JCL, SDSF & ISPF expert knowledge
• Knowledge with Rexx coding and maintenance
• Knowledge Cobol/VSAM capabilities
• Full understanding of DASD requirements, calculations & interpretation
• DB2 Master Console, DB2PMSTR, DB2PDBM1, DB2PDIST

Responsibilities

• Maintain the integrity of the organization’s data while enabling business deployments and user provisioning.
• Address detailed data problems with practical, scalable solutions.
• Other duties as assigned

Skills

Mainframe

DB2/DBA

JCL

TSO

ISPF

SDSF

Rexx

Cobol/VSAM

Education

Bachelor of Computer Science

Tools

DB2 Master Console

DB2PMSTR

DB2PDBM1

DB2PDIST

UNLOAD/LOAD

RUNSTATS

Job description

Skill: APP DB2 Mainframe

Must Have Technical/Functional Skills:

• DB2/DBA in Mainframe Z O/S architecture.
• TSO, MVS, JCL, SDSF & ISPF expert knowledge
• Knowledge with Rexx coding and maintenance
• Knowledge Cobol/VSAM capabilities
• Full understanding of DASD requirements, calculations & interpretation
• DB2 Master Console
• DB2PMSTR
• DB2PDBM1
• DB2PDIST

DBA Administration/SKillset will include

• DB2 UTS Conversion Strategies
• Requirements, Limitations, Enhancements
• DB2 v12
• DB2 Catalog Tables
• DB2 Performance Tunning, Explain and Plan Tables, Plan vs Packages
• DB2 Partition Rotation Architecture
• Understanding of DDL, DML & CML
• Understanding DB2 PRIMARY OPTION MENU
• SPUFI, DCLGEN, PROGRAM PREPARATION, PRECOMPILE, BIND/REBIND/FREE, RUN, DB2 COMMANDS, UTILITIES, DB2I DEFAULTS
• DB2 Commands
• Display, Cancel Threads, Term Utility, Start/Stop, etc
• DB2 IBM Tool sets DB2 Administration Menu
• DB2 Utilities
• UNLOAD/LOAD, IMAGE COPY, RUNSTATS, REORGS, RECOVER, CHECK Data/Index, REPAIR, STOSPACE, DSNCOPY
• DB2 Logs

Roles & Responsibilities:

• Maintain the integrity of the data of the organization, while facilitating Business developments and innovations through deploys and user provisioning.
• Focus on detailed data problems and come up with creative and efficient solutions.
• Other duties as assigned

Salary Range - $115,000-$118,000 a year

TCS Employee Benefits Summary:

• 1.Discretionary Annual Incentive.
• 2.Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• 3.Family Support: Maternal & Parental Leaves.
• 4.Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• 5.Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• 6.Time Off: Vacation, Time Off, Sick Leave & Holidays.
• 7.Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Midvale, UT

Function

TECHNOLOGY

Role

Engineer

ID

436518

Skills

Mainframe

Salary Range

$115,000 - $118,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE