MSSQL Database Administrator

Division Name: Finance and Planning
Department: Application Services

Job Summary

The MSSQL Database Administrator works within a team environment to maintain, optimize, and provide technical expertise for enterprise and business level databases.

The incumbent oversees Enterprise and/or Business Databases acting as a Primary Administrator for multiple servers and versions of database software and support tools which host data for enterprise and business applications along with custom data warehouses, etc. The primary database systems in our environment include Oracle, Microsoft SQL Server, MySQL, and PostgreSQL. The incumbent also serves as backup or secondary administrator on other database systems performing only some of the duties outlined for those specific databases.

Additional Information

Technology Solutions provides information technology products and services for the administrative and business functions of Illinois State University. Through our Technology Support Center and our highly trained staff, Technology Solutions looks to improve the campus experience for all students, faculty, staff, and the rest of the campus community.

The Application Services (APPS) team develops, administers, and delivers quality application services to the University. They work on enterprise and business applications, such as PeopleSoft, Canvas, and others. https://techsolutions.illinoisstate.edu/ 

Position Highlights:

• There is the potential for 100% remote work or a hybrid arrangement in this position, within the State of Illinois. Illinois residency is required. Eligibility is based upon employee performance, appropriate remote working environment, and business needs.

University Benefit Highlights:

• Insurance benefits, including health, dental, vision, and life
• Retirement and supplemental retirement planning options
• Tuition waiver benefits available to staff as well as their eligible dependents
• Paid holiday/administrative closures during Thanksgiving and Winter Breaks
• Paid benefit time

For more University Benefit information: https://hr.illinoisstate.edu/benefits/ 

Information regarding eligibility for participation in the State Universities Retirement System and the State of Illinois Group Insurance program can be reviewed here https://hr.illinoisstate.edu/benefits/insurance/

Salary Rate / Pay Rate

$58,000 - $72,000 annual

Required Qualifications

1. High school diploma or equivalent
2. Any one or combination totaling two years from the following categories:
   a. College course work in Information Technology (IT), IT Management, or a closely related discipline, as measured by the following conversion table or its proportional equivalent:
        - 60 semester hours or Associate's degree equals one year
        - 90-120 semester hours or Bachelor's degree equals two years
   b. Progressively more responsible work experience in a database administration related profession
3. At least six (6) months of experience performing any of the following:
   a. Database administration in the MS SQL Server 2019 and newer platforms
   b. Database or server monitoring tools for health and performance monitoring
   c. Windows System Administration on Microsoft Windows Server 2019 or newer version with Windows Failover Cluster
   d. System administration duties for assigned databases and servers including installation, configuration, and patch management systems using query/reporting tools such as SQL Server Management Studio
4. Experience with ITSM, ticketing and issue tracking

Preferred Qualifications

1. Technically focused area of study from a higher education institution.
2. The following experience:
   a. supporting software applications using MSSQL databases, especially higher education administrative systems
   b. with Windows operating system script languages (such as PowerShell) for systems and database administration
   c. with Windows system administration with Windows failover cluster and advance firewall configuration
   d. with clustering, load balancing, mirroring, log shipping, and replication technologies to provide high availabilit