DB2 DBA for IBM z/OS Mainframe

IBM Mainframe DB2 Systems DBA

We are looking for an experienced IBM Mainframe DB2 Systems DBA for the United States Senate, Office of the Sergeant at Arms (SAA).  The successful applicant will work as a member of a team supporting DB2 Version 9 in an IBM zSeries, z/OS, and TSO/ISPF enterprise environment.

This is a contract role and the best candidate will be assigned to the SAA for a six-month+ contract, starting as soon as our client has interviewed, approved the candidate and all the necessary paperwork is completed.  Candidates will be interviewed by the DBA manager and members of the DB2 support team.  Interviews will be technical in nature, with situational and personality assessments made to ensure the best fit with the organization's culture and the candidate's potential colleagues.

There is a possibility for contract extension for candidates who perform per client expectations and fit in well with the culture of this historical organization.  You will work in their downtown Washington, D.C. offices, Monday through Friday, and be available on-call as needed to provide the appropriate levels of support.

Your responsibilities will include:

Provide database and operating system level troubleshooting support in a z/OS operating environment.
Enforce database naming/creation/deletion standards in the Test and Production environments.
Establish, maintain and optimize all database maintenance and backup processes.
Analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity.
Provide recommendations and strategies to developers on how to improve performance and scalability of their database components and assist in problem resolution.
Utilizing IBM JCL, TSO/ISPF, DB2 Utilities and IBM DB2 Tools products to administer several DB2 subsystems on different Mainframe LPARS.
Provide architectural guidance on strategies to improve operations and monitoring of current and future implementations.
Implement and maintain security, backup and disaster recovery strategies.

Requirements: Minimum of a B.S. degree, plus 7 years of DB2 system database administration experience or equivalent combination of education and experience.

Minimum of 4 years of experience in:

DB2 Version 8/9 system administration
Performing administrative functions on a z/OS platform
Performing DB2 implementations on a z/OS platform
Implementing and managing DB2 high-availability technologies
Utilizing DB2 SQL and a strong knowledge of VSAM file structure and utilities
Strong Mainframe DB2 administration skills with experience in IBM JCL, DB2 Utilities and IBM DB2 Tools
Ability to design and maintain DB2 Stored Procedures, triggers and automated scripts

Desired (Additional) Skills:

Experience working with SMP/e
CICS
DB2 LUW experience
DB2 Connect experience
Experience utilizing IBM's Query Workload Tuner
Experience with IBM's DB2 Admin tool & DB2 Automation tool