Illinois State University
Location
Normal, IL | United States
Job description
Division Name: Finance and Planning
Department: Application Services
Job Summary 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, Microsoft SQL Server, PostgreSQL, 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.
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. 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:
- Information regarding eligibility for participation in the State Universities Retirement System and the State of Illinois Group Insurance program can be reviewed here
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.
Salary Rate / Pay Rate $70,000 - $90,000 annual
Required Qualifications - Bachelor’s degree
- Work experience which included:
a. Three years performing various system administration duties for assigned databases and applications including installation, configuration, and patch management
b. Windows System Administrator and MS SQL Database Administrator experience at either the Mid-Level (3-7 years of experience) or the Senior-Level (7-10 years of experience) - Understanding of relational database concepts, queries (SQL), and ability to use 1 or more common query/reporting tools (SQL Server Management Server (SSMS), SQL Developer, TOAD, Cognos, SSRS, Crystal Reports)
- Knowledge of IT Infrastructure Hardware as it relates to DB architecture such as Servers, Storage, Networking, Backups
- 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
- A keen interest in learning new tools and methods
- Demonstrated skills
a. strong customer service skills along with a desire for achieving excellence in customer satisfaction, process, and product quality and reliability.
b. strong problem-solving skills
c. excellent interpersonal and communication skills, with the ability to conduct internal and external meetings
d. strong project, analysis, and research skills - Ability to:
a. work independently and in a team environment with good communication and collaboration skills.
b. work with considerable latitude and independence of action.
c. clearly communicate complex technical concepts verbally and in writing to management, technical staff, and customers in terms appropriate for each audience including developing good documentation
d. analyze large amounts of detailed information, quickly understand complex issues, and break information down into smaller, more manageable pieces
e. leverage Microsoft Word, Visio, and Excel
f. adapt quickly to new technologies and changing business requirements
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 to include 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 - Vendor certifications such as Microsoft Certified Solutions Associate (MCSA) or Microsoft Certified Database Administrator (MCDBA)
- Foundation qualification in Information Technology Infrastructure Library (ITIL)
Work Hours Core Hours: 8:00am-4:30pm Monday through Friday; occasional weekend and evening hours as business needs dictate
Functional Expectations Must be able to complete the following with or without a reasonable accommodation:
- Remain at a workstation for extended periods.
- Distinguish colors on a monitor.
- Effectively communicate on a daily basis.
Proposed Starting Date April 2024
Required Applicant Documents Resume
Reference List
Please Note : These documents are required to be submitted online in order to complete the application process. Please have these documents ready prior to clicking on "Apply"
Optional Applicant Documents Transcripts - See Special Instructions to Applicants for additional options
Certification of Retirement Annuity
Please Note : These documents may be submitted online in order to complete the application process. Please have these documents ready prior to clicking on "Apply"
Special Instructions for Applicants 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.
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 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.
Contact Information for Applicants Kira Shelton
Human Resources
[email protected]
(309) 438-2120
Important Information for Applicants This position is subject to a criminal background investigation and if applicable, an employment history review, based on University Policy 3.1.30 and any offer of employment is contingent upon you passing a satisfactory criminal background investigation and/or an employment history review. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.
Illinois State University is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If you are an individual with a disability and need a reasonable accommodation under the Americans with Disabilities Act (ADA) or other state or federal law you may request an accommodation by contacting the Office of Equal Opportunity and Access at (309) 438-3383 . The Office of Equal Opportunity and Access will hold any confidential information you provide in confidence.
If you are having difficulty accessing the system, please call Human Resources at (309) 438-8311 .
Job tags
Salary
