Apply »

zOS DBA (Information Systems Analyst II/Personal Service Contract)

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

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded under My Documents → Additional Documents section for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss 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 17, 2023
Location: 

Springfield, IL, US, 62762

Job Requisition ID:  27209

Agency:  Department of Human Services 

Posting ID: 10-28-27209

Opening Date: 06/05/23
Closing Date/Time:  07/03/2023 
Salary:  Anticipated Salary: $25.61 - $60.51 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:  Personal Service Contract

 

****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 that is not 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. Five (5) or more years of demonstrated experience in IBM Content Manager.

3. Five (5) 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:  DHS.HiringUnit@Illinois.gov
Job Family: Science, Technology, Engineering & Mathematics; Social Services 

 

 

About the Agency

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation, and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds, life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation.

 

The main form of communication will be through email. Please check your “junk mail”, “spam”, or “other” folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:

  • donotreply@SIL-P1.ns2cloud.com
  • systems@SIL-P1.ns2cloud.com


Nearest Major Market: Springfield

Apply »