Agency : Department of Human Services
Opening Date: 8/18/23
Closing Date/Time: 08/31/2023
Salary: Anticipated Salary: $6,543 – $9,936 per month ($78,516 – $119,232 per year)
Job Type: Salaried Full Time
County: Sangamon; Champaign; Coles; Cook; DeKalb; DuPage; Jackson; Madison; McLean; Rock Island; St. Clair; Winnebago
Number of Vacancies: 3
Plan/BU: RC063
This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.
All applicants who want to be considered for this position MUST apply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.
While not required, a Resume/Curriculum Vitae (CV) is recommended. When applicable, titles that require specific coursework, professional license or certification will include a notation requesting the appropriate document(s) be uploaded in the Additional Documents section of your application. Failure to upload requested transcripts, license and/or proof of certification when specified may result in ineligibility. Please note that the Department of Human Services must verify proof of higher education for any degree earned (if applicable) regardless of vacancy title before any offer can be extended.
Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.
Posting Identification Number 28-32-27818
Position Overview
Under administrative direction in the Technical Support Services Unit, performs complex professional and advisory functions. Collaborates with technical support personnel and program administrators to support an extensive array of complex relational databases and end user applications. Plans, analyzes, designs, and implements complex enterprise-wide relational database structures. Analyzes and tunes database structures in consultation with other technical experts. Maintains departmental goals of integrated data architecture while striving to improve system performance and optimal use of computer systems. Travels in performance of duties.
Job Responsibilities
- Performs complex professional and advisory functions.
- Collaborates with technical support personnel and program administrators to support an extensive array of complex relational databases and end user applications.
- Plans, analyzes, designs, and implements complex enterprise-wide relational database structures.
- Analyzes and tunes database structures in consultation with other technical experts.
- Consults with users and staff regarding system/code modifications.
- Maintains departmental goals of integrated data architecture while striving to improve system performance and optimal use of computer systems.
- Provides database software consultation services to agency developers of large complex computer systems.
- Performs other duties as assigned or required which are reasonably within the scope of duties enumerated above.
Minimum Qualifications
- Requires knowledge, skill and mental development equivalent to four (4) years of college with course work in computer science or directly related fields.
- Requires three (3) years of professional experience in a related Information Technology field.
Specialized Skills:
- Requires three (3) years of professional experience with DB2 and SQL Server relational database software.
Preferred Qualifications
- Three (3) years of professional experience with DB2 and SQL Server relational database software.
- Working knowledge of mainframe and midrange platforms.
- Developed oral and written communication skills to present technical information to others with clarity and precision.
Conditions of Employment
- Requires ability to travel.
- Requires ability to serve on-call.
- Requires ability to work outside of normal business hours.
- Requires ability to keep abreast of new developments in the Information Technology field.
- Requires ability to pass a name-based background check.
*The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description.
Work Hours: 8:30am – 5:00pm Monday-Friday
IES/Technical (SQL)
Work Location: 100 South Grand Ave E Springfield, IL 62762
Health & Human Services/DHS
Integrated Eligibility Systems
Technical Support Services
100 S. Grand Avenue East, Springfield, IL
401 S. Clinton, Chicago, IL
1717 Park Street, Naperville, IL
705 N. Country Fair Drive, Champaign, IL
608 W. St Louis, East Alton, IL
225 N. 9th St., East St Louis, IL
342 North St., Murphysboro, IL
501 W. Washington, Bloomington, IL
171 Ex. Parkway, Rockford, IL
1629 Afton Rd., Sycamore, IL
1550 Douglas St., Charleston, IL
3561 60th St., Moline, IL
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
This position DOES contain “Specialized Skills” (as that term is used in CBAs).
As a State of Illinois Employee, you will receive a robust benefit package that includes the following:
• A Pension Program
• Competitive Group Insurance Benefits including Health, Life, Dental and Vision Insurance
• 3 Paid Personal Business Days annually
• 12 Paid Sick Days annually (Sick days carry over from year to year)
• 10-25 Days of Paid Vacation time annually – (10 days in year one of employment)
* Personal, Sick, & Vacation rates modified for 12-hour Work Schedules (as applicable)
• 13 Paid Holidays annually, 14 on even numbered years
• Flexible Work Schedules (when available dependent upon position)
• 10 Weeks Paid Maternity/Paternity Leave
• Deferred Compensation Program – A supplemental retirement plan
• Optional Pre-Tax Programs such as Medical Care Assistance Plan (MCAP), Dependent Care Assistance Plan (DCAP)
• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility
• 5% Salary Differential for Bilingual Positions
• Commuter Savings Program (Chicago only)
For more information about our benefits please follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx
APPLICATION INSTRUCTIONS
Use the “Apply” button at the top right or bottom right of this posting to begin the application process.
If you are not already signed in, you will be prompted to do so.
State employees should sign in to the career portal for State of Illinois employees – a link is available at the top left of the Illinois.jobs2web.com homepage in the blue ribbon.
Non-State employees should log in on the using the “View Profile” link in the top right of the Illinois.jobs2web.com homepage in the blue ribbon. If you have never before signed in, you will be prompted to create an account.
If you have questions about how to apply, please see the following resources:
State employees: Log in to the career portal for State employees and review the Internal Candidate Application Job Aid
Non-State employees: on Illinois.jobs2web.com – click “Application Procedures” in the footer of every page of the website.
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