Job Title: Product Specialist 4/PS4 (this is the position discussed on the 12/5 Supplier call)
NFPRate: $63.02
Interview: Onsite Interviews are required. The management team is willing to conduct an initial Skype interview but would still need to meet on-site for any additional interviews Please submit resumes in a word document and remove all candidate personal information (phone,address,email) and vendor information (logos).
Will close to submissions on: Thursday 12/12 @10AM
PLEASE DO NOT reach out to ANY individuals at ODOT regarding this posting. All questions/comments/etc. must be directed to the MSP Team, specifically, Andy Hovest. Thank you in advance for your cooperation and support on this.
Role: Product Specialist 4 (PS4). The PS4 is requested from TBD, 2019 to June 30, 2020 (TBD hours)
ALPS Project: DOT – Staff Augmentation
MBE/Open Market
Position Responsibilities:
This position is in ODOT’s Department of Information Technology.
Successful candidates for this position should have a combination of experience in information technology and administering enterprise geographic information systems with an expected emphasis of 70% IT and 30% GIS.
GIS experience should be focused on administering & supporting server-side enterprise technologies, rather than desktop mapping and analysis technologies.
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, ArcGIS Online / 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.
Required Skills & Experience:
Information Technology Skills & Experience
• Six years or more experience with:
o Implementation, configuration, and administration of Windows Server (2008 through 2016).
o Troubleshooting, identifying, and resolving system level problems in Windows Server environments.
o Support of enterprise system architectures, load balancing, and networking basics.
• Understanding of virtualized environment configuration and operation.
• Understanding of Active Directory functionality, including authentication and group-based authorization.
• Understanding of MSSQL Server database operation, permissions, and capabilities in an enterprise environment.
• Understanding of Oracle 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.
Geographic Information Systems Skills & Experience
• Four years or more experience with:
o Administering, designing, building, and implementing enterprise GIS systems.
o ESRI administration, specifically: Enterprise SDE geodatabase, ArcGIS Server, Portal, ArcGIS Online.
o ESRI geodatabase administration in an MSSQL environment.
• Experience developing, publishing, administering, and using REST services with ArcGIS Server.
• Experience deploying and maintaining Web Adaptors for ArcGIS Server.
• Experience developing and troubleshooting Python scripts.
• Experience developing, testing, and implementing ETLs with ArcGIS Model Builder.
• Experience with system integrations of ArcGIS in an enterprise environment.
• Experience administering ArcGIS Online users, groups, data, and maps.
• Experience using ArcToolbox and custom Python tools for data manipulation.
Desired Skills & Experience:
Information Technology Skills & Experience
• Experience with Microsoft Azure Cloud Computing Platform & Services.
• Experience performing end-to-end solution testing & troubleshooting.
• Experience with system monitoring tools and performance analysis for troubleshooting and system scaling.
• Experience with ADFS for AD, SAML, or other authentication methods.
Geographic Information Systems Skills & Experience
• Experience with Roads & Highways (including Event Editor/RCE).
• Experience with FME Server and FME Desktop.
• Experience with ESRI Data Reviewer and Work Flow Manager.
• Experience using Data Interoperability to create various data source connections and transforms.
• Experience with Microsoft PowerBI for data visualization.
• Familiarity with ArcGIS Desktop.
• Familiarity with using Collector for ArcGIS app to perform data collection.
• Familiarity with ArcGIS Pro.
• Familiarity with ESRI Web AppBuilder.
• Understanding of base map services.
• Familiarity with OGC-compliant web services (e.g. WMS).
