Skip to Main Content

Database Administrator

Please see Special Instructions for more details.

Your reference list should include three (3) professional references.

Posting Details

Position Information

Position Title Database Administrator
Department Information Technology
Location Main Campus (Houghton, MI)
Position Type Staff
Full-time/ Part-time Full-time
Full-Time Equivalent (1.0=100%) 1.0
Appointment Term 12 Month
Pay Type Salary Basis
Salary or Hourly Rate No Less Than $65,000
Shift
Position Duration Dependent on External Funding? No
Title of Position Supervisor Director of Enterprise Application Services

Position Summary Information

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Job Description Summary

The Database Administrator is a key person within the Information Technology Enterprise Application Services group. As the Database Administrator, you will be responsible for a diverse database environment. Some of the database types include Oracle, Microsoft SQL Server and MySQL. These underlying databases support software which include but are not limited to Ellucian Banner ERP, Campus Card System, Research Microscope Usage, Sponsored Research Proposal Tracking and the Bookstore.

Essential Duties & Responsibilities (other duties may be assigned)

1. Perform planning, design, installation, configuration, upgrade and migration for the Oracle enterprise databases including support for ASM, RMAN, Oracle Enterprise Manager Cloud Control.
2. Perform planning, design, installation, configuration, upgrade and migration for the MySQL database on Linux environment.
3. Perform planning, design, installation, configuration, upgrade and migration for the Microsoft SQL Server environment.
4. Apply the database portion of application installation and patches as needed.
5. Perform daily administrative tasks for all databases supported by Information Technology.
6. Support OLTP and data warehouse systems for all University Business systems.
7. Resolve database performance and capacity issues as they occur.
8. Participate as an active team member to design, maintain, and optimize database driven applications.
9. Assist with developing and implementing backup and recovery strategies.
10. Must be able to work independently to resolve system issues.
11. Create and update database maintenance and change management procedures.
12. Provide on-call support outside of regular business operating hours including evenings and weekends.
13. Perform other duties and projects as assigned or directed.
14. Apply safety-related knowledge, skills, and practices to everyday work.
15. Commit to learning about continuous improvement strategies and applying them to everyday work. Actively engage in University continuous improvement initiatives.

Required Education (minimum requirements)

• Bachelor’s degree in computer science, management of information systems, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired.

Required Experience (minimum requirements)

• 5 years experience managing an Oracle database environment
• Experience with a UNIX environment

Desirable Education and/or Experience

• Experience upgrading Banner systems
• Experience upgrading ODS and EDW
• Experience in Higher Education
• Experience installing and configuring a new Oracle installation

Required Knowledge, Skills, and/or Abilities (minimum requirements)

• Demonstrated ability to communicate effectively across cultural boundaries and work harmoniously with diverse groups of students, faculty, and staff
• Strong SQL skills, including experience tuning SQL statements
• Effective interpersonal communication skills, with an emphasis on a high degree of customer service satisfaction
• Demonstrated commitment to contribute to a safe work environment
• Experience applying quarterly Oracle PSUs and interim Oracle patches within the past 2-3 years
• Experience managing an Oracle Database environment
• Experience using RMAN to perform hot and cold backup, recover, and duplicate databases
• Experience using and configuring Oracle Enterprise Manager Cloud Control
• Experience configuring Automatic Storage Management (ASM)

Desirable Knowledge, Skills, and/or Abilities

• Experience using SQL to create SQL statements

Language, Mathematical, and/or Reasoning Skills
Work Environment and/or Physical Demands
Required Training and Other Conditions of Employment

Required University Training:
• Employee Safety Overview
• Anti-Harassment, Discrimination, Retaliation Training
• Annual Data Security Training

Background Check:
Offers of employment are contingent upon and not considered finalized until the required background check has been performed and the results received and assessed.

Posting Detail Information

Posting Number 17277
Posting Type Internal & External Posting
Internal Posting Date
External Posting Date 09/12/2017
Open Until Filled Yes
Special Instructions to Applicants (if applicable)

Your reference list should include three (3) professional references.

Additional Information

References

Settings

Accept References No
Cutoff Date
Reminder Days
Minimum Requests
Maximum Requests
Applicant Special Instructions
Provider Special Instructions
Confirmation Message To Provider

Posting Specific Questions

Required fields are indicated with an asterisk (*).

Applicant Documents

Required Documents
  1. Cover Letter
  2. Resume
  3. Reference List
Optional Documents