Database Analyst

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food, and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.

OIS is currently undergoing a large IT Service Management (ITSM) system replacement project, transitioning from legacy CA Service Desk Manager (SDM) and CA Asset Portfolio Management (APM) to Ivanti ITSM and Neurons for Discovery and Configuration Management.

This role is critical to supporting the configuration of Ivanti for an automated and scalable IT asset tracking.

We are seeking an experienced Database Analyst IV to support design, development, testing, and implementation of data structures required for hardware and software asset tracking, purchasing workflows, and configuration item (CI) management. This role will provide technical expertise in translating legacy manual processes into structured, normalized datasets supporting data modeling, cleansing, migration, and process alignment to enable automation, workflows, and reporting within Ivanti s ITSM and ITAM platforms

Scope:

Key Person under this WOC will participate in the OIS ITSM Maturation Project by supporting the transition and instantiation of ITAM data from legacy sources to the Ivanti suite. The Key Person will:

Collaborate with the Asset Management team members to support the configuration and management of relational data models aligned with Ivanti ITSM and Neurons platform requirements.

Translate spreadsheet-based and manual processes into structured, scalable data systems to support hardware/software asset and purchasing workflows.

Contribute to the design and population of the configuration management database (CMDB), asset inventories, and line-item-level purchasing structures.

Assist in mapping legacy records (e.g., hardware, software, vendor, location, financial) into Ivanti object structures, identifying and integrating missing or incomplete data.

Support integration efforts with procurement systems, inventory sources, and automated discovery tools.

Plan and support data migration activities, including extraction, transformation, and load (ETL), testing, cleanup, and validation.

Ensure data normalization, integrity, and accessibility across the asset lifecycle, incorporating performance tuning, error correction, and auditing best practices.

Collaborate with internal technical teams and vendors to troubleshoot and validate data mappings, field configurations, and automation triggers.

Document custom database structures, data dictionaries, and configuration elements to support maintainability and knowledge transfer.

Tasks:

Contractor s Key Person shall:

Review existing data systems models, queries, quality, security and provide recommendations and a suggested roadmap for migration.

Provide expertise and guidance for data cleansing, data validation, data standardization, and data purging, with a focus on transforming and importing legacy data from Excel and CA APM into Ivanti.

Establish repeatable processes for data quality control, deduplication, and validation to support ongoing bulk imports and integrations.

Provide expertise and guidance for data mapping, including identifying authoritative sources and defining key configuration items (CIs), relationships, and lookup values in support of Ivanti's data model.

Create and support execution of plans for resolving data anomalies and discrepancies, including identifying gaps in current data and reconciling conflicting or incomplete records.

Provide expertise, create plans, and support execution of ETL (extract, transform, load) activities to transition data into the Ivanti platform.

Recommend and support strategies for maintaining long-term database health, performance, and governance.

Partner with the project team members to define and document asset lifecycle processes such as procurement, deployment, changes, and disposals, ensuring alignment with audit and compliance requirements.

Develop technical documentation, data dictionaries, and configuration guides; assist in creating training and knowledge base materials to support long-term maintainability and staff enablement.

Provide knowledge transfer, guidance, and industry best practices with regards to the tasks above.

Required skills and experience:

The key person must have similar, recent experience supporting the launch of Ivanti tools, including recent, relevant experience:

Hands-on ETL experience migrating from legacy ITAM data to Ivanti.

Experience mapping legacy records to Ivanti object structures.

Experience with data cleansing, validation, standardization, and purging as part of an Ivanti implementation.

Proven ability to detect and resolve data anomalies and discrepancies.

In-depth understanding of Ivanti data mapping and platform capabilities.

In-depth knowledge of industry best practices for data modeling, cleansing, and migration.

Demonstrated experience in relational database design, development, and analysis.

Strong SQL skills (e.g., PostgreSQL, SQL Server, Oracle).

Familiarity with CI relationships and CMDB structures in an ITSM/ITAM context.

Ability to clearly document schema designs, data definitions, and mapping logic.

Experience working in large public sector environments.

Ability to work independently, manage competing priorities, and work collaboratively with state staff.

In addition, the ideal candidate will have skills and experience in:

Ivanti ITSM and Neurons for Discovery/Configuration.

Familiarity with CA Service Desk Manager (SDM) and Asset Portfolio Management (APM).

Knowledge of ITIL v4 practices, especially Asset Management, Configuration Management, and Change Enablement.

Experience with CMDB best practices and automated discovery tools.

Understanding of service catalog structure and line-item-level procurement workflows.

Experience working on state government or similar public sector IT projects.

Building and managing scalable, clean, and auditable datasets in support of enterprise ITSM and ITAM solutions.

Experience performing knowledge transfer / mentoring.

Covendis rate card description for a Database Analyst IV:

Maintains data storage and access by evaluating, designing and implementing company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a manager. May require a bachelor s degree in a related area and 0 2 years of relevant experience.

Full-time professional work experience in Software Development, Maintenance, or Implementation. Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.) Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years. Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.) Two (2) years of work experience as a Data Administrator; Data Warehousing Administrator; Data Architect; Database Analyst-Intermediate; Data Warehousing Analyst may substitute for all of the required experience.

Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.

Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate.

This position is approved for remote or hybrid work.

Remote onboarding will be required for the first day.

The selected key person could potentially telecommute, as agreed to between the Agency Authorized Representative and the key person. Any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a regular basis. The key person should be available to work onsite within a reasonable timeframe.

Telecommuting will be contingent upon the key person providing his/her own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via VPN or similar software. No hardware or additional software will be provided at the key person's home site or his/her PC.

For Services that are agreed to occur remotely that those Services will only be completed by the Key Person resourced for the Project and all work must be performed in the United States of America. Remote engagement requires Key Person to have consistent access and/or clarity for: high speed internet, cellular phone/landline phone, web camera and microphone.

OIS operates on standard business days (Monday - Friday, 8 AM 5 PM, Pacific Standard Time, except for State of Oregon holidays and business closures) and Key Person must be available to engage with OIS/ODHS as agreed upon with OIS management.

Skills:

Data Analysis Advanced (7-9 Years)

Data Modeling Advanced (7-9 Years)

DBA Advanced (7-9 Years)

Microsoft Access Advanced (7-9 Years)

Microsoft SQL Server Advanced (7-9 Years)

MySQL Advanced (7-9 Years)

PostgreSQL Advanced (7-9 Years)

Migrating legacy ITAM data to Ivanti Advanced (7-9 Years)

CA APM Proficient (4-6 Years)

CMDB Expertise Proficient (4-6 Years)

Experience in large public sector environments Proficient (4-6 Years)

Industry best practices for data modeling, cleansing, migration Advanced (7-9 Years)

ITIL Proficient (4-6 Years)

Ivanti ITSM Proficient (4-6 Years)

Ivanti Neurons Proficient (4-6 Years)

Mapping legacy records to Ivanti data structure Advanced (7-9 Years)

Backup and recovery Advanced (7-9 Years)

Communication skills both verbal and written Advanced (7-9 Years)

Team work Advanced (7-9 Years)

MicrosoftOffice Advanced (7-9 Years)