Job Description
Developer - GIS Developer - - Ashburn, VA - work from home job Company: Job description: Job Description GIS Developer Ashburn, VA (Hybrid) MUST: Experienced GIS Developer 2+ years of experience in GIS Development Relational database administration and development in Oracle and bolthires SQL Server systems. Knowledge of relational database architecture, administration, and management in Oracle, bolthires Access, and bolthires SQL Server systems. bolthires 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, bolthires Access, Python, ArcGIS Arcade, Crystal Reports, bolthires 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. bolthires Earth and KML/KMZ creation. Linear Referencing in ArcGIS and ArcPro DUTIES: 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 programs 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 bolthires Access, Oracle, bolthires 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 organizations 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. Create and manage accounts to access the databases and track changes done by the users. Performance Management (for DBA position only): Monitor and review performance variables for the database system to support the IT Team (such as disk and network Input/Output, CPU utilization, paging rates, and database cache hit ratios, checking for contention, unbalanced index growth, and other performance related events).
Space Management: Monitor the components of the database systems space management, such as disk space capacity, swap space available, objects reaching maximum extents, and amount of free space. They shall advise IT Team when disk space is reaching capacity and verify the completeness of the RIP data. Data Integrity and Quality Control (QC): Perform quality control on large datasets (including spatial GIS datasets) created by themselves or obtained from others. Assist with database QC of the total database structure for the RIP via the MS Access and SDE/Oracle formats.
Creating, updating, and removing protocols (tests) to ensure a complete and accurate database. Spatial data QC will be required using ESRI Products and using any proprietary software and they will be responsible for creating and updating protocols (tests) to ensure a complete and accurate spatial database. File Management / Change Management: Create and implement a backup and recovery strategy for the databases. Monitor the components of the database systems and other files related to the database and data within Maintaining a change management system and tracking versioning.
This is critically important to maintaining historical records of script and database development for knowledge transfer and process tracking. Fault Management: Monitoring the database system and an alert will trigger when specific types of events occur, such as when the database is down, new alerts have been written to log files, and when users are unable to connect to the database. • Quadrant, Inc. is an equal opportunity and affirmative action employer. Quadrant is committed to administering all employment and personnel actions on the basis of merit and free of discrimination based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or status as an individual with a disability.
Consistent with this commitment, we are dedicated to the employment and advancement of qualified minorities, women, individuals with disabilities, protected veterans, persons of all ethnic backgrounds and religions according to their abilities. Expected salary: $40 - 45 per hour Location: Ashburn, VA Job date: Sat, 16 Sep 2023 05:41:49 GMT Apply for the job now! Apply tot his job Apply tot his job Apply tot his job