Mainframe DB2 System Programmer

Mainframe DB2 System Programmer

Oloop Technology Solutions Private Limited
Mumbai India
3 - 8 Years
Not Specified

Job Description


Job Description :
Overview
Skill- Mainframe DB2 System Programmer
Location -Mumbai.
Nature of hiring- C2H.
Initial contract- 6 months
Job Description:
Mainframe DB2 System Programmer
1. Installation of new software products versions,releases related to DB2
2. Install New DB2 subsystems
3. Tune DSNZPARM and other DB2 parameters
4. Execute Utilities
5. Analyse abend reports
6. Providing permanent resolution for the issue
7. Analyze exceptions
8. Provide tuning support
9. Support DB2 Related product upgrades
10. Disaster recovery planning and testing from DB2 Side.
11. Provide 24x7 Oncall support for Incident Management on rota basis.
12. Plan for infrastructure and operational changes such as DB2 subsystem version upgrades and customization
13. Troubleshooting the most complex activities such as reading system and application dumps and providing recommendations and performing resolution activities
14. Collaborate with other team such as ( MVS, RACF, STORAGE, Automation, Network ( HNS ), Performance and Capacity Management, Application DBA, application users and vendors to provide guidance and manage project implementation
15. Repair and recover from hardware or software failures
16. System level performance tuning like buffer pool, EDM pool, DSNZPARM’s and other system/application related changes etc..
and skills required would be these..
a) Knowledge of DB2 Tools such as SPUFI,QMF, Platinum and BMC usage
b) Knowledge of DB2 Online/Offline Utilities such as Copy, Reorg, Load and Unload
c) Knowledge of DBADM and SYSADM authority
d) Knowledge of adding volumes to Stogroup
e) Knowledge of DB2 Controlling parameters
f) Knolwedge of RDBMS Database concepts Database,Tablespace,Table and others
g) Knowledge of Database types in DB2, Catalog and Directory, Storage and Types, Isolation levels
h) Knowledge of DB2 and Tools version upgrade and maintenance
i) Knowledge of Altering Bufferpool, Start and STOP, Backup and Restore process
j) Knowledge of DB2 Stored Procedures, DB2 Performance monitor, DB2 Traces, DB2 Cpu utililzation, DB2 Recovery to PIT and Query Tuning

Similar Jobs

People Also Considered

Career Advice to Find Better