Fairview Health Services - Minneapolis, MN
posted 2 months ago
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. 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. You will develop, test, implement, and maintain database technology components, providing database support for production and non-production environments, including back-up and recovery services. Monitoring database environments, identifying existing or potential performance issues, and effectively tuning when needed will be essential to your role. In this position, you will gain a thorough understanding of data requirements and business/client needs. You will design, test, implement, and maintain complex databases with the required organization, access methods, access time, validation checks, and security to meet or exceed requirements. Ensuring that design and implementation meet architectural standards, Fairview guidelines, and client requirements will be a key responsibility. You will proactively evaluate, recommend, and perform database upgrades and changes, as well as perform system optimization and improvement planning, including database performance analysis, capacity planning, and system sizing. You will also be responsible for proactively monitoring the performance of development and production databases to detect existing or potential incidents and/or performance issues. Performing tuning and maintenance to correct and prevent unplanned downtime or performance degradation will be crucial. You will ensure that the operation of database environments meets or exceeds agreed-upon service levels (e.g., availability and performance). Planning, scheduling, and managing the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems will be part of your daily tasks. Additionally, you will set up and manage database security, manage data purging/archiving activity, and other day-to-day database administration activities. Providing ongoing support to operations and support teams as needed, you will use your database subject matter expertise to investigate and troubleshoot database-related issues/incidents, escalating and managing escalated issues as appropriate. Conducting data analysis involving the design and modification of complex reports, forms, and system queries will be part of your responsibilities, as well as utilizing data analysis and data modeling techniques to establish, modify, and maintain complex data structures and their associated components to increase efficiency. You will ensure that back-up, recovery, and replication strategies are developed, tested, implemented, and maintained for development and production database environments, allowing for data recovery in accordance with agreed-upon service levels. Continually monitoring and making improvements to back-up and recovery mechanisms and processes will be essential. You will champion consistency across databases by identifying data inconsistencies and working with environment owners to enable data completeness, monitoring assigned data assets to ensure consistent data definitions and standard data naming conventions. Collaboration with other internal teams to champion and uphold governance policies will also be expected.