DB2 DB Admin
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.
Salary Range -$100,000-$125,000 a year