DB2 Database Administrator

Education

Bachelors Degree in Computer Science Information Systems or other related field. Or equivalent work experience.

The candidate must have skill and 15 years combined experience in database administration for the following database platforms:

1. DB2 for z/OS

2. SQL Server 2008R2 2012

2. Oracle 10g and above

This resource will primarily be tasked with performing Database (DB2 SQL Server Oracle GIS) planning and operational activities including but not limited to the following:

1. Daily operational and database administration activities

2. Plan design implement support for database structures

3. Conduct database performance monitoring and tuning

4. Develop and maintain database administration procedures and documentation

5. Perform SQL Code reviews

6. Assist with training/mentoring other technical staff This resource may also be required to perform other database or infrastructure activities as requested

Skills:

Advanced knowledge of DB2 for z/OS application integration performance management and data base administration

Advanced knowledge of upgrading DB2 for z/OS

Advanced knowledge of JCL

In depth knowledge of the z/OS integrated platform

In depth knowledge of CA GEN model management and application object support

In depth knowledge of ISPF

In depth knowledge of the ASG Scheduler

In depth knowledge of COBOL

In depth knowledge of the use and interpretation of DB2 for z/OS database monitoring tools

Solid working knowledge of z/OS started task creation and management

Solid working knowledge of IBI z/OS service support

Solid working knowledge of AFOPER commands

Solid working knowledge of RACF

Solid working knowledge of CICS

Solid working knowledge of IOF

Working knowledge of z/OS EXITs

Working knowledge of Windows Servers

Working knowledge of SSMS SSRS SSIS

Working knowledge of Azure

Required Skills:

COBOLSQL ServerOracle