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 Statement 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. Job Summary 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. Responsibilities 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. Required Qualifications 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. Understanding of OLTP and OLAP concepts. Experience with ADF triggers, activities, data integration, and performance monitoring. Experience with role‑based access control, Active Directory, Azure AD, encryption standards. Experience implementing database replication. Experience using performance tools such as Extended Events, SQL Profiler, Azure Diagnostics, and deadlock analysis. Experience scheduling jobs using SQL Agent, ADF, and Logic Apps for orchestration. Experience managing backup, restore, data archiving, Azure Backup, Recovery Vault, LRS, ZRS. Experience with database performance metrics, query optimization tools, and cloud tuning. Excellent written, oral, and presentation skills. Experience on‑call rotation support 24/7 for monitoring and handling severity problems. Familiarity with SQL Monitor or similar products for managing multiple instances. Experience with database auditing, roles, and permissions. Strong analytical skills, able to formulate workable plans for complex problems. Self‑motivated and driven to improve processes and increase velocity. Experience working with Data Warehouse teams and understanding concepts. Knowledge of BI tools. Desired Qualifications Bachelor’s degree in computer science or related field, or equivalent training and experience. Script knowledge for automating day‑to‑day tasks (Shell script, PowerShell). Experience with automation tools such as PowerShell, Python, Azure SDKs, and SSMS scripting. Experience developing and maintaining SQL jobs tailored to the needs of Dev and User communities. Experience providing feedback on disaster recovery plans and tests. Experience in database partitioning, compression, and encryption. Professional demeanor and ability to represent projects to stakeholders in a friendly, unbiased, and professional manner. Experience with SSIS and SSRS concepts. Experience working with network and system administrators. Experience with database migration from on‑premise to cloud and performance tuning. Certification in Microsoft SQL Server. Equal Opportunity Employer The Washington Health Benefit Exchange is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, marital status, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. E‑Verify We participate in E‑Verify. #J-18808-Ljbffr State of Washington Health Benefits Exchange