SQL Server Administrator

Overview

Location :
Hybrid:
This position has the possibility of being 100% remote.

Most of the positions at YCCO are hybrid, meaning they have the flexibility to work both remotely and in-person at YCCO's office in McMinnville, OR.

Department: Information Systems FLSA Status: Exempt (Salaried)

Division: Information Systems Physical Strength: Light (L)

Reports To: Chief Information Officer Work Location Type: Hybrid / 100% Remote

Supervisory Role: No Occasional Weekend Work: No

About Us:
Yamhill Community Care is a nonprofit coordinated care organization dedicated to managing the healthcare for Medicaid members, covered under the Oregon Health Plan, in Yamhill County, as well as parts of Washington and Polk Counties. Our mission is to improve the quality of life of the communities we serve by coordinating effective care. Beyond healthcare, we also provide an Early Learning Hub, supporting families and children with essential resources and programs for early childhood development.

Together, we re building a unified healthy community that celebrates physical, mental, emotional, spiritual, and social well-being.

Learn more about Yamhill Community Care – Learn more about Yamhill Community Care.

Summary

The SQL Server Administrator is responsible for implementing, maintaining, and optimizing our SQL Server database infrastructure, ensuring the availability, performance, and security of our data management systems. This position requires a strong understanding of Health Plan core administrative data (health care claims, members, providers, primary care assignment, etc.). This position also requires experience in data integration methods and warehousing practices to support reporting and analytics.

Job Duties

• Performs / coordinates scheduled maintenance and supports release deployment activities.
• Creates, refines, and automates recurring processes, tracks issues, and documents changes.
• Shares domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Provide support for critical production SQL Server data management processes.
• Manages databases through multiple product lifecycle environments, from development to mission-critical production data systems.
• Independently analyzes, solves, and corrects issues in real time, providing end-to-end problem resolution.
• Applies data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Assists developers / analysts with complex query tuning and schema refinement.
• Identifies pain points and bottlenecks and recommends solutions.
• Documents processes, scripts, and writes complex stored procedures.
• Analyzes database performance and conducts performance tuning.
• Monitors and tunes all SQL databases to ensure availability.
• Develops unique, simple solutions to meet the immediate and long-term needs of information customers and stakeholders.
• Develops data architecture, data modeling, and ETL mapping solutions.
• Supports the development and validation required throughout the entire lifecycle of data warehousing and business intelligence systems.
• Documents business, functional, and technical requirements.
• Understands cloud data warehouse platforms and modern data warehousing techniques.
• Commissions and decommissions data sets as needed.
• Provides data support for the reporting environment, including data sources, security, and metadata.

• Works to cultivate and develop inclusive and equitable services, and working relationships with diverse groups of employees, community partners, and community members.
• Participates in the preparation and submission of regulatory and contract required deliverables.
• Works closely with other Yamhill Community Care (YCCO) departments, including Health Plan Operations and Compliance to assist with audits; including the External Quality Review (EQR), as needed.
• Detail-oriented with a strong commitment to data accuracy and security.
• Proposes and implements process improvements.
• Meets deadlines for completion of assigned responsibilities and projects.
• Maintains agreed upon work schedule with punctual, regular, and predictable attendance.
• Attends in person Annual Company Conference in Oregon; typically held in the fourth week of September.
• Demonstrates cooperation and teamwork using a professional and respectful demeanor.
• Provides cross-training on specific job…