DOT-PRODUCT SPECIALIST 4 (PS4)

JOB TITLE: DOT-PRODUCT SPECIALIST 4(PS4)

JOB DURATION: 12+ MONTHS

JOB LOCATION: COLUMBUS, OH (ONSITE) - PREFERRED LOCAL ONLY

EXPERIENCE: 8+ YEARS

VISA: UCS/EAD/H1B

In-person interviews are required

Complete Description: This position is in ODOT's Information Technology 3rd Party App Support Team. Successful candidates for this position should have a combination of experience and knowledge in information technology and administering enterprise geographic information systems. 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 ongoing 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.