Yamhill Community Care · 3 hours ago
SQL Server Administrator
McMinnville, OR
Full-time
Hybrid
Entry, Mid Level
2+ years expYamhill Community Care is a nonprofit coordinated care organization dedicated to managing healthcare for Medicaid members. The SQL Server Administrator is responsible for implementing, maintaining, and optimizing the SQL Server database infrastructure, ensuring the availability, performance, and security of data management systems.
CommunitiesHealth CareNon Profit
Responsibilities
Implementing and managing SQL Server instances and configuring them according to the organization’s requirements
Work closely with Information Systems (IS) teams, data analysts, and business stakeholders to support data-related initiatives
Monitoring and optimizing the performance of SQL Server databases to ensure efficient operation
Develop Extract, Transform, and Load (ETL) processes for data extraction, transformation, and loading from various sources
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 responsibilities
Meets identified goals that contribute to departmental goals
Works collaboratively in a team and matrixed (cross-department) environment with a spirit of cooperation
Respectfully takes direction from Supervisor
Performs other duties as assigned
Qualification
Required
Two Plus (2+) years of MS SQL Server Administration experience
Two Plus (2+) years of SQL server database administration expertise
Two Plus (2+) years of experience working in / with a physical health plan organization
Experience supporting mission-critical production systems
Preferred
Experience with Medicaid and working with state agencies to meet contractual requirements
Company
Yamhill Community Care
Yamhill Community Care (YCCO) is a Coordinated Care Organization (CCO) that serves Oregon Health Plan (OHP) members in Yamhill County, and parts of Washington and Polk counties.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Seamus McCarthy
President and Chief Executive Officer
Company data provided by crunchbase