Columbus,OH 5 days a week.
In-person interviews are required
The focus of this role is to provide technical infrastructure administration and support for the agency’s enterprise geographic information systems (GIS) technology, including:
• Performing enterprise GIS software installations (ArcServer, ESRI Enterprise, SDE geodatabase, Portal, Web Adaptors, etc.).
• Providing on-going monitoring and troubleshooting of GIS infrastructure.
• Creating system architecture documentation, scoping & building new environments.
• Automating processes such as ETLs, GIS environment administration tasks, and other monitoring needs.
• Ensuring environments maintain compliance with enterprise IT security policies (e.g. secure access, least privilege, and separation of duties).
• Advising on GIS system integrations.
• Maintaining knowledge of trends and developments in GIS systems, and how those could apply to existing or future ODOT applications.
• Maintaining and troubleshooting ArcGIS Collector environments.
• Reporting project status metrics and team performance metrics to different levels of management in a timely fashion.
Information Technology Skills & Experience
• Understanding of enterprise networking concepts such as load balancing, firewalls, and traffic flow.
• Understanding of virtualized environment configuration and operation.
• Understanding of Active Directory functionality, including authentication and group-based authorization, and ADFS.
• Understanding of MSSQL Server database operation, permissions, and capabilities in an enterprise environment.
• Experience writing SQL statements to query and modify data in MSSQL Server and Oracle databases using SQL Server Management Studio and Aqua Data Studio.
• Clear, concise communication & documentation skills with experience documenting system architecture and use cases.