Database Administrator III

The University of Kansas Health System; Kansas; On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Job summary

The University of Kansas Health System is seeking a DBA III to design, develop, implement, monitor and maintain complex databases at the Broadmoor Campus in Kansas. You will lead standards to maximize performance, integrity and recoverability while collaborating with Data Architecture, BI, Software Engineering and Data Warehousing teams.

Ideal candidates have 12+ years of production DB experience (SQL 2012–2016 or EPIC Intersystems Cache), proficiency with Always On, AIX/Windows Server, and

Qualifications

• 12 years of Database Administrator experience in production environments (SQL 2012–2016 or Epic Intersystems Cache).
• Experience with SQL Always On technologies.
• Experience with AIX and Windows Server platforms.
• Fluent English language skills.

Responsibilities

• Design, develop, implement, monitor and maintain databases.
• Lead standards and procedures for performance, integrity and recoverability.
• Install patches, create/modify database objects and perform ETL.
• Monitor alerts, performance, replication and resource usage.
• Ensure backups and uptime SLAs; document changes.

Skills

SQL Server

SQL Always On

AIX

Windows Server

EPIC Chronicles

Data Warehousing

SSAS

SSRS

SSIS

SAP Business Objects

Education

Bachelor's Degree Computer Science or related field

Master's Degree Computer Science or related field

High School Diploma

Tools

Epic Intersystems Cache

Job description

Job ID: R-58793 Job Type: Full time Site Location: 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
• Validateintegrity 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

We are an equal employment opportunity employer without regard to a person’s race, color, religion, sex (including pregnancy, gender identity and sexual orientation), national origin, ancestry, age (40 or older), disability, veteran status or genetic information.