Database Administrator III

The University of Kansas Health System; Lenexa (KS); On-site; USD 90,000 - 120,000; Full time

Job summary

The University of Kansas Health System is seeking a Database Administrator III to design, implement, monitor, and maintain enterprise databases at Broadmoor Campus. You will lead standards for performance, data integrity, and recoverability while collaborating with Data Architecture, BI, Software Engineering, and Data Warehousing teams.

The role requires extensive SQL Server experience, on-call support, and expertise with AIX and Windows Server platforms.

Qualifications

• 12 years of Database Administrator experience in production environments with SQL 2012–2016.
• Experience with SQL Always On technologies.
• Experience with AIX and Windows server platforms.
• Fluent English in reading, writing, and speaking.

Responsibilities

• Design, develop, implement, monitor, and maintain databases.
• Lead in standards and procedures for performance, data integrity and recoverability.
• Install patches, upgrades, and modify database objects.
• Monitor alerts, replication, and resource utilization; ensure uptime.

Skills

SQL Always On

AIX

Windows Server

English fluency

Education

High School Diploma

Bachelor's degree in Computer Science or related field

Master’s Degree Computer Science or related field

Tools

EPIC Chronicles

SAP Business Objects

SQL Server / Cache certification

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

Time Type:

Full time

Job Requisition ID:

R-58793

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