Database Engineer 2 (FORECASTED)

We need to output HTML fragment with sections: h3 headings for sections present: About the role (description), Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must include only sections with real specific content. Remove boilerplate, EEO, legal, etc. Keep all substantive info. We need to parse the posting. First line: "This Position is Contingent on Contract Award**" then description. We need to produce sections: - About the role: likely the description paragraph(s) after "Description Columbia Technology Partners is seeking a Database Engineer 2 ..." That includes overview. We'll put that in

. - Responsibilities: list of key responsibilities bullet points. - Minimum Qualifications: maybe under Requirements? The posting has "Minimum Qualifications" and "Preferred Qualifications". Also "Requirements" includes US Citizenship, etc. We need to decide sections. We have headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to map content. - About the role: description paragraph(s) about role. - Responsibilities: bullet list of responsibilities. - Requirements: includes US Citizenship, security clearance, polygraph, DOD 8570 certification, maybe also "U.S. Citizenship is required for all applicants." Also "Employment is contingent upon successful completion of a security background investigation and polygraph." Also "Certification Requirements: DOD 8570 Certification". Also "This position requires an active Security Clearance with appropriate Polygraph." Also maybe "All applicants and employees are subject to random drug testing..." but that's boilerplate legal? Might be considered EEO/legal; we should remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate. The drug testing might be considered legal; but it's a requirement? Might be considered part of requirements. However instruction: remove EEO/equal-opportunity/scam-warning boilerplate. Drug testing is not EEO; it's a condition. Might keep? But could be considered boilerplate. Safer to keep only substantive: US Citizenship, security clearance, polygraph, DOD 8570 certification. Also maybe "U.S. Citizenship is required for all applicants." Keep. - Qualifications: Minimum Qualifications and Preferred Qualifications. Could combine under Qualifications heading with subpoints? But we need to use

• for any list of duties/requirements/benefits. So we can list Minimum Qualifications as bullet points, Preferred Qualifications as bullet points. - Skills: maybe not explicitly listed; but we could infer from responsibilities? However we should not invent. If no explicit skills section, we should not create Skills heading. - Benefits: there is a section "Really Good Benefits, For Really GREAT People" with details: Medical, Vision + Dental, Retirement, PTO + Leave, Career Growth, Life and AD&D Insurance/Short-Term & Long-Term Disability, Profit Sharing Bonus, Referral Bonus Program. Also mention "Salary Range Transparency" but that's about pay. So Benefits section should include those details. - Pay: there is "Salary Range Transparency" section describing how they determine salary ranges, but no actual numbers. It says "Our pay is competitive". No specific numbers. According to instruction: never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD") and never create Pay/Schedule/Benefits sections unless the posting actually states them. The posting does state "Salary Range Transparency" but does not give actual numbers or range. It describes how they determine salary ranges but not actual numbers. Is that considered filler? It's not a specific number, but it's substantive description of how they determine salary. The instruction says: never create Pay/Schedule/Benefits sections unless the posting actually states them. It does state a section about salary ranges, albeit without numbers. I'd argue we can include Pay section with the description of how they determine salary ranges (the factors). That is substantive content. Not just placeholder like "competitive". So we can include Pay. - Schedule: no mention of schedule (full-time, part-time, hours). Not present, so omit Schedule. - Skills: not present as separate heading; we could omit. Thus sections: About the role, Responsibilities, Requirements, Qualifications, Benefits, Pay. We need to use

  for each section heading. Inside each section, use

  for prose,

  • for lists. We must preserve all substantive information; do not invent or summarize away detail. We need to include all details from the posting, except boilerplate. Let's extract details. About the role: The description paragraph(s) after "Description Columbia Technology Partners is seeking a Database Engineer 2 to support the design, development, implementation, and optimization of mission-critical database systems. The ideal candidate will provide technical expertise throughout the database lifecycle, supporting database architecture, data storage and retrieval solutions, system performance improvements, and the development of database software supporting complex enterprise environments. This role contributes to requirements analysis, database design, implementation, testing, and operational deployment while ensuring solutions align with system architecture, performance objectives, security requirements, and operational needs." We should keep that as a paragraph (maybe two sentences). Could combine into one

    . Responsibilities: bullet list: - Design, develop, implement, and maintain database systems supporting data storage, retrieval, flow, and analysis requirements. - Develop and optimize database structures, schemas, queries, scripts, macros, and data-loading solutions to support operational and business needs. - Support and lead database development efforts, including database parser software and database loading software. - Analyze system requirements and recommend database improvements, optimization strategies, and maintenance activities. - Translate customer and system requirements into scalable database architectures and data models. - Develop database solutions that balance data volume, user demand, distribution requirements, performance, retention policies, security, and domain controls. - Support short- and long-term database administration and design planning efforts. - Collaborate with system engineers, developers, and stakeholders throughout the system lifecycle, from requirements development through system acceptance testing and Initial Operational Capability (IOC). We need to keep exactly as written. Requirements: bullet list: - U.S. Citizenship is required for all applicants. - Employment is contingent upon successful completion of a security background investigation and polygraph. - Certification Requirements: DOD 8570 Certification (this position requires an active Security Clearance with appropriate Polygraph). Actually the text: "Certification Requirements:DOD 8570 Certification This position requires an active Security Clearance with appropriate Polygraph." We'll combine: Must have active Security Clearance with appropriate Polygraph and DOD 8570 Certification. Also maybe "All applicants and employees are subject to random drug testing in accordance with Executive Order 12564." This is a requirement but could be considered legal boilerplate. The instruction says remove EEO/equal-opportunity/scam-warning boilerplate. Drug testing is not EEO; it's a condition. Might keep? However many job postings include drug testing as standard; but it's still a requirement. I'd keep it to be safe? The instruction: "Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate". Drug testing could be considered legal boilerplate. I'd remove it to be safe. Also "CTP is an equal opportunity employer..." is EEO, remove. So we keep only citizenship, security clearance/polygraph, DOD 8570 cert. Qualifications: Minimum Qualifications bullet list: - Bachelor's degree in a technical discipline and five (5) years of experience as a Database Engineer supporting programs of similar scope and complexity; five (5) additional years of DBE experience may be substituted for the degree. - Experience designing, developing, and maintaining relational and/or object-oriented database solutions. - Experience developing database schemas, queries, scripts, and data manipulation solutions to support enterprise data environments. - Experience supporting database architecture, performance optimization, and data storage/retrieval requirements. Preferred Qualifications bullet list: - Experience with database architecture and enterprise-scale system integration. - Experience supporting cloud-based database storage and retrieval methodologies. - Knowledge of database performance tuning, security controls, and data retention requirements. - Experience collaborating across business and technical teams to develop database solutions throughout the system development lifecycle. We could combine under Qualifications heading with two sublists? But we need to use

    • for any list. Could have two separate
      under same heading, each preceded by a

      indicating Minimum Qualifications and Preferred Qualifications. Or we could make separate sections? But we only have Qualifications heading; we can include paragraphs before each list. Benefits: need to capture all benefits details: From "Really Good Benefits, For Really GREAT People": - Medical: CTP offers 3 superior plans, bringing our employees both in-network and out-of-network options. - Vision + Dental: Both free to you + paid in full by CTP. - Retirement: 401k - 6% company contribution - PTO + Leave: A work life balance is extremely important to our team here at CTP, which is why our paid time off plans are so lucrative. Offering customizable leave plans to meet your needs is just one of our many perks! Jury Duty, Bereavement + Military Leave provided. - Career Growth: Up to $10,000 provided for approved career-related learning, training, education, and/or tuition. - Life and AD&D Insurance/Short-Term & Long-Term Disability: More peace of mind, at zero cost to you. - Profit Sharing Bonus: End of year cash gets added to your bottom-line. - Referral Bonus Program: Our tiered program provides an incentive with each stage of the hiring process your referral passes. Our bonuses range from $7,000-$20,000, if your referral joins the team. Also maybe mention "Our pay is competitive, our missions are critical, and our benefits represent what matters most to CTP: Our People." That's more fluff but could be included as prose. We should keep all those details. Pay: from "Salary Range Transparency" section: - Paragraph: "At Columbia Technology Partners we are committed to transparency and fairness in our compensation practices. We believe in creating a work environment where employees feel valued, empowered, and rewarded for their contributions." - Then "How We Determine Salary Ranges" with bullet factors: - Job Role and Responsibilities: The specific duties and responsibilities associated with each role form the foundation of our compensation structure. - Market Research and Industry Benchmarks: We conduct regular analysis of market trends and salaries across our industry, using reliable compensation data to ensure we stay competitive. - Experience and Qualifications: An individual's experience, education, certifications, and specialized skills all contribute to determining their position within a salary range. - Location: Salary ranges may be adjusted based on geographic cost of living, in accordance with local and national standards. - Company Performance: Our compensation practices also take into account overall company performance and financial health, ensuring that we maintain sustainability while rewarding our team. We should keep that as a

      intro and then a

      • list. We must not include any boilerplate like EEO, legal, etc. Also remove duplicated lines. Check for duplicated lines: The posting repeats "Columbia Technology Partners is an Equal Opportunity Employer." etc. We'll remove. Now construct HTML. We'll start with

        About the role

        then

        ...

        Then

        Responsibilities

        with each responsibility as
        • . Then

          Requirements

          with each requirement. Then

          Qualifications

          maybe include a

          Minimum Qualifications:

          ... then

          Preferred Qualifications:

          ... Then

          Benefits

          Really Good Benefits, For Really GREAT People

          maybe as intro then
          with each benefit. Then

          Pay

          At Columbia Technology Partners we are committed