PWS - 2020-2021 HDB Acquisition Process_1.docx

HYDROLOGICAL DATABASE SUPPORT SERVICES IDIQ

PERFORMANCE WORK STATEMENT

1.0 SCOPE

1.1 OBJECTIVE - The objective of this performance-based contract is to maintain and further develop the Bureau of Reclamation's Hydrological Database (HDB) through the Contractor's provision of services for on-call technical support, troubleshooting of HDB malfunctions, development of modifications to HDB, support of HDB enhancements, and the development, documentation, and distribution of software applications that interface with HDB.

1.2 BACKGROUND - HDB is currently used in production in the Upper Colorado Region, in all four of its area offices, in the Lower Colorado Region in the Boulder Canyon Operations Area and Yuma Area Offices, in the Great Plains Region in the Eastern Colorado Area Office, in the Mid Pacific Region in the Lahontan Basin Area Office, and in the Pacific Northwest Region in the Klamath Basin Area Office. Each of these offices support separate instances of HDB for the collection and storage of vital hydrological data within their operational jurisdiction to aid in decision support and reporting for Reclamation facilities managed within each of these offices.

The HDB system is a critical decision support tool for day-to-day operations of many of Reclamation’s major water storage and distribution facilities throughout the Western United States. HDB is critical for enabling and supporting ongoing modeling activities that including basin inflow forecasting, NEPA and ESA compliance processes as well as day-to-day operational control and management. HDB is also utilized to support Reclamation’s website and other publicly available data portals such as RISE and RWIS.

The HDB is the foundation for Reclamation's Database of Record. As conceptualized by the Database of Record defining document, the driving vision for the Hydrologic Database is to:

sources.

Reclamation managers are often interrogated formally or informally regarding the basis for operational decisions - decisions that are usually based on data such as forecasts, flows, available water supply and downstream demands. Reasonable explanation of decisions requires maintaining the exact data considered in the decision and being able to reproduce the overall state of the system and retrieve forecast information available at the time the decision was made. Enhanced capability to document the basis for the past decisions is urgently needed to assist Reclamation's defense in litigation and other processes.

Development of the database of record will facilitate Reclamation's ability to rely on and interpret their data in order to make sound operational decision, provide an indisputable record of data used to make past decisions, and provide a complete record of best available historical and forecast data for research proposed and policy development.

The HDB system is comprised of the Oracle based HDB database combined with a collection of software applications (computer programs) that are set up to automatically collect and store a variety of operational and hydrologic data from various data sources. Software applications within the system also allow operational staff to access the data for day to day operations and modeling of, dams, reservoirs and related features. These software applications collect and store data in to HDB while others allow it to be retrieved from HDB and displayed in ways that assist operation staff and the public to interpret the state of the hydrologic system.

2.0 REFERENCES

2.1 Definitions

2.1.1 Qualified Contractor Personnel means those Contractor employees directly performing on this contract possess or obtain within 6 months of contract award all of the following skills, capabilities and knowledge in order to provide a high quality level of technical support services:

2.1.2 Normal business hours are 8:00am-4:00pm, Monday through Friday, Mountain Standard Time. However, the Government will pay only for time directly spent on phone calls involving HDB technical support and for any other HDB technical support offline such as travel expenses, software programming support, etc. directly related to HDB technical support. In other words, the cost of standby time for contractor personnel waiting to accept calls is not going to be chargeable to this contract.

2.2 References

3.0 TASKS - The contractor shall perform the following tasks:

3.1 Provide On-demand Technical Support. Provide on-demand HDB technical support to Water Resources users. These services shall be provided by qualified Contractor personnel during normal Reclamation business hours and within the performance standards outlined in paragraph 4.0.

3.2 Database System Maintenance and System Malfunction Resolution Services. Troubleshoot, diagnose, and solve software and database management problems involving HDB system malfunctions as expeditiously as possible and within the performance standards outlined in paragraph 4.0.

3.3 HDB Development, Coordination and Documentation.

3.3.1 Develop enhancements to HDB as requested by Reclamation's HDB Water Resources Group to be transferrable, functional, and available to other instances of HDB.

3.3.2 Install and test available enhancements and regular updates to production and test databases, systems and applications at each HDB instance. All enhancements and modifications prepared by contractor shall be fully tested on a test environment maintained with the Reclamation network. Reclamation will be responsible to maintain the test environment and access to the contractor for this purpose Documentation of successful testing shall be submitted to Reclamation. Only after Reclamation review of testing results and approval by Reclamation shall contractor install enhancements or modifications onto HDB production environment.

3.3.3 Integrate HDB enhancements and code modifications into the HDB source code and database scripts baseline.

3.3.4 Maintain and support the HDB source code and the computation processor algorithms for HDB to be consistent as possible with other HDB installations.

3.3.5 Coordinate OPENDCS development with the other participating entities.

3.3.6 Documentation of new developments shall be provided with new deliverables.

3.3.7 Provide download capabilities of HDB installation scripts, documentation and application software on the HDB web site.

4.0 PERFORMANCE REQUIREMENTS SUMMARY – The table below specifies the standard for satisfactory performance of the tasks specified in this performance work statement. Inspections will be based on the standards in the Performance Requirements Summary in the contract Statement of Work.

Task

Task Description

Performance Indicator

Performance Standard Minimum Acceptable Quality Level

2) 25% of calls are returned within 2 hours by qualified Contractor personnel to the original caller.

3) 25% of calls are returned within 24 hours by qualified Contractor personnel to the original caller.

All customer calls shall be responded to within 24 hours of receipt from Contractor

3.2

2) 25% of HDB system malfunctions (more complex ones) are diagnosed by qualified Contractor personnel within 24 hours of being notified by Government personnel and resolved within 96 hours.

All reported HDB system malfunctions shall be resolved withing 7 days unless extenuating circumstances exist.

4.0

5.0 DATA, REPORTS AND DELIVERABLES - The contractor shall prepare and submit monthly status reports to all participating Reclamation Offices, These reports shall contain the following information:

· Dates and approximate length of time (hours) required by contractor to resolve each incident for which on-demand HDB technical support services rendered by Contractor to Reclamation under this contract.

· Description of the issues involved for each reported incident requiring on-demand HDB technical support and the actions taken by the contractor to achieve a resolution of the reported incident.

· Details for all authorized Contractor travel associated with this contract such as dates, times, locations, specific costs, purposes of travel, and what contributions the Contractor provided as a result of the travel.

· For specific tasks described in each task order under this contract, the report should include the task order, a brief description of the overall task, and the status of performance and completion of the task, including a determination by the Contractor as to whether or not the task will be completed by the deadline specified in the associated task order.

· Task orders issued under this contract may include additional reporting requirements beyond those specified within this performance work statement.