Job Description

• Stored Procedures monitoring ,movement(Dbasys) and error handling .
• performance monitoring.
• Performance Tuning.
• SQL performance tuning, moving sql codes with proper access path, tuning the bad performing query.
• Monitoring of Daily/ weekly tablespace image copy list, catalog tablespace image copy .
• Monitoring of Daily/ weekly Image copy job list, JCL lib.
• Index recovery from image copy .
• Monitoring of Daily/ weekly reorg, runstats job list, proc lib.
• Other database maintenance, house keeping ,monitoring jobs .
• Refresh Tables/Data.
• Provide support to application for various SQL errors.
• SOX password activity and involvement in bridge call .
• Change Handling & process (SNOW) for DB environment .
• Work on system stability and system improvement plan.

• DB2 objects creation (Tables, tablespace,Columns, database, index).
• DB2 objects alteration.
• Data Handling.
• Plan/ package migration , Rebinds.
• Plan, package linking in Dbasys.
• WLM movement.