GIS / Travelways Engineer with Security Clearance

About the role

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.

Responsibilities

• Maintain and update ESRI GIS services on existing Oracle Spatial tables as needed for mapping purposes across all TMS applications
• Support the Travelways Management System (LRS, Travelway Overlapping Browser) and Travelway Associative Maintenance application including Data Quality Assurance
• Support Location Referencing Point and Click applications and maps; support Lane Maintenance and Travelway maintenance
• Expose spatial data from ArcGIS Server as needed for the TMS Reporting System; create MXDs/MSDs as needed
• Validate changes made to the Roadway Network Coverage and coordinate ArcGIS-to-Oracle synchronization via the Travelway Maintenance Interface
• Support the Traveler Information System (Work Zones, OSOW) and Oversize Overweight Travelway Curfews Inventory System with spatial data maintenance
• 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

Requirements

• 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 MoDOT's current computer technical architecture
• Ability to pass MoDOT background check

Qualifications

• Experience administering ArcGIS services and publishing feature layers from Oracle Spatial data sources
• 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