IT Tech Support & Database Administrator
Job Title: IT Tech Support & Database Administrator
Job Requisition ID: 49816
Closing Date: 09/24/2025
Salary: $7,787 a month
Work Hours: M-F 7:45 AM-4:15 PM
Work Location: (Hybrid) 101 W Jefferson St, Springfield, Illinois, 62702
Union Position: Yes
Work authorization: US work authorization required at time of application. No sponsorship available. Not eligible for F1 OPT/CPT. Positions are W2 only and cannot be converted to a contract position. If you have questions about your work authorization eligibility, please email doit.recruitment@illinois.gov.
Questions? Email doit.recruitment@illinois.gov
Transcripts are required for consideration.
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 an IT Tech Support & Database Administrator supporting the Department of Revenue. In this position you will maintain and support the software tools used for database modeling including Erwin, design development and relational database management systems including SQL Server or DB2, and the supporting software for the products on the Windows platforms.
In addition, you will review and provide technical assistance and advice on database design, application design and SQL statements and queries.
This position also administers, monitors, tunes and maintains the database management systems and databases within the systems.
If you possess these knowledges, skills, abilities and experience, we invite you to apply and join the DoIT Team!
Why Work for Illinois?
Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.
No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.
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 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
• Under administrative direction, serves as an IT Tech Support & Database Administrator for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Revenue (IDOR) performing complex professional and advisory functions in Application Services.
• Reviews and provides technical assistance and advice on database design, application design and SQL statements and queries.
• Administers, monitors, tunes, and maintains the database management systems and databases within the systems.
• Develops and maintains programs, procedures, and scripts to enhance the handling, reconstruction and administration of the database and for modeling.
• Evaluates benefits and impacts of new releases, fixes, or new development products, performs tests and research studies as a prelude to recommendations to facilitate their implementation.
• Coordinates or conducts training and education for various application development groups, regarding the capabilities, utilization, and interaction of these products.
• Keeps abreast of new developments in the information technology field by continuing education through online training platforms, meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
• Performs other duties as required or assigned, which are reasonably within the scope of duties.
Minimum Qualifications
• Requires knowledge, skill, and mental development equivalent to four (4) years college with course work in computer science or directly related fields.
• Requires three (3) years of professional experience in Application Services or a related Information Technology field.
Preferred Qualifications
• Three (3) years of professional experience designing, developing, testing, and implementing information systems, including the installation and configuration of relational database management systems (RDBMS) using SQL Server, as well as proficiency in data modeling using tools like Erwin or similar database modeling software.
• Three (3) years of experience providing technical leadership, consultation, support and training to developers and application programmers in relational database design, SQL optimization, and troubleshooting to achieve project goals.
• Three (3) years of professional technical experience administering, monitoring, and tuning relational database environments, identifying and resolving performance issues, and recommending system optimizations in multi-platform environments including Windows, mainframe, network, and web-based applications. potential problems before they affect performance.
• Three (3) years of experience with data warehouse, data mart, and multi-tenant application database environments, including implementation, maintenance, and optimization techniques.
• Three (3) years of experience using advanced SQL (Structured Query Language) for database management, reporting, troubleshooting, and performance analysis.
• Three (3) years of experience conducting database and application feasibility studies, system conversion planning, or technical environment upgrades, to evaluate options and recommend improvements.
• Ability to manage and troubleshoot database modeling and design tools (Erwin or equivalent), integrating models into live development and production systems.
• Ability to gain and maintain effective working relationships with agency officials, technical staff, vendors, and client stakeholders in a collaborative IT support environment.
• Demonstrated verbal and written communication skills, with the ability to explain technical concepts to non-technical audiences, and prepare clear technical documentation, reports, and recommendations.
• Database administration certification such as Microsoft Certified Solutions Expert (MCSE) or Azure Database Administrator.
Conditions of Employment
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.
• Requires the ability to verify identity.
• Requires employment authorization to accept permanent full-time position with the State of Illinois.
• Requires the ability to pass a tax compliance and position specific, agency required background check.
• Requires self-disclosure of criminal history.
• Requires ability to attend seminars, conferences, and trainings to stay current on methods, tools, ideologies, or other industry related topics relevant to the job duties.
• Requires ability to lift and carry objects weighing up to 20 pounds. This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.
• Requires ability to travel in performance of duties.
• Requires ability to work overtime and serve on an on-call basis.
• Requires ability to work outside of normal business hours to meet deadlines.
The conditions of employment listed are incorporated and/or related to any duties included in the position description.