Database Architect / Software Developer

Zachary Piper
Ashburn, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 100K

Job location

Ashburn, United States of America

Tech stack

Microsoft Access
ASP.NET
HTML
JavaScript
Extensible HyperText Markup Language (XHTML)
ASP.NET
CSS
Computer Programming
Databases
Crystal Reports (Reporting Software)
Data Dictionary
Data Migration
Data Systems
Database Applications
Relational Databases
Database Design
Database Queries
GIS Applications
JSON
jQuery
Python
Microsoft Visual Studio
Microsoft SQL Server
Visual Basic
Windows Server
Object-Oriented Software Development
Oracle Applications
Performance Tuning
Software Maintenance
Power BI
Software Engineering
Systems Integration
Web Applications
Windows Desktop
XML
Vba Programming Language
Performance Monitor
Data Management
FHWA

Job description

Zachary Piper Solutions is seeking a Database Architect / Software Developer to support a federal program focused on national bridge and tunnel inspection systems, mission-critical infrastructure data, and enterprise-level web and database applications. This position is onsite in Ashburn, VA with a compressed work schedule available . The Database Architect / Software Developer will support the design, development, testing, and maintenance of software applications and database systems., * Design, develop, test, and maintain web-based and Windows-based applications supporting bridge inspection data.

  • Enhance and maintain the FLH Bridge Data Management Web System and internal FHWA intranet applications.
  • Develop database applications aligned with NBIS, NTIS, and NTI federal inspection standards.
  • Install, configure, patch, tune, and maintain Microsoft SQL Server, Oracle, and Microsoft Access databases.
  • Create and optimize triggers, procedures, packages, and SQL statements to improve system performance.
  • Perform data migration, backup and recovery, performance monitoring, and capacity planning.
  • Generate and maintain Section 508-compliant reports and maps using Crystal Reports, Power BI, and GIS tools.
  • Support software integration, troubleshoot issues, and ensure compliance with federal security requirements.
  • Maintain documentation including schemas, data models, data dictionaries, and software engineering standards.
  • Participate in bridge inspection field trips (up to 25% travel) for data collection and QA/QC.

Requirements

  • Experience developing software using ASP.NET MVC, Classic ASP, VB.NET , Visual Studio , and Python .
  • Strong experience with Microsoft SQL Server, Oracle, and Microsoft Access database administration.
  • Proficiency with HTML/XHTML, JavaScript, jQuery, CSS, XML, JSON , and VBA/Macro programming.
  • Knowledge of database design, object-oriented programming, and relational database management.
  • Experience installing, patching, tuning, and maintaining databases on Windows servers.
  • Familiarity with NBIS , NTIS , or federal inspection data systems (SDMS, PONTIS, BrM, AssetWise).
  • Must be able to obtain and maintain a Public Trust clearance .
  • Ability to travel up to 25% for field inspection support.

Benefits & conditions

  • Salary Range: $90,000 - $100,000
  • Full Benefits Package: PTO, Paid Holidays, Medical, Dental, Vision, 401K, Sick Leave as required by law
  • Compressed work schedule available

Apply for this position