Database Administrator III

Kansas Health System; Kansas; On-site; USD 90,000 - 120,000; Full time

Job summary

Kansas Health System is seeking a Database Administrator III at Broadmoor Campus to lead design, deployment, and maintenance of large databases. You will set standards for performance, data integrity, and recoverability, collaborating with Architecture, BI, and Software teams. Strong VLDB experience and leadership are essential.

You will handle on-call support, patches, backups, and high availability planning while mentoring junior staff and documenting procedures. Fluency in English is required.

Qualifications

• Twelve years of Database Administrator experience with SQL 2012-2016 in production environments or Epic Intersystems Cache.
• Experience with SQL Always On technologies.
• Experience with AIX and Windows server platforms.
• Familiarity with data warehousing concepts and BI tools.
• Certification on SQL Server or Cache is preferred.

Responsibilities

• On-call support for Priority I and II issues.
• Install patches and upgrades to databases.
• Create and modify database objects.
• Export, Transform, and Load data (ETL).
• Monitor alerts, performance, replication, and resource usage.
• Forecast and budget database resources and licenses.
• Ensure licensing compliance and backup integrity.
• Perform backups, recoveries, and database tuning.
• Plan high availability and document changes.

Skills

SQL concepts

Data warehousing

Performance tuning

ETL processes

Education

Bachelor's Degree in Computer Science or related field

Master's Degree in Computer Science or related field

Tools

SQL Server

Cache database

AIX

Windows Server

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

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.