Mainframe DB2 Database Administrator
Reference #663

Contract Position
Posted on 02/6/07
Start: ASAP
Salary: 75.00


Description:

Consultant will work with a team of DBA's to support and provide backup in a Development & Production environment across several DHR projects. Under limited supervision, the mid-level DB2 Mainframe DBA will report to the Manager of the Data Management Group and must be able to install, maintain and monitor multiple DB2 database systems (version 7 and higher), including development, test, training and production database environments.



Has experience with State Government based systems such as Medicaid, DFCS, Child Support, etc.; as well as maximum proficiency with the following:



• Has five plus years experience as a DB2 DBA with OS/390 and/or Z/OS

• Has experience with CLIST/REXX, Change Man, DB2 Connect.

• Is a DB2 Certified DBA.

• Has experience with Disaster and/or Data Recovery Planning and documentation.

• Has experience building or maintaining data warehouse or data marts.

• Has experience developing, documenting and enforcing DBA standards.

• Has experience using DBA tools such as Quest (Spotlight), Embarcadero, ER/Studio, ER/Win.



Required Skills:

The mid-level DB2 DBA (Mainframe) should posses at least three years of experience managing DB2 database systems (Version 7 and up) in a mainframe environment running OS/390 and/or Z/OS as well as possess the following DBA skills:



• 5+ years of (documented) experience as a DB2 DBA with OS/390 and/or Z/OS

• Analyze customer database needs and requirements, implement recommended solutions.

• Assist in developing database security, control procedures, testing, conversion, implementation and documentation.

• Assist with data modeling assignments and provide database related assistance to application developers as needed such as SQL tuning.

• Assist in the analysis of changes to hardware, network, database objects, patches, application, etc.

• Assist in the preparation, creation and review of test plans and data.

• Assist in developing and conducting database presentations and project work plans.

• Perform pro-active database performance monitoring and tuning.

• Utilization of vendor provided DBA tools and utilities such as Computer Associates (Platinum), IBM, Strobe, TMON, Visual Explain, File-Aid DB2, File-Aid RDX, QMF/SPUFI, TSO, etc.

• Working knowledge of CICS, COBOL II, VSAM, and IDCAMS.

• Database support including database backup, recovery, run stats, and re-orgs, etc.

• Develop and deploy SQL scripts, stored procedures, functions in support of application database needs.

• Interact closely and professionally with other team members on various projects or tasks. Be willing to learn and be willing to mentor others.

• Serve as point of contact and responsibility for database and other application vendors when problem escalation is warranted.

• Be willing to rotate on-call support as needed for production systems.

• Have excellent written and verbal communication skills as well as a college degree in engineering, computer science or another related area.

• Three business references as outlined in Other Comments below.



Education:

College Education



Position potential:

Contract to Permanent


Contact



Scott Collins
scottc@suzanpageconsulting.com


APPLY ONLINE RETURN TO POSTINGS