DB2 Admin

Responsibilities

Number of Openings 1 - DB2 Admin Profile ECMS ID in sourcing stage 471478 Assignment Duration 2 Years Total Yrs. of Experience 8 to 10 years Relevant Yrs. of experience 8 years Detailed JD (Roles and Responsibilities) Responsibilities:

Providing technical consulting in the definition, design, and creation of a database environments.

Reviewing project requests and determining rough order of magnitude estimate of time and cost required to accomplish scope.

Administering database organizations, standards, controls, procedures, and documentation.

Maintaining database dictionaries and documents Job Control Language (JCL), SQL, Perl and shell scripts and batch processes.

Requirements

Maintaining database dictionaries and documents Job Control Language (JCL), SQL, Perl and shell scripts and batch processes.

LUW would be a large bonus.

5+ years hands on database administration experience with IBM DB2.

Administering database organizations, standards, controls, procedures, and documentation.

DB2 Experience.

Reviewing project requests and determining rough order of magnitude estimate of time and cost required to accomplish scope.

Providing technical consulting in the definition, design, and creation of a database environments.

Daily manully health check Prod,QA,Dev,F systesms

Daily monitor DB backup jobs

Perform Patching activity

Troubleshoot below issues

Perfomance issues during Daily batch

Data FS above threshold - Reorg/LWH tasks

Memory utilization is high

database locks

Commvault Backup Failure

Log Backup failure

Mandatory skills DB2 Administration, Production Support, willing to work 24*7 Max Vendor Rate in Per Day INR 7000 per day Work Location given in ECMS ID Bangalore/Hyderabad/Pune BG Check (Pre OR post onboarding) Post Is there any working in shifts 2 to 11:30 PM IST, P1/P2 - 24*7

Full time