Database Administrator III

The University of Kansas Health System; United States; On-site; USD 110,000 - 150,000; Full time

Job summary

The University of Kansas Health System in Kansas City is seeking a Database Administrator III for Broadmoor Campus to lead the design, deployment, and maintenance of large-scale databases and VLDB projects. You will drive standards, performance, data integrity and recoverability while collaborating with Data Architecture, BI, Software Engineering and Data Warehousing teams.

The role requires extensive SQL Server/Cache experience, Always On, AIX/Windows, and strong English communication.

Qualifications

• High School Diploma and 12 years of DBA experience with SQL 2012–SQL 2016 in production.
• Experience with SQL Always On technologies and with AIX/Windows server platforms.
• Fluent English and knowledge of SQL BI, SSAS, SSRS or SSIS, and EPIC Chronicles.

Responsibilities

• Lead design, development, implementation, monitoring and maintenance of databases.
• Develop standards and procedures to maximize performance, integrity and recoverability.
• Monitor alerts, performance, replication, backups, and uptime objectives.
• Plan and implement high availability; participate in change control and documentation.
• Mentor and coach junior DBAs; collaborate with BI, data warehousing and software teams.

Skills

Fluent English

SQL/BI

SQL Server

Cache database

EPIC Chronicles

SAP Business Objects

Data warehousing concepts

AIX

Windows Server

Education

High School Diploma

Bachelors Degree Computer Science or related field

Masters Degree Computer Science or related field

Tools

SQL Server

Cache database

Job description

Position Title

Database Administrator III Broadmoor Campus

Position Summary / Career Interest

The DBA III will participate in the design, development, implementation, monitoring, and maintenance of new and existing databases. The position will also lead in the development of standards and procedures to maximize performance, data integrity and recoverability. The ideal candidate is team oriented, experienced in the design and deployment of complex and very large databases (VLDB). The DBA III is the subject matter expert on database technologies and will work closely with Data Architecture, Business Intelligence, Software Engineering and Data Warehousing teams.

Responsibilities and Essential Job Functions

• Competent in the areas of critical thinking, interpersonal relationships, and technical skills.
• On Call and supports DBA's during Priority I and II issues.
• Database installation, patches, and upgrades.
• Creates and modifies database objects.
• Export, Transforms, and Loads data.
• Monitors Database Alerts, Performance, Replication, and Resource Utilization.
• Assist with Forecasting and Budgeting for Database Resources and Licenses.
• Ensures compliance with Database licensing.
• Validate integrity of database objects.
• Audits database, operating system, ETL, and HA logs.
• Performs and monitors database backups.
• Validates backup plans to ensure they meet stated recoverability goals.
• Performs database recovery.
• Provides analysis of database failures and identifies corrective action.
• Performs database tuning.
• Ensures databases meet stated uptime objectives.
• Plans and implements database high availability when needed.
• Documents database modifications according to Change Control Policy.
• Develops and documents tools, scripts, and processes.
• Develops and reviews documentation for database functionality.
• Review changes made by DBA I and DBA II and assist with peer review of changes.
• Highly skilled with new database version and functionality.
• Facilitates knowledge transfer of database skills to team members.
• Coaches and mentors new associates.
• Assists with application evaluation and implementation.
• Assists with application testing and validation.
• Assists programming staff in script tuning programs to access data efficiently.
• Environment planning and management.
• Advising Leadership/Executives of Technology Trends.
• Able to independently resolve most issues that may arise.
• Creation of database SLAs and verification that databases have met existing SLAs including backup, uptime and recoverability.
• Independently and proactively manages all aspects of the responsibilities listed above.
• 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
• Twelve (12) years of Database Administrator experience with SQL 2012 – SQL 2016 in a production environment or Epic Intersystems Cache Database server.
• Experience with SQL Always On technologies.
• Experience with AIX and Windows server platform.

Preferred Education and Experience

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

Preferred Licensure and Certification

• 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. SAP Business Objects. Familiarity with Data-warehousing concepts. EPIC Chronicles
• Time Type: Full time

Equal Employment Opportunity Statement

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.

If you need to request reasonable accommodations for your disability as you navigate the recruitment process, please let our recruiters know by requesting an Accommodation Request form using this link [e-mail].

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.