DB2 Mainframe Database Administrator

Infosys; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Infosys seeks a DB2 on Mainframe DBA to administer and support DB2 databases on z/OS, monitor performance, and perform tuning. You will manage objects, backups, recovery, and maintenance, while assisting application teams with SQL optimization and database changes.

You will execute DB2 utilities such as REORG, RUNSTATS, LOAD, and RECOVER, troubleshoot production incidents, and ensure security and data integrity. Participation in deployments, migrations, and capacity planning is required.

Qualifications

• DB2 on Mainframe is the core tech.
• Educational qualifications include MCA, MTech, BE, BCA, BTech.
• Preferred skills reiterate DB2 on Mainframe.

Responsibilities

• Administer and support DB2 databases on Mainframe (z/OS).
• Monitor database performance and perform tuning activities.
• Manage database objects, backups, recovery, and maintenance tasks.
• Support application teams with SQL optimization and database changes.
• Execute DB2 utilities such as REORG, RUNSTATS, LOAD, and RECOVER.
• Troubleshoot database issues and resolve production incidents.
• Ensure database security, availability, and data integrity.
• Support application deployments, migrations, and release activities.
• Perform capacity planning and storage management.
• Prepare documentation, SOPs, and provide L2/L3 production support.

Skills

DB2 on Mainframe

Education

MCA

MTech

Bachelor of Engineering

BCA

BTech

Job description

• Administer and support DB2 databases on Mainframe (z/OS).
• Monitor database performance and perform tuning activities.
• Manage database objects, backups, recovery, and maintenance tasks.
• Support application teams with SQL optimization and database changes.
• Execute DB2 utilities such as REORG, RUNSTATS, LOAD, and RECOVER.
• Troubleshoot database issues and resolve production incidents.
• Ensure database security, availability, and data integrity.
• Support application deployments, migrations, and release activities.
• Perform capacity planning and storage management.
• Prepare documentation, SOPs, and provide L2/L3 production support.

Technical Requirement

Technology->Database Administration->DB2 on Mainframe

Educational Requirement

MCA,MTech,Bachelor of Engineering,BCA,BTech

Preferred Skills

Technology->Database Administration->DB2 on Mainframe

Service Line

Cloud Infrastructure Services