Database Administrator

The mission of Washington Health Benefit Exchange (Exchange) is to radically improve how Washington residents secure health insurance through innovative and practical solutions, an easy-to-use customer experience, our values of integrity, respect, equity and transparency, and by providing undeniable value to the health care community.

The 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. Through this platform, and with support from a Customer Support Center and statewide network of in-person navigators and brokers, individuals and families can shop, compare and enroll in private, qualified health plans (as defined in the Affordable Care Act) or enroll in Washington Apple Health, the state Medicaid program.

The Exchange embraces the following equity statement adopted by our Board of Directors:

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 with 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 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.

SUMMARY

The Database Administrator is responsible for administering and maintaining the organization's on-premises and Azure-based database platforms. Ensure high availability, security, and optimal performance by following established standards, procedures, and automation practices. Work includes building and executing SQL and cloud-native scripts to manage and modify data, collaborating with the Senior Database Administrator on performance and scalability improvements, and leading initiatives for physical data modeling and architecture design across hybrid infrastructures.
• Installs, Patches, upgrades and maintains the system health for the database servers.

* Builds database schemas and structures based on customer needs and established standards

* Suggests performance tuning database systems/servers and database structures.  

* Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; and evaluating existing systems and designing proposed systems.

* Evaluates and runs SQL and other Database scripts.

* Azure Data Factory (ADF) pipeline management

* Uses data and database processes and procedures for daily tasks such as log analysis.

* Implements and maintains transactional replication for the database environment

* Troubleshooting DB integrity and performance issues

* SQL Job scheduling and automation

* Backup and restore strategy

* Indexing and parameter optimization

* Utility and tool development for DB support

* Collaborate across Dev and User teams related to database setup and data related activities.

* On-call rotation support

* Monitoring tool assessment and set up

* Evaluates Security Auditing and Maintaining server & DB permissions

* Documents business continuity, plan processes and procedures.

* Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

* Develop and maintain SQL Jobs based on maintenance tasks as well as tools and requirements of Dev and User communities.

* Runs and schedules backup schedules to meet organizational RTO and RPOs.

* Restore data and databases based on organizational needs.

* Test restores data recovery at a regular interval.

* Participate…