OpportunityTitle: Maintenance of a Centralized PIT tag Database for the San Juan and Upper Basin Recovery Programs
Description: 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 &#183; Maintain the server, server security, and perform regular database backups&#183; Maintain the test server and development environment&#183; 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.&#183; Assess overall performance and optimize resources&#183; Maintain Database Manager credentials to access SQL Server&#183; Replace hardware (e.g. server, hard drives, RAM, etc.) as needed and configure new hardware Task 2: Website Maintenance and Feature Enhancements&#183; Enhancements to existing toolso Batch uploadso QC toolso Movement toolo Calculated fields&#183; 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&#183; Work with Database Managers to develop any necessary custom queries, including non-tagged fish queries&#183; Bug fixes&#183; Internal testing and stress tests&#183; Update online help, data dictionary, user manuals, Data Managers user guide, and system documentation&#183; Train Recovery Program participants on features and enhancements&#183; Other priorities identified by Recovery Program Database ManagersTask 3: Project Management&#183; Prepare annual reports&#183; Perform project management and CSU compliance&#183; Maintain regular communication with Database Managers
GrantorContactEmailDescription: gjosephson@usbr.gov
GrantorContactText: Glen Josephson &lt;br/&gt;Grants Management Specialist &lt;br/&gt;Phone 801 524 3756