Database Architect - 174029

Zachary Piper Solutions; Ashburn, Northern (VA, KY); Hybrid; USD 90,000 - 100,000; Full time

Benefits offered by this job

On-site in Ashburn, VA

Compressed work schedule

Full benefits package

Job summary

Zachary Piper Solutions is seeking a Database Architect / Software Developer to support a federal program focused on national bridge and tunnel inspection systems, data, and enterprise-level applications. This on-site role in Ashburn, VA offers a compressed work schedule and opportunities to design, develop, and maintain key data systems.

Responsibilities include building web and Windows apps, managing SQL Server, Oracle, and Access databases, and creating reports with Crystal Reports, Power BI,

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

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

JavaScript

Tools

Microsoft SQL Server

Oracle

Microsoft Access

HTML/XHTML

jQuery

CSS

XML

JSON

VBA/Macro

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.

Responsibilities for the Database Architect / Software Developer include:

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

Required Qualifications for the Database Architect / Software Developer include:

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

Compensation for the Database Architect / Software Developer includes:

• 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

#LI-MC1 #LI-ONSITE

SEO Keywords:

Database Architect, Software Developer, Developer, SQL Server DBA, Oracle DBA, Microsoft Access Developer, Web Developer, Bridge Inspection Data, NBIS, NTIS, Federal Lands Highway, FHWA, Crystal Reports Developer, Power BI Developer, Section 508 Compliance, Data Migration, Database Performance Tuning, Public Trust Clearance, Ashburn VA Jobs, Federal IT Jobs, Infrastructure Data Systems, Mission-Critical Software, DOT Systems, BrM, AssetWise, SDMS, PONTIS.