Zachary Piper Solutions · 3 hours ago
Database Developer
Ashburn, VA
Full-time
Onsite
Mid Level
$85K/yr - $95K/yrZachary Piper Solutions is seeking a highly skilled Database Administrator / Software Developer to join a rapidly growing team supporting the Department of Transportation. The Database Developer will support the design, development, and maintenance of enterprise database systems used for field data collection, spatial data management, and reporting.
GovernmentInformation ServicesInformation TechnologySoftware
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Develop, administer, and optimize Oracle and SQL Server database systems
Design and maintain database objects, including tables, triggers, packages, and procedures
Build and maintain tools, scripts, and applications to support data ingestion, processing, QC, and reporting workflows
Manage spatial (GIS) data structures and integrations using ArcGIS platforms
Import, export, validate, and archive datasets while maintaining data accuracy and historical records
Implement database performance tuning, testing, and compatibility validation
Maintain data integrity through established QC processes and referential integrity standards
Support reporting and visualization deliverables for both technical and non-technical audiences
Apply Agile or similar methodologies for development and project execution
Maintain documentation, version control, and backup/recovery processes for all database systems
Qualification
Required
Experience with Oracle and Microsoft SQL Server database development and administration
Proficiency with SQL/PL-SQL and experience developing stored procedures, triggers, and functions
Experience with Python or similar scripting languages for automation and data processing
Experience with GIS platforms such as ArcGIS Desktop/Pro and ArcSDE/ArcGIS Enterprise
Familiarity with spatial data management, geodatabases, and geoprocessing workflows
Experience integrating databases with reporting tools and/or web applications
Strong understanding of data integrity, QC processes, and performance optimization
Ability to communicate technical concepts to functional and leadership stakeholders
Benefits
Comprehensive Benefits: Medical
Dental
Vision
401(k)
PTO
Sick Leave (as required by law)
Holidays
Company
Zachary Piper Solutions
Zachary Piper Solutions is an IT company providing government contracting solutions in support of the nation’s Intelligence Community.
Founded in 2011
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
$3M2018-02-22Series Unknown· $1.3M
2014-04-10Series Unknown· $1.7M
Leadership Team
Christopher Stroud
Partner Outreach & Engagements
Justin Jordan
Founder and Chairman
Company data provided by crunchbase