Job Information

University of Utah Health Database Administrator III in SALT LAKE CITY, Utah

Overview

As a patient-focused organization, University of Utah Health exists to enhance the health and well-being of people through patient care, research and education. Success in this mission requires a culture of collaboration, excellence, leadership, and respect. University of Utah Health seeks staff that are committed to the values of compassion, collaboration, innovation, responsibility, diversity, integrity, quality and trust that are integral to our mission. EO/AA

This position collaborates, mentors, defines, tests, and performs database engineering level work in our mission critical enterprise scale Oracle RAC, SQL Server AOAG, and Epic Cache HA/DR environments. This position engineers and designs database software release and system upgrade processes, evaluates and installs upgrades and patches, and helps identify and troubleshoot performance related problems both independently and in collaboration with other senior Database Team members. Performs and develops database backups and recovery tasks. Establishes, develops, maintains and monitors database system configurations and alerts to ensure data integrity, continuity, and availability. Serves as a mentor to junior level Database Team members. This position has no responsibility for providing care to patients.

Top candidates for this posting will have Oracle RAC experience.

Corporate Overview: The University of Utah is a Level 1 Trauma Center and is nationally ranked and recognized for our academic research, quality standards and overall patient experience. Our four hospitals and seventeen clinics provide excellence in our comprehensive services, medical advancement, and overall patient outcomes.

Responsibilities

  • Becomes familiar, competent, and authoritative with multiple Database System platforms and implementations through independent study, hands on work, training, and collaboration with senior Team members.

  • Analyzes system logs and identifies potential issues with database systems.

  • Researches, develops, documents and performs tasks needed to integrate new technologies into existing database environments.

  • Defines and completes audits and reviews of database systems including hardware, software, and network infrastructure.

  • Completes, and designs new processes for, database backups, restores, and data migrations as needed.

  • Reviews, documents, and performs database recovery plans and procedures to ensure maximum availability of systems.

  • Installs, configures, and documents database software according to best practices as required.

  • Adds, removes, or updates database user account information, resetting passwords, etc.

  • Proactively investigates technical queries, provides solutions or root cause, and resolves system and user issues.

  • Understands and adheres to security policies and procedures.

  • Defines, documents, and implements standard configurations to current and future systems and processes in collaboration with senior Database Team members.

  • Triages and remediates reported problems, determines root cause, and designs preventative configurations and processes.

  • Performs qualitative and quantitative performance tuning and testing and shares knowledge with team.

  • Develops protocols and procedures to validate that the database infrastructure is up and running appropriately.

  • Installs and migrates database object changes through development, test, and production.

  • Fully and proactively participates in On-Call rotation established for team.

  • Works independently, and leads collaboratively, on complex projects with minimal direction and supervision.

  • Explores, tests, and remains knowledgeable of current and future industry database options, trends, and directions.

  • Design and develop repeatable, manual or automated Standard Operating Procedures (SOP) and teach others through Knowledge Transfer (KT) presentations.

Knowledge / Skills / Abilities

  • Detail oriented, process focused, ability to learn independently in a fast paced environment and communicate effectively.

  • Design, develop, document, test, and perform the implementation and integration of new database architectures into future and existing team supported environments.

  • Knowledge of, experience with, and adherence to change control processes in a large production environment.

  • Knowledge of, experience with, and ability to deploy highly available database technologies such as replication, load balancing, mirroring, and clustering.

  • Experience with, and ability to, authoritatively install and configure database server software and document and compare new and existing systems.

  • Identify, design, develop, and defend standard monitoring requirements and apply additional setting requirements authoritatively and collaboratively with Team.

  • Ability to triage, troubleshoot and remediate complex and difficult issues in the database management system.

  • Proactively and independently lead and participate in the architecture and design configuration plans and discussions from vendors or system architects.

  • Proactively and authoritatively participate in the documentation, creation, and implementation of standards and guidelines.

  • Ability to write complex queries, programming, scripting, and coding to automate, support, and retrieve data from the database management system.

Qualifications

Qualifications Required

  • Bachelors Degree in Computer Science or Information Technology or equivalency.

  • Three years of applicable database experience.

Qualifications (Preferred)

Preferred

  • Oracle OCP, Microsoft MCSE, Epic ODBA, or other Technical Certification in related area or equivalency.

  • Experience working with any modern DBMS (Oracle, SQL Server, Cache', DB2, Teradata, and/or other).

  • Oracle RAC, SQL Server AOAG, Cache Mirroring, or other HA/ DR/ Mirroring / Clustering database technologies.

  • Familiarity with Cloud platforms (Microsoft Azure, VMware vCloud, Amazon Web Services, etc.

  • Demonstrated experience with at least ONE of the following DBMS: Oracle, SQL Server, Epic (Inersystems) Cache.

Working Conditions and Physical Demands

Employee must be able to meet the following requirements with or without an accommodation.

  • This is a sedentary position that may exert up to 10 pounds and may lift, carry, push, pull or otherwise move objects. This position involves sitting most of the time and is not exposed to adverse environmental conditions.

Physical Requirements

Carrying, Climbing, Color Determination, Crawling, Far Vision, Lifting, Listening, Manual Dexterity, Near Vision, Non Indicated, Pulling and/or Pushing, Reaching, Sitting, Speaking, Standing, Stooping and Crouching, Tasting or Smelling, Walking

EEO Statement

The University of Utah Health Care is an Affirmative Action/Equal Opportunity employer. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities. The University of Utah Health Care is committed to diversity in its workforce. Women and minorities are encouraged to apply.

Requisition Number 45780
Reg/Temp Regular
Employment Type Full-Time
Shift Day
Work Schedule 8-5
Location Name Information Technology Services
Patient Care? No
City SALT LAKE CITY
State UT
Department COR ISC 17A ENTERPRISE SYSTEMS
Category Information Technology

The University of Utah Health Care is an Affirmative Action/Equal Opportunity employer. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities. The University of Utah Health Care is committed to diversity in its workforce. Women and minorities are encouraged to apply.