DATABASE ADMINISTRATOR

Under the general supervision of the Deputy Chief Information Officer, the Database Administrator plans, administers, secures, monitors, and supports the agency’s Microsoft SQL Server and Azure SQL Managed Instance environments. The position ensures the availability, performance, integrity, security, backup, and recovery of databases supporting election operations and other mission-critical agency systems. The Database Administrator leads database modernization and cloud migration activities and collaborates with infrastructure, cybersecurity, development, application support, and vendor teams., Administer and maintain SQL Server and Azure SQL Managed Instance environments. Monitor database availability, storage, capacity, SQL Agent jobs, service health, connections, and resource utilization. Troubleshoot database, application, linked-server, replication, and connectivity problems and provide timely support for mission-critical election systems.

Essential Function 2

Plan and execute the migration of on-premises SQL Server workloads to Azure SQL Managed Instance. Inventory databases, logins, permissions, jobs, linked servers, and dependencies; assess compatibility; configure cloud services; perform test and production migrations; validate application connectivity and data integrity; and maintain cutover and rollback procedures.

Essential Function 3

Manage database security and compliance controls. Administer logins, roles, user mappings, permissions, service accounts, authentication, and auditing in accordance with least-privilege principles. Coordinate password rotations, remove obsolete or shared accounts, investigate unauthorized access, and maintain documentation supporting security reviews and election-related compliance requirements.

Essential Function 4

Analyze and improve database performance. Review execution plans, indexes, blocking, waits, CPU, memory, storage, and I/O trends. Tune queries, stored procedures, database configurations, and maintenance schedules. Automate index and statistics maintenance and recommend resource changes that improve system responsiveness, scalability, and cost efficiency.

Essential Function 5

Develop, maintain, and test backup, recovery, high-availability, and disaster-recovery processes. Verify backups stored locally and in Azure, monitor Always On Availability Groups and replication, investigate failures, conduct restoration and failover tests, and ensure documented recovery procedures meet agency recovery objectives.

Essential Function 6

Develop automated monitoring, alerting, reporting, and operational tools for database health, performance, capacity, security, and cost management. Maintain technical documentation, architecture records, permissions matrices, change records, knowledge-base articles, standard operating procedures, and support runbooks.

Essential Function 7

Provide database technical guidance to developers, analysts, support personnel, and vendors. Review database changes and deployment processes, assist with reporting and application access, support Azure and DevOps modernization initiatives, provide training, and perform other duties reasonably related to the responsibilities of the position.

Knowledge, skill, and mental development equivalent to completion of four years of college, preferably in computer science, information technology, database administration, or a related field., Professional experience administering Microsoft SQL Server environments, including configuration, monitoring, performance tuning, security, backup and recovery, high availability, disaster recovery, SQL Agent, T-SQL, and PowerShell automation., Ability to troubleshoot complex technical problems, protect confidential information, document procedures, manage competing priorities, and communicate effectively with technical and nontechnical personnel., Knowledge of Azure SQL Managed Instance, Azure networking, identity and access management, migration tools, auditing, and cloud cost governance is preferred., Microsoft database or Azure certifications are preferred.

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 paid holidays per year
• 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