Database Administrator II

The University of Kansas Health System•Shawnee Mission, KS

About The Position

This is a DBA II role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems. This DBA II role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.

Requirements

High School Graduate
8 or more years Database Administrator experience with SQL 2012, SQL 2014 and SQL 2016 in a production environment, or Epic Intersystems Cache Database server.
Database Administration experience such as SQL or Intersystems Cache Database server.
Experience with AIX and Windows server platform.
Fluent English - Read, write, understand and speak English
SQL Business Intelligence, SQL Analysis Services, SQL Reporting or Integration Services, SQL Always On technologies.
SAP Business Objects.
Familiarity with Data-warehousing concepts.
EPIC Chronicles.

Nice To Haves

Bachelors Degree Computer Science or related field.
Experience in hospital or Healthcare environment.
Experience with UNIX, AIX or Linux OS.
One of the following: Certification on SQL Server or Cache database technology.

Responsibilities

Competent in the areas of critical thinking, interpersonal relationships, and technical skills.
Coaches and mentor new associates.
Assists with Environment planning and management.
Participates in installations, tests, and implementations of system hardware, software, maintenance releases, and utilities.
Participates in timely resolution of all database technical questions, analysis, problems, incidents, requests, and on-call.
Monitors database alerts, replication, resource utilization, and system integrity.
Analyzes database failures and identifies corrective action.
Analyzes system performance to ensure it is meeting availability and performance objectives.
Audits application, database, operating system, and HA logs.
Performs and monitors database backups.
Participates in Disaster Recovery and High Availability events.
Performs planned Disaster Recovery Plan tests and database restores.
Performs implementation of projects and configuration changes.
Performs application testing and validation.
Evaluates Upgrade and Update Release Notes.
Performs application upgrades and updates.
Monitors SLAs including, backup, uptime, and recoverability objectives.
Ensures compliance with Database licensing.
Proactively manages all aspects of the responsibilities listed above.
Performs other responsibilities as needed.
Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.