MAKE A DIFFERENCE AT OCHIN

OCHIN is a rapidly growing national nonprofit health IT organization with two decades of experience transforming health care delivery to drive health equity. We are hiring for 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 mission.

OCHIN provides leading-edge technology, data analytics, research, and support services to nearly 1,000 community health care sites, reaching nearly 6 million patients nationally. We believe that every individual, no matter their race, ethnicity, background, or zip code, should have fair opportunity to achieve their full health potential. Our work addresses differences in health that are systemic, avoidable, and unjust. We partner, learn, innovate, and advocate, in order to close the gap in health for individuals and communities negatively impacted by racism or other structural inequities.

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

Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1000 diverse 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 equitable opportunity for professional advancement. We are curious, collaborative learners who strive to live our values everyday: leadership, collaboration, excellence, innovation, inclusion, and stewardship. 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 Programmer/Developer I / II is responsible for assisting in designing, developing, enhancing, and maintaining the Epic SQL servers and databases.

Essential Duties

• #1 responsibility is high quality support for our clinic membership
• SQL development and SDLC
• Database development and maintenance
• Assist in designing and implementing new database schemas
• Design, implement and maintain database stored procedures
• Optimize batch processing
• Assist in designing and implementing strategies for assuring data quality
• Participate in database related code review
• System administration
• Assist with the management of OCHIN SQL backups
• Administer organizational Red-Gate SQL product licenses
• Administer Data Services team GitHub repositories
• In cooperation with other OCHIN teams:
• Assist with installation and configuration of SQL servers
• Investigate and troubleshoot SQL performance issues
• Assist with updating and upgrading SQL server instances
• Assist with SQL-related VM migrations and systems-level maintenance
• Respond to SQL-related ticket escalations
• Business Objects Enterprise management:
• Apply version upgrades and patches
• Perform troubleshooting
• Perform routine maintenance and monitoring
• Clarity Replication management
• Perform routine maintenance and monitoring
• Complete new subscriber implementations
• Documentation
• Assist in the creation and maintenance of functional and technical requirements documents
• Assist with technical process and business process documentation
• General
• Participate in internal process improvement projects
• Provide technical support to OCHIN members (ticket-based support)
• Participate in informal internal training as part of ongoing team improvement
• Other duties as assigned