Maintenance of a Centralized PIT tag Database for the San Juan and Upper Basin Recovery Programs

The summary for the Maintenance of a Centralized PIT tag Database for the San Juan and Upper Basin Recovery Programs grant is detailed below. This summary states who is eligible for the grant, how much grant money will be awarded, current and past deadlines, Catalog of Federal Domestic Assistance (CFDA) numbers, and a sampling of similar government grants. Verify the accuracy of the data FederalGrants.com provides by visiting the webpage noted in the Link to Full Announcement section or by contacting the appropriate person listed as the Grant Announcement Contact. If any section is incomplete, please visit the website for the Bureau of Reclamation, which is the U.S. government agency offering this grant.

Maintenance of a Centralized PIT tag Database for the San Juan and Upper Basin Recovery Programs: CNHP will continue to maintain the Species Tagging, Research and Monitoring System (STReaMS) database and add feature enhancements during the Federal FY2020-24. Tasks are broken out below.Task 1: Server Maintenance · Maintain the server, server security, and perform regular database backups· Maintain the test server and development environment· Perform necessary software installs and upgrades including Windows operating system, Windows updates, MS SQL Server, MS TFS, and PHP. Ensure all code performs as expected following updates.· Assess overall performance and optimize resources· Maintain Database Manager credentials to access SQL Server· Replace hardware (e.g. server, hard drives, RAM, etc.) as needed and configure new hardware Task 2: Website Maintenance and Feature Enhancements· Enhancements to existing toolso Batch uploadso QC toolso Movement toolo Calculated fields· Work with Utah State University PIT electrical engineer and Recovery Program database manager to ensure complete PIA data in STReaMSo Shift units from Loggernet process to new FTPS upload process as they are upgradedo Needs assessment and training with USU and the Recovery Program.o Add and remove PIAs to the automatic upload system as needed· Work with Database Managers to develop any necessary custom queries, including non-tagged fish queries· Bug fixes· Internal testing and stress tests· Update online help, data dictionary, user manuals, Data Managers user guide, and system documentation· Train Recovery Program participants on features and enhancements· Other priorities identified by Recovery Program Database ManagersTask 3: Project Management· Prepare annual reports· Perform project management and CSU compliance· Maintain regular communication with Database Managers