You are viewing a preview of this job. Log in or register to view more details about this job.
Email

Job Title: Database Support Analyst

Job Requisition ID: 42449 

Closing Date: 11/27/2024

Salary: $7,491.00 a month

Work Hours: M-F 8:30 - 5:00 PM 

Work Location: (Hybrid) 100 South Grand Ave E, Springfield, Illinois, 62762   OR  401 S. Clinton St. Chicago IL

Union Position: Yes

Work Authorization: US work authorization required. No Sponsorship Available. W2 only, no C2C. Not eligible for OPT/CPT. 

 

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. 

This position serves as a IES (Integrated Eligibility System) Database Support Analyst supporting the Illinois Department of Human Services (IDHS) collaborating with technical support personnel and program administrators to support an extensive array of complex relational databases and end user applications.  In this role, you will plan, analyze, design, and implement complex enterprise-wide relational database structures. 

Analyzes and tunes database structures in consultation with other technical experts. In addition, you will maintain departmental goals of integrated data architecture while striving to improve system performance and optimal use of computer systems. 

If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!

 

As a State of Illinois employee, you receive a comprehensive benefits package including:
•    Competitive Group Insurance benefits including health, life, dental and vision plans.
•    Flexible work schedules (when available and dependent upon position)
•    10 -25 days of paid vacation time annually (10 days for first year of state employment)
•    12 days of paid sick time annually which carryover year to year
•    3 paid personal business days per year
•    13-14 paid holidays per year dependent on election years
•    12 weeks of paid parental leave
•    Pension plan through the State Employees Retirement System
•    Deferred Compensation Program – voluntary supplemental retirement plan
•    Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
•    Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

 

Why Work for Illinois?
Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.

No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.

 

Essential Functions

  • Under administrative direction, serves as a IES Database Support Analyst for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Human Services (IDHS), performing complex professional and advisory functions in the maintenance of the DB2 and SQL Server relational database structures.
  • 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.
  • Coordinates or conducts the implementation of the changes to both enterprise and tactical databases of a critical nature.
  • 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.
  • Keeps abreast of new developments in the Information Technology field by continuing education through meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
  • 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 Application Services or a related Information Technology field.

Preferred Qualifications (In Order of Significance)

  • Three (3) years of professional application experience with DB2 and SQL Server relational database software.
  • Three (3) years of professional application experience planning, analyzing, designing, and implementing relational database structures.
  • Two (2) years of experience conducting feasibility studies for system conversions and enhancements.
  • One (1) year of professional experience developing reports and projections.
  • Working knowledge of mainframe and midrange platforms.
  • Developed verbal and written communication skills to present technical information to others with clarity and precision.
  • Ability to analyze and diagnose system issues and coordinate efforts to resolve.
  • Ability to gain and maintain effective working relationships.

Conditions of Employment

NOTE: Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position. 

  • Requires the ability to verify identity.
  • Requires employment authorization to accept permanent full-time position with the State of Illinois.
  • Requires the ability to pass a position specific, agency required background check.
  • Requires self-disclosure of criminal history.
  • Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone and any other required equipment or devices.
  • Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies or other industry related topics relevant to job duties.
  • Requires the ability to lift and carry objects or equipment weighing up to 20 pounds. This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.
  • Requires the ability to travel in performance of duties.
  • Requires the ability to serve in an on-call capacity.
  • Requires the ability to work overtime including scheduled, unscheduled, short notice, evenings, weekends and holidays.

 

The conditions of employment listed are incorporated and/or related to any duties included in the position description.