GIS Travelways Engineer Job id007

POSITION SUMMARY

The GIS / Travelways Engineer maintains the ESRI ArcGIS services layer that powers TMS spatial capabilities and the Location Referencing System (LRS) at the core of the TMS architecture. Every application in the TMS portfolio from Adopt-A-Highway to OSOW restrictions to the Bridge Management System is spatially keyed to Missouri travelways and log miles. This individual maintains ArcGIS Server Portal and Pro services; supports the Travelways Management System and Location Referencing applications; exposes spatial data to reporting systems; and creates MXD/MSD files as needed. The TMS GIS layer connects to an Oracle Spatial database with 3026 tables and must be maintained at 100% availability for downstream TMS consumers.

KEY RESPONSIBILITIES

Maintain and update ESRI GIS services on existing Oracle Spatial tables as needed for mapping purposes across all TMS applications (2.3.1)

Support the Travelways Management System (LRS Travelway Overlapping Browser) and Travelway Associative Maintenance application including Data Quality Assurance (2.3.9)

Support Location Referencing Point and Click applications and maps; support Lane Maintenance and Travelway maintenance (2.3.9)

Expose spatial data from ArcGIS Server as needed for the TMS Reporting System; create MXDs/MSDs as needed (2.3.10)

Validate changes made to the Roadway Network Coverage and coordinate ArcGIS-to-Oracle synchronization via the Travelway Maintenance Interface (2.3.9)

Support the Traveler Information System (Work Zones OSOW) and Oversize Overweight Travelway Curfews Inventory System with spatial data maintenance

Support web-based map rendering for the Adopt-A-Highway Safety Data Management Outdoor Advertising Stormwater and Right-of-Way systems

Administer ArcGIS Server and Portal configurations; maintain service definitions feature layers and spatial indexes

Document all GIS service modifications and spatial data changes in the TMS Technical Records

Perform biannual (Memorial Day and Labor Day) OSOW SQL data resets as required (2.3.9)

REQUIRED QUALIFICATIONS

Minimum 3 years of GIS / geospatial engineering experience in a production environment

Minimum 1 year of experience with ESRI ArcGIS Server ArcGIS Portal and ArcGIS Pro (2.2.3)

Minimum 1 year of experience with business/location referencing applications and data (2.2.3)

Minimum 1 year of experience with Oracle Spatial database (2.2.3)

Minimum 1 year of experience similar to MoDOTs current computer technical architecture

Experience administering ArcGIS services and publishing feature layers from Oracle Spatial data sources

Ability to pass MoDOT background check

PREFERRED QUALIFICATIONS

Experience with ESRI ArcGIS Tools 10.6.1 and ESRI ArcGIS Mapping in a .NET application context

Minimum 1 year of experience with transportation-related applications including LRS or network datasets (2.2.3)

Experience with the ESRI ArcGIS SDK/REST API for integration with web applications

Experience with SQL Developer and PL/SQL for spatial query optimization

ESRI ArcGIS Desktop Professional or ArcGIS Server Specialty certification

Missouri residency or St. Louis metro area location

Familiarity with MoDOT travelway network or Missouri state road data.