IT Data Management – Senior/Specialist (ITDM-SS/ETS)

State of Washington; Olympia (WA); Hybrid; USD 110,000 - 140,000; Full time

Job summary

The Health Care Authority (HCA) seeks a Senior Database Administrator to lead the EDD DBA team and oversee traditional databases. This role focuses on architectural guidance, design standards, and maintaining compliant, scalable data systems.

You will drive improvements, align with enterprise data strategy, and ensure secure SQL Server deployments while enabling telework as needed.

Qualifications

• Four years of experience in architecture and implementing SQL Server solutions.
• Four years of database development and administration with relational design and SQL procedures.

Responsibilities

• Lead the EDD DBA team and ensure traditional databases meet design standards.
• Implement databases using enterprise data architecture and standards.
• Design and develop traditional databases with logical/physical data models.
• Advise leadership on architecture, changes, and data standards.
• Develop roadmaps, standards, and best practices for DBA administration.
• Monitor regulatory guidelines and assess impact on the platform.

Skills

Microsoft SQL Server

Relational database design

SQL queries

Stored procedures

Education

Bachelor’s degree or higher in Computer Science, Business, Business Analysis/Intelligence, or closely related field

Associate’s degree OR two years vocational training in a technical field

Nine years IT programming, database administration and analytic experience

Three years’ experience as a Journey Level Professional in IT Data Management

Tools

AWS Aurora/RDS

Snowflake

Job description

IT Data Management – Senior/Specialist (ITDM-SS/ETS)

71115336

Lead the Health Care Authority's EDD DBA team as a Senior Database Administrator. This role offers flexible telework, and the chance to shape core data strategy and secure SQL Server systems.

All HCA employees will apply an equity lens to their work, which may include but is not limited to all analyses of core business and processes

About the division:

The Enterprise Technology Services (ETS) division is responsible for management and operation of the state’s federally certified Medicaid Management Information System (MMIS) called ProviderOne, the Agency’s Enterprise Data program, data governance support, and information management functions. ProviderOne processes over two million claims per month and processes/pays claims more than $10 billion annually to providers of services to Medicaid clients statewide.

About the position:

This position leads the work of the EDD DBA team, and is responsible for the appropriate analysis, design, development, implementation, and maintenance of all traditional databases used at the Health Care Authority. This position must consider the architectural constraints set by the manager of EDD and the architecture team and make appropriate recommendations for the design and implementation of traditional databases. As the senior level specialist in the agency on the use of traditional database technologies, this position must ensure that the DBA team keeps databases updated and maintained, deprecating and retiring non-operational and non-compliant databases, and comparing existing deployments to the design standards set by EDD.

The position is eligible to telework and is typically not required to report on-site. The default assigned work location of all Health Care Authority (HCA) positions – both on-site and telework eligible positions – is within the State of Washington. This position reports to Olympia, WA. Frequency of onsite work will vary based on business and operational needs. All agency employees are required to report on-site in Olympia on their first and last days of employment to pick up and return state-issued equipment, regardless of telework status or location.

Some of what you will do:

• Guide staff in creating and implementing traditional database solutions with new processes and frameworks, delivering valuable, adaptable, scalable solutions for complex business tasks.
• Implement databases using enterprise data architecture and standards.
• Design and develop traditional databases. Convert business requirements into logical and physical data models for traditional databases.
• Incorporate human-centered design concepts to enhance services and tools for end users.
• Advise management, IT staff, and business partners on change requests, needs assessments, systems analysis, architecture, and design for traditional databases.
• Provide technical advice and guidance to senior managers and technical resources in the creation and implementation of data standards and architecture.
• Develop and manage roadmaps, standards, patterns, and best practices for database administration which support agency strategy.
• Analyze business intelligence data and make recommendations for growth and change of traditional databases.
• Research, analyze, propose, design, and deliver standards and frameworks that are appropriate for agency’s business and technology strategies for traditional databases.
• Make platform decisions that are based on enterprise significance, business impact, risk management, and organizational considerations.
• Monitor regulatory guidelines, compliance guidance, and emerging industry standards to assess their impact on the platform and its products.
• Lead platform redesign or modification efforts in line with business improvement initiatives.

Required qualifications:

This experience may be concurrent:

• Four (4) years of experience and demonstrated ability in architecture, developing and implementing technical solutions utilizing Microsoft SQL Server.
• Four (4) years of database development and administration experience, including relational database design and modeling, writing SQL queries and stored procedures.

Qualifying candidates will also meet one of the following criteria options:

Option 1:

• Bachelor’s degree or higher in Computer Science, Business, Business Analysis/Intelligence, or closely related field.
• Five (5) years of progressively responsible for IT programming, database administration and analytic experience with large, complex administrative databases.

Option 2:

• An associate’s degree OR equivalent to two years of vocational training in a technical field.
• Seven (7) years of progressively more responsible IT programming, database administration and analytic experience with large, complex administrative databases.

Option 3:

• Nine (9) years of progressively more responsible IT programming, database administration and analytic experience with large, complex administrative databases.

Option 4:

• Three years’ experience as a Journey Level Professional in an IT Data Management job family.

Required competencies:

• The ability to take action to learn and grow.
• The ability to take action to meet the needs of others.
• Advanced knowledge in application and database development methodologies and best practices to architect, develop and implement efficient technology solutions.
• Advanced knowledge, skill and ability in designing, developing, implementing, administering and securing databases and data warehouses.
• Proficient with the software development life cycle (SDLC), identifying and documenting user requirements, analyzing requirements and architecting solutions, planning and managing development activities, testing strategies and implementation and maintenance procedures.
• Advanced knowledge in technology innovations to support department’s needs to support customers and manage day-to-day business.
• Working-level knowledge of business and management principles involved in planning, resource allocation, leadership techniques, production methods and coordination of people and resources.

Preferred qualifications:

• Experience utilizing and implementing Amazon Web Services (AWS) services databases such as Aurora and RDS.
• Experience with modern cloud database engines like Snowflake.
• Demonstrated ability to develop and implement internal standards to guide the organization in the design of technical solutions.

About HCA:

Functioning as both the state's largest health care purchaser and its behavioral health authority, the Washington State Health Care Authority (HCA) is a leader in ensuring Washington residents have the opportunity to be as healthy as possible.

There are three pillars of our work: Apple Health (Medicaid); the Public Employees Benefits Board (PEBB) and School Employees Benefits Board (SEBB) programs; and behavioral health and recovery. Under these pillars, HCA purchases health care, including behavioral health treatment for more than 2.7 million Washington residents and provides behavioral health prevention, crisis, and recovery supports to all Washington residents.

What we have to offer:

• Meaningful work with friendly co-workers who care about those we serve Voices of HCA
• A clear agency mission that drives our work and is person-centered HCA's Mission, Vision & Values
• A healthy work/life balance, including alternative/flexible schedules and mobile work options.
• A great total compensation and benefit package WA State Government Benefits
• A safe, pleasant workplace in a convenient location with restaurants, and shopping nearby.
• And free parking!

Notes:

This position is covered by the Washington Federation of State Employees (WFSE). Once the listed position(s) is(are) filled, this recruitment announcement may also be used to fill additional position(s) for up to sixty (60) days.

Prior to a new hire, a background check including criminal record history will be conducted. Information from the background check will not necessarily preclude employment.

HCA is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected, included, and empowered to bring unique ideas to the agency. HCA has five employee resource groups (ERGs). ERGs are voluntary, employee-led groups whose aim is to foster a diverse, inclusive workplace aligned with HCA’s mission. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. Studies have shown women, racial and ethnic minorities, and persons of disability are less likely to apply for jobs unless they feel they meet every qualification as described in a job description. Persons over 40 years of age, disabled and Vietnam era veterans, as well as people of all sexual orientations and gender identities are also encouraged to apply. If you have any questions about the required qualifications or how your experience relates to them, please contact us at [e-mail]. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact Angelic Matthews at [e-mail].

The Washington State Health Care Authority (HCA) is an E-Verify employer. All applicants with a legal right to work in the United States are encouraged to apply.

E-Verify® is a registered trademark of the U.S. Department of Homeland Security.