Back to search
Tata Consultancy Services Linkedin · Posted 17d ago

Engineer

Midvale

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

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

Qualifications: BACHELOR OF COMPUTER SCIENCE
Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock more results and save your role and location preferences.

Unlock free search
Want help applying to roles like this? Search Caio for free. If repetitive applications get heavy, Managed Job Search adds supervised execution for $99/month.
View Managed Job Search