Mainframe DB2-DBA

Mainframe DB2-DBA

Oloop Technology Solutions Private Limited
3-8 years
Not Specified

Job Description


Job Description :
Overview
Skill- Mainframe DB2-DBA
Location -Mumbai.
Nature of hiring- C2H.
Initial contract- 6 months
Job Description:
Mainframe DB2 DBA
1. Creating New Databases and related objects such as Tablespaces, Tables, Indices, Aliases, Stored procedures, etc.
2. Managing accesses through Grants and Revokes.
3. Taking regular backups by scheduling Imagecopy jobs.
4. Planning and Participating in Disaster Recovery Tests.
5. Hands-on experience in troubleshooting Production DB2 Issues.
6. Database design and object creation such as table, tablespaces, view, synonym, index, stored procedure, alias etc.
7. Alteration of table schema like adding/ deleting columns
8. Resolve DB2 database performance tuning issues, support database security issues such as grants and revokes
9. Performed data maintenance using LOAD, UNLOAD, REORG, RUNSTATS
10. Well versed with Data Refresh activities and various Point in Time DB2 recoveries
11. Efficiently carried out DBA responsibilities in planning DB2 version migration
12. Monitored and managed DB2 thread and locking issues
13. Involved in granting various authorizations and privileges to different users
14. Proactively monitored and performed daily maintenance activities
15. Provided 24*7 support on rotation basis
16. Should have work experience on DB2 database administration with skills on BMC, Change man, CA insight, Strobe tools experience.
17. Skill set:
zOS DB2 DBA, JCL, BMC DB tools, CA Monitoring tool, Script like Rexx

Similar Jobs

People Also Considered

Career Advice to Find Better