zOS DBA (Information Systems Analyst II/PSC)

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

Persons with disabilities are provided reasonable accommodations throughout the hiring process and during performance of all job duties. Please email the Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524 - 7514 for further information and to request an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant’s wage or salary history. Employment decisions are not made based on an applicant’s wage or salary history. To that end, please do not include wage or salary information in your resume or other profile or application materials.

Date: May 2, 2022

Location:

Springfield, IL, US, 62762

Job Requisition ID: 13965

Agency: Department of Human Services

Posting ID: 13965-22-022

Opening Date: 05/03/2022
Closing Date/Time:  06/15/2022
Salary:  Anticipated Salary: $25.61 - $58.21 per hour
Job Type:  Hourly Intermittent
County:  Sangamon; Adams; Alexander; Bond; Boone; Brown; Bureau; Calhoun; Carroll; Cass; Champaign; Christian; Clark; Clay; Clinton; Coles; Cook; Crawford; Cumberland; DeKalb; DeWitt; Douglas; DuPage; Edgar; Edwards; Effingham; Fayette; Ford; Franklin; Fulton; Gallatin; Greene; Grundy; Hamilton; Hancock; Hardin; Henderson; Henry; Iroquois; Jackson; Jasper; Jefferson; Jersey; Jo_Daviess; Johnson; Kane; Kankakee; Kendall; Knox; LaSalle; Lake; Lawrence; Lee; Livingston; Logan; Macon; Macoupin; Madison; Marion; Marshall; Mason; Massac; McDonough; McHenry; McLean; Menard; Mercer; Monroe; Montgomery; Morgan; Moultrie; Ogle; Peoria; Perry; Piatt; Pike; Pope; Pulaski; Putnam; Randolph; Richland; Rock_Island; Saline; Schuyler; Scott; Shelby; St._Clair; Stark; Stephenson; Tazewell; Union; Vermilion; Wabash; Warren; Washington; Wayne; White; Whiteside; Will; Williamson; Winnebago; Woodford
Number of Vacancies:  1
Plan/BU:

****A RESUME IS REQUIRED FOR THIS JOB POSTING****

Please attach a DETAILED Resume/Curriculum Vitae (CV), a copy of your transcripts or diploma for all degrees earned, and a copy of any applicable professional licensures to the MY DOCUMENTS section of your application. Please note that the Department of Human Services must verify proof of higher education for any degree earned (if applicable) before any offer can be extended. You WILL NOT be considered for the position if you attach a CMS100, CMS100b or any other document in lieu of a Resume or CV.

Position Overview

Provide IBM Content Manager support, and assisting the DBA's with Db2 z/OS SQL tuning and daily tasks.

Job Responsibilities

1. Provides IBM Content Manager support, performing complex professional and advisory database administration functions. Performs analysis of existing Content Manager software and implementation of databases within the department.

2. Conducts and coordinates DB2 Z/OS SQL tuning and daily tasks. Maintains the IBM DB2 for z/OS relational database software for the department; monitors the day to day operation of the software. Conducts analysis of program applications, databases and system software in order to tune performance, maintains overall performance of the program applications. Confers with manager to verify activities are consistent with department priorities.

3. Reviews and analyzes functional system requirements and compares to end user needs/requests for modifications and feasibility studies. Performs joint application design sessions, develops written recommendations and prepares presentations for management. Writes, debugs, tests and documents new programs or updates existing programs using Relational Database Management Software. Evaluates test results to determine conformance to desired system objectives. Utilizes Relational Database Management Software to conduct database/system software implementation relative to the interface functions between applications and the database/system software..

4. Conducts analyses of data and processes support departmental activities and program; designs or implements data architecture using Erwin and implements with DB2 software. Maintains relational database model which fits the strategic goals of the business and department as related to integrated data architecture. Confers with manager to verity activities are consistent with department priorities.

Minimum Qualifications

1. Knowledge and skill equivalent to four (4) years of college with coursework in computer science.

2. Three (3) or more years of demonstrated experience in IBM Content Manager.

3. Three (3) or more years of demonstrated experience working with z/OS DB2 databases and SQL Tuning.

4. Must have strong analytical skills and good communication skills both orally and in writing.

Work Hours: Mon - Fri, 8:30am - 5:00pm
Work Location: Statewide

Agency Contact: Alexandria.Puccetti@Illinois.gov
Job Function: Technology

About the Agency

The Illinois Department of Human Services serves families in need across Illinois. Our mission is providing equitable access to social services, supports, programs and resources to enhance the lives of all who we serve. We are committed to the core values of Human Dignity, Equity, Community, Urgency, Transparency and Kindness.

Nearest Major Market: Springfield

Apply »