> Markdown version of [/jobs/ext/4312769-database-administrator](https://www.wearedevelopers.com/jobs/ext/4312769-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # DATABASE ADMINISTRATOR - **Company:** State of Illinois - **Location:** Springfield, IL, United States - **Experience:** Experienced - **Salary:** $90,000.0 - $120,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Backup Devices, Databases, Data Integrity, Database Security, DevOps, Disaster Recovery, Identity and Access Management, Microsoft SQL Server, SQL Azure, Performance Tuning, Windows PowerShell, Cloud Services, Runbook, SQL Stored Procedures, SQL Server Agent, Transact-SQL, Connectivity Problems, System Availability, Database Performance, Information Technology, Cloud Optimization - **Published:** October 12, 2026 - **Apply:** https://illinois.jobs2web.com/talentcommunity/apply/1439528300/?locale=en_US ## About the Role 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. ## Description 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.