DB2 DBA Programmer

Job title :- DB2 System programmer Admin

Location :- Mississauga, ON (Remote )

Need L3 Level of candidate 12+ year experience

JD :-

·        Upgrade/Migrate DB2 Versions to newer versions

·        Regularly applying PTFS/APARS if required.

·        Manage DB2 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, DSNJU004, DSNJU003 etc.

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

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

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

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

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

·        Implement DBDC (CICS, DB2, 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

·        DB2 recycle

·        DB2 Image copy (full/incremental)

·        Database creation

·        Grant/revoke of authorities

·        DB2 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