Database Administrator (Information Systems Analyst II, Option S)
Springfield, IL, US, 62701
Agency: Department of Innovation and Technology
Class Title: INFORMATION SYSTEMS ANALYST II - 21166
Skill Option: System Services - Information Technology
Bilingual Option: None
Posting Date: 03/25/2025
Closing Date/Time: 04/07/2025
Salary: Anticipated Starting Pay $7,491 per month, Full Range $7,491 - $11,015 per month
Job Type: Salaried
Category: Full Time
County: Sangamon
Number of Vacancies: 1
Plan/BU: RC063
This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.
All applicants who want to be considered for this position MUST apply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.
Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.
PROOF OF EDUCATIONAL COURSEWORK IS REQUIRED. ACCEPTABLE PROOF OF COURSEWORK INCLUDES UNOFFICIAL TRANSCRIPTS, COPIES OF OFFICIAL TRANSCRIPTS, ACCOUNT RECORDS (INCLUDING SCREENSHOTS) OF ACADEMIC COURSEWORK, AND ANY SIMILAR DOCUMENTS CREATED BY AN ACADEMIC INSTITUTION. Answer all questions thoroughly – Do Not State ‘See Resume’
Identification Number 45901
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 a Database Administrator for the Department of Innovation and Technology (DoIT), supporting the Department of Children & Family Services (DCFS) performing complex professional and advisory and advisory functions in Systems Services. In this role, you will provide technical consultation on software, utilities, and hardware products used for large-scale computer systems in the development of databases and computer applications. In addition, you will develop, support, and resolve the more difficult, complex report issues. Additionally, you will develop and implement complex, detailed database maintenance plans encompassing integrity checks and updating statistics. If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!
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 paid 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
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.
Essential Functions
- Under administrative direction, serves as a Database Administrator for the Department of Innovation and Technology (DoIT), supporting the Department of Children & Family Services (DCFS), performing complex professional and advisory functions in Systems Services.
- Develops, supports, and resolves the more difficult, complex reports issues, and recreates reports utilizing Crystal Reports and SQL reporting tools.
- Provides input into large scale database design reviews during the application development process for complex computer systems.
- Schedules and manages difficult and complex jobs for data transfers and procedures by the utilization of database tools for monitoring performance and impact on normal operations.
- Analyzes long-term database performance trends to optimize database performance by reviewing, installing, and configuring DBMS software and application service packs and/or patches.
- Keeps abreast of new developments in the information technology field by continuing education through 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 the duties enumerated above.
Minimum Qualifications
- Requires knowledge, skill, and mental development equivalent to four (4) years of college with coursework in computer science or directly related fields.
- Requires three (3) years of professional experience in Systems Services or a directly related Information Technology field.
Specialized Skills
- Requires three (3) years of professional database administration experience managing Microsoft SQL Server, IMS, and DB2, including installation, configuration, patching, performance tuning, and backup/recovery to ensure system reliability and efficiency.
- Three (3) years of professional experience providing technical consultation on software, utilities, and hardware products used for large-scale computer systems in the development of databases and computer applications.
Preferred Qualifications (In Order of Significance)
- Three (3) years of professional database administration experience managing Microsoft SQL Server, IMS, and DB2, including installation, configuration, patching, performing tuning, and backup/recovery to ensure system reliability and efficiency.
- Three (3) years of professional experience providing technical consultation on software, utilities, and hardware products used for large-scale computer systems in the development of databases and computer applications.
- Three (3) years of professional information systems experience in Microsoft SQL/Legacy database administration.
- Three (3) years of professional experience providing leadership, guidance, and technical assistance to lower-level team members regarding complex database administration activities.
- Three (3) years of experience with Crystal Reports, SQL-based reporting, and legacy database tools, including troubleshooting, optimizing, and developing complex reports to support database operations.
- Extensive knowledge of database design reviews, integrity checks, performance tuning, security management, and resource optimization to ensure efficient and secure database operations.
- Extensive knowledge of user access management, security policies, backups, transaction log management, and system compatibility to ensure database integrity and performance.
- Ability to analyze data logically and exercise sound judgement in defining and evaluating problems of an operational or procedural nature.
- Ability to gain and maintain effective working relationships with associates, vendors, clients, and others.
- Developed verbal and written communication skills to present technical information to others with clarity and precision.
Conditions of Employment
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 State of Illinois.
- Requires the ability to pass a position specific, agency required background check.
- Requires self-disclosure of criminal history.
- Requires the ability to travel in performance of duties.
- Requires the ability to work outside of normal hours to meet deadlines.
- Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
- Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies, or other industry related topics relevant to job duties.
- Requires the ability to lift and carry objects or equipment 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.
The conditions of employment listed are incorporated and/or related to any duties included in the position description.
Work Hours: Monday - Friday 8:30am - 5:00pm
Work Location: 1 N Old State Capitol Plz Springfield, IL 62701-1323
Agency Contact: Lois Green
Email: lois.d.green@illinois.gov
Posting Group: Science, Technology, Engineering & Mathematics
This position DOES contain “Specialized Skills” (as that term is used in CBAs).
APPLICATION INSTRUCTIONS
Use the “Apply” button at the top right or bottom right of this posting to begin the application process.
If you are not already signed in, you will be prompted to do so.
State employees should sign in to the career portal for State of Illinois employees – a link is available at the top left of the Illinois.jobs2web.com homepage in the blue ribbon.
Non-State employees should log in on the using the “View Profile” link in the top right of the Illinois.jobs2web.com homepage in the blue ribbon. If you have never before signed in, you will be prompted to create an account.
If you have questions about how to apply, please see the following resources:
State employees: Log in to the career portal for State employees and review the Internal Candidate Application Job Aid
Non-State employees: on Illinois.jobs2web.com – click “Application Procedures” in the footer of every page of the website.
The main form of communication will be through email. Please check your “junk mail”, “spam”, or “other” folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:
- donotreply@SIL-P1.ns2cloud.com
- systems@SIL-P1.ns2cloud.com
Nearest Major Market: Springfield