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: 39716

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 verifying the development and completion of all required forms, documentation, and procedures confirming implementation and production systems.  

In this position, you will prepare user guidelines, operational manuals, and systems documentation.  In addition, you will review and analyze system requirements, feasibility studies, joint application design sessions, development of written recommendations and presentations on issues for management.  

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

20% 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).
  • Serves as project leader for specific systems and tasks.
  • Coordinates the workload of less experienced staff.
  • Verifies the development and completion of all required forms, documentation, and procedures confirming implementation and production of the systems.
  • Prepares user guidelines, operational manuals, and systems documentation.


20% Reviews and analyzes system requirements, feasibility studies, joint application design sessions, development of written recommendations and preparing presentations on issues for management:   

  • Evaluates test results to determine conformance to desired system objectives.
  • Evaluates and diagnoses database/systems issues and coordinates efforts to resolve.
  • Conducts large complex database/systems software tuning and performance to maintain and/or improve overall performance of the program applications.
  • Confers with manager to verify activities are consistent with department priorities.


15% Coordinates the activities of the DoIT/DHS program databases, including, but not limited to DB2 on AIX and SQL server:  

  • Conducts complex analyses of program applications, database/system software tuning and performance to maintain and/or improve overall performance of the program applications.
  • Confers with manager to verify activities are consistent with department priorities. 
     

15% Consults with user and staff regarding system code modifications:  

  • Assists in determining solutions to problems and prepares recommendations and impact statements for project management.
  • Coordinates the implementation of the changes.
  • Utilizes Relational Database Management Software to conduct database/system software implementation activities related to the interface functions between applications and the database/system software.


10% Conducts analysis of data and processes supporting departmental activities and program: 

  • Designs or implements data architecture using data modeling software and implements that design with DB2 software.
  • Utilizes Data Replication Center Software to maintain the relational database model which fits the strategic goals of the business and department as related to an integrated data architecture.


5% Performs extensive maintenance of large and complex department-developed software in the most efficient operating environment possible: 

  • Tests and analyzes the interactions between backend software products such as DB2 and ADC.
  • Writes, debugs, tests and documents new programs or updates existing programs using Relational Database Management Software.


5% Prepares written and or graphical reports depicting the development progress as requested by DoIT/DHS management. 


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 required or assigned which are reasonably within the scope of duties enumerated above.

 

Minimum Qualifications

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

Preferred Qualifications

  1. Three (3) years of experience performing database administration utilizing DB2 on AIX 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 (with overnight stays, only if applicable).
  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.