Zachary Piper Solutions · 8 hours ago
Database Developer
Zachary Piper Solutions is currently seeking a Database Developer in Ashburn, VA. The role involves relational database administration and development, as well as managing spatial data in ArcGIS environments.
GovernmentInformation ServicesInformation TechnologySoftware
Responsibilities
Relational database administration and development in Oracle and Microsoft SQL Server systems
Knowledge of relational database architecture, administration, and management in Oracle 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
Installation and management of ArcSDE / ArcGIS Enterprise. SQL / PL-SQL, Oracle SQL Developer, 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
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
Create Oracle Triggers, Packages and Procedures as needed to simplify workflow and ensure data consistency across the database
Qualification
Required
3 to 5 years of experience
Relational database administration and development in Oracle and Microsoft SQL Server systems
Knowledge of relational database architecture, administration, and management in Oracle 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
Installation and management of ArcSDE / ArcGIS Enterprise
SQL / PL-SQL, Oracle SQL Developer, 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
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
Linear Referencing in ArcGIS and ArcPro
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
Assist the DBA in managing data by the program's data QC plan and protocols
Create Oracle Triggers, Packages and Procedures as needed to simplify workflow and ensure data consistency across the database
Benefits
Cigna Medical
Dental
Vision
Holidays
401k
PTO
Sick leave as required by law
Company
Zachary Piper Solutions
Zachary Piper Solutions is an IT company providing government contracting solutions in support of the nation’s Intelligence Community.
H1B Sponsorship
Zachary Piper Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
$3M2018-02-22Series Unknown· $1.3M
2014-04-10Series Unknown· $1.7M
Company data provided by crunchbase