SQL Database Administrator (Information Systems Analyst II, Option S)

State of Illinois•Springfield, IL

23h•Onsite

About The Position

The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates for an SQL Database Administrator role. This position involves performing complex installations, systems configurations, testing, and implementation of software, hardware, and operating systems. The administrator will also conduct and coordinate in-depth feasibility studies, involving substantial technical research and systems analysis, and serve as a project coordinator for major/complex projects, including large hardware/software deployments and installations across multiple agencies and locations. Working with the State of Illinois offers a rewarding career with comprehensive benefits and opportunities for professional advancement. DoIT is the state's IT agency, providing enterprise technology, innovation, telecommunication, policy, and cybersecurity services to improve services for Illinois residents. The department is committed to a diverse and inclusive workplace culture.

Requirements

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.
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 Continuity 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.

Nice To Haves

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.
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.
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.
Working knowledge of data base structures and Microsoft Windows Server platform support.
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.

Responsibilities

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 Hosting.
Conducts and coordinates in-depth feasibility studies involving substantial technical research and systems analysis and develops complex written IT analysis, recommendation documents and implementations plans.
Performs advanced problem diagnostics of complex operating systems and monitors connectivity utilizing software to notify of alerts.
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 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 the duties enumerated above.

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 (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