SQL Server Administrator

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

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:

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.

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