University of Utah Health Care

Returning Candidate?

Database Administrator III - Enterprise Systems

Database Administrator III - Enterprise Systems

Requisition Number 
27617
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

More information about this job

Overview

As a patient-focused organization, the University of Utah Health Care 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 Care 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.

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 identify 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.
  • Install, configure, and document database software according to best practices as required.
  • Add, remove, or update 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.
  • Triage and remediate reported problems, determine root cause, and design 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.

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.
  • Five 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.

We are University of Utah Health. healthcare.utah.edu

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