Yamhill Community Care-posted 3 months ago
Full-time
Mcminnville, OR
11-50 employees
Insurance Carriers and Related Activities

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.

  • 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.
  • 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.
  • Experience with Medicaid and working with state agencies to meet contractual requirements.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service