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.
More Information
Application Details
- Organization DetailsTCS / Tata Consultancy Services
Recommended Comments
There are no comments to display.
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.