Database Administrator

Governor of Illinois; Springfield (IL); In loco; USD 84.000 - 112.000; Tempo pieno

Vantaggi offerti da questo lavoro

Comprehensive benefits

Flexible schedules

Paid vacation

Paid sick time

Pension plan

Deferred compensation

Tuition reimbursement

Loan forgiveness eligibility

Descrizione del lavoro

State Board of Elections in Springfield, IL seeks a Database Administrator to manage SQL Server and Azure SQL environments, ensuring availability, security, and data integrity for election systems.

You will lead migrations to Azure, implement high-availability, automate monitoring, and collaborate with developers and vendors. A four-year degree and strong SQL/T-SQL skills are required.

Competenze

• Four-year college degree in CS/IT or related field.
• Experience administering Microsoft SQL Server environments.
• Ability to troubleshoot complex technical problems and document procedures.

Mansioni

• Administer SQL Server and Azure SQL Managed Instance environments.
• Plan and execute migration of on-prem workloads to Azure SQL Managed Instance.
• Manage database security, logins, permissions, auditing per least-privilege.
• Analyze and optimize performance; tune queries and maintenance.
• Develop backup, recovery, high-availability and DR procedures.
• Develop automated monitoring, alerts, and runbooks for DB health.
• Provide database guidance to developers and vendors; support DevOps modernization.

Conoscenze

SQL Server

Azure SQL

PowerShell

T-SQL

Database security

Performance tuning

Migration to Azure

Backup and recovery

Monitoring

DevOps collaboration

Formazione

Bachelor’s degree (CS/IT/related)

Strumenti

Azure SQL Managed Instance

Descrizione del lavoro

Agency: Board of Elections
Closing Date/Time: October 27th, 2026 at 11:59 p.m.
Anticipated Starting Salary: $7,500 - $10,000 per month
Full Range: $7,500 - $11,667 per month
County: Sangamon
Number of Vacancies: 1
FLSA Status: Exempt

The SBE is a non-code agency.

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

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

Work Hours: 8:00 - 4:30 PM Monday - Friday
Work Location: 2329 S. MacArthur Blvd, Springfield IL 62704
Agency Contact: [e-mail]
Posting Group: Science, Technology, Engineering and Mathematics

****A RESUME IS REQUIRED FOR THIS JOB POSTING****

Please attach a DETAILED Resume/Curriculum Vitae (CV), a copy of your transcripts or diploma for all degrees earned, and a copy of any applicable professional licensures to the MY DOCUMENTS section of your application.

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.

Functional Statement

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.

Essential Function 1

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.

Minimum Qualifications 1

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.

Minimum Qualifications 2

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.

Minimum Qualifications 3

Ability to troubleshoot complex technical problems, protect confidential information, document procedures, manage competing priorities, and communicate effectively with technical and nontechnical personnel.

Preferred Qualifications 1

Knowledge of Azure SQL Managed Instance, Azure networking, identity and access management, migration tools, auditing, and cloud cost governance is preferred.

Preferred Qualifications 2

Microsoft database or Azure certifications are preferred.

The State Board of Elections welcomes all and promotes workplace diversity. It is our individual traits, character, and experiences that make each of us special and unique. It is only when we bring that individualism together and work as a diverse team that we thrive. There is no place for discrimination based on race, religion, culture, sexual identity or orientation, age, or disability at the State Board of Elections.