Database Administration Analyst; Information Systems Analyst II, Option

Position Summary

This position serves as a Database Administration Analyst for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Revenue (IDoR). The analyst monitors performance and use of databases and database designs for application systems implemented at IDOR, performs analysis and tuning recommendations for improved performance, and supports complex functional and technical activities for the production information system.

• Under administrative direction, serves as a Database Administration Analyst for DoIT supporting IDoR, performing complex and advisory functions for the Gentax application systems.
• Independently performs complex functional and technical activities supporting the production information system and makes complex systems modification design changes.
• Monitors the performance and use of database and database designs for the application systems implemented at IDOR and performs analysis and tuning recommendations for improved performance.
• Conducts technical studies to evaluate and optimize system performance, establishing criteria for information system requirements.
• Keeps abreast of new developments in information technology through continuing education and professional development activities to remain current on products, vendors, techniques, and procedures.
• Performs other duties as required or assigned which are reasonably within the scope of duties enumerated above.

• Four (4) years of college coursework in computer science or a related field.
• Three (3) years of professional experience in Application Services or a related Information Technology field.

• Three (3) years of experience designing, implementing, and administering SQL Server relational databases within Windows Server environments, including SQL Server Agent client/server architecture and performance tuning to support complex information systems.
• Three (3) years of experience developing and automating administrative tasks using Power Shell scripting, with ability to interpret and apply Active Directory security models and manage NTFS permissions.
• Three (3) years of experience configuring, maintaining, and supporting Gentax systems, including troubleshooting and implementing system modifications.

• Experience as described in Specialized Skills.
• Sound judgment in defining, evaluating, and resolving complex technical and operational problems.
• Establishes and maintains effective working relationships with agency officials, technical teams, vendors, and stakeholders.
• Ability to interpret data, identify root causes, and develop solutions for operational or procedural changes within production and test environments.
• Strong verbal and written communication skills to present technical concepts, system designs, and performance recommendations to technical and non‑technical audiences.

• Verify identity.
• Employment authorization to accept permanent full‑time position with the State of Illinois.
• Pass a tax compliance and position‑specific background check.
• Self‑disclosure of criminal history.
• Use agency‑supplied equipment such as laptop, personal computer, cell phone.
• Attend seminars, conferences, and training to stay current on methods, tools, and industry topics relevant to job duties.
• Lift and carry objects or equipment weighing up to 20 pounds.
• Serve in an on‑call capacity.
• Work overtime including scheduled, unscheduled, short‑notice, evenings, weekends, and holidays.

Work Hours:

Monday‑Friday 7:45 am–4:15 pm (hours may vary). Headquarter

Location:

101 W Jefferson St, Springfield, Illinois, 62702. Work County:
Sangamon.

All applicants must apply electronically through the website. State of Illinois employees should click the link near the top left to apply through the Success Factors employee portal. Applications submitted via email or paper will not be considered. Proof of educational coursework is required.

Agency Contact:
Madison Beyer
Email: madison.beyer
Posting Group:
Science, Technology, Engineering & Mathematics

• d