zOS DBA (Information Systems Analyst II/PSC)
Springfield, IL, US, 62762
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