Active - Benefit Eligible and Accrues Time Off Work Hours per Biweekly Pay Period: 80.00
Shift: Onsite M-F with Call Rotation
Location: 210 South Florida Avenue Lakeland, FL
Pay Rate: Min $83,803.20 Mid $104,759.20Position Summary
The IS Epic Cache Database Administrator will be responsible for implementing and supporting Epic Database Solutions that take into account appropriate redundancy, availability, scalability, security and manageability requirements of Lakeland Regional Health's IS Department. This individual will be part of a team that is responsible for the technical strategy, vision, architecture and evolution of LRH's Epic implementation(s), infrastructure and ancillary technologies. This is a technical position providing analysis, configuration, maintenance, modification and monitoring of all Epic Caché and SQL databases. The ideal individual understands and supports best practices and requirements for data storage, database architecture, tuning, maintenance and reporting, ensuring hardware and software compatibility and optimization. This individual assists in and supports personnel in determining databases are available, backed up regularly, and can be restored. Participates in, and evaluates installations (server and database binaries), tests, and implementations of system hardware, clustering technologies, software, manufacturer's maintenance releases and utilities. Analyzes system performance to ensure it is meeting availability and performance objectives. Evaluates and recommends team personnel in resolution of hardware and operating system, and application software problems. Develops and maintains documentation on design specifications and system/software development life cycle for development projects.
Position Responsibilities
People At The Heart Of All That We Do - Fosters an inclusive and engaged environment through teamwork and collaboration.
- Ensures patients and families have the best possible experiences across the continuum of care.
- Communicates appropriately with patients, families, team members, and our community in a manner that treasures all people as uniquely created.
Safety And Performance Improvement - Behaves in a mindful manner focused on self, patient, visitor, and team safety.
- Demonstrates accountability and commitment to quality work.
- Participates actively in process improvement and adoption of standard work.
Stewardship - Demonstrates responsible use of LRH's resources including people, finances, equipment and facilities.
- Knows and adheres to organizational and department policies and procedures.
People At The Heart Of All We Do- Fosters an inclusive and engaged environment through teamwork and collaboration.
- Ensures patients and families have the best possible experiences across the continuum of care.
- Communicates appropriately with patients, families, team members, and our community in a manner that treasures all people as uniquely created.
Safety And Performance Improvement- Behaves in a mindful manner focused on self, patient, visitor, and team safety.
- Demonstrates accountability and commitment to quality work.
- Participates actively in process improvement and adoption of standard work.
Stewardship- Demonstrates responsible use of LRH's resources including people, finances, equipment and facilities.
- Knows and adheres to organizational and department policies and procedures.
Standard Work: IS Epic Cache Database Administrator- Implements, manages and maintains the Epic SQL Database infrastructure, including installing/upgrading and/or deploying Epic applications on servers and clients using Kuiper, and System Pulse. Installs database software (e.g. Oracle, SQL Server or InterSystems Caché)
- Manage and maintain Epic databases for Hyperspace, EPS, Web BLOB, Hyperspace Web, BCA, MyChart, Carelink\Healthy Planet, Haiku, Rover, Care Everywhere, Home Health, Kuiper, and System Pulse services
- Performs technical analysis, configuration, maintenance, modification and monitoring of databases on a variety of platforms including SQL, Cache, Windows Server OS and Linux
- Uses processes for monitoring performance of installed systems or services and takes corrective actions when necessary. Uses tools for capacity planning, reporting, and proactive problem solving. Screen and analyze application performance for potential bottlenecks, specify possible solutions, and act jointly with developers to apply those fixes
- Acts as a technical resource to evaluate evolving infrastructure technology and perform as a consultant interface to the business and clinical units for new company initiatives. Gather requirements from functional teams for their integrations with third party products
- Supports third party software implementation as a technical resource and maintains private and public cloud infrastructure
- Identify, repair, and resolve any Epic Database system hardware or software failures within the enterprise, in a timely manner and following company procedures and standards
- Evaluate applicable requirements to provide appropriate technical specifications and solutions for new and existing implementations
- Work closely with other departments, teams and engineers to build and troubleshoot system problems and software implementations
- Develops and maintains systems documentation and technical procedures, user guides and run-books
Competencies & Skills
Essential:
- Knowledge of database administration including analysis, architecture, configuration, maintenance, modification, monitoring, performance tuning and reporting. Primary support for Caché, MS SQL Server and Oracle databases
- Knowledge of data modeling, repository and warehousing concepts and best practices. Advanced knowledge of database development and reporting tools (i.e. Oracle Designer, Oracle Developer, PL/SQL, Crystal Enterprise/Crystal Reports, etc.)
- Knowledge of supported software development tools and programming languages (i.e. Visual Studio .NET, C# and/or VB.NET, ASP.NET, Web Services; Java and C++; PC and UNIX system administration)
- Proficiency in Windows operating system administration, engineering and hardening, 2012, 2016, 2019 and Windows 10. Microsoft SQL server administration to include high availability clustering
- Technically proficient, and aware of self-limitations with experience in one or more Epic technologies
Nonessential:
- Experience in Epic MyChart, Epic-Link, Epic Hyperspace Web, Epic interconnect servers, Epic FIPS servers, BCA and Web deployment, Kuiper, Haiku, and Canto Database Administration and Configuration
- Problem resolution, including ownership and communication through resolution
- Experience in a larger, highly available healthcare environment (500+ servers and multiple sites). Health Level 7 (HL7), ANSI and other healthcare system standards with knowledge of Health Care regulatory environment
- Understanding of computer and healthcare related concepts and vernacular with proficiency in oral and written communication
- Proven competence in troubleshooting and critical thinking skills. Problem resolution, including ownership through resolution specific to electronic health record (EHR) systems
Qualifications & Experience
Essential:
Nonessential:
Essential:
- Information Technology, Healthcare Administration, Information Management, or related field
Nonessential:
- Information Technology, Healthcare Administration, Information Management, or related field
Other information:
Experience Essential:
- Minimum three years of experience in IT infrastructure engineering to include: Inter-operational relationships of various infrastructure components, such as server systems, storage technology and software applications and database administration
- Engineering and administrative experience on Windows Servers 2012 and up, MS SQL, Cache, Oracle and related technologies
- Experience in administering a highly available and secure database environment
- Backup management, Disaster Recovery, vulnerability management, patch management and hot fixes on hardware, server OS and database applications
- Experience managing and maintaining an electronic health record (EHR) in a large hospital environment with the ability to document systems and write procedures for EHR system staff
Experience Preferred:
- Server Hardware management with Cisco UCS Systems and/or HP ProLiant Servers OneView
- Knowledge of enterprise system monitoring, log management and event analysis with an emphasis on performance tuning and application optimization
- Ability to work efficiently under pressure and make independent decisions. Ability to work independently under limited supervision and take initiative
- Certification in one or more of the following: Microsoft SQL Server, Cache, Linux Operating System, Epic MyChart, Epic-Link, Epic Hyperspace Web, Epic interconnect servers, Epic FIPS servers, BCA and Web deployment, Kuiper, Haiku, and Canto
- Problem resolution, including ownership through resolution
Certifications Essential:
- Microsoft Certified DBA, Cache Certified DBA
Certifications Preferred:
- Microsoft MCSE and one or more of: VMware VCP, Citrix CCEA or CCIA, Microsoft MCP, MCSA, or Other, Cisco CCNA, Palo Alto PCCSA
