Database Analyst

Fairview Health Services - Minneapolis, MN

Full-time - Mid Level

Minneapolis, MN

Ambulatory Health Care Services

About the position

As an Epic ODBA at Fairview Health Services, you will play a critical role in maintaining, optimizing, installing, and securing our Epic operational databases, which are essential for supporting healthcare operations and patient care. This position is designed to support the information needs of the organization through the development and operation of database technology and administration services that ensure data integrity, availability, reliability, and performance across a wide range of databases and applications. You will be responsible for developing, testing, implementing, and maintaining database technology components, as well as providing database support for both production and non-production environments, including backup and recovery services. In this role, you will monitor database environments to identify existing or potential performance issues and effectively tune them as needed. You will gain a thorough understanding of data requirements and business/client needs, designing, testing, implementing, and maintaining complex databases that meet or exceed these requirements. Your responsibilities will include ensuring that the design and implementation of databases meet architectural standards and Fairview guidelines, proactively evaluating and recommending database upgrades and changes, and performing system optimization and improvement planning. You will also be tasked with monitoring the performance of development and production databases, performing tuning and maintenance to prevent unplanned downtime or performance degradation, and ensuring that database environments meet or exceed agreed-upon service levels. Additionally, you will set up and manage database security, manage data purging and archiving activities, and provide ongoing support to operations and support teams as needed. Your expertise will be crucial in investigating and troubleshooting database-related issues, conducting data analysis, and ensuring that backup, recovery, and replication strategies are developed and maintained effectively. You will collaborate closely with application teams to optimize database configurations for specific Epic modules and workflows, implement security measures to protect sensitive patient data, and maintain comprehensive documentation of database configurations and best practices.

Responsibilities

• Gain thorough understanding of data requirements and business/client needs.
• Design, test, implement and maintain complex databases with required organization, access methods, access time, validation checks and security.
• 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 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.
• 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.
• 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.
• Ensure that back-up, recovery, and replication strategies are developed, tested, implemented and maintained for development and production database environments.
• 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.

Requirements

• 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

Nice-to-haves

• 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
• Strong written and verbal communication skills
• Certifications: Epic ODBA Certification, Microsoft Technology Associate (MCT), Oracle Certified Associate (OCA), Microsoft Certified Solution Associate (MCSA)

Benefits

• 403(b) matching
• Health insurance
• Dental insurance
• Paid time off