Database Management Specialist – Klamath Basin Scientific Data Architect/Engineer

Job description

The Pacific States Marine Fisheries Commission (PSMFC) is seeking a Database Management Specialist – Klamath Basin Scientific Data Architect/Engineer (Specialist) to support scientific research and management activities at the USGS Klamath Falls office in Klamath Falls, Oregon. This full ‑ time position is respons ible for designing, administering, and modernizing large ‑ scale scientific database systems, ensuring their performance, assuring continuous system availability , and working with IT in administering permissions and security . The Specialist develops data models and automated pipelines, manages legacy data migration, supports GIS and electronic field data collection, and collaborates closely with scientists, contractors, and IT staff. The role also involves querying and analyzing data to address management ‑ relevant questions, supporting data stewardship alignment with the USGS Science Data Lifecycle, and developing tools and workflows using SQL, Python, R, Power Automate, and related technologies. Project Description: The USGS Klamath Falls Field Station (KFFS) conducts research on rare and imperiled fishes in the Klamath Basin, helping managers make informed decisions...