Job ID :
4613
Company :
State of Arkansas
Location :
LITTLE ROCK, AR
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
10 Feb 2014
Job Seekers, Please send resumes to resumes@hireitpeople.com

 

Short Description:

The Database Administrator will be primarily responsible for the maintenance, enhancement and performance tuning of z/OS DB2 databases as well as VSAM files, JCL, and TSO.  The DBA will also work as part of a team to provide DB2 DBMS subsystem management

 

Complete Description:

Local candidates preferred, but not required.

 

In addition, this person will be required to provide after hours support, 24 x 7 on a rotating basis.

 

While z/OS support will be the primary responsibility of the Database Administrator, providing maintenance, enhancement and operational support to additional DBMSs will be required. 

 

Qualifications:

Bachelors Degree in Computer Science or related technical field

In-depth z/OS DB2 Database Administration (V9) experience (3+ years). 

Solid experience with VSAM files, JCL, and TSO.

DBA certifications a plus.

Database Administration experience with DB2 UBD on LUW, CA tools and REX will be a plus.

 

 

Responsibilities:

•Database administration, implementation, and maintenance tasks including but not limited to:

­                 -Enforcing database naming/creation/deletion standards in the Test and Production environments

­                 -Establish, oversee, and optimize all database maintenance (i.e. update statistics, etc) and backup processes

­                 -Enforce and implement appropriate security measures

•Troubleshoot application database issues

•Ensure the 24/7 availability and performance of the databases that support our systems, including "on-call" responsibilities

•Optimize the hardware/system resources allocated to the databases for high availability & minimum downtime

•Provide assistance to developers in DBMS performance tuning, best practices and problem resolution.

•Resolve database performance issues, database capacity issues, and other data issues

•Manage backup and recovery of databases

•Prepare, maintain and execute disaster recovery plans

•Monitor databases for errors and perform problem determination when necessary

 

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

z/OS DB2 Database Administration

Required

3

Years

VSAM, JCL, TSO

Required

3

Years

DB2 UBD on LUW

Highly desired

 

 

CA Tools, REX

Highly desired

 

 

Certifications

Required