Mission-Critical DB Architect & Software Engineer

Piper Companies; Ashburn (VA); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Full benefits package

PTO and paid holidays

Medical, dental, vision

401K with company match

Sick leave as required by law

Compressed work schedule

Job summary

Zachary Piper Solutions is seeking a Database Architect / Software Developer to support federal bridge inspection data and enterprise applications. This onsite role in Ashburn, VA includes a compressed work schedule, with responsibilities spanning design, development, testing, and maintenance of SQL Server, Oracle, and Access databases.

Required skills include ASP.NET MVC, VB.NET, Python, and strong SQL Server/Oracle expertise. Travel up to 25% and NBIS/NTIS familiarity are preferred.

Qualifications

• 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.
• Familiarity with NBIS, NTIS, or federal inspection data systems (SDMS, PONTIS, BrM, AssetWise).

Responsibilities

• 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.

Skills

ASP.NET MVC

Classic ASP

VB.NET

Python

HTML/XHTML

JavaScript

jQuery

CSS

XML

JSON

VBA/Macro

Database design

OOP

Relational databases

Tools

Crystal Reports

Power BI

SharePoint

Job description

Zachary Piper Solutions is seeking a Database Architect / Software Developer to support federal bridge inspection data and enterprise applications. This onsite role in Ashburn, VA includes a compressed work schedule, with responsibilities spanning design, development, testing, and maintenance of SQL Server, Oracle, and Access databases.

Required skills include ASP.NET MVC, VB.NET, Python, and strong SQL Server/Oracle expertise. Travel up to 25% and NBIS/NTIS familiarity are preferred.