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

2. DB2 v12

3. DB2 Catalog Tables

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

5. DB2 Partition Rotation Architecture

6. Understanding of DDL, DML & CML

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

8. DB2 Commands

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

9. DB2 IBM Tool sets DB2 Administration Menu

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

11. 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.