Database Analyst

Fairview Health Services - Minneapolis, MN

Full-time

Minneapolis, MN

Ambulatory Health Care Services

About the position

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 is crucial. 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. Your responsibilities will also include proactively monitoring the performance of development and production databases to detect existing or potential incidents and/or performance issues. You will perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation, ensuring that the operation of database environments meets or exceeds agreed-upon service levels. Additionally, you will 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. Setting up and managing database security, managing data purging/archiving activity, and other day-to-day database administration activities will be part of your daily tasks. You will provide ongoing support to operations and support teams as needed, using your database subject matter expertise to investigate and troubleshoot database-related issues/incidents, escalating and managing escalated issues as appropriate.

Responsibilities

• 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.

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 and visibility
• 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)
• 403(b) matching
• Dental insurance
• Health insurance
• Paid time off