Sr Database Admin

Who we are

Community Health Plan of Washington is an equal opportunity employer committed to a diverse and inclusive workforce. All qualified applicants will receive consideration for employment without regard to any actual or perceived protected characteristic or other unlawful consideration.

Our commitment is to:

• Strive to apply an equity lens to all our work.
• Reduce health disparities.
• Become an anti-racist organization.
• Create an equitable work environment.

About the Role

Responsible for supporting the database servers, databases, cloud data storage, operational stores, workspaces and tasks associated with administering and maintaining assigned SQL Server, Snowflake and Azure Data Lake Storage (ADLS) platforms that support day-to-day operations and projects.

To be successful in this role, you:

• Possess a bachelor's degree in IT, health information management, or management information systems; or an equivalent combination of education and highly relevant experience (required). Master’s degree preferred.
• Have a minimum of 5 years experience in Snowflake and Azure environment administration, configuration, utilities, and tools.
• Have a minimum of 5 years experience in SQL Server administration, configuration, on-prem or hybrid database administration, utilities, and tools.
• Have a minimum of 3 years healthcare experience; managed care organization, health insurance data management experience preferred.
• Have a minimum of 3 years experience as data steward working with business data producers and consumers.
• Have experience administering cloud database management systems such as Oracle, Redshift, GCP, etc.
• Have experience developing data management and administration requirements, functional specifications, data mapping and supporting documentation.
• Have experience with Agile/Scrum software development methodology preferred.

Essential functions and Roles and Responsibilities:

Database and Data Repository Administration:

• Configures and maintains Snowflake and SQL Server environments to ensure optimal database performance and availability.
• Installs, configures, tests, maintains, monitors, troubleshoots, and reports metrics on assigned Snowflake and SQL Server databases.
• Identify and apply industry best practices to on-premise and cloud databases for better performance and security management.
• Provisions user roles, user accounts, upgrades, and security settings for all Snowflake and SQL Server users; perform regular user account audits.
• Monitors database performance, storage, and credit usage on Azure SQL, Snowflake, and ADLS.
• Performs timely analysis, diagnosis, and resolution of complex database issues. Recommends and implements approved corrective solutions.

Standards and procedures:

• Participates in the definition and implementation of group standards and processes for tool utilization, business solution frameworks, and standardized documentation required in the delivery of database administration services.
• Recommends, plans, and implements database user access and security strategies based on the company data security policy.

Operations Management:

• Contributes expertise in areas of tool utilization, production support, business solutions framework, customer facilitation and coordination to ensure SQL Server, Snowflake, ADSL, and other database applications are operating at the highest level of efficiency possible and the business’ data needs are being met.
• Receives, organizes, and effectively performs all assigned database requests required to meet the needs of data management, applications development, business intelligence, data analysis, IT operations and other external entities affecting the Community Health Plan of Washington enterprise data environment.
• Supports strategic projects sponsored by the company adhering to the priorities and schedules established for designated project work.

Knowledge, Skills, and Abilities:

• Ability to read and write advanced SQL, T-SQL.
• Ability to script in PowerShell and Python.
• Working knowledge of data stores, data lake organization, and integration solutions.
• Working knowledge of Snowsight, DBeaver and/or SQL Server Management Studio.
• Working knowledge of cloud orchestration tools such as Airflow, ETLWorks, HVR, Fivetran.
• Strong analysis and troubleshooting skills of data and systems integration related issues.
• Ability to work independently with limited supervision.
• Ability to organize tasks, timelines, and delivery.
• Ability to communicate effectively at all levels of the organization.
• Managed care health plan and/or health care industry experience preferred.

As part of our hiring process, the following criteria must be met:

• Complete and successfully pass a criminal background check.
• Has not been sanctioned or excluded from participation in federal or state healthcare programs by a federal or state law enforcement, regulatory, or licensing agency.
• Vaccination requirement (CHPW offers a process for medical or religious exemptions).
• Candidates whose disabilities make them unable to meet these requirements are considered fully qualified if they can perform the essential functions of the job with reasonable accommodation.

Compensation and Benefits:

The position is FLSA Exempt and is not eligible for overtime. Based on market data, this position grade is 69 and has a 10% annual incentive target based on company, department, and individual performance goals.

CHPW offers the following benefits for Full and Part-time employees and their dependents:

• Medical, Prescription, Dental, and Vision.
• Telehealth app.
• Flexible Spending Accounts, Health Savings Accounts.
• Basic Life AD&D, Short and Long-Term Disability.
• Voluntary Life, Critical Care, and Long-Term Care Insurance.
• 401(k) Retirement and generous employer match.
• Employee Assistance Program and Mental Fitness app.
• Financial Coaching, Identity Theft Protection.
• Time off including PTO accrual starting at 17 days per year.
• 40 hours Community Service volunteer time.
• 10 standard holidays, 2 floating holidays.
• Compassion time off, jury duty.

Sensory/Physical/Mental Requirements:

Sensory:

• Speaking, hearing, near vision, far vision, depth perception, peripheral vision, touch, smell, and balance.

Physical:

• Extended periods of sitting, computer use, talking and possibly standing.

Mental:

• Frequent decision-making. Ability to gather and assess data, determine appropriate actions, apply protocols and knowledge to unique situations, problem-solve and provide consultation.

Work Environment:

Office environment. Employees who frequently work in front of computer monitors are at risk for environmental exposure to low-grade radiation.

Qualifications Behaviors

Required

Team Player: Works well as a member of a group.

Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well.

Motivations

Required

Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization.

Self-Starter: Inspired to perform without outside help.

Preferred

Peer Recognition: Inspired to perform well by the praise of coworkers.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.