Database Administrator II

The University of Kansas Health System; Mission (KS); On-site; USD 85,000 - 110,000; Full time

Job summary

The University of Kansas Health System is seeking a Database Administrator II for Broadmoor Campus to deliver reliable database services, resolve incidents, and ensure SLA compliance. Responsibilities include monitoring backups, performance, outages, and coordinating with engineering for optimization.

Ideal candidates will have a high school diploma with extensive DBA experience, and a bachelor’s degree in computer science is preferred.

Qualifications

• Fluent English - read, write, speak.
• Experience with SQL Server or Intersystems Cache in production.
• Experience on AIX and Windows server platforms.

Responsibilities

• Provide operational database services and resolve incidents within SLAs.
• Monitor backups, maintenance, replication, and performance for availability.
• Coordinate with database engineering for strategic fixes and upgrades.
• Maintain communication with technology customers and on-call support.

Skills

Fluent English

SQL Server

Intersystems Cache

AIX / LinuxOS

Education

Bachelor's degree in Computer Science

High School Diploma

Tools

EPIC Chronicles

SAP Business Objects

SQL Server

Job description

Position Title Database Administrator II Broadmoor Campus

Position Summary / Career Interest: 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.

Responsibilities and Essential Job Functions

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

These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

Required Education and Experience

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

Preferred Education and Experience

• Bachelors Degree Computer Science or related field.
• Experience in hospital or Healthcare environment.
• Experience with UNIX, AIX or Linux OS.

Preferred Licensure and Certification

• One of the following: Certification on SQL Server or Cache database technology.

Required Language Skills

• Fluent English - Read, write, understand and speak English
• Knowledge Requirements 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.

Time Type: Full time

Job Requisition ID: R-52545

Important information for you to know as you apply

The health system is an equal employment opportunity employer. Qualified applicants are considered for employment without regard to race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, ancestry, age, disability, veteran status, genetic information, or any other legally-protected status. See also Diversity, Equity & Inclusion. The health system provides reasonable accommodations to qualified individuals with disabilities.

Employment with the health system is contingent upon, among other things, agreeing to the health-system-dispute-resolution-program.pdf and signing the agreement to the DRP.

About The University of Kansas Health System

As part of the region’s premier academic medical center, The University of Kansas Health System in Kansas City is a world-class healthcare provider and destination for complex care and diagnosis.

We are driven by our commitment to service, continuous improvement and to the highest degree of excellence. Collaboration between physicians, nurses, researchers, educators and other professionals who share their expertise leads to exciting discoveries and life-changing treatments for the people we serve.