PacificSource is anything but a typical health insurance company. Founded in 1933, we’re an independent, not-for-profit organization that puts our members, and their communities first—across Idaho, Oregon, Montana, and Washington. It's our 1,700 employees who make it happen: promoting health equity and partnering with providers to deliver better access to optimal, affordable care. So yes, with PacificSource, you get to do great things. In our effort to put members first—more than 500,000 of them—initiative, commitment, and hard work are supported and rewarded with excellent benefits, competitive wages, and opportunities for personal growth and advancement. Benefits: Flexible telecommute policy, medical, vision, and dental insurance, incentive program, paid time off and holidays, 401(k) plan, volunteer opportunities, tuition reimbursement and training, life insurance, and options such as a flexible spending account. We love our common purpose. Empowerment, flexibility, and sharing success make for a great place to work. Here’s what else we feel good about: A mission with a real sense of shared values Competitive wages and outstanding benefits, including telecommuting Opportunities for learning development and career advancement Organizational leadership style rooted in servant and transformational leadership A commitment to support the communities we serve A belief in the importance of work-life balance PacificSource is an equal opportunity employer and a company that loves helping people. We work with our employees to understand their goals, and provide training, individual development, and career advancement opportunities to help them achieve just that. In 2021 alone we had 240 internal promotions! Top Workplace 2022 for Idaho | Idaho Press Top Workplace 2022 for Oregon and SW Washington | The Oregonian #4 Healthiest Employer of Oregon 2021 | Portland Business Journal Healthy Worksite 2021 | Design Coalition in Montana PacificSource is an equal opportunity employer. Click here to review our AAP Policy Statement. If you have questions about working at PacificSource or need help with your application, please email HR@PacificSource.com. Looking for a way to make an impact and help people? Join PacificSource and help our members access quality, affordable care! PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, sexual orientation, gender identity or age. Diversity and Inclusion: PacificSource values the diversity of the people we hire and serve. We are committed to creating a diverse environment and fostering a workplace in which individual differences are appreciated, respected and responded to in ways that fully develop and utilize each person’s talents and strengths. Position Overview: Implement, support and maintain all enterprise databases and environments with a focus on providing high performance availability. This includes database development, information ETL, administration, maintenance, and troubleshooting to all PacificSource departments and subsidiaries. Assist other Information Technology staff with database-related tasks. Essential Responsibilities: Provide support and maintenance for all corporate databases. Design, develop, and maintain Microsoft SQL databases and Integration Services packages. Install and maintain DBMS server software. Manage and champion upgrade processes. Configure and administer cloud-based database and data warehouse services such as Azure SQL Database / Data Warehouse and Cosmos DB. Recommend and implement modifications and improvements to existing databases to increase performance, user-friendliness, and stability. Perform server health monitoring, alerting and incident response. Interpret user requests on database changes, updates, and restores; perform appropriate actions. Handle source control and configuration management issues. Responsible for data security, integrity, and disaster recovery, including strategies, implementation, and staff education. Responsible for scheduled and unscheduled DB backup and restoration in the event of disaster or as assistance to staff. Advise developers in best practice database table design, champion development, and design standards. Participate in cross-functional project teams as database technical expert, working with IT Staff and end users in defining and implementing new systems per project requirements Rotational on-call after hours critical incident support. Supporting Responsibilities: Meet department and company performance and attendance expectations. Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information. Perform other duties as assigned. SUCCESS PROFILE Work Experience: 2-4 years of intensive database administration in an enterprise environment, working as a professional DBA. Commercial and/or Medicare health care insurance industry systems experience preferred. Education, Certificates, Licenses: Bachelor’s in Computer Science, Information Systems, MIS or similar or equivalent combination of education and experience. System vendor certifications such as MCSA or MCSE in Data Management and Analytics or Cloud Platform and Infrastructure or AWS Associate-level certification, or similar preferred. Knowledge: Advanced experience: Microsoft SQL Server, Azure SQL Database, Azure Data Warehouse, SQL Stored Procedure Development, T-SQL, SQL Server Management Studio, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services, Microsoft SQL Server Integration Services, Microsoft PowerShell, Database Architecture Design. Database Performance Tuning and Resource Management practices, and SQL DB Security Models. Working knowledge or familiarity with: Microsoft Power Suite (Power View, PowerPivot, Power Query), Microsoft Master Data Services and Data Quality Services, Spotlight, and Informatica. Additional desired experience includes Microsoft Cosmos DB, Cognizant/TriZetto Facets; EDI (ANSI x12 formats), HL7, Dell/Quest Lightspeed, Commvault, Rubrik, AWS RDS, AWS Redshift, and integration of enterprise-wide applications. Ability to respond to common inquiries and effectively present information to a variety of groups. Requires excellent interpersonal skills and ability to work closely with others as well as independently. Database normalization skills. Proficiency in word processing, spreadsheets, and other common office software tools, including Microsoft Office. Interest in ongoing training and learning about technology. Excellent written and verbal communication skills. Basic math skills, including fractions, percentages, ratios, and proportions. Ability to read, analyze, and interpret technical journals, financial reports, and legal documents. Competencies Adaptability Building Customer Loyalty Building Strategic Work Relationships Building Trust Continuous Improvement Contributing to Team Success Planning and Organizing Work Standards Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately 5% of the time. Requires some activity outside normal working hours. Requires ability to be on-call. Our Values We live and breathe our values. In fact, our culture is driven by these seven core values which guide us in how we do business: We are committed to doing the right thing. We are one team working toward a common goal. We are each responsible for customer service. We practice open communication at all levels of the company to foster individual, team and company growth. We actively participate in efforts to improve our many communities-internally and externally. We actively work to advance social justice, equity, diversity and inclusion in our workplace, the healthcare system and community. We encourage creativity, innovation, and the pursuit of excellence. Physical Requirements: Stoop and bend. Sit and/or stand for extended periods of time while performing core job functions. Repetitive motions to include typing, sorting and filing. Light lifting and carrying of files and business materials. Ability to read and comprehend both written and spoken English. Communicate clearly and effectively. Disclaimer: This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times.