Database Administration Analyst (Information Systems Analyst II, Option A)

State of Illinois•Springfield, IL

20h

About The Position

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 Administration Analyst, for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Revenue (IDoR).In this role you will monitor the performance and use of database and database designs for the application systems implemented at IDOR and perform analysis and tuning recommendations for improved performance. In addition, you will perform complex functional and technical activities supporting the production information system. If you possess these knowledges, skills, abilities and experience, we invite you to apply 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.

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 Application Services or a related Information Technology field.
Requires three (3) years of professional experience designing, implementing, and administering SQL Server relational databases within Windows Server environments, including SQL Server Agent Client/Server architecture, and performance tuning to support complex information systems.
Requires three (3) years of professional experience developing and automating administrative tasks using PowerShell scripting, with the ability to interpret and apply Active Directory security models and manage NTFS permissions to ensure secure and efficient system operations.
Requires three (3) years of professional experience configuring, maintaining, and supporting Gentax systems, including troubleshooting and implementing system modifications to meet evolving business requirements.
Requires the ability to verify identity.
Requires employment authorization to accept permanent full-time position with the State of Illinois.
Requires ability to pass a tax compliance and position specific, agency required background check.
Requires self-disclosure of criminal history.
Requires the ability to use agency supplied equipment such as laptop, personal computer, cell phone and any other required equipment or devices.
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 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.
Requires the ability to serve in an on-call capacity.
Requires the ability to work overtime including scheduled, unscheduled, short notice, evenings, weekends and holidays.

Nice To Haves

Three (3) years of professional experience designing, implementing, and administering SQL Server relational databases within Windows Server environments, including SQL Server Agent Client/Server architecture, and performance tuning to support complex information systems.
Three (3) years of professional experience developing and automating administrative tasks using PowerShell scripting, with the ability to interpret and apply Active Directory security models and manage NTFS permissions to ensure secure and efficient system operations.
Three (3) years of professional experience configuring, maintaining, and supporting Gentax systems, including troubleshooting and implementing system modifications to meet evolving business requirements.
Ability to exercise sound judgment in defining, evaluating, and resolving complex technical and operational problems, including precedent-setting or research-based solutions.
Ability to establish and maintain effective working relationships with agency officials, technical teams, vendors, and stakeholders to ensure successful system implementation and support.
Ability to logically interpret data, identify root causes, and develop solutions for operational or procedural changes withing production and test environments.
Developed verbal and written communication skills to clearly present technical concepts, system designs, and performance recommendations to both technical and non-technical audience, ensuring clarity and precision in documentation and reporting.

Responsibilities

Under administrative direction, serves as a Database Administration Analyst for the Department of Innovation & Technology (DoIT) supporting the Illinois Department of Revenue (IDoR) performing complex and advisory functions for the Gentax application systems.
Independently performs complex functional and technical activities supporting the production information system and makes complex systems modification design changes.
Monitors the performance and use of database and database designs for the application systems implemented at IDOR and performs analysis and tuning recommendations for improved performance.
Conducts technical studies to evaluate and optimize system performance, establishing criteria for information system requirements.
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 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