DATABASE ADMINISTRATOR

MAKE A DIFFERENCE AT OCHIN

OCHIN is a nonprofit leader in health care innovation and a trusted partner to a growing national provider network, providing the clinical insights and tailored technologies needed to expand patient access, grow and connect care teams, and improve the health of rural and underserved communities.

We are hiring a number of new positions to meet increasing demand. When you choose to join OCHIN, you have the opportunity to continuously grow your skills and do meaningful work to help fulfill our vision of good health and well-being for everyone.

At OCHIN, we value the unique perspectives and experiences of every individual and work hard to maintain a culture rooted in our values.

Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1,200 skilled professionals, working remotely across 49 states. We offer a generous compensation package and are committed to supporting our employees' entire well-being by fostering a healthy work-life balance and opportunity for professional advancement. We are curious, collaborative learners who strive to live our values every day. OCHIN is excited to support our continued national expansion and the increasing demand for our innovative tools and services by welcoming new talent to our growing team.

Position Overview

The Database Administrator is responsible for the design, logical/physical data modeling, stored procedure/trigger development, database configuration/tuning, and system documentation of all internally developed databases. In this role you will develop procedures for automating data feeds and data transformation process between external and internal data systems and among internal data sources and for automating data warehouse processes. This position requires strong data architecture, logical, and physical modeling, and effective communication skills.

The Database Administrator performs duties within a multi-function, cross-division, or mission critical environment. This person uses SQL Server, Epic Cogito applications, and other development tools. They work closely with developers, programmers, and system administrators. The Database Administrator assists in developing a long-term plan for Information Systems. This position will be part of a 24x7 rotational on-call roster to ensure ongoing support is available for the business.

Essential Duties

• Oversees the development and maintenance of database objects (such as stored procedures and triggers) to ensure quality and best practices.
• Create and maintain database documentation, including ER diagrams, stored procedure listings and descriptions, and usage and performance statistics
• Develop and maintain stored procedures and views to deliver data for reporting needs
• Performing day to day management of databases and database platforms
• Monitor and maintain the security of databases and database software in cooperation with the Systems Administrator
• Provide db/log backup/recovery and replication
• Carry out Database and OS tuning
• Responsible for job scheduling for automating data transfer between both internal and external data systems
• Provide technical guidance and recommendations to developers
• Participate in long-term systems architecture planning
• Provide backup support to other team members
• Other duties and projects as assigned

• 4+ years' experience in database development and administration
• 2+ years demonstrated proficiency as Microsoft SQL Server DBA
• Epic Cogito Administration certification a plus
• MCSA Certification version 2012 or newer a plus
• Working knowledge of Power BI, Azure and MS Fabric highly desired
• Knowledge of and experience in the Health Care industry or Healthcare IT preferred
• Advanced MS SQL programming skills preferred
• Data warehousing experience preferred
• Extensive experience in database design and implementation, query tuning and optimization
• Experience with replication
• Excellent written and verbal communication skills
• Meticulous, methodical and data-driven
• Intense attention to detail and ability to apply critical thinking skills in order to identify and carry out solutions
• Ability to work at least 1 weekend a month and intermittent nights to support system health monitoring

COVID-19 Vaccination Requirement

To keep our colleagues, members, and communities safe, OCHIN requires all employees-including remote employees, contractors, interns, and new hires-to be vaccinated with a COVID-19 vaccine, as supported by state and federal public health officials, as a condition of employment. All new hires are required to provide proof of full vaccination or receive approval for a medical or religious exemption before their hire date.

Work Location and Travel Requirements

OCHIN is 100% remote organization.? Work from home requirements are:

• Ability to work independently and efficiently from a home office environment
• High Speed Internet Service
• It is a requirement that employees work in a distraction free workplace

We offer a comprehensive range of benefits. See our website for details:

https://ochin.org/employment-openings

Equal Opportunity Statement

OCHIN is proud to be an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills for the benefit of our staff, our mission, and the communities we serve.

As an Equal Opportunity and Affirmative Action employer, OCHIN, Inc. does not discriminate on the basis of race, ethnicity, sex, gender identity, sexual orientation, religion, marital or civil union status, age, disability status, veteran status, or any other protected characteristics. All aspects of employment are based on merit, performance, and business needs.

Base Pay Overview

The typical offer range for this role is minimum to midpoint, with the midpoint representing the average pay in a national market scope for this position. Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will consider a wide range of factors directly relevant to this position, including, but not limited to, skills, knowledge, training, responsibility, and experience, as well as internal equity and alignment with market data.