Employment Opportunities
Job Details

Job Description

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
This position is open to consideration for varying levels of experience. Pay within the salary range will be commensurate with experience.

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:

Health, dental, vision, and life insurance
Tuition waiver benefits are available to staff as well as their eligible dependents.
Paid holiday/administrative closures during Thanksgiving and Winter Breaks
Paid vacation and sick time
Retirement and supplemental retirement
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/
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/

Qualifications

Required Qualifications
High school diploma or equivalent
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
At least three years (36 months) of experience with/in the following:
a. Windows System Administration, MS SQL Database Administration or PostgreSQL DB administration while performing various system administration duties for assigned databases and applications including installation, configuration, and patch management
b. Understanding of relational database concepts, queries (SQL), and ability to use 1 or more common query/reporting tools (SQL Server Management Studio (SSMS), SQL Developer, TOAD, Cognos, SSRS, Crystal Reports)
c. Knowledge of IT Infrastructure Hardware as it relates to DB architecture such as Servers, Storage, Networking, Backups
Preferred Qualifications
Three years of experience:
a. supporting software applications that leverage databases, especially higher education administrative systems
b. with other relational database technologies, especially PostgreSQL 13 and higher and MySQL 8.0 or higher. Experience in installation, configuration, upgrade, and patch management of PostgreSQL and MySQL.
c. with Windows operating system script languages (such as PowerShell) for systems and database administration
d. with Windows failover cluster and advance firewall configuration
e. in Linux system administration and Linux firewall configuration with software installation (via yum or other repositories).
f. with Source Control, Defect Management, and Incident Management Software Tools
g. with clustering, load balancing, mirroring, log shipping and replication technologies to provide high availability systems
h. supporting large ERPs or Applications that must support many users
Working knowledge of relational and dimensional data structures
System Administrator understanding of common technologies used by database applications such as backups firewall settings, and event monitoring
Vendor certifications such as Microsoft Certified Solutions Associate (MCSA) or Microsoft Certified Database Administrator (MCDBA)
Foundation qualification in Information Technology Infrastructure Library (ITIL)
The following skills:
a. strong customer service skills along with a desire for achieving excellence in customer satisfaction, process, and product quality and reliability.
b. strong project, analysis, and research skills, and problem-solving ability
c. excellent interpersonal and communication skills, ability to conduct internal and external meetings
Ability to:
a. work independently and

Salary

$70,000 - $90,000 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	Please fully complete the entire application including, but not limited to, the education and work history portions. Be specific on your work history, including employment dates (if part-time you must list the number of work hours) and duties for all positions held. Applicable part-time work experience will be considered toward qualifying for this position; however, it will be converted to a full-time equivalency to determine combined length of experience. Please do not put "see resume" in the duties and responsibilities section of the work history. This will be considered an incomplete application and incomplete applications will not be considered. If you are using education to qualify, then college or university transcripts (may be unofficial) must be submitted prior to the application deadline to receive full consideration. Transcripts can either be uploaded with your application or submitted via the options listed below. To be eligible for Veteran's Preference points on the exam, appropriate military service documentation such as a DD-214 must be submitted prior to the application deadline. Transcripts and/or military service documentation 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 and responses to the supplemental questions. 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. Illinois State University is authorized to do business within the State of Illinois. All work under this appointment is required to be performed from within the State of Illinois. If hired, out-of-state candidates must establish Illinois residency within 180 calendar days from the start date for this position. Illinois residency requires proof of a valid Illinois driver’s license or a valid State of Illinois ID card. Failure to produce the required documentation within 180 calendar days will result in immediate termination of employment.