Database Administrator

Overview

Washington Health Benefit Exchange (Exchange) is a public‑private partnership that operates Washington Healthplanfinder, the eligibility and enrollment portal used by one in four Washington residents to obtain health and dental coverage. Our mission is to radically improve how Washington residents secure health insurance through innovative and practical solutions, an easy‑to‑use customer experience, and a commitment to integrity, respect, equity, and transparency.

Equity is fundamental to the mission of the Washington Health Benefit Exchange. The process of advancing toward equity and becoming anti‑racist is disruptive and demands vigilance to dismantle deeply entrenched systems of privilege and oppression. While systemic racism is a root cause of many societal inequities, we must also use an intersectional approach to address all forms of bias and oppression, which interact and often exacerbate racial inequities.

To be successful, we must recognize the socioeconomic drivers of health and focus on people and places where needs are greatest. As we listen to the community, we must hold ourselves accountable to responding to recommendations to remedy inequitable policies, systems, or practices within the Exchange’s area of influence. Our goal is that all Washingtonians have full and equal access to opportunities, power and resources to achieve their full potential.

The Database Administrator is responsible for administering and maintaining the organization’s on‑premises and Azure‑based database platforms, ensuring high availability, security, and optimal performance. The role involves building and executing SQL and cloud‑native scripts, collaborating with the Senior Database Administrator on performance and scalability improvements, and leading initiatives for physical data modeling and architecture design across hybrid infrastructures.

• Install, patch, upgrade, and maintain database servers.
• Build database schemas and structures based on customer needs and standards.
• Recommend performance tuning for database systems, servers, and structures.
• Identify database requirements by interviewing customers, analyzing applications, programming, and operations.
• Evaluate and run SQL and other database scripts.
• Manage Azure Data Factory (ADF) pipelines.
• Use data and database processes and procedures for daily tasks such as log analysis.
• Implement and maintain transactional replication.
• Troubleshoot database integrity and performance issues.
• Schedule and automate SQL jobs.
• Develop backup and restore strategies, schedule backups to meet RTO and RPOs, and test restores.
• Perform indexing, parameter optimization, and database performance tuning.
• Develop utility and tool support for database operations.
• Collaborate with development and user teams related to database setup and data activities.
• Participate in on‑call rotation support.
• Assess, set up, and maintain monitoring tools.
• Evaluate security auditing and maintain server and database permissions.
• Document business continuity plans and procedures.
• Resolve replication, log shipping, connectivity, and security issues.
• Maintain professional technical knowledge through learning and participation in professional societies.
• Maintain database functions by designing and coding utilities.
• Support Microsoft SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Model data using Microsoft Data Warehouse technologies and generate reports.
• Create and modify DNS, DHCP, Active Directory, and Group Policy settings.
• Migrate databases from on‑premise to Azure SQL, including table partitioning, compression, and encryption.
• Configure SQL monitoring systems for managing multiple instances.
• Conduct root cause analysis and create SOP documents.

• Seven years of experience in enterprise SQL Database administration with large‑scale, mission‑critical applications (Microsoft SQL Server 2016+, MySQL, etc.).
• Experience with SSMS, MS tools, Azure VM deployment, lifecycle patching, Azure SQL database.
• Experience with data modeling, ER/physical design tools.
• Experience with database server performance and optimization tools.
• Understand…