GovChime
Notice ID: 882a239a9ae84d718842d438f8311ffbCombined Synopsis/SolicitationArchived

Corps Water Management System (CWMS) Database Authorization

Archived on April 12, 2025. Original response deadline: . Full description on SAM.gov.

Overview

Response deadline
4:30 PM EDT
Posted
March 25, 2025
Notice type
Combined Synopsis/Solicitation
Set-aside
Total Small Business Set-Aside (FAR 19.5)
NAICS
541511: Custom Computer Programming Services
Agency
Department of WarDepartment of the Army

Notice details

Office
W4LD USA HECSA
Place of performance
Davis, CA
Last updated
Nov 16, 2026
First published
Last updated on SAM.gov

Identifiers

Solicitation number
W912HQ25R0007
Notice ID
882a239a9ae84d718842d438f8311ffb

Description

This is a combined synopsis/solicitation for commercial services prepared in accordance with the format in FAR 12.603 Streamlined Solicitation for Commercial Items, as supplemented with additional information included in this notice and FAR Part 13 procedures. This announcement constitutes the only solicitation. Proposals are being requested. This solicitation document and incorporated provisions and clauses are those in effect through Federal Acquisition Circular 2025-03, dated 03 JAN 2025. Background: The mission of the US Army Corps of Engineers (USACE) Institute for Water Resources (IWR) Hydrologic Engineering Center (HEC) is to serve as the USACE Center of Expertise in the technical areas of surface and groundwater hydrology, river hydraulics and sediment transport, reservoir system analysis and a number of other closely associated technical subjects. HEC's primary goal is to support the nation in its water resources management responsibilities by increasing USACEs technical capability in hydrologic engineering and water resources planning and management. Additionally, HEC provides services to other Federal, state, local and international agencies engaged in these technical areas. The Corps Water Management System (CWMS) is the Army Information System (AIS) that supports and enhances the decision-making process for the USACE water management mission. USACE is responsible for round-the-clock monitoring and operation of approximately 600 reservoir, lock and dam, and other water control projects. This responsibility also expands, during flood control operations, to approximately 120 additional Section 7 (Non-USACE) projects. The focus of this contract is on the database and API components of our CWMS system. CWMS is currently going through a transition from maintaining 32 independent, and geographically isolated systems, that feed into a public only central database, to a "single" cloud-based system that will contain all data, both public and private. Part of this transition is merging the multiple District databases into an Oracle RDS instance with an HTTP REST API called CWMS-Data-API (CDA). Previous to this decision, much of the data authorization was done within each individual database so that appropriate data constraints could be implemented while allowing District applications to access Oracle directly. The CWMS Database Schema (CWMS DB) has thus made heavy use of session contexts and the Oracle Virtual Private Database (VPD) system to provide appropriate authorization. Due to changes in technology, a more appropriate model of authorization needs to be adopted. Requirement: The objective of this contract is to develop a detailed plan on how to implement the Authorization Scheme into the CWMS Data API and then implement the created plan. This will include a review of our current data Schema and API to determine the best path forward. After the initial review, the following objectives will be required for the accomplishments of this contract. 1. ability to authorize read permissions to data objects in the database 2. ability to authorize write permissions to data objects in the database 3. ability to authorize delete permissions to data objects in the database 4. ability to authorize create permissions to data objects in the database 5. ability to authorize update permissions to data objects in the database 6. ability and platform for data administrators to assign the above permissions to users as appropriate The overall period of performance (POP) is two-hundred and seventy (270) days from the date of contract award; there are different POPs per each task in the Performance Work Statement (PWS). See the Combined Synopsis-Solicitation and the Performance Work Statement for additional information. Amendment 001 is to correct the date proposals are due on SAM.gov to match what is in the attached Combined Synopsis-Solicitation. The correct date proposals are due is 20 March 2025. Amendment 002 is to provide all answers to all questions received prior to the due date and time for questions. A revised Combined Synopsis-Solicitation is attached. A Past Performance Questionnaire is attached. The due date and time for receipt of proposals is extended to 28 March 2025. Amendment 003 is to provide additional supporting documents for the Performance Work Statement. Amendment 004 is to provide the missing Past Performance Questionnaire. Amendment 005 is to allow for an increased page count for Factors 1 and 2.

Full description on SAM.gov

Award Overview

No prior contract identified

No prior award matched this notice's agency, NAICS, place of performance and PSC within 18 months. It may be a new requirement.

Contacts

Documents

Files (9)

  • B08.03 Answers to Questions - Solicitation W912HQ25R0007 - amended 2025.03.25.docx

    39 KBAdded in Combined Synopsis/Solicitation version 10Posted
    Download
  • B08.02 USACE PPQ.pdf

    179 KBAdded in Combined Synopsis/Solicitation version 8Posted
    Download
  • Ratings-ERD.png

    262 KBAdded in Combined Synopsis/Solicitation version 7Posted
    Download
  • Location Levels-ERD.png

    283 KBAdded in Combined Synopsis/Solicitation version 7Posted
    Download
  • Time Series-ERD.png

    254 KBAdded in Combined Synopsis/Solicitation version 7Posted
    Download
  • Locations-ERD.png

    77 KBAdded in Combined Synopsis/Solicitation version 7Posted
    Download
  • B01.01 CSS - W912HQ25R0007 - CWMS Database Authorization - Amended 2025.03.10.docx

    90 KBAdded in Combined Synopsis/Solicitation version 6Posted
    Download
  • B08.03 Answers to Questions - Solicitation W912HQ25R0007.docx

    39 KBAdded in Combined Synopsis/Solicitation version 6Posted
    Download
  • A02.12 PWS CWMS Database Authorization dated 2025.02.25.docx

    586 KBAdded in Combined Synopsis/Solicitation version 4Posted
    Download

Lifecycle

  1. 3
    Version 3Sources SoughtArchived

    Corps Water Management System (CWMS) Database Authorization

    Notice be5672f0d012471c93b68acb74e3985d on SAM.gov

  2. 4
    Version 4Combined Synopsis/SolicitationArchived

    Type changed from Sources Sought to Combined Synopsis/Solicitation

    Corps Water Management System (CWMS) Database Authorization

    Notice 43d7f8435caa44ac9ec5f729bdc8e6cd on SAM.gov

  3. 5
    Version 5Combined Synopsis/SolicitationArchived

    Corps Water Management System (CWMS) Database Authorization

    Notice 97e42c7df6624625b3955fa06a8a396d on SAM.gov

  4. 6
    Version 6Combined Synopsis/SolicitationArchived

    Corps Water Management System (CWMS) Database Authorization

    Notice 67ab8856025e46dd80ea5ca18715dbc3 on SAM.gov

  5. 7
    Version 7Combined Synopsis/SolicitationArchived

    Corps Water Management System (CWMS) Database Authorization

    Notice 6c5bdad1720d47969e764fb9a875efbc on SAM.gov

  6. 8
    Version 8Combined Synopsis/SolicitationArchived

    Corps Water Management System (CWMS) Database Authorization

    Notice b9969ffbcfaf4c97a55a3114040c6615 on SAM.gov

  7. 10
    Version 10Combined Synopsis/SolicitationArchivedCurrent

    Corps Water Management System (CWMS) Database Authorization

    Notice 882a239a9ae84d718842d438f8311ffb on SAM.gov

Similar Opportunities

Title
Match
Phase
Deadline

Additional Details

Solicitation Number

W912HQ25R0007

Archive Date

Apr 12, 2025

Office Address

ALEXANDRIA, VA, 22315-3860