Senior Technical Database Administrator (Public Service Administrator, Option 3)

Full-time - Senior

Springfield, IL

1,001-5,000 employees

Executive, Legislative, and Other General Government Support

About the position

The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates for the position of Senior Technical Database Administrator supporting the Illinois Department of Public Health (IDPH). This role involves providing technical guidance and assistance to application development project teams and management in the areas of database design, implementation, and maintenance. The Senior Technical Database Administrator will support leading edge multi-tier applications and systems critical to the Agency. Responsibilities include creating and maintaining procedures for database design, backup, recovery, integrity, and security for the Office of Health Protection (OHP), as well as monitoring production systems and databases to ensure optimal performance.

Responsibilities

• Serve as the Senior Technical Database Administrator for the Department of Innovation & Technology (DoIT), supporting the Illinois Department of Public Health (IDPH).
• Create and maintain procedures for database design, backup, recovery, integrity, and security for the Office of Health Protection (OHP).
• Provide support to application developers by participating in system design reviews and providing recommendations on database design and modifications.
• Assist project managers in the development of system project plans, including the installation of OHP databases.
• Monitor all Office of Health Protection production systems and databases to ensure optimal performance.
• Write and maintain complex SQL scripts to support infrastructure of business objects.
• Conduct feasibility studies to determine user needs and requirements for computer applications.
• Review and analyze computer systems to ensure adherence to department standards.

Requirements

• Knowledge equivalent to four (4) years of college with coursework in management information systems, data processing, telecommunications, or a related field.
• Prior experience equivalent to three (3) years of progressively responsible administrative experience in management information systems, data processing, or telecommunications.

Nice-to-haves

• Three (3) years of professional database administration experience including installation, configuration, and maintenance of SQL Server databases.
• Three (3) years of professional experience utilizing SQL Server tools (e.g., SQL Server Management Studio, Profiler).
• Three (3) years of professional IT experience demonstrating technical proficiency in analysis, design, and system development.
• Three (3) years of professional experience utilizing T-SQL and PowerShell to automate administrative tasks.
• Working knowledge of SQL application development, including writing scripts for database conversions and optimizing database performance.
• Working knowledge of JAVA J2E_E programming.
• Ability to analyze administrative problems and adopt effective courses of action.
• Demonstrated verbal and written communication skills.

Benefits

• 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.
• 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.
• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility.