Skip to main content
State Universities Civil Service System

Employment Opportunities
Job Details


This posting is no longer active.

MSSQL Database Administrator

University/Agency Illinois State University
Civil Service Classification Information Technology Technical Associate
View Class Spec Details
Posting Duration 8/7/2020 - 8/20/2020
Probationary Period 12 months

Job Description

The 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 12c, Microsoft SQL Server, and MySQL. The incumbent also serves as backup or secondary administrator on other database systems performing only some of the duties outlined for those specific databases.


Qualifications

Required Qualifications
1. Any combination totaling two years from the following categories:
a. Progressively more responsible work experience in an IT related profession
b. 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

2. At least six (6) months of work or classroom experience performing any of the following:
a. Database administration in the MS SQL Server 2012 and newer platforms
b. Database or server monitoring tools for health and performance monitoring
c. Windows Server Administration on Microsoft Windows Server 2012 or newer version with Windows Failover Cluster

3. Understanding of relational database concepts, queries (SQL), and ability to use one or more common query/reporting tools (SQL Developer, TOAD, Cognos, SSRS, Crystal Reports)

4. Ability to perform various system administration duties for assigned databases and servers including installation, configuration, and patch management systems

5. Knowledge of IT Infrastructure Hardware as it relates to DB architecture such as Servers, Storage, Networking, Backups

6. Working knowledge of relational and dimensional data structures

7. Strong customer service skills along with a desire for achieving excellence in customer satisfaction, process, and product quality and reliability.

8. Strong problem-solving ability

9. Excellent interpersonal and communication skills, ability to conduct internal and external meetings

10. Ability to work independently and in a team environment with good communication and collaboration skills

11. Ability to work with considerable latitude and independence of action.

12. Ability to clearly communicate complex technical concepts verbally and in writing to management, technical staff, and customers in terms appropriate for each audience

13. Ability to analyze large amounts of detailed information, quickly understand complex issues, and break information down into smaller, more manageable pieces

14. System Administrator understanding of common technologies used by database applications such as backups and event monitoring

15. Ability to leverage Microsoft Word, Visio, and Excel

16. Ability to adapt quickly to new technologies and changing business requirements

17. Strong project, analysis, and research skills

18. A keen interest in learning new tools and methods

Desired Qualifications
1. Technically focused Bachelor's degree from accredited institution

2. Two years of experience supporting software applications using MS SQL databases, especially higher education administrative systems

3. One year of experience with other relational database technologies, especially MySQL 8.0

4. One year of experience with Windows operating system script


Salary

$52,500 - $62,500 annual


Links

ISU Jobs Website


Contact Information


University/Agency Illinois State University
Department/College Human Resources
Contact Kira Shelton
Phone Number 309-438-8311
Address
Comments Special Instructions for Applicants
Please fully complete the entire application including, but not limited to, the education and work experience portions. Please list all education and all jobs you have had. Do not leave gaps in employment. You must list all duties you performed in the job duties section (Phrases such as "See Resume" are not acceptable). Failure to follow any of these instructions may constitute an incomplete application. Incomplete applications will not be considered.

If you are using college or university coursework to qualify for this position, then college or university transcripts (may be unofficial) must be submitted prior to the application deadline in order to receive full consideration. Transcripts can either be uploaded with your application or submitted via the options listed below.

In order to be eligible for Veteran's Preference points on the exam, a copy of your DD-214 must be submitted prior to the application deadline.

Transcripts and/or DD-214 paperwork may be faxed or mailed to Human Resources by the application deadline:

Fax: 309.438.0011, Attn: Kira Shelton
Address: Illinois State University
Human Resources
Campus Box 1300
Normal, IL 61790-1300

The Civil Service examination for this classification is based on your application materials. No participation other than submission of applicant materials is required from applicants that qualify to take the exam. If you meet the minimum required qualifications for this position, you will receive a score calculated based on your education and experience, and your name will be placed on the active employment register by exam score. After the application deadline, the names within the top three scores will be referred to the department for interview. The active register for this classification will be voided when the position is filled.