Home

DB2 DBA with Z/OS

Thousand Oaks, CA. Posted 06-19-17

SWINSOFT INC.
Posted By
Ashima Gupta
Duration
6 Months
Start Date
Immediate
Tech Category
RelationalDatabase - DB2
Pay
Negotiable
Experience
8 - 15 Years
Tech Sub-Category
Administration
Work Permit
Canadian Citizen, US Citizen are encouraged to apply
Tax Terms
N/A

Job Description

DB2 DBA – 100% Onsite project

 

Position Is open in any of these locations :  Mason, OH, Richmond, VA, Wallingford, CT, Atlanta, GA, Thousand Oaks CA

 

DB2 DBA on z/OS (Primary Skill)

Must be a production support DBA

Creating Database objects, Tablespaces, Tables, Views, Indexes etc. and coordinating with application team for design related issues

Experience on following:

IBM DB2 Utilities, Commands

UNLOAD, RELOAD, COPY, RECOVER, REORG & RUNSTATS

DB2 Performance Tuning

Recovery

Tools like File Aid, QMF, SPUFI

Platinum tools

Log Analyzer

Database & Plan Analyzer

RC Tools

Detector

Subsystem Analyzer

 

Good exposure on mainframe skills like JCL, VSAM

Experience on DB2 Upgrades

Database monitoring, health check, housekeeping

Knowledge/experience with DR (Disaster Recovery) drill

Able to perform routine task like load/import/export

Understands db2 migration/upgradation concepts

Check diaglog for any issues

Database upgrades, Fix pack patches and maintenance

Db2 migration/upgradation

perform routine task like load/import/export

Database performance and overall server health check and monitoring

Database backup & recovery

Disaster Recovery

Provide support to application team

 

 

Key Skills
db2 ibm db2 z/os production support vsam jcl disaster recovery qmf performance tuning drill mainframe

Similar Jobs

Similar jobs will be listed here