Database Administrator/Software Developer
Zachary Piper Solutions · Ashburn, VA · Yesterday
On-siteInformation Technology$90k–$100k/yrFull-time
We need to output HTML fragment with headings for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title as heading. Must not include Job ID etc. Must preserve all substantive info. Remove boilerplate, navigation, legal, EEO, etc. Also remove SEO keywords line. Also remove duplicated lines. Must not create sections with filler like "commensurate with experience". We have content: description about role, responsibilities list, required qualifications, preferred qualifications, compensation (salary range, benefits, compressed schedule). Also location: onsite in Ashburn, VA. Also mention compressed work schedule available. Also mention travel up to 25% (field trips). Also mention Public Trust clearance. Also mention ability to travel up to 25% (duplicate). Also mention "Join a team responsible..." etc.
We need to map to sections: About the role (intro paragraph). Responsibilities (list). Requirements (maybe required qualifications). Qualifications (maybe preferred qualifications). Skills (maybe technical skills list). Benefits (benefits package). Pay (salary range). Schedule (compressed work schedule). Also maybe location? Could be part of About the role.
We must not create sections with placeholder. Ensure each section has content.
Let's extract content:
About the role: "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 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."
That's about role.
Responsibilities list: bullet points after "Responsibilities for the Database Architect / Software Developer include:" then list items.
We need to preserve all bullet points.
Let's list them:
- 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.
Now Required Qualifications: after "Required Qualifications for the Database Architect / Software Developer include:" then list:
- Experience developing software using MVC, Classic ASP, , Visual Studio, and Python. (Note there is a stray comma after Classic ASP; but we keep as is.)
- 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.
Preferred Qualifications: after "Preferred Qualifications:" then list:
- Experience generating reports using Crystal Reports and Power BI.
- Experience with SharePoint development or GIS mapping tools.
- Agile project management experience.
Compensation: after "Compensation for the Database Architect / Software Developer includes:" then:
- 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
Also there is "SEO Keywords:" line which we drop.
We need to map to sections: About the role (intro). Responsibilities (list). Requirements (maybe required qualifications). Qualifications (maybe preferred qualifications). Skills (maybe technical skills list). Benefits (benefits package). Pay (salary range). Schedule (compressed work schedule). Could also include location in About the role.
We must not create sections with placeholder. Ensure each has content.
We need to decide which sections to include. We have content for About the role, Responsibilities, Required Qualifications, Preferred Qualifications, Compensation (salary+benefits+schedule). Could split compensation into Pay and Benefits and Schedule.
We have Salary Range, Benefits Package, Compressed work schedule available. So we can have Pay (
for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title as heading. Must not include Job ID etc. Must preserve all substantive info. Remove boilerplate, navigation, legal, EEO, etc. Also remove SEO keywords line. Also remove duplicated lines. Must not create sections with filler like "commensurate with experience". We have content: description about role, responsibilities list, required qualifications, preferred qualifications, compensation (salary range, benefits, compressed schedule). Also location: onsite in Ashburn, VA. Also mention compressed work schedule available. Also mention travel up to 25% (field trips). Also mention Public Trust clearance. Also mention ability to travel up to 25% (duplicate). Also mention "Join a team responsible..." etc.
We need to map to sections: About the role (intro paragraph). Responsibilities (list). Requirements (maybe required qualifications). Qualifications (maybe preferred qualifications). Skills (maybe technical skills list). Benefits (benefits package). Pay (salary range). Schedule (compressed work schedule). Also maybe location? Could be part of About the role.
We must not create sections with placeholder. Ensure each section has content.
Let's extract content:
About the role: "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 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."
That's about role.
Responsibilities list: bullet points after "Responsibilities for the Database Architect / Software Developer include:" then list items.
We need to preserve all bullet points.
Let's list them:
- 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.
Now Required Qualifications: after "Required Qualifications for the Database Architect / Software Developer include:" then list:
- Experience developing software using MVC, Classic ASP, , Visual Studio, and Python. (Note there is a stray comma after Classic ASP; but we keep as is.)
- 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.
Preferred Qualifications: after "Preferred Qualifications:" then list:
- Experience generating reports using Crystal Reports and Power BI.
- Experience with SharePoint development or GIS mapping tools.
- Agile project management experience.
Compensation: after "Compensation for the Database Architect / Software Developer includes:" then:
- 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
Also there is "SEO Keywords:" line which we drop.
We need to map to sections: About the role (intro). Responsibilities (list). Requirements (maybe required qualifications). Qualifications (maybe preferred qualifications). Skills (maybe technical skills list). Benefits (benefits package). Pay (salary range). Schedule (compressed work schedule). Could also include location in About the role.
We must not create sections with placeholder. Ensure each has content.
We need to decide which sections to include. We have content for About the role, Responsibilities, Required Qualifications, Preferred Qualifications, Compensation (salary+benefits+schedule). Could split compensation into Pay and Benefits and Schedule.
We have Salary Range, Benefits Package, Compressed work schedule available. So we can have Pay (Pay
) with salary range. Benefits (Benefits
) with list of benefits. Schedule (Schedule
) with compressed work schedule.
Skills: we could combine technical skills from required qualifications (like MVC, Classic ASP, Visual Studio, Python, SQL Server, Oracle, Access, HTML/XHTML, JavaScript, jQuery, CSS, XML, JSON, VBA/Macro, etc.) but those are already in qualifications. Might be redundant. The instruction: "Prefer a few substantive sections over many thin ones." So maybe we combine Required Qualifications and Preferred Qualifications into a single "Requirements" section? But they said use headings like Requirements, Qualifications, Skills. We could have Requirements (required qualifications) and Qualifications (preferred qualifications). Skills maybe not needed if covered. But we could still include Skills if we have distinct skill list not covered elsewhere. However the required qualifications already list many skills; we could treat them as Skills section and Requirements as something else? But we have no separate "Requirements" besides qualifications. The instruction: "Use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." So we can choose which to include. We need to avoid filler. Let's include About the role, Responsibilities, Requirements (required qualifications), Qualifications (preferred qualifications), Benefits, Pay, Schedule. That's 7 sections. Skills we could omit because it's covered.
Check that we don't repeat content. Ensure we preserve all substantive info.
Now we need to output HTML fragment only, no /, no markdown fences.
We'll produce:
About the role
About the role
...
Responsibilities
- ... ...
Requirements
- Experience developing software using MVC, Classic ASP, 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.
Qualifications
- Experience generating reports using Crystal Reports and Power BI.
- Experience with SharePoint development or GIS mapping tools.
- Agile project management experience.
Benefits
- PTO
- Paid Holidays
- Medical
- Dental
- Vision
- 401K
- Sick Leave as required by law
Pay
Salary Range: $90,000 – $100,000
Schedule
Compressed work schedule available
We also need to include location maybe in About the role. Already we have "onsite in Ashburn, VA". Good. Check for any missing substantive info: The description also mentions "Join a team responsible for developing software and databases that ensure the accuracy, security, and performance of critical national infrastructure inspection data." included in About the role. Also mention "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." included. Also mention "Participate in bridge inspection field trips (up to 25% travel) for data collection and QA/QC." included in Responsibilities. Also mention "Support software integration, troubleshoot issues, and ensure compliance with federal security requirements." included. Also mention "Maintain documentation including schemas, data models, data dictionaries, and software engineering standards." included. Also mention "Generate and maintain Section 508‑compliant reports and maps using Crystal Reports, Power BI, and GIS tools." included. Also mention "Develop database applications aligned with NBIS, NTIS, and NTI federal inspection standards." included. Also mention "Install, configure, patch, tune, and maintain Microsoft SQL Server, Oracle, and Microsoft Access databases." included. Also mention "Create and optimize triggers, procedures, packages, and SQL statements to improve system performance." included. Also mention "Perform data migration, backup and recovery, performance monitoring, and capacity planning." included. Also mention "Enhance and maintain the FLH Bridge Data Management Web System and internal FHWA intranet applications." included. Also mention "Design, develop, test, and maintain web‑based and Windows‑based applications supporting bridge inspection data." included. Also mention "Experience developing software using MVC, Classic ASP, , Visual Studio, and Python." we removed extra comma after Classic ASP? We kept "MVC, Classic ASP, Visual Studio, and Python." The original had a stray comma after Classic ASP; we can keep as "MVC, Classic ASP, Visual Studio, and Python." That's fine. Also mention "Strong experience with Microsoft SQL Server, Oracle, and Microsoft Access database administration." included. Also mention "Proficiency with HTML/XHTML, JavaScript, jQuery, CSS, XML, JSON, and VBA/Macro programming." included. Also mention "Knowledge of database design, object‑oriented programming, and relational database management." included. Also mention "Experience installing, patching, tuning, and maintaining databases on Windows servers." included. Also mention "Familiarity with NBIS, NTIS, or federal inspection data systems (SDMS, PONTIS, BrM, AssetWise)." included. Also mention "Must be able to obtain and maintain a Public Trust clearance." included. Also mention "Ability to travel up to 25% for field inspection support." included. Preferred qualifications: "Experience generating reports using Crystal Reports and Power BI." included. "Experience with SharePoint development or GIS mapping tools." included. "Agile project management experience." included. Compensation: Salary range, Benefits Package, Compressed work schedule available. We split benefits and schedule. Check benefits list: "PTO, Paid Holidays, Medical, Dental, Vision, 401K, Sick Leave as