Epic Database Administrator Operational

POSITION SUMMARY

The Operational Database Administrator is responsible for creating, managing, and maintaining the Operational Database (ODB) environments that support production, reporting, disaster recovery, training, and non-production needs. This role involves installing and managing administrative and monitoring tools to ensure high availability and performance of the Epic system. The administrator will regularly assess performance metrics, monitor system health, and troubleshoot any issues to optimize database efficiency. Additionally, the role includes managing user logins and access configurations, applying IRIS and Epic updates and upgrades across production and non-production environments, and configuring environment copies based on strategic needs. The DBA will also participate in capacity planning to ensure sufficient system resources, respond to emergency or after-hours issues, and collaborate with technical teams and Epic for proactive support. Other responsibilities include writing and maintaining automation scripts, participating in change control processes, maintaining business continuity plans, and ensuring compliance with Epic and vendor best practices for hardware and software configurations. This position requires strong problem-solving skills, the ability to handle critical database issues, and a deep understanding of Epic system management and database administration. Off-hours work and participation in on-call rotation are required.

MINIMUM REQUIREMENTS

Education:

1. Bachelor’s degree in Information Technology or equivalent combination of education and experience.

Experience:

1. Two or more years of Linux/Unix experience or Linux/Unix certification preferred.
2. Strong Unix skills using the command‐line prompt, including navigating directory structures and file manipulation
3. Understanding of operating system concepts such as user and group ownership and file permissions, file system/volume group configuration, etc.
4.  Knowledge of a command shell ﴾Korn, POSIX, Bourne, or C﴿, plus languages and utilities such as awk, sed, and Perl
5.  Ability to create, understand, and follow processes to ensure successful execution of critical maintenance procedures

Knowledge, Skills, Abilities:

1. Knowledge of system development methodology and principles of project management.
2. Ability to analyze and solve problems.
3. Technical knowledge and understanding of clinical systems.
4. Ability to communicate effectively with staff.
5. Ability to set priorities and manage time effectively.

License/Certification/Registration:

None required

SUPERVISION RECEIVED

Receives minimal supervision from the Manager, Infrastructure & Cyber Security.

SUPERVISION GIVEN

None

ESSENTIAL FUNCTIONS

1. Creating and managing the ODB environments that serve production, reporting, disaster recovery, training, and non‐production needs
2. Installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of your Epic system
3. Understanding performance metrics, monitoring system performance, and troubleshooting issues
4. Managing the logins for different types of access, including login behavior and working environment configuration
5. Applying IRIS and Epic upgrades and updates to production and non‐production environments
6. Configuring and maintaining environment copies according to the environment strategy
7. Responding to emergency and after‐hours issues
8. Engaging in capacity planning exercises to ensure adequate system resources
9. Collaborating with your technical teams and Epic to ensure proactive support
10. Writing and maintaining scripts to improve system management tasks
11. Participating in your change control process for all planned application and technical activities
12. Maintaining and testing processes related to business continuity
13. Following vendor and Epic best practices for hardware and software configuration

NON-ESSENTIAL FUNCTIONS

Performs related and miscellaneous duties as assigned.