Mainframe Professional

Golden Opportunities; Hyderabad; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Golden Opportunities in Hyderabad, India seeks a DB2 Database Administrator to manage DB2 on IBM z/OS and optimize SQL. You will handle utilities like REORG, RUNSTATS, COPY, LOAD, and UNLOAD to support critical workloads.

You will monitor batch processing with CA-ESP Workload Automation, operate in TSO/ISPF, and participate in HA/DR testing and Sterling product configurations to ensure robust operations.

Qualifications

• Any Graduate, 6+ years of Experience.
• Analyze and optimize SQL queries and access paths.
• Execute REORG, RUNSTATS, COPY, LOAD, UNLOAD, and related DB2 utilities.
• Monitor, manage, and support enterprise batch workloads using CA-ESP Workload Automation.
• Navigate and support activities in Mainframe environments using TSO/ISPF.
• Understand and participate in High Availability (HA) and Disaster Recovery (DR) testing activities.
• Configure, administer, and support IBM Sterling Connect: Direct environments.
• Configure and manage IBM Sterling File Gateway (SFG).
• Maintain routing channels, mailbox configurations, and business processes.
• Monitor and manage enterprise batch processing using CA ESP Scheduler.

Responsibilities

• Administer and maintain DB2 databases on IBM z/OS platforms.
• Analyze and optimize SQL queries and access paths.
• Execute REORG, RUNSTATS, COPY, LOAD, UNLOAD, and related DB2 utilities
• Monitor, manage, and support enterprise batch workloads using CA-ESP Workload Automation.
• Navigate and support activities in Mainframe environments using TSO/ISPF.
• Understand and participate in High Availability (HA) and Disaster Recovery (DR) testing activities.
• Configure, administer, and support IBM Sterling Connect: Direct environments.
• Configure and manage IBM Sterling File Gateway (SFG).
• Maintain routing channels, mailbox configurations, and business processes.
• Monitor and manage enterprise batch processing using CA ESP Scheduler.

Skills

DB2 administration

SQL optimization

Batch processing

TSO/ISPF

Mainframe operations

CA-ESP Workload Automation

HA/DR testing

Sterling Connect Direct

Sterling File Gateway

Education

Any Graduate

Tools

CA-ESP Workload Automation

CA ESP Scheduler

TSO/ISPF

IBM Sterling Connect Direct

IBM Sterling File Gateway

Job description

Candidate Specification:

• Any Graduate , 6+ years of Experience


• Job Description : Administer and maintain DB2 databases on IBM z/OS platforms.


• Analyze and optimize SQL queries and access paths.


• Execute REORG, RUNSTATS, COPY, LOAD, UNLOAD, and related DB2 utilities


• Monitor, manage, and support enterprise batch workloads using CA-ESP Workload Automation.


• Navigate and support activities in Mainframe environments using TSO/ISPF.


• Understand and participate in High Availability (HA) and Disaster Recovery (DR) testing activities.


• Configure, administer, and support IBM Sterling Connect: Direct environments.


• Configure and manage IBM Sterling File Gateway (SFG).


• Maintain routing channels, mailbox configurations, and business processes.


• Monitor and manage enterprise batch processing using CA ESP Scheduler.