DB2 Database Administrator

Title

DB2 Database Administrator

Estimated Duration 05/01/2017 - 10/27/2017

Location

Salem, OR 97302

Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. May require a bachelor''s degree in a related area and with eight or more years of experience in the field or in a related area. Familiar with expert concepts, practices, and procedures within a particular field. Relies on experience and judgement to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is required.

Minimum of eight years experience as a z/OS DB2 Database Administrator

Other desirable experience is as follows

Strong DB2-z/OS

Working knowledge of DB2 LUW (Linux, Unix, and Windows)

Knowledge of SQL construction and optimization

Knowledge of OMVS, MVS, CICS, JCL, Cobol, Cobol source code migration, compile and bind, REXX, and CLIST utilities in a DB2 Z/OS environment

Experience with database connectivity to DB2 z/OS from SQL-Server, Oracle, Websphere, Cold fusion, Business Objects, DB2-LUW, MS-Access, Toad or others

Web services construction, implementation and migration within a Z/OS environment running CICS and DB2

Familiarity with performance and exception monitoring tools such as CA Detector, Omegamon for DB2, Omegamon for CICS

Experience with IBM DB2 for Z/OS utilities for LOAD, REORG, COPY, RESTORE, UNLOAD, CHECK DATA

Experience and Knowledge of

Methods and procedures for designing, developing, monitoring and maintaining databases

Tools for constructing database structures

Experience determining efficient design of data structures and software applications

AIX security, scripting and monitoring experience

Information systems architecture

Experience identifying scope and managing complexity of projects

Experience in de-identifying data and obfuscation

Experience in source code management

Experience with naming standards

Rodger Martin

RDA

Phone

(636) 812-4000, Ext.

6721