Epic Database Administrator (Clarity & Caboodle)

Job Posting Title:

----

Hiring Department:

----

Position Open To:

----

Weekly Scheduled Hours:

----

FLSA Status:

----

Earliest Start Date:

----

Position Duration:

----

Location:

----

Job Details:

The Epic Database Administrator is responsible for the design, implementation, optimization, and maintenance of SQL database environments supporting Epic's reporting and data warehouse systems, such as Clarity and Caboodle, which are integral components of the broader Epic electronic health record (EHR) ecosystem. Reporting to the Manager of Enterprise Decision Support, this role ensures the integrity, security, and availability of data across development, test, and production environments. The Epic Database Administrator collaborates closely with Epic analysts, infrastructure teams, and clinical informatics staff to support data-driven decision-making and operational efficiency.

Administers and Maintains Epic Reporting and Data Warehouse Databases

• Installs, configures, and maintains SQL databases supporting Epic modules, such as Clarity (reporting) and Caboodle (data warehousing).

• Ensures successful execution of nightly ETL processes from database systems, (e.g., Epic Chronicles) to Epic reporting and warehouse systems, including Clarity and Caboodle.

• Applies upgrades, patches, and performance tuning to maintain optimal performance.

• Troubleshoots and resolves database-related issues across development, test, and production environments.

Ensures Data Security, Integrity, and Compliance

• Defines and enforces database security policies and access controls.

• Implements encryption, backup, and recovery protocols to safeguard sensitive data.

• Monitors for unauthorized access and potential vulnerabilities.

• Ensures compliance with organizational policies and IT configuration guidelines.

Supports Disaster Recovery, Business Continuity, and Performance Optimization

• Develops and tests disaster recovery and business continuity plans.

• Ensures high availability and resilience of database services.

• Monitors performance metrics and usage trends, resolving bottlenecks and inefficiencies.

• Automates recurring workflows to improve operational efficiency.

Collaborates with Cross-Functional Teams and Participates in Projects

• Works closely with Epic analysts, clinical informatics, and infrastructure teams.

• Serves as a technical resource on Epic-related projects and initiatives.

• Applies project management principles to support deliverables and timelines.

• Communicates technical issues and solutions to both technical and non-technical stakeholders.

Designs and Implements Scalable Database Solutions

• Creates database architectures aligned with academic and business objectives.

• Adds new tables and columns to ETL extracts as needed.

• Supports integration with other reporting and analytics platforms.

Prepares and Maintains Comprehensive Documentation

• Develops and updates documentation for disaster recovery plans, licenses, warranties, and contracts.

• Maintains inventories, life cycle plans, project plans, and customer road maps.

• Documents technical specifications and contributes to planning efforts.

Marginal or Periodic Functions:

• Participates in Epic upgrade cycles, system migrations, and platform transitions.

• Conducts peer reviews of database configurations and ETL processes.

• Provides mentorship or training to junior staff or interns.

• Engages in professional development and certification renewal.

• Supports audits and compliance reviews as needed.

• Performs related duties as required.

KNOWLEDGE/SKILLS/ABILITIES

Technical Learning

• Quickly learns and applies new technical skills and tools.

• Adapts to evolving database technologies and Epic system updates.

• Applies new features in SQL Server or other platforms.

• Stays current with healthcare data architecture and standards.

Problem Solving

• Uses logic and analysis to solve complex technical issues.

• Diagnoses and resolves ETL failures.

• Identifies root causes of performance issues.

• Applies structured troubleshooting across environments.

Drive for Results

• Consistently delivers high-quality outcomes and meets goals.

• Ensures data pipelines run successfully and on time.

• Maintains system uptime and performance standards.

• Meets project milestones and technical deliverables.

Collaborates

• Works effectively with others to achieve shared goals.

• Partners with clinical and technical teams.

• Communicates clearly across disciplines.

• Supports cross-functional planning and execution.

Planning

• Scopes out tasks and projects accurately.

• Develops lifecycle and disaster recovery plans.

• Forecasts resource needs for database growth.

• Aligns upgrades with organizational timelines.

Organizational Agility

• Understands how to navigate formal and informal structures.

• Coordinates with clinical and administrative departments.

• Aligns database strategies with institutional priorities.

• Navigates IT governance and policy compliance.

Bachelor's degree in Computer Science, Information Systems, or a related field. 3 years of experience as a Database Administrator or in database design, implementation, and maintenance, with experience supporting Epic or other healthcare enterprise systems. Experience in an academic medical center, healthcare or similar regulated environment. Strong understanding of data security and integrity principles. Experience with disaster recovery and business continuity planning for databases. Relevant education and experience may be substituted as appropriate. Relevant education and experience may be substituted as appropriate.

Master's degree in Computer Science, Information Systems, or a related field. 5+ years of experience in healthcare database administration, with advanced knowledge of Epic modules and SQL performance optimization.

$90,000+ depending on qualifications

Standard office conditions

• Resume/CV

• 3 work references with their contact information; at least one reference should be from a supervisor

• Letter of interest

Importantfor applicants who are NOT current university employees or contingent workers:You will be prompted to submit your resume the first time you apply, then you will be provided an option to upload a new Resume for subsequent applications. Any additional Required Materials (letter of interest, references, etc.) will be uploaded in the Application Questions section; you will be able to multi-select additional files. Before submitting your online job application, ensure thatALLRequired Materials have been uploaded. Once your job application has been submitted, you cannot make changes.

Important for Current university employees and contingent workers:As a current university employee or contingent worker, you MUST apply within Workday by searching for Find UT Jobs. If you are a current University employee, log-in to Workday, navigate to your Worker Profile, click the Career link in the left hand navigation menu and then update the sections in your Professional Profile before you apply. This information will be pulled in to your application. The application is one page and you will be prompted to upload your resume. In addition, you must respond to the application questionspresented to upload any additional Required Materials (letter of interest, references, etc.) that were noted above.

----

Employment Eligibility:

----

Retirement Plan Eligibility:

----

Background Checks:

A criminal history background check will be required for finalist(s) under consideration for this position.

----

Equal Opportunity Employer:

The University of Texas at Austin, as an equal opportunity/affirmative action employer,complies with all applicable federal and state laws regarding nondiscrimination and affirmative action. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, or veteran status in employment, educational programs and activities, and admissions.

----

Pay Transparency:

The University of Texas at Austin will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.

----

Employment Eligibility Verification:

If hired, you will be required to complete the federal Employment Eligibility Verification I-9 form. You will be required to present acceptable and original documents to prove your identity and authorization to work in the United States. Documents need to be presented no later than the third day of employment. Failure to do so will result in loss of employment at the university.

----

E-Verify:

The University of Texas at Austin use E-Verify to check the work authorization of all new hires effective May 2015. The university's company ID number for purposes of E-Verify is 854197. For more information about E-Verify, please see the following:

• E-Verify Poster (English and Spanish) [PDF]
• Right to Work Poster (English) [PDF]
• Right to Work Poster (Spanish) [PDF]

----

Compliance:

Employees may be required to report violations of law under Title IX and the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act). If this position is identified a Campus Security Authority (Clery Act), you will be notified and provided resources for reporting. Responsible employees under Title IX are defined and outlined in HOP-3031.

The Clery Act requires all prospective employees be notified of the availability of the Annual Security and Fire Safety report. You may access the most recent report here or obtain a copy at University Compliance Services, 1616 Guadalupe Street, UTA 2.206, Austin, Texas 78701.