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: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: Minimum 3 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: BS 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:
Demonstrated 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.
