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

Job Title: Database Administrator

Job Requisition ID: 39723

Closing Date: 07/24/2024

Salary: $7,491-$11,015 per month

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

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

Union Position: Yes

Work Authorization: The State of Illinois does not provide sponsorship for employment visa status and cannot accept F1 OPT/CPT. To be considered for permanent employment with the State of Illinois, applicants must be legally authorized to work in the United States without the need for employer sponsorship now or at any time in the future.

 

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 Database Administrator supporting the Department of Human Services (DHS) in conducting analysis of program applications, databases, and system software to tune performance and maintain overall performance of the program applications. 

In this role, you will review and analyze functional system requirements and compare to end user needs/requests for modifications and feasibility studies.  

In addition, you will perform maintenance of complex department-developed software, tests and analyzes the interactions between backend software products such as DB2, AIX and Mainframe, etc.  

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
 

 

Essential Functions

30%    Under administrative direction, serves as a Database Administrator for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Human Services (DHS):

  • Performs complex professional and advisory database administration functions for the IL Department of Innovation & Technology-Department of Human Services (DHS).
  • Maintains the IBM DB2 for z/OS and SQL Server relational database software for DoIT/DHS.
  • Monitors the day-to-day operations of the software.
  • Conducts analysis of program applications, databases, and system software to tune performance and maintain overall performance of the program applications.
  • Confers with manager to verify activities are consistent with department priorities.

 

25%    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.
  • Conducts complex database/systems software implementation as a team member on a state-wide application system.
  • Analyzes and diagnoses system issues and coordinates efforts to resolve.
     

20%    Conducts analyses of data and processes supporting 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.

 

10%    Consults with Data Administration analysts, users, and applications staff regarding system/code modifications:

  • Determines solutions and prepares recommendations and impact statements for project management.
  • Coordinates the implementation of the changes to both enterprise and tactical databases.

 

5%    Performs maintenance of complex department-developed software, tests and analyzes the interactions between backend software products such as DB2, AIX and Mainframe, etc.

 

5%    Keeps abreast of new developments in the Information Technology field:

  • Continues education by attending meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
  • Attends demonstrations and exhibitions related to assigned operations.

 

5%    Performs other duties as assigned or required which are reasonably with the scope of duties enumerated above.
 

Minimum Qualifications

  1. Requires knowledge, skill and mental development equivalent to four (4) years of college with course work in computer science or directly related fields.
  2. Requires three (3) years of professional experience in Application Services or a related Information Technology field.
     

Preferred Qualifications

  1. Three (3) years of professional information technology experience, requires three (3) years’ experience with IBM DB2 for z/OS and SQL Server relational database software, mainframe and midrange platforms, and relational database management systems.
  2. Three (3) years of experience performing maintenance of large and complex department-developed software including testing and documentation.
  3. Extensive experience performing in-depth studies and analysis of client needs and objectives and to determine feasibility of changing current operations, applications and/or automating operations into database systems to improve the effectiveness of these systems.
  4. Developed verbal and written communication skills to present information to others with clarity and precision.
  5. Ability to analyze and diagnose system issues and coordinate efforts to resolve.
  6. Ability to coordinate the activities of teams to achieve desired results.
  7. Ability to maintain satisfactory working relationships with others.
     

Employment Conditions

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. 

 

  1. Requires the ability to verify identity.
  2. Requires employment authorization to accept permanent full-time position with the State of Illinois.
  3. Requires the ability to pass a position specific, agency required background check.
  4. Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone and any other required equipment or devices.
  5. 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.
  6. Requires the ability to lift and carry objects or equipment weighing up to 10 pounds. This is considered sedentary work as defined by the U.S. Department of Labor (20 CFR 404.1567(a)). Sedentary work involves lifting no more than 10 pounds at a time and requires occasional lifting, carrying, walking, and standing.
  7. Requires the ability to travel in performance of duties.
  8. Requires the ability to serve in an on-call capacity.
  9. 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.