Database Management Specialist – Klamath Basin Scientific Data Architect/Engineer

Pacific States Marine Fisheries Commission•Klamath Falls, OR

29d•Onsite

About The Position

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 responsible 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.

Requirements

Valid Driver's License
Knowledge of the customary approaches, techniques, and requirements appropriate to database management
Knowledge of planning sequences necessary to accomplish assignments where this entailed coordination with others outside the organizational unit and development of project controls
Adaptation of guidelines or precedents to the needs of the assignment
Database software packages: Microsoft SQL Server, SQLite, query languages, table relationships, and views.
Experience with database backup and recovery tools, performance monitoring, and optimization features within enterprise database platforms
Data Architecture and Data Stewardship: Experience, or strong familiarity, developing and maintaining data models, database schemas, data dictionaries, and metadata repositories.
Knowledge of data stewardship best practices, including data documentation, preservation, publication, and long-term archiving.
Programming languages: SQL
Server software: Experience administering Microsoft SQL Server servers, including performance tuning, availability, and storage management
Collaboration & Technical Support: Demonstrated ability to work collaboratively with scientists, IT staff, and contractors.
Experience coordinating and working with a team of individuals to achieve a specific goal

Nice To Haves

Microsoft Azure SQL database or similar.
Experience supporting or migrating databases to cloud hosted platforms.
Familiarity with automation or AI assisted tools used in data processing and analytics.
Experience maintaining or supporting software written in Visual Basic and C#.
Knowledge of Python and R, including scripting for scientific data analysis and automation.
Experience developing dashboards and reports using Power BI or similar business intelligence and visualization platforms
ESRI ArcGIS (Pro, Online and/or Enterprise) or similar.
Experience managing and integrating geospatial (GIS) data within relational database systems.
Geospatial analysis skills in ArcGIS, R, or other similar platforms.
Experience supporting electronic field data collection platforms (e.g., Survey123).
Experience designing automated data validation and ingestion workflows for field-collected data.
Windows Server and Linux
Experience providing technical support, documentation, and training to non-technical users.
Experience working with biological, fisheries, ecological, or environmental datasets.
Experience supporting long-term monitoring, capture-recapture, or telemetry-based research programs.
Familiarity with telemetry, tagging, and fish movement monitoring.

Responsibilities

Design, develop, administer, and optimize SQL Server and SQLite databases, including implementation of backup and recovery procedures, storage allocation, and performance monitoring.
Develop and maintain data dictionaries, conceptual and physical data models, metadata repositories, documentation to support integration of diverse scientific data sources, and produce schemas for integrating diverse source data.
Assess existing legacy database structures to identify redundant or inefficient table layouts, and lead efforts to modernize schemas and migrate historical data into improved, standardized formats.
Develop complex queries, reports, and analytics in response to scientific project leaders and management needs; translate legacy R and Python query scripts into automated, production-level data pipelines using SQL, Power Automate, and artificial intelligence where appropriate. Lead the transition from internal query programs to Power BI dashboards (or similar tools).
Serve as the office lead and primary point of contact for data stewardship, ensuring alignment with USGS policies and the USGS Science Data Lifecycle practices that consists of data acquisition, processing, analysis, preservation, publication, and archiving.
Troubleshoot, diagnose, and resolve database performance, integrity, and availability issues.
Provide technical oversight for contractors engaged in database modernization efforts, including re-architecting schemas around mission workflows, rebuilding data pipelines, and coordinating with USGS IT to manage permissions, security, and migration to cloud-hosted platforms (e.g., Microsoft Azure).
Manage and support geospatial (GIS) components of scientific datasets, and design workflows that enable scientists to visualize spatial data and track the movement of individual fish and fish species.
Support electronic field data collection systems (e.g., tablets using Survey123) and design automated validation and ingestion workflows to integrate electronically captured data into centralized databases.
Collaborate with scientists to design and implement new database table structures, data standards, and workflows as new research projects are initiated.
Provide guidance, training, and technical assistance to scientists on data stewardship, accessibility, long-term research data archiving, and use of artificial intelligence.
Develop and maintain analytical and visualization tools in Python and R to support scientifically valid analyses, statistical and mathematical modeling, and reproducible research workflows.
Troubleshoot, maintain, and support custom software applications written in Visual Basic and C#.