Database Administrator/Software Developer

Zachary Piper Solutions is seeking aDatabase Architect / Software Developerto support a federal program focused on national bridge and tunnel inspection systems, missioncritical infrastructure data, and enterpriselevel web and database applications. This position isonsite in Ashburn, VAwith acompressed work schedule available . The Database Architect / Software Developer will support the design, development, testing, and maintenance of software applications and database systems used by the Federal Lands Highway Division (FLH) Bridge Inspection Program. Join a team responsible for developing software and databases that ensure the accuracy, security, and performance of critical national infrastructure inspection data.Responsibilities for the Database Architect / Software Developer include:Design, develop, test, and maintain webbased and Windowsbased 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 508compliant 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 usingASP.NETMVC, Classic ASP,VB.NET, Visual Studio , andPython . Strong experience withMicrosoft SQL Server, Oracle, and Microsoft Accessdatabase administration. Proficiency withHTML/XHTML, JavaScript, jQuery, CSS, XML, JSON , and VBA/Macro programming. Knowledge of database design, objectoriented programming, and relational database management. Experience installing, patching, tuning, and maintaining databases on Windows servers. Familiarity withNBIS ,NTIS , or federal inspection data systems (SDMS, PONTIS, BrM, AssetWise). Must be able to obtain and maintain aPublic Trust clearance . Ability to travel up to25%for field inspection support. Preferred Qualifications: Experience generating reports usingCrystal ReportsandPower BI . Experience with SharePoint development or GIS mapping tools. Agile project management experience. 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-ONSITE SEO Keywords:Database Architect, Software Developer, ASP.NET 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, MissionCritical Software, DOT Systems, BrM, AssetWise, SDMS, PONTIS.