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 tools

o  Batch uploads

o  QC tools

o  Movement tool

o  Calculated fields

·        Work with Utah State University PIT electrical engineer and Recovery Program database manager to ensure complete PIA data in STReaMS

o  Shift units from Loggernet process to new FTPS upload process as they are upgraded

o  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 Managers

Task 3: Project Management

·        Prepare annual reports

·        Perform project management and CSU compliance

·        Maintain regular communication with Database Managers

Education

• Public and state institutions of higher education