at Illinois Department of Innovation & Technology in Chicago, Illinois, United States
Job Description
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.