SQL Database Administrator (Information Systems Analyst II, Opt. S)
SQL Database Administrator (Information Systems Analyst II, Opt. S)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 7787 - 11450
1 Vacancy
Job Description
Job Requisition ID:48545
Posting Date: 07/18/2025
Closing Date: 07/31/2025
Agency:Department of Innovation and Technology
Class Title:INFORMATION SYSTEMS ANALYST II - 21166
Skill Option:System Services - Information Technology
Bilingual Option:None
Salary: Anticipated starting salary: $7787 monthly; Full range: $7787-$11450 monthly
Job Type: Salaried
Category:Full Time
County: Sangamon
Number of Vacancies: 1
Bargaining Unit Code: RC063
Merit Comp Code: None
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 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.
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 youre helping to improve schools protect our natural resources or support families in need youre part of something biggersomething that touches the lives of every person who calls Illinois home.
No matter what state career youre looking for we offer jobs that fit your life and your scheduleflexible 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.
Position Overview
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 SQL Database Administrator performing complex installations systems configurations testing and implementation of software hardware and operating this role you will conduct and coordinate in-depth feasibility studies involving substantial technical research and systems addition you will serve as project coordinator for full-range major/complex projects very large hardware/software deployments and installations across multiple agencies and locations. 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: Functions
- Under administrative direction serves as an SQL Database Administrator for the Department of Innovation & Technology (DoIT) performing complex installations systems configurations testing and implementation of software hardware and operating systems for Data Center Operations/Midrange Wintel.
- Conducts and coordinates in-depth feasibility studies involving substantial technical research and systems analysis.
- Performs advanced problem diagnostics of complex operating systems and problems.
- Serves as project coordinator for full-range major/complex projects very large hardware/software deployments and installations across multiple agencies and locations.
- 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 course work in computer science or directly related fields.
- Requires three (3) years of professional experience in Systems Services or a related Information Technology field.
Specialized Skills
- Requires three (3) years of professional SQL database administrative experience with expertise in troubleshooting and optimizing Online Analytical Processing (OLAP) or tabular data models and deploying the models as databases to an Analysis Services instance processing data loads proficiently and configuring user permissions to ensure secured and controlled data access.
- Requires three (3) years of professional experience managing Microsoft SQL Server (all current Microsoft supported versions) VMware Microsoft Windows Active Directory Microsoft Windows Server operating system support (all current Microsoft supported versions) and technical concepts including Risk Management Web Applications Workflow Data Management and Business Continutiy Planning.
- Requires three (3) years of professional experience implementing and managing Microsoft SQL High Availability features SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to support enterprise reporting and data integration solutions.
- Requires three (3) years of professional experience performing installation configuration performance troubleshooting optimization backup and recovery of an SQL Server.
Preferred Qualifications
- Three (3) years of professional SQL database administrative experience with expertise in troubleshooting and optimizing Online Analytical Processing (OLAP) or tabular data models and deploying the models as databases to an Analysis Services instance processing data loads proficiently and configuring user permissions to ensure secured and controlled data access.
- Three (3) years of professional experience managing Microsoft SQL Server (all current Microsoft supported versions) VMware Microsoft Windows Active Directory Microsoft Windows Server operating system support (all current Microsoft supported versions) and technical concepts including Risk Management Web Applications Workflow Data Management and Business Continuity Planning.
- Three (3) years of professional experience implementing and managing Microsoft SQL High Availability features SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to support enterprise reporting and data integration solutions.
- Three (3) years of professional experience performing installation configuration performance troubleshooting optimization backup and recovery of an SQL Server.
- Extensive knowledge of the methods procedures and techniques of conducting feasibility studies for system conversions and enhancements including developing IT analysis recommendations and implementation plans
- Three (3) years of professional experience implementing and managing cloud-native and hybrid data platform solutions using SQL Server and Azure SQL services including evaluating and implementing migration strategies between Azure and on-premises environments.
- Three (3) years of professional experience coordinating large-scale IT projects managing deployments assigning tasks providing technical guidance and integrating project components into final deliverables.
- Ability to analyze data logically and exercise sound judgement in defining and evaluating problems of an operational or procedural nature.
- Developed verbal and written communication skills to present technical information to others with clarity and precision.
- Working knowledge of data base structures and Microsoft Windows Server platform support.
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 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 serve in an on-call capacity.
- 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 65pounds. This is considered very heavy work as defined by the U.S. Department of Labor (20 CFR 404.1567(e)). Very Heavy work involves lifting objects weighing more than 100 pounds at a time with frequent lifting or carrying of objects weighing 50 pounds or more.
- The conditions of employment listed are incorporated and/or related to any duties included in the position description.
About the Agency
The Department of Innovation & Technology (DolT) is the states IT agency delivering an enterprise approach to statewide technology innovation and telecommunication services as well as policy and standards development lifecycle investment planning and cybersecurity services. With over 1500 employees DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents DolT offers employees the opportunity to advance their careers develop new skills and reach their potential both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective leading to greater innovation and recruiting for our team we recognize the unique contributions of each applicant regardless of culture ethnicity race national origin sex gender identity and expression age religion disability and sexual orientation.
Work Hours: 8:30am-5:00pm Monday-Friday
Work Location: 201 W Adams St Springfield Illinois 62704-1874
Agency Contact: Elizabeth Bridges
Email:
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 homepage in the blue ribbon.
Non-State employees should log in on the using the View Profile link in the top right of the 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 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:
Required Experience:
IC
Employment Type
Full Time
