Database Administrator
Job Code: 1792

Position Summary:
The Database Administrator researches, designs, implements and maintains databases of moderate to high complexity, affecting multiple departments or entities. Database Administrator is accountable for the 24x7 availability of mission critical production environments and all aspects of administration for non-production environments. Ensures availability and performance of the databases that support customer's applications, proactively monitors the database systems to establish secure services with minimum downtime, gathers technical requirements and implements various database patches to support their database requirements, and assists with the planning, implementation, integration, and maintenance of the hardware and software infrastructure supporting a wide variety of applications. Resolves production problems and assist users with issues beyond what front-line support can resolve.

INTEGRIS Health is an Equal Opportunity/Affirmative Action Employer.
Essential Functions:
The Database Administrator responsibilities include, but are not limited to, the following:

* Ensures accuracy and integrity of data and applications through proper execution of loading and maintenance of quality assurance protocols.

* Analyzes information problems, requested changes, and required modifications to develop appropriate business process solutions

* Leads and contributes to design discussions in a cross-functional project setting including capacity planning for compute and storage requirements while assisting with project estimation

* Installs, maintains, configures and upgrades database server and management tools

* Designs and delivers documented database solutions, which often require complex system integration, following established standards, guidelines, and configuration according to best practice

* Provides support to staff and vendors involved in the deployment, installation of applications as projects move from design and planning to operational status and functions as a team member in all development and implementation efforts.
Accountability:
Reports to the department Manager or Director.
Required Physical Demands (Subject to Reasonable Accommodation):
Keyboarding/Dexterity: Frequently; activity exists from 1/3 to 2/3 of the time
Standing/Walking: Occasionally; activity exists up to 1/3 of the time
Strength (Lift/Carry/Push/Pull): Sedentary (exerting up to 10 pounds of force occasionally)
Talking (Must be able to effectively communicate verbally): Yes
Seeing: Yes
Hearing: Yes
Color Acuity (Must be able to distinguish and identify colors): No
This position may have additional or varied physical demand and/or respiratory fit test requirements. Please consult the Physical Demands Project SharePoint site or contact Risk Management/Employee Health for additional information.
Environmental Conditions:
Normal office environment.
When working in clinical areas, potential for exposure to infections and communicable diseases, blood and body fluids, electrical equipment, and chemicals. Must follow standard precautions.

All applicants will receive consideration regardless of membership in any protected status as defined by applicable state or federal law, including protected veteran or disability status.

Qualifications:

* Masters degree preferred, or Bachelors degree with 2 years experience, or Associates degree with 4 years experience, or 6 years experience.

* Previous work experience working in a large enterprise environment supporting operational database(s) is preferred.

* Previous work experience in programming constructs and structures.

* Previous work experience with management platform knowledge and remote monitoring preferred.

* ITIL Foundation Certification within 6 months of hire.

* Must have one or more of the following specialties: SQL, Cache, Cogito/Clarity/Caboodle/SAP, or ERP DBA.

* Must be able to communicate effectively in English (Verbal/Written).

SQL Database Administrator:

* Intermediate level certification (examples include RHCSA, CCNA, MCSA, MTA DB, VCP, VCAP, VCDX, CWNA, EMCSA, ACIS, CCP etc.) or intermediate level database certification (4 years experience in programming and/or database analysis, physical database schema design and support may be substituted for the certification requirement).

* Previous work experience with Microsoft Windows server administration or training.

* Previous work experience administering SQL Database server environments.

* Previous work experience scripting on Microsoft Windows using Powershell preferred.

Cache Database Administrator:

* Previous work experience with RedHat Linux (RHEL) shell commands, privilege escalation, file and user permissions.

* Previous work experience writing and maintaining scripts to improve system management tasks.

* Previous work experience applying Cache and Epic upgrades and updates to production and non-production environments preferred.

* Previous work experience configuring and maintaining Epic environment copies according to environment strategy preferred.

* Epic Certification as Cache DBA within 6 months of attending first class.

Cogito/Clarity/Caboodle/SAP BI Administrator:

* All additional requirements for SQL Database Administrator.

* Previous work experience in writing SQL.

* Previous work experience in SAP Business Objects administration preferred.

* Previous work experience modifying ETL processes to meet organizational reporting requirements preferred.

* Certification as Epic Cogito/Clarity/Caboodle/SAP DBA within 6 months of attending first class.

ERP DBA:

* Previous work experience with Performance Tuning.

* Industry certifications (Oracle PL/SQL, MS MCA, etc) preferred.

* Previous work experience scripting on AIX, Windows, and UNIX/Linux x using Shell, Perl, or Powershell preferred.

* Previous work experience installing and administering PeopleSoft FSCM/HCM preferred.

* Previous work experience in the use of RMAN and other DR tools preferred.

* Previous work experience with PL/SQL preferred.

* Previous work experience administering and maintaining databases on AIX, MS Windows, or RHEL preferred.


Safety and Quality DBA:
Previous work experience preferred utilizing:
o RLDatix Event Management System
o PolicyStat Policy Management System
o Leading Wisely - HealthCatalyst DOS-MART
o The Joint Commission Performance Measurement Program - ORYX
o Inpatient Payment Prospective System (IPPS)
o Outpatient Quality Reporting Program (OQR)
o Medisolv / IBM / Watson Health
o Epic EHR
o Cesia