Senior Database Analyst ITAM Ivanti
Senior Database Analyst ITAM Ivanti
Posted on :
29-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Title: Senior Database Analyst IT Asset Management (Ivanti ITSM/ITAM Specialist)
Location: Salem OR/Remote
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:
Contractors 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 Ivantis data model.
- Create and support 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 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.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
