Bridge Systems Database Architect Onsite Ashburn

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

Benefits offered by this job

PTO

Paid Holidays

Medical

Dental

Vision

401(k)

Sick Leave

Job summary

Zachary Piper Solutions seeks a Database Administrator / Software Developer to support a federal program focused on bridge inspection systems and infrastructure data. This onsite role in Ashburn, VA requires developing and maintaining enterprise applications and databases.

Responsibilities include designing and optimizing SQL Server, Oracle, and Access databases; creating queries, reports with Crystal Reports and Power BI; and supporting field data collection with up to 25% travel; Public Trust

Qualifications

• Experience with ASP.NET MVC, Classic ASP, VB.NET, Visual Studio, and Python.
• Strong experience with SQL Server, Oracle, and Microsoft Access.
• Proficiency with JavaScript, jQuery, CSS, XML, JSON, HTML/XHTML, and VBA.
• Understanding of relational database design and object-oriented programming.
• Experience with database administration, patching, tuning, and maintenance on Windows servers.
• Familiarity with NBIS, NTIS, SDMS, PONTIS, BrM, or AssetWise preferred.
• Ability to obtain and maintain a Public Trust clearance.

Responsibilities

• Develop, test, and maintain web and Windows-based applications supporting bridge inspection data.
• Design, administer, and optimize SQL Server, Oracle, and Microsoft Access databases.
• Develop and optimize SQL queries, stored procedures, triggers, and database packages.
• Perform database migrations, backup/recovery, performance tuning, and capacity planning.
• Develop reports and data visualizations using Crystal Reports, Power BI, and GIS tools.
• Troubleshoot application and database issues while maintaining federal security and engineering standards.
• Maintain schemas, data models, data dictionaries, and technical documentation.
• Support field inspection activities and data collection, requiring up to 25% travel.

Skills

ASP.NET MVC

Classic ASP

VB.NET

Visual Studio

Python

SQL Server

Oracle

Microsoft Access

JavaScript

jQuery

CSS

XML

JSON

HTML/XHTML

VBA

Relational database design

Object-oriented programming

Database administration

Windows servers

NBIS/NTIS/SDMS/PONTIS/BrM/AssetWise

Public Trust clearance

Tools

Crystal Reports

Power BI

GIS tools

Job description

Zachary Piper Solutions seeks a Database Administrator / Software Developer to support a federal program focused on bridge inspection systems and infrastructure data. This onsite role in Ashburn, VA requires developing and maintaining enterprise applications and databases.

Responsibilities include designing and optimizing SQL Server, Oracle, and Access databases; creating queries, reports with Crystal Reports and Power BI; and supporting field data collection with up to 25% travel; Public Trust