Epic Database Administrator

Title: Epic Database Administrator

Location: Remote / EST / CST

Hours: 40 hours per week - Monday through Friday in east coast hours. Will require on-call work and occasional (around once per month) off hours/overnight work.

What to Look For: Seek a senior-level Epic Database Administrator with a bachelor's degree and active certifications in Epic ODBA, ECSA, Data Courier, or Chronicles, backed by at least eight years of relevant experience including Epic ODBA/ECSA. The ideal candidate should have hands-on expertise managing Microsoft SQL Server environments (on-premises and cloud), designing high-availability and disaster recovery solutions, and performing performance tuning and security compliance. Strong knowledge of Cache databases, Epic Windows applications, and Linux/Windows operating systems is essential, along with experience leading an ECSA/ODBA team, managing on-call rotations, and handling build migrations and critical-call event management. Preferred extras include Clarity certification and exposure to storage, cloud, security, and networking infrastructure. Look for someone who combines deep technical skill with mentorship ability, cross-team collaboration, project management, and clear communication and who is comfortable with remote work, EST/CST hours, occasional overnight/on-call work, and up to 10% travel.

Location: Fully Remote may require up to 10% travel for training, events, etc.

Job Profile Summary

This role focuses on the design, development, and implementation of information technology (IT) solutions in order to meet the organization's needs through new and existing applications, systems architecture, network systems and applications infrastructure and the management of the IT infrastructure. In addition, this role focuses on performing the following Analytics related duties: Performs complex data research and analysis to support business operations, creates data mining architectures/models/protocols, statistical reporting, and data analysis methodologies to identify trends in large data sets, researches and applies knowledge of existing and emerging data science principles, theories, and techniques to inform business decisions, and may conduct scientific research projects with the goal of breaking new ground in data analytics. A professional individual contributor role that may direct the work of other lower-level professionals or manage processes and programs. The majority of time is spent overseeing the design, implementation, or delivery of processes, programs and policies using specialized knowledge and skills typically acquired through advanced education. A senior level role that requires advanced knowledge of job area typically obtained through advanced education and work experience. Typically, responsible for: managing projects / processes, working independently with limited supervision, coaching and reviewing the work of lower-level professionals, resolving difficult and sometimes complex problems.

Job Overview

This position designs, installs, maintains, troubleshoots and optimizes database instances for departmental and enterprise-wide systems that provides a cutting-edge high-visibility and high-availability healthcare IT ecosystem to physicians, patients and employees. Evaluates and integrates new database system versions, drivers, and hardware. Provides technical expertise for system transitions, migrations, and consolidations. Manages physical, virtual, and cloud-based operational databases.

Minimum Qualifications:

• Bachelor s degree.
• Certifications in Epic ODBA, Epic ECSA, Data Courier Certification, or Chronicles Certification.
• Eight (8) years of relevant experience including Epic ODBA/ECSA.

Preferred Qualifications:

• Clarity Certification(s).
• Experience with storage systems, cloud services, security and networking infrastructure. RedHat Linux Administration

Duties and Responsibilities: The duties and responsibilities listed below are intended to describe the general nature of work and are not intended to be an all-inclusive list. Other duties and responsibilities may be assigned.

• Accountable for contributing to the technical architecture and supporting the day-to-day operations, support and management of the cloud hosted healthcare application ecosystem.
• Leads staff and sets project goals, requirements, and schedules.
• Leads and coordinates the work of the Epic ECSA/ODBA team.
• Supervises and performs the installs, upgrades, maintenance and support database software and Windows related applications on selected server platforms and ensures license compliance.
• Manages storage associated with databases and assists system administrators with storage allocation and planning related to the database.
• Monitors, optimizes and troubleshoots the performance of database instances and applications in a networked environment.
• Designs and implements viable database backup, recovery, and high availability strategies and mechanisms.
• Creates, maintains and ensures documentation of team processes and procedures, including operating manuals or training materials for internally managed databases and systems.
• Executes database recovery, restoration, and/or restart as required.
• Monitors and optimizes database instance using database administration tools, SQL scripts, and database utilities.
• Monitors and configures database parameters accordingly.
• Defines and implements database parameters, security, audit, and resource allocation policies and procedures.
• Defines, creates, and manages user accounts, profiles, privileges, roles, and required audit information.
• Designs, implements and performs data extraction, data load, data conversion and interfacing and database synchronization routines and functions.
• Communicates and coordinates with other teams (Linux, Oracle, Windows, Network, SAN etc.) related to database, application and environment support and projects.
• Keeps abreast of current and emerging database trends/technologies.
• Attends training and educational seminars as required.
• Provides technical expertise to outside vendors, contractors, EIS management and other EIS staff as needed.
• Provides on-call support for the ECSA/ODBA team (24/7 weekly rotation.)
• Mentors and supports ECSA/ODBA team members during their on-call rotations when assigned.
• Participates and offers expertise in critical-call event management.
• Manages the on-call rotation of ECSA/ODBA staff members.
• Maintains version control, administration of scripts for file manipulation and programming access to multiple environments.
• Responsible for daily build migrations working closely with application and change teams.
• Analyze and troubleshoot migration issues and mitigate the fixes and resolutions.
• Conducts cross-team training and lessons learned sessions.
• A SQL Server DBA manager handles the design, implementation, maintenance, and security of an organization's SQL Server databases, ensuring optimal performance, availability, and data integrity.
• Database Infrastructure Management: Install, configure, patch, and upgrade Microsoft SQL Server environments on both on-premises and cloud platforms .
• Performance Monitoring and Tuning: Proactively monitor database health and performance, identify bottlenecks, and implement optimization strategies such as query tuning, indexing, and capacity planning.
• High Availability & Disaster Recovery: Design, implement, and test backup and recovery procedures and high-availability solutions (e.g., Always On Availability Groups, log shipping, clustering) to meet business RPO/RTO objectives and ensure business continuity.
• Security and Compliance: Implement security measures, manage user access and permissions, enforce security policies, conduct audits, and ensure compliance with relevant data protection regulations.

Physical Requirements:

• Professional office environment with typical office requirements such as computers, phones, photocopiers, filing cabinets, etc.
• This is largely a sedentary role, which involves sitting most of the time, but may involve movements such as walking, standing, reaching, ascending / descending stairs and operate office equipment.
• Frequently required to speak, hear, communicate and exchange information.
• Able to see and read computers displays, read fine print, and/or normal type size print and distinguish letters, numbers and symbols.
• Occasionally lift and/or move up to 25 pounds.
• Ability to work in confined or open environments.
• Ability to work independently or in a team environment.

Skills & Abilities:

• Ability to communicate technical, complex issues in simple terms.
• Knowledge of technical product roadmaps and determines support requirements.
• Team orientation and proven ability to work across boundaries up and down the organization.
• Innovative problem-solving skills and excellent written, briefing, and communication skills.
• Advanced knowledge of industry standards and audit requirements.
• Working knowledge of patient care databases and financial and administrative database applications.
• Working knowledge of monitoring, tuning, and administration of Cache databases and Epic Windows applications.
• Knowledge of Linux and Windows.
• Strong skills in prioritizing workloads, meeting deadlines, managing several broad-scope projects at one time, and utilizing time effectively for staff and self.
• Strong interpersonal skills in dealing effectively with diverse skill sets and personalities.
• Ability to provide mentorship, team leadership and work effectively as a team player.
• Project management skills for cross-team and internal projects.
• Knowledge of Linux and Windows operating systems and tools.
• Knowledge of latest Epic/Cache versions.
• Skilled in project management, systems, and database administration and integration, user relations and vendor interactions.