Database Administration Analyst, Information Systems Analyst II, Option A
United States
Full Time
1 week ago
$7,787 - $11,450 USD
Key skills
SQLPowerShellSQL ServerActive Directory
About this role
Role Overview
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.
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.
Tech Stack
SQL
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