Engineer

Skill: Mainframe Db2

• Must Have Technical/Functional Skills:

• DB2/DBA in Mainframe Z O/S architecture.

1. TSO, MVS, JCL, SDSF & ISPF expert knowledge

2. Knowledge with Rexx coding and maintenance

3. Knowledge Cobol/VSAM capabilities

4. Full understanding of DASD requirements, calculations & interpretation

5. DB2 Master Console

• • DB2PMSTR

• • DB2PDBM1

• • DB2PDIST

• DBA Administration/SKillset will include:

1. DB2 UTS Conversion Strategies

• • Requirements, Limitations, Enhancements

1. DB2 v12

2. DB2 Catalog Tables

3. DB2 Performance Tunning, Explain and Plan Tables, Plan vs Packages

4. DB2 Partition Rotation Architecture

5. Understanding of DDL, DML & CML

6. Understanding DB2 PRIMARY OPTION MENU, SPUFI, DCLGEN, PROGRAM PREPARATION, PRECOMPILE, BIND/REBIND/FREE, RUN, DB2 COMMANDS, UTILITIES, DB2I DEFAULTS

7. DB2 Commands

• a. Display, Cancel Threads, Term Utility, Start/Stop, etc

1. DB2 IBM Tool sets DB2 Administration Menu

2. DB2 Utilities, UNLOAD/LOAD, IMAGE COPY, RUNSTATS, REORGS, RECOVER, CHECK Data/Index, REPAIR, STOSPACE, DSNCOPY

3. DB2 Logs

• Roles & Responsibilities:

• • Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements

• • Recommend operating system and database performance monitoring, tuning and configuration changes

• • Experience with database physical and logical design, query analysis and optimization

• • Provide technical assistance and subject matter expertise to applications groups

• • Provide database storage management and capacity management recommendations

• • Define and manage database security and access permissions in consultation with customer

• • Ensure completion of authorized Service Requests, Changes, Problem tickets

• • Manage escalations and track Service Delivery and ensure SLA compliance including with vendors

• • Review and update the SOP documents on regular basis

• • Support on all in-flight and upcoming project activities

• • Recommend and perform customer-approved database replication procedures

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

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

</div

Role: Engineer

Desired skills: Mainframe DB2 | Mainframe

Qualifications: BACHELOR OF COMPUTER SCIENCE

• Experience: 8 - 14 Years

• Job function: TECHNOLOGY

• Location: Midvale, UT

Salary range: $110,000–$118,000

Apply by: 2026-09-20 00:00:00