Corps Water Management System (CWMS) Database Authorization
Closed Solicitation Posted
- Solicitation number
- W912HQ25R0007
- Agency
-
Humphreys Engineer Center Support Activity
US Army Corps of Engineers, Department of Defense
- Responses due
- Set-aside
- Total Small Business
Opportunity facts
- NAICS code
- 541511 Custom Computer Programming Services
- Place of performance
- Davis, California, United States
Notice details come from SAM.gov. Updated .
About this opportunity
The U.S. Army Corps of Engineers (USACE) Hydrologic Engineering Center is seeking a contractor to develop and implement an authorization scheme for the Corps Water Management System (CWMS) Database API. The primary objective is to transition from 32 independent, geographically isolated databases to a single cloud-based system with comprehensive data permission capabilities. Specific requirements include developing authorization mechanisms for read, write, delete, create, and update permissions across database objects, with a focus on creating a platform for data administrators to assign these permissions. The contract will be evaluated based on technical approach (most important), management approach, past performance, and price, with non-price factors significantly more weighted. Proposals are due by March 28, 2025, with questions accepted until March 6, 2025, and the anticipated contract award will follow shortly after the proposal deadline.
This solicitation is a total small business set-aside under NAICS code 541511 for Custom Computer Programming Services, with a $34M size standard. The contract will be awarded as a firm-fixed-price for a 270-day base period of performance, with a total contract duration of 450 days. The estimated not-to-exceed value for Task 3 is $184,775, and the work will be performed remotely, primarily at the contractor's facility. The place of performance is designated as Davis, California, with the system to be hosted in AWS GovCloud at an IL2 security level. The project aims to support USACE's water management capabilities by enhancing the technical infrastructure for monitoring and operating approximately 600 reservoir, lock, and dam projects, with potential expansion to an additional 120 Section 7 (Non-USACE) projects during flood control operations.
Notice text
5 versions
Update #5 · Latest ·
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 USACE’s 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.
Update #4 ·
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 USACE’s 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.
Update #3 ·
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 USACE’s 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.
Update #2 ·
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 USACE’s 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 2024.
Update #1 ·
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 USACE’s 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.
Files
| File | Type | Posted |
|---|---|---|
| B08.03 Answers to Questions - Solicitation W912HQ25R0007 - amended 2025.03.25.docx | DOCX document | |
| B08.02 USACE PPQ.pdf | ||
| Location Levels-ERD.png | PNG image | |
| Time Series-ERD.png | PNG image | |
| Ratings-ERD.png | PNG image | |
| Locations-ERD.png | PNG image | |
| B08.03 Answers to Questions - Solicitation W912HQ25R0007.docx | DOCX document | |
| B01.01 CSS - W912HQ25R0007 - CWMS Database Authorization - Amended 2025.03.10.docx | DOCX document | |
| B01.01 Combined Synopsis - Solicitation - W912HQ25R0007 - CWMS Database Authorization.docx | DOCX document | |
| A02.12 PWS CWMS Database Authorization dated 2025.02.25.docx | DOCX document |
Notice history
| Notice | Type | Posted |
|---|---|---|
| This notice | Solicitation | |
| Corps Water Management System (CWMS) Database Authorization | Pre-Solicitation |
On GovTribe
Work this opportunity
- Track it in your pipeline
- Find teaming partners
- Similar opportunities
- Ask GovTribe AI about this opportunity