SQL Database Administrator (INFORMATION SYSTEMS ANALYST II, OPT S)

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded underMy Documents Additional Documentssection for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant's wage or salary history. Employment decisions are not made based on an applicant's wage or salary history. To that end, pleasedo not include wage or salary information in your resume or other profile or application materials.

Springfield, IL, US, 62704-1874

Position Title: Information Systems Analyst II, Option S

Agency: Department of Innovation and Technology
Posting Date:07/30/2024

Closing Date:08/12/2024
Salary:$7,491 to $11,015 monthly
Job Type:Salaried
County:Sangamon
Number of Vacancies:2
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 positionMUSTapply 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.**

Posting Identification Number40333

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 systems. In this role you will conduct and coordinate in-depth feasibility studies involving substantial technical research and systems analysis. In 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: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

Essential Functions

25% Under administrative direction, serves as an SQL Database Administrator for the Department of Innovation & Technology (DoIT):

• Performs complex installations, systems configurations, testing, and implementation of software, hardware, and operating systems.
• Implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services.
• Utilizes a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.
• Approves and documents installations and enhancements.
• Coordinates complex enhancements and maintenance with the client.
• Troubleshoots, deploys, and analyzes OLAP or tabular data models.

25% Conducts and coordinates in-depth feasibility studies involving substantial technical research and systems analysis:

• Develops complex written IT analysis and recommendation documents.
• Develops written implementations plans.
• Provides complex technical assistance to clients and technicians pertaining to hardware, software, and operating systems.
• Conducts reviews of complex components and processes making recommendations for modifications to provide availability, flexibility, and usability for clients.
• Reviews, creates, and modifies current configurations, tables, and programs.
• Configures and maintains security requirements on servers.
• Updates existing processes for installs and develops processes on configuration for the software that are installed and implemented.
• Provides monitoring and reporting of software and servers.

20% Performs advanced problem diagnostics of complex operating systems and problems:

• Monitors connectivity and utilizes software to notify of alerts.
• Evaluates and resolves complex hardware and software problems.
• Performs diagnosis and resolution of system software problems.
• Confers with vendors to resolve software and hardware problems.
• Serves as liaison between agency customers and DoIT management and technicians for resolution of customer requirements.
• Monitors trouble tickets to ensure acceptable service levels to agencies within listed time frames are being met.
• Escalates time sensitive trouble calls to appropriate person for faster resolution time.

Essential Functions Continued

20% Serves as project coordinator for full-range major/complex projects, very large hardware/software deployments and installations across multiple agencies and locations:

• Determines and coordinates project components such as project scheduling and assignments.
• Assigns and reviews the work of project analyst staff.
• Provides expertise, guidance, and direction to staff.
• Reviews results and incorporates individual components of project into the final products.

5% Keeps abreast of new developments in the Information Technology (IT) field:

• Continues education by attending meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
• Attends demonstrations and exhibitions related to assigned operations.

5% Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.

Minimum Qualifications

1. Requires knowledge, skill, and mental development equivalent to four (4) years of college with course work in computer science or directly related fields.
2. Requires three (3) years of professional experience in Systems Services or a related Information Technology field.

Specialized Skills

1. Requires three (3) years of professional experience troubleshooting OLAP or tabular data models and deploying the model as a database to an Analysis Services instance, process the database to load it with data, and then assign permissions to allow data access.
2. Requires three (3) years of professional experience utilizing 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 of technical concepts including Risk Management, Web Applications, Workflow, Data Management and Business Continuity Planning.
3. Requires three (3) years of professional experience with Microsoft SQL High Availability features, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
4. Requires three (3) years of professional experience performing installation, configuration, performance troubleshooting, optimization, backup, and recovery of a SQL Server.

Preferred Qualifications

1. Three (3) years of professional experience troubleshooting OLAP or tabular data models and deploying the model as a database to an Analysis Services instance, process the database to load it with data, and then assign permissions to allow data access.
2. Three (3) years of professional experience utilizing 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 of technical concepts including Risk Management, Web Applications, Workflow, Data Management and Business Continutiy Planning.
3. Three (3) years of professional experience with Microsoft SQL High Availability features, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
4. Three (3) years of professional experience performing installation, configuration, performance troubleshooting, optimization, backup, and recovery of a SQL Server.
5. Three (3) years of professional experience as a Microsoft SQL Administrator.
6. Extensive knowledge of the methods, procedures and techniques of conducting feasibility studies for system conversions and enhancements.
7. Three (3 years) professional experience with cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services, including evaluating and implementing migration strategies between Azure and on-premises environments.
8. Ability to analyze data logically and exercise sound judgement in defining and evaluating problems of an operational or procedural nature.
9. Developed verbal and written communication skills to present technical information to others with clarity and precision.
10. Working knowledge of data base structures and Microsoft Windows Server platform support.

Conditions of Employment

NOTE:Applicants must possess the ability to meetALLof the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

1. Requires the ability to verify identity.
2. Requires employment authorization to accept permanent full-time position with the State of Illinois
3. Requires the ability to pass a position specific, agency required background check.
4. Requires self-disclosure of criminal history.
5. Requires the ability to travel in performance of duties.
6. Requires the ability to serve in an on-call capacity.
7. Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
8. 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.
9. 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 state's 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 1,500 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 achievement. In 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 to 5:00pm, M-F
Work Location:201 W Adams St, Springfield, Illinois, 62704-1874
Agency Contact:

Elizabeth Bridges

elizabeth.bridges@illinois.gov

Posting Group:Science, Technology, Engineering & Mathematics

This position DOES contain “Specialized Skills” (as that term is used in CBAs).