Engineer

Job description

Skill

Mainframe Db2 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 a. 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

• 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

Qualifications

BACHELOR OF COMPUTER SCIENCE