Company:
Fairview Health Services
Location: Minneapolis
Closing Date: 30/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview:
Fairview is looking for a Database Analyst – IRIS Operational Database Administrator (ODBA) role to join the Epic Environment team. As an Epic ODBA, you will play a critical and key position in our organization, responsible for maintenance, optimization, installation, and security of our Epic operational databases, supporting healthcare operations and patient care. Experience with Linux/Unix is a plus in excelling at this position. The Database Analyst role is to support the information needs of the organization through the development and operation of database technology and administration services that ensure data integrity and database availability, reliability, and performance across a broad range of databases and applications. Develop, test, implement and maintain database technology components. Provide database support for production and non-production environments, to include back-up & recovery services. Monitor database environments, identify existing or potential performance issues, and effectively tune when needed.
This position is eligible for benefits!
Some of the benefits we offer at Fairview include medical insurance - as low as $0, dental insurance - also a $0 option, PTO (24 days per year starting), and a 403B with up to a 6% employer match; visit to learn more and get all the details.
Responsibilities/Job Description:
Gain thorough understanding of data requirements and business/client needs. Design, test,
implement and maintain complex databases with the required organization, access
methods, access time, validation checks and security to meet or exceed requirements.
Ensure design and implementation meet architectural standards, Fairview guidelines and
client requirements.
Proactively evaluate, recommend, and perform database upgrades and changes. Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing.
Proactively monitor the performance of development and production databases to detect
existing or potential incidents and/or performance issues. Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and
performance).
Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems. Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities.
Provide ongoing support to operations and support teams as needed. Use database subject
matter expertise to investigate and troubleshoot database related issues/incidents. Escalate and manage escalated issues as appropriate.
Conduct data analysis involving the design and modification of complex reports, forms and
system queries. Apply data analysis and data modeling techniques to establish, modify and
maintain complex data structures and their associated components to increase efficiency of
structures and components.
Ensure that back-up, recovery, and replication strategies are developed, tested, implemented
and maintained for development and production database environments. Ensure strategies allow for data recovery in accordance with agreed upon service levels. Continually monitor and make improvements to back-up and recovery mechanisms and processes.
Champion consistency across databases by identifying data inconsistencies and working with environment owners to enable data completeness. Monitor assigned data assets to ensure consistent data definitions and standard data naming conventions. Collaborate with other internal teams to champion and uphold governance policies.
Additional Job Expectations:
Work closely with application teams to optimize database configurations for specific Epic modules and workflows.
Implement and maintain database security measures to protect sensitive patient data and ensure compliance with regulatory requirements, such as HIPAA.
Perform regular security audits and vulnerability assessments to identify and address potential security risks.
Collaborate with IT security teams to implement database encryption, access controls, and other security best practices.
Monitor database growth trends and forecast future capacity requirements.
Collaborate with infrastructure teams to plan and implement database capacity upgrades as needed to accommodate growing data volumes and user loads.
Maintain comprehensive documentation of database configurations, procedures, and best practices.
Provide training and support to IT staff and end-users on database-related topics, such as database maintenance tasks and performance optimization techniques.
Additional Job Expectations:
Creating and managing the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs
Installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of your Epic system
Understanding performance metrics, monitoring system performance, and troubleshooting issues
Managing the logins for different types of access, including login behavior and working environment configuration
Applying IRIS and Epic upgrades and updates to production and non-production environments
Configuring and maintaining environment copies according to the environment strategy
Responding to emergency and after-hours issues
Engaging in capacity planning exercises to ensure adequate system resources
Collaborating with your technical teams and Epic to ensure proactive support
Writing and maintaining scripts to improve system management tasks
Participating in your change control process for all planned application and technical activities
Maintaining and testing processes related to business continuity
Following vendor and Epic best practices for hardware and software configuration
Automation and Scripting: Develop automation scripts and tools using shell scripting or other scripting languages to streamline system administration tasks, automate repetitive processes, and improve operational efficiency.
Qualifications:
Required
Computer Science/Engineering degree or equivalent work experience
3-5 years of technology experience of increasing scope and responsibility
3+ years of experience with database design and operations
3+ years of experience troubleshooting and resolving database issues, including performance tuning
Experience in database design, clustering, related programming languages, backup/restore technologies, replication and security
Preferred
Effective verbal and written communication skills
2+ years’ experience maintaining enterprise-scale database environments
Demonstrated successful experience working effectively in emergency or high-pressure situations and visibility
Strong written and verbal communication skills
IRIS and Cache database management systems
Strong understanding of Linux file systems, permissions, and security.
Utilize strong scripting skills in Linux-related languages and operate efficiently within the Linux command-line interface (CLI).
Certifications
Epic ODBA Certification.
Microsoft Technology Associate (MCT)
Oracle Certified Associate (OCA)
Microsoft Certified Solution Associate (MCSA)
Fairview is looking for a Database Analyst – IRIS Operational Database Administrator (ODBA) role to join the Epic Environment team. As an Epic ODBA, you will play a critical and key position in our organization, responsible for maintenance, optimization, installation, and security of our Epic operational databases, supporting healthcare operations and patient care. Experience with Linux/Unix is a plus in excelling at this position. The Database Analyst role is to support the information needs of the organization through the development and operation of database technology and administration services that ensure data integrity and database availability, reliability, and performance across a broad range of databases and applications. Develop, test, implement and maintain database technology components. Provide database support for production and non-production environments, to include back-up & recovery services. Monitor database environments, identify existing or potential performance issues, and effectively tune when needed.
This position is eligible for benefits!
Some of the benefits we offer at Fairview include medical insurance - as low as $0, dental insurance - also a $0 option, PTO (24 days per year starting), and a 403B with up to a 6% employer match; visit to learn more and get all the details.
Responsibilities/Job Description:
Gain thorough understanding of data requirements and business/client needs. Design, test,
implement and maintain complex databases with the required organization, access
methods, access time, validation checks and security to meet or exceed requirements.
Ensure design and implementation meet architectural standards, Fairview guidelines and
client requirements.
Proactively evaluate, recommend, and perform database upgrades and changes. Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing.
Proactively monitor the performance of development and production databases to detect
existing or potential incidents and/or performance issues. Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and
performance).
Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems. Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities.
Provide ongoing support to operations and support teams as needed. Use database subject
matter expertise to investigate and troubleshoot database related issues/incidents. Escalate and manage escalated issues as appropriate.
Conduct data analysis involving the design and modification of complex reports, forms and
system queries. Apply data analysis and data modeling techniques to establish, modify and
maintain complex data structures and their associated components to increase efficiency of
structures and components.
Ensure that back-up, recovery, and replication strategies are developed, tested, implemented
and maintained for development and production database environments. Ensure strategies allow for data recovery in accordance with agreed upon service levels. Continually monitor and make improvements to back-up and recovery mechanisms and processes.
Champion consistency across databases by identifying data inconsistencies and working with environment owners to enable data completeness. Monitor assigned data assets to ensure consistent data definitions and standard data naming conventions. Collaborate with other internal teams to champion and uphold governance policies.
Additional Job Expectations:
Work closely with application teams to optimize database configurations for specific Epic modules and workflows.
Implement and maintain database security measures to protect sensitive patient data and ensure compliance with regulatory requirements, such as HIPAA.
Perform regular security audits and vulnerability assessments to identify and address potential security risks.
Collaborate with IT security teams to implement database encryption, access controls, and other security best practices.
Monitor database growth trends and forecast future capacity requirements.
Collaborate with infrastructure teams to plan and implement database capacity upgrades as needed to accommodate growing data volumes and user loads.
Maintain comprehensive documentation of database configurations, procedures, and best practices.
Provide training and support to IT staff and end-users on database-related topics, such as database maintenance tasks and performance optimization techniques.
Additional Job Expectations:
Creating and managing the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs
Installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of your Epic system
Understanding performance metrics, monitoring system performance, and troubleshooting issues
Managing the logins for different types of access, including login behavior and working environment configuration
Applying IRIS and Epic upgrades and updates to production and non-production environments
Configuring and maintaining environment copies according to the environment strategy
Responding to emergency and after-hours issues
Engaging in capacity planning exercises to ensure adequate system resources
Collaborating with your technical teams and Epic to ensure proactive support
Writing and maintaining scripts to improve system management tasks
Participating in your change control process for all planned application and technical activities
Maintaining and testing processes related to business continuity
Following vendor and Epic best practices for hardware and software configuration
Automation and Scripting: Develop automation scripts and tools using shell scripting or other scripting languages to streamline system administration tasks, automate repetitive processes, and improve operational efficiency.
Qualifications:
Required
Computer Science/Engineering degree or equivalent work experience
3-5 years of technology experience of increasing scope and responsibility
3+ years of experience with database design and operations
3+ years of experience troubleshooting and resolving database issues, including performance tuning
Experience in database design, clustering, related programming languages, backup/restore technologies, replication and security
Preferred
Effective verbal and written communication skills
2+ years’ experience maintaining enterprise-scale database environments
Demonstrated successful experience working effectively in emergency or high-pressure situations and visibility
Strong written and verbal communication skills
IRIS and Cache database management systems
Strong understanding of Linux file systems, permissions, and security.
Utilize strong scripting skills in Linux-related languages and operate efficiently within the Linux command-line interface (CLI).
Certifications
Epic ODBA Certification.
Microsoft Technology Associate (MCT)
Oracle Certified Associate (OCA)
Microsoft Certified Solution Associate (MCSA)
Share this job
Useful Links