This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/12567513

This position serves as the Senior Technical Database Administrator supporting the Illinois Department of Public Health (IDPH). In this role, you will provide technical guidance and assistance to application development project teams and management in the highly technical area of database design, implementation, and maintenance. In addition, you will provide support to leading edge multi-tier applications and systems critical to the Agency.

Essential Functions

• Subject to management approval, serves as the Senior Technical Database Administrator for the Department of Innovation & Technology (DoIT), supporting the Illinois Department of Public Health (IDPH) creating and maintaining procedures for database design, backup, recovery, integrity, and security for the Office of Health Protection (OHP).
• Provides support to application developers by participating in system design reviews and providing detailed recommendations on the database design and modifications pertaining to new system requirements.
• Assists project managers in the development of system project plans, including the installation of OHP databases and system related tasks.
• Monitors all Office of Health Protection production systems and databases to ensure systems are running optimally and efficiently by the utilization of database monitoring tools to interpret when databases and systems are in critical status.
• Writes and maintains complex SQL scripts used to support infrastructure of business objects.
• Reviews, conducts, and coordinates feasibility studies to determine user needs and requirements for computer applications.
• Reviews, analyzes, and evaluates computer systems to determine adherence to department standards by verifying databases and systems to best utilize current technologies.
• Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.