Mainframe DB2 System programmer Admin

Job title : - Mainframe DB System programmer Admin

Location : - Mississauga, ON (Remote )

JD : -

Upgrade / Migrate DB Versions to newer versions

Regularly applying PTFS / APARS if required.

Manage DB IVS Products and upgrade to supported versions if required.

Managing system catalogs

Manage application data and database environments, performing reorganizations when required to optimize performance

Offline utilities - DSNJLOGF, DSNJU, DSNJU etc.

Database and related object security manage user ids, rights and privileges

DB administration on z / OS, SQL creation, DB command line creation and execution, DB performance tuning,

Physical database definition (DDL) and understanding of logical database design

Implement DBDC (CICS, DB, or IMS) base software installs and upgrades

Implement DBDC (CICS, DB, or IMS) related product installs and upgrades

Implement DBDC (CICS, DB, or IMS) security compliance corrections

Monitoring threads, table space and index spaces.

Monitoring instances for events and resolution / escalations

Performance tuning Database and SQL tuning

DB recycle

DB Image copy (full / incremental)

Database creation

Grant / revoke of authorities

DB archive logs

Having experience of DR setup through various synch methods

Build and maintenance of database and related objects like table space, tables, indexes, views, triggers

Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc

Thanks and Regards

Saurabh Srivastava

Account Manager