D--HYDROLOGICAL DATABASE (HDB) SUPPORT SERVICES

HYDROLOGICAL DATABASE (HDB) SUPPORT SERVICES IDIQ DRAFT PERFORMANCE WORK STATEMENT 1. SCOPE: 1.1. OBJECTIVE: The objective of this performance-based contract is to maintain, support, 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 Basin Region, in all four of its area offices, in the Lower Colorado Basin Region in the Boulder Canyon Operations Area and Yuma Area Offices, in the Missouri Basin and Arkansas-Rio Grande-Texas Gulf Region in the Eastern Colorado Area Office, in the California Great Basin Region in the Lahontan Basin Area Office and 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 include (but are not limited to) basin inflow forecasting, National Environmental Policy Act (NEPA) and Endangered Species Act (ESA) compliance processes, long- and mid-term modeling and planning efforts, and day-to-day operational control and management. HDB -- 1 of 12 -- 2 is also utilized to support Reclamation’s website and other publicly available data portals such as Reclamation Information Sharing Environment (RISE), and public and internal Application Programming Interfaces (APIs). 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: • Consolidate data previously existing in various systems and personal spreadsheets. • Assure complete and consistent data collection and storage; documentation of data sources. • Provide historical information on other existing HDB data versions including information on when the data was either used or available for use. • Perform as a means of quality control. • Allow the user access, at any time interval, to the original source data for calculated or summarized data • Provide for an automated generation of time-aggregated summary data as well as automated computations that compute data parameters based on collected inputs. 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 water and/or energy 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 continued ability to rely on and interpret their data in order to make sound operational decisions, provide an indisputable record of data used to make past decisions, and provide a complete record of -- 2 of 12 -- 3 best available historical and forecast data for research proposed and policy development. The HDB system is comprised of the Oracle based HDB databases 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 quality control as well as hydrologic modeling studies, water accounting efforts, and day-to-day operations and modeling of dams, reservoirs and related assets and features. Some of these software applications collect and store data in HDB while others allow data to be retrieved from HDB and displayed in ways that assist operations staff and the public to interpret the state of the hydrologic system. 2. REFERENCES: 2.1. Hydrological Database - Bureau of Reclamation http://hydrodb.net 2.2. National Environmental Policy Act http://www.epa.gov/nepa 2.3. Endangered Species Action https://www.law.cornell.edu/wex/endangered_species_act_(esa) 3. DEFINITIONS: 3.1. Qualified Contractor Personnel: means those Contractor employees directly performing work under this contract who collectively possess and maintain all of the following skills, capabilities, and knowledge to provide a high-quality level of technical support services. Individual personnel assigned to specific tasks must have the relevant qualifications for those tasks; however, the full set of qualifications may be met and maintained by the contractor’s team as a whole throughout the life of the contract. These qualifications -- 3 of 12 -- 4 include: 3.1.1. High level of knowledge with regard to the HDB database structure, including database relationships in HDB, including DECODES and the Computational Processor. 3.1.2. Full understanding of the HDB objectives with respect to time-series data management including, but not limited to: computation management, interval data consistency, model data management, validation and quality assurance, etc. 3.1.3. Expert-level proficiency in Oracle database Operations and Maintenance and programming, as well as other computer programming languages such as JAVA, C, python, C#, Perl, and VB.net. 3.1.4. Ability …