GIS Analyst

Position- Road Inspection Program (RIP) Developer / (Geospatial)

Location- Ashburn, VA

Clearance- Public Trust

Must haves:
Relational database administration and development in Oracle and Microsoft SQL Server
systems. Knowledge of relational database architecture, administration, and management in
Oracle, Microsoft Access, and Microsoft SQL Server systems. Google Earth and KML creation.
Knowledge of Python scripting for customizing ArcGIS Geoprocessing tasks. Detailed knowledge
of tools in ArcToolbox. Building and designing Geodatabases. Installation and management of
ArcSDE / ArcGIS Enterprise. SQL / PL-SQL, Oracle SQL Developer, Microsoft Access, Python,
ArcGIS Arcade, Crystal Reports, Microsoft SharePoint. Spatial data management in ArcGIS
Desktop and ArcGIS Pro. Deployment and administration of ArcGIS Enterprise, either in a
network or cloud environment. Skills to quickly adapt to rapidly changing software platforms to
take advantage of GIS software advances. Installation and management of ArcSDE. Editing and
analysis of spatial data in ArcGIS Desktop and ArcPro. ArcGIS Online map creation, sharing map
content, and knowledge of mapping applications. Knowledge of Python scripting for
customizing ArcGIS Geoprocessing tasks within ArcToolbox. Google Earth and KML/KMZ
creation. Linear Referencing in ArcGIS and ArcPro
Description:
Position Overview: The BIP/BMP Database Administrator/Software Developer (DBA/SD) will be
responsible for managing the existing database as well as providing updates to the system and
setting up new database systems. In addition, the DBA/SD will create or organize systems to
store different types of data and ensure databases run efficiently and securely. Also, the
DBA/SD will query databases to generate reports and present such reports in a way that non-
technical personnel in leadership can understand the data to make informed decisions.
The DBA/SD shall design, develop, install, patch, update, and test software/web applications
used for the collection, storage, and management of bridge inspection data.

Responsibilities:

• Maintain, update, and create new custom tools and scripts. These scripts and tools

facilitate tabular and spatial workflows through all stages of the RIP process such as
inventory updates, data collection, post-collection data processing, and reporting.

• Support the development and implementation of mobile applications to collect field

data and return collected data to the database system (mobile applications may or
may not be custom-built)

• Prepare final deliverables in formats required by FHWA (e.g. EFLHD Pavement

Management System) and external Partners. This may include the development of
web applications or websites to view and distribute final reports and other data.

• Assist the DBA in managing data by the program’s data QC plan and protocols.
• Utilize GIS knowledge and skills to manage spatial components of the data.
• Provide support to the DBA and Project Managers to facilitate highly efficient

workflows

• Apply Agile or similar project management methodologies for project development.
• Project Management: Apply Agile or similar project management methodologies for

project development.

• Database Management, Development, and Testing: Manage large datasets using

database systems such as Microsoft Access, Oracle, Microsoft SQL, and ESRI
products.

• Manage spatial (GIS) database administration, development, planning, and support.
• Exporting/importing data to/from RIP databases, whether this is on a regularly

scheduled basis or by special request.

• Manage data transactions with file logs and archive historical data.
• Ensure data integrity for each database that meets the organization’s requirements by

creating and maintaining

• referential integrity according to agreed-upon definitions.
• Review and test the functionality and accuracy of the database to support all data

elements. This may include testing on triggers/constraints, packages for database
access, refining SQL statements, optimizing performance, and creating/maintaining
necessary database objects.

• Ensure that proper compatibility and testing are completed before making any changes

to the existing production environment.
Road Inspection Program (RIP) Developer with GIS skills

Job Type: Full-time

Salary: $85,000.00 - $90,000.00 per year

Schedule:

• 8 hour shift

Security clearance:

• Confidential (Required)

Work Location: In person