Mainframe DB2 DBA

Maven Workforce Pvt. Ltd.
  • Chennai, Noida
  • 10-15 lakh
  • 8-13 years
  • Views
  • 27 Feb 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

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 etc.
Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.

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 etc.
Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.


Competencies/Skill sets for this job

Cics Sql Ims Ivs Synch

Job Posted By

Meenakshi
Key Account Manager

About Organisation

Maven Workforce Pvt. Ltd.