Job Description
Location
Noida, Uttar Pradesh
Benefits
Pulled from the full job description
Paid time off
Provident Fund
Full job description
JOB TITLE: DB2 DBA
LOCATION: Noida
SKILL: DB2 DBA
WORK TIMING: Rotational Shifts
JOB DESCRIPTION
A. Database Object Creation and Maintenance:
1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc.
2. Knowledge and expertise on DB2 utility execution.
B. Data load and migration:
1. Knowledge and understanding of data migration process from VSAM to DB2.
2. Unload data from DB2 tables using UNLOAD utility.
3. Load data from files to Tables using LOAD utility.
4. Unload data from Image copy using UNLOAD or other utilities.
5. Migrate data from one environment to another.
C. Database backup and Recovery:
1. Setup and maintain Image Copy and other DB2 housekeeping jobs.
2. Able to recover data from Image Copy using RECOVER utility.
D. Database access and security control:
1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects.
2. Understand and provide Group level access on DB2 objects to RACF user groups.
E. Support to Application team:
1. Monitor and troubleshoot batch job failures.
2. Handle and resolve all DB2 package related consistency token issues.
3. Assist application team to resolve performance issues for the SQLs and/or Stored procedures.
F. Performance monitoring and tuning:
1. Monitor current active and historical threads using DB2 monitoring tool.
2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them.
3. Check overall Mainframe CPU utilization using SYSVIEW online panels.
4. SQL tuning by rewriting the SQLs or designing appropriate indexes.
Job Type: Full-time
Pay: ₹811,840.25 - ₹2,05+,28+.75 per year
Benefits:
Paid time off
Provident Fund
Schedule:
Day shift
Monday to Friday
Supplemental Pay:
Yearly bonus
Work Location: In person
Noida, Uttar Pradesh
Benefits
Pulled from the full job description
Paid time off
Provident Fund
Full job description
JOB TITLE: DB2 DBA
LOCATION: Noida
SKILL: DB2 DBA
WORK TIMING: Rotational Shifts
JOB DESCRIPTION
A. Database Object Creation and Maintenance:
1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc.
2. Knowledge and expertise on DB2 utility execution.
B. Data load and migration:
1. Knowledge and understanding of data migration process from VSAM to DB2.
2. Unload data from DB2 tables using UNLOAD utility.
3. Load data from files to Tables using LOAD utility.
4. Unload data from Image copy using UNLOAD or other utilities.
5. Migrate data from one environment to another.
C. Database backup and Recovery:
1. Setup and maintain Image Copy and other DB2 housekeeping jobs.
2. Able to recover data from Image Copy using RECOVER utility.
D. Database access and security control:
1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects.
2. Understand and provide Group level access on DB2 objects to RACF user groups.
E. Support to Application team:
1. Monitor and troubleshoot batch job failures.
2. Handle and resolve all DB2 package related consistency token issues.
3. Assist application team to resolve performance issues for the SQLs and/or Stored procedures.
F. Performance monitoring and tuning:
1. Monitor current active and historical threads using DB2 monitoring tool.
2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them.
3. Check overall Mainframe CPU utilization using SYSVIEW online panels.
4. SQL tuning by rewriting the SQLs or designing appropriate indexes.
Job Type: Full-time
Pay: ₹811,840.25 - ₹2,05+,28+.75 per year
Benefits:
Paid time off
Provident Fund
Schedule:
Day shift
Monday to Friday
Supplemental Pay:
Yearly bonus
Work Location: In person
💡 Quick Summary
Seeking a career-building opportunity? The DB2 Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in Noida offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
