System Modernization Analyst (Microsoft Access UI SQL Server backend

System Modernization Analyst (Microsoft Access UI + SQL Server backend, known as RBDMS) into a cloud-hosted web application in Azure)

Columbus, OH – Hybrid (Onsite)

We are seeking a highly skilled Product Specialist to support ODNR’s modernization of the RICS system and guide the retirement of the legacy RBDMS platform. This role is ideal for someone who excels in system analysis, SQL development, data synchronization, and acting as a bridge between business teams and development vendors.

Project Background

RICS Modernization:

The Division of Oil & Gas is modernizing the legacy RICS application (Microsoft Access UI + SQL Server backend, known as RBDMS) into a cloud-hosted web application in Azure.

RBDMS Legacy Support:

The legacy system is still operational. The Product Specialist will work closely with internal teams to plan the retirement/sunset of RBDMS functionality.

Deliverables / Goals

Evaluate and resolve synchronization issues between RICS system tables/fields and RBDMS data structures.

Develop a roadmap for retiring legacy RBDMS functionality still in use.

Serve as a proxy Product Owner, working with vendors to define features, user stories, and acceptance criteria in Azure DevOps.

Lead business-side testing & validation for RICS enhancements.

Manage and enhance OnBase taxonomy, including creation of new document groups and types.

Key Responsibilities

Act as the technical SME for an enterprise-wide system.

Support implementation of new products and enhancements.

Resolve bi-directional sync issues between RICS & RBDMS.

Develop a roadmap to retire legacy RBDMS functionality.

Serve as a proxy Product Owner—define features, user stories, and acceptance criteria in Azure DevOps.

Lead testing and validation of RICS enhancements with business teams.

Manage and enhance OnBase taxonomy, including new document groups and types.

Create and maintain detailed technical documentation and workflows (Visio, ADO).

Support data cleanup, ETL processes, stored procedures, and SQL trigger-based integrations.

Required Skills

7+ years MS Access & SQL Server (T-SQL) development

Strong experience with Stored Procedures, Triggers, ETL, and complex SQL for data cleanup

Hands-on bi-directional synchronization between systems

OnBase document taxonomy experience (5+ years)

Agile/SCRUM methodology (3+ years)

Ability to document processes in Azure DevOps & Visio