Progression Inc
*Work with Progression, Inc. get your application bumped to the front of the line* Senior GIS Database Engineer Ashburn, VA MUST: 3 – 7 years developing in relational database administration (Oracle and SQL Server) 2+ years recent GIS tools and Python scripting 3+ years of relational database administration and development in Oracle and Microsoft SQL Server systems. 3+ years of relational database architecture, administration, and management in Oracle, Microsoft Access, and Microsoft SQL Server systems. 3+ years Google Earth and KML creation. Knowledge of Python scripting for customizing ArcGIS Geoprocessing tasks. 3+ years of 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 DUTIES: Maintain and create custom tools and scripts for data management Develop mobile applications for field data collection Ensure data integrity and quality control for large datasets Monitor database performance and manage security 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. 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. *Progression Inc. is an affirmative action/equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or status as an individual with a disability.* #INDPRO