SQL Server Administrator

Location: Hybrid (as needed In-Office)

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

Reports To:       Information Systems Sr. Director           Physical Strength:     Light (L)

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:  click here

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.

Essential Duties

1. Database Installation and Configuration: Implementing and managing SQL Server instances and configuring them according to the organization’s requirements.
2. Collaboration and Support: Work closely with Information Systems (IS) teams, data analysts, and business stakeholders to support data-related initiatives.
3. Performance Tuning: Monitoring and optimizing the performance of SQL Server databases to ensure efficient operation.
4. Automation: Develop Extract, Transform, and Load (ETL) processes for data extraction, transformation, and loading from various sources.

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.

Essential Department & Organizational Functions

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

Knowledge, Skills, & Abilities

• Experience developing and working with Microsoft tools such as SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Integration Services (SSAS).
• Experience with performance tuning and optimization tools in a SQL Server environment.
• Experience with ETL design and operations, such as SSIS.
• Knowledge of project management practices and ability to document processes and procedures.
• Ability to remain updated on industry and technology trends.
• Translate a logical data model or user specifications into a physical design.
• Experience with business intelligence reporting tools, particularly Tableau.
• Highly motivated, hard-working, excited to learn, and able to motivate others.
• Present technical solutions to management and decision makers.
• Listen carefully and act upon user requirements.
• Excellent organizational skills including ability to simultaneously handle multiple priorities and demands in a dynamic work environment while maintaining high attention to detail and accuracy.
• Ability to work independently, use sound judgment, anticipate next steps and be proactive as part of a diverse team within a matrix or shared resource (across departments) work model.
• Excellent computer skills, including Microsoft Windows, Word, Excel, and Outlook.
• Ability to communicate both professionally and effectively in all forms of communication.
• Ability to work in an environment with diverse individuals and groups.
• Ability to work in a rapidly changing environment.
• Flexible, team player, “get-it-done” personality.
• Ability to remain flexible, positive, and adaptable. 

Supervisory Responsibilities

This position has no supervisory responsibility.

Qualifications

Ability to perform essential job duties with or without reasonable accommodation and without posing a direct threat to safety or health of employee or others. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation(s) may be made to enable individuals with disabilities to perform the essential duties.

Education & Experience

Required:

• 2+ years of MS SQL Server Administration experience.
• 2+ years of SQL server database administration expertise.
• 2+ years of experience working in/with a physical health plan organization.
• Experience supporting mission-critical production systems.

OR:

• Any combination of education and experience that qualifies a candidate for the position.

Preferred:

• Experience with Medicaid and working with state agencies to meet contractual requirements.

Certificates, Licenses and/or Registrations

This position does not require any certificates, licenses, or registrations. 

Physical Demands & Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this position. The work environment characteristics described here are representative of those an employee encounters while performing the essential duties of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform their essential duties.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to sit, stand, walk, use hands and fingers, handle or feel, and reach with hands and arms. The employee is occasionally required to climb or balance, stoop, kneel, crouch or crawl. The employee may occasionally need to lift and/or move up to 25 pounds.

This position operates in a professional office environment and requires frequent use of standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Specific vision abilities required by this job include close vision, color vision, distance vision, depth perception, and ability to adjust focus. The noise level in the work environment is usually moderate.

This position may include occasional required or optional travel outside of the workplace, in which the employee’s personal vehicle, local transit, or other means of transportation may be used.