Information Technology (IT) invites applications for a Database and Application Administrator to oversee the availability, integrity, security, and performance of the University's enterprise database environment and the applications that run on it, including the Oracle databases behind the Banner ERP that support student, finance, human resources, and financial aid operations. The administrator reports directly to the Manager of the Database Administration team, which is within the Enterprise Technology division in IT. Manage Ellucian application servers and Application Navigator. Plan and execute patches, releases, and upgrades with departments across campus, and maintain test and training environments refreshed from production Design and administer database roles, privileges, and privileged-access controls, along with account provisioning and role assignment for enterprise applications Conduct database audits, apply encryption and masking to regulated data, remediate vulnerabilities on schedule, and support security reviews with Information Security Install, configure, patch, and upgrade Oracle, PostgreSQL, MySQL, AWS RDS, and Azure SQL. Monitor health and capacity, plan for growth, and clone databases between environments Design, implement, and test backup and recovery procedures, and maintain documentation of configurations, standards, upgrade procedures, and known issues Analyze execution plans, tune queries and instances, and advise developers and report writers on query design and data access Troubleshoot application and database issues, find root causes, manage vendor support cases, and lead post-incident reviews to prevent recurrence Administer middleware and integration tools, monitor scheduled jobs and data exchanges with internal and external partners, and collaborate with developers on integration requirements Bachelor's degree in computer science, information systems, or a related field, or an equivalent combination of education and experience Knowledge of relational database administration on at least one enterprise platform (Oracle, PostgreSQL, MySQL, or SQL Server), including installation, configuration, patching, and version upgrades Understanding of backup and recovery design, with the ability to plan and execute a database restore under time pressure Ability to write and tune SQL, read execution plans, and diagnose database performance problems Knowledge of database security, including privileged access management, role design, encryption, and auditing Competency administering cloud-managed databases such as AWS RDS or Azure SQL, or demonstrated ability to learn a cloud platform quickly Knowledge of networking fundamentals and database connectivity protocols (e.g., SQL

•Net/TNS, ODBC, JDBC), including port and firewall requirements Ability to document technical work clearly, explain technical constraints to non-technical colleagues, and plan and perform changes during scheduled maintenance windows, including occasional nights and weekends Preferred Qualifications Solid experience administering Oracle databases in a higher-education Ellucian Banner environment Demonstrated experience with automated database deployment or infrastructure-as-code tooling Experience coordinating vendor-driven application upgrades with functional business offices Experience with PL/SQL, Bash, Python, and/or similar programming languages

Compensation Title:

Data Systems Manager I Bargaining Unit:

FOCUS-MFPE

Work Schedule:

Full-time, 1.0 FTE (40 Hours a week), Monday through Friday 8:00 am to 5:00 pm, 12 months/year

Probationary Period:

Six (6) months minimum

Benefits Include :

Insurance package, mandatory retirement plan, partial tuition waiver, and wellness program. Screening of applications will begin after the closing date ; however, applications will continue to be accepted until an adequate applicant pool has been established.

Required Application Materials:

Cover Letter:

addressing your qualifications and experience related to the stated required skills for the position

Detailed Resume:

listing education and describing work experience Three (3)

Professional References:

names and contact information The University of Montana is interested in receiving applications from people who would assist the University in demonstrating its five priorities for action : Place student success at the center of all we do; drive excellence and innovation in teaching, learning, and research; embody the principle of "mission first, people always"; partner with place; and proudly tell the UM story. Must be eligible to work in the United States upon hire. Sponsorship is not available for this position.