DB2 Database Administrator

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

OLAP
INFORMATICA
DATABASE DESIGN
INFOSPHERE
Data Studio
DB2 Query Monitor

Job Details

Job Title: DB2 Database Administrator

Experience: 10 years

Location: Harrisburg, PA (Hybrid)

Duration: 12 months Contract



Job Description:

Design and maintain DB2 Database applications which have the following characteristics:

Design for high availability.

Design for maximum performance.

Maintain and develop techniques and procedures to provide 24x7 availability.

Provide production and test database support in a complex environment.

Perform all functions which are performed by a DB2 Database Administrator, such as:

SQL code reviews.

Performance Monitoring and Tuning DB2 at the application database level.

Enforce appropriate DB2 security standards.

Collaborate with the DB2 systems programming staff to appropriately manage DSNZPARM settings.

Create, manage and support DB2 Stored Procedures, DB2 Triggers, and DB2 Referential Integrity.

Create Change Requests, Resolve Service Requests, Provide 24x7 On call support.

Provide DB2 Connect configuration access support for individual users and distributed systems.

Coordinate with team members on technical decisions and directions.

Work with Management to develop project schedules.

Provide Database performance and tuning which typically involves collaboration between Data Center, Technical Operations, Database Design and Administration, and the various software development areas.

Responsible for the evaluation and creation of appropriate backup and recovery strategies for new database requirements.

Participate in Disaster Recovery planning.



Qualifications

Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following:

z/OS DB2 12 for zOS or higher in a production environment with high transaction rates

High availability 24x7 designs and techniques

Managing large data stores

DB2 V10 utilities setup and execution

DB2 performance and tuning

Data Modeling expertise logical and physical design

Complex SQL coding / tuning

Data Warehouse design with an understanding of OLAP design and query solutions

DB2 attachments/interfaces include DRDA, DB2Connect

DB2 tools skill set will include, but is not limited to the following:

IBM Data Studio

IBM DB2 Administration Tool

IBM DB2 Automation Tool

IBM DB2 Explain

IBM DB2 Query Monitor

IBM OPTIM Workload Query Tuner

IBM File Manager

IBM Tivoli OMEGAMON

QMF

z/OS Mainframe skills, but not limited to the following:

TSO and ISPF

JCL

DFSORT and /or ICETOOL

REXX

z/OS Utilities



Additional Desired Skills:

Problem solving and analytical skills

Ability to organize and prioritize workflow and projects

Excellent written and oral communication skills

DB2 V9 or V10 Certification preferred

IMS Database experience

IMS Database Utilities (IBM, BMC, NEON, etc.)

ETL tools experience (Infosphere, Informatica, etc.)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.