Database Administrator II

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

Job summary

Kansas Health System, Broadmoor Campus, seeks a Database Administrator II to manage operational database services and ensure SLA-driven incident resolution. You will own incidents, monitor backups and performance, and coordinate with engineering for strategic fixes.

The role requires 8+ years in SQL Server with production experience, knowledge of AIX/Windows, and familiarity with EPIC Chronicles and data warehousing concepts. Fluency in English is required.

Qualifications

• 8+ years Database Administrator experience with SQL Server in a production environment or Epic Intersystems Cache.
• Experience with SQL Server tools and data maintenance practices.
• Experience on AIX and Windows server platforms.

Responsibilities

• Coaches and mentors new associates.
• Monitors database alerts, replication, resource utilization, and system integrity.
• Performs and monitors database backups.
• Participates in Disaster Recovery and High Availability events.
• Performs planned DR tests and database restores.
• Performs application upgrades and updates.
• Ensures compliance with Database licensing.

Skills

SQL Server DBA

Database performance

Incident management

Production environment

Epic Cache

Education

High School Graduate

Bachelor's Degree in Computer Science

Tools

SAP Business Objects

EPIC Chronicles

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