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