What are the responsibilities and job description for the Epic Database Administrator Cogito Clarity position at Mount Nittany Health?
POSITION SUMMARY
The Cogito/Clarity Database Administrator is responsible for configuring, maintaining, and optimizing the Cogito databases to align with the environment strategy. This role involves engaging in capacity planning to ensure sufficient system resources, monitoring database size and health, and creating and managing plans for statistics and index maintenance. A key aspect of the role is understanding performance metrics, monitoring system performance, and troubleshooting issues as they arise, including responding to emergency and after-hours situations. The administrator manages login configurations for different access levels and works on RDBMS upgrades and updates for both production and non-production environments. Additionally, the position involves performing regular database backups, verifying restores, and ensuring business continuity through thorough process maintenance and testing. The administrator is also responsible for installing and maintaining the necessary administrative and monitoring tools to ensure high availability and performance of the Epic system. Adhering to vendor and Epic best practices for hardware and software configuration is essential, and the administrator actively participates in change control processes for all planned technical activities. Collaboration with technical teams and Epic is crucial to ensure proactive and effective support. Off-hours work and participation in on-call rotation are required
MINIMUM REQUIREMENTS
Education:
- Bachelor’s degree in Information Technology or equivalent combination of education and experience.
Experience:
- RDBMS Certification REQUIRED (Preferably Microsoft SQL Server).
- Technically proficient in MS SQL Server analytical database platforms
- Working knowledge of the database operating systems.
Knowledge, Skills, Abilities:
- Knowledge of system development methodology and principles of project management.
- Ability to analyze and solve problems.
- Technical knowledge and understanding of clinical systems.
- Ability to communicate effectively with staff.
- 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
- Configuring and maintaining the Cogito databases according to the environment strategy
- Engaging in capacity planning exercises to ensure adequate system resources
- Monitoring database size and health
- Creating and managing plans for maintaining statistics and indexes
- Understanding performance metrics, monitoring system performance, and troubleshooting issues
- Responding to emergency and after ‐ hours issues
- Managing the logins for different types of access, including login behavior and working environment configuration
- Applying RDMS upgrades and updates to production and non ‐ production environments
- Performing database backups and verifying restores
- Maintaining and testing processes related to business continuity
- Installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of your Epic system
- Following vendor and Epic best practices for hardware and software configuration
- Participating in your change control process for all planned application and technical activities
- Collaborating with your technical teams and Epic to ensure proactive support
NON-ESSENTIAL FUNCTIONS
Performs related and miscellaneous duties as assigned.
