Company: University of Washington - College of the Environment
Location: Seattle, WA
Employment Type: Full Time
Date Posted: 01/14/2022
Expire Date: 03/14/2022
Job Categories: Administrative and Support Services, Education, Finance/Economics, Government and Policy, Human Resources, Collegiate Faculty, Staff, Administration, Executive Management, Environmental, Web Technology, Nonprofit and Volunteer Services
The Database Manager works within a small CBR team of scientists, web designers, and statistical/programming analysts to build and maintain functional tools and databases. The employee is responsible for all database administration, including databases that can be queried through public online analytical processing tools, and databases used for in-house research studies and product development. The employee also collaborates frequently with public entities, including researchers, database managers, resource managers in state, federal and non-governmental organizations, and stakeholders.
Design and implement database architectures to integrate relevant datasets.
Ensure in-house data mirror primary data sources.
Design and implement effective QA/QC procedures.
Tune database resource use and query performance.
Create effective SQL to deliver accurate, functional query results.
Advise on the acquisition and specifications of computing resources.
Document database architecture, programs, and procedures.
Ensure access to critical data through professional relationships with primary sources.
Work with regional partners to develop data and research products.
Provide feedback to primary sources on dataflow and QA/QC issues.
Discover and acquire relevant fisheries and environmental datasets.
Assist with machine-learning projects.
Obtain and disseminate appropriate metadata for each primary source.
Process data to appropriate formats and import to in-house databases.
Develop and maintain procedures to cluster data into functional groups.
Perform self-directed data exploration to develop and improve products.
Provide custom, curated, datasets as requested by team members and the public.
Assists with the preparation of progress reports and research papers.
Document all analyses, programs, processes, and procedures.
Advise on the availability and utility of data for various projects.
Assist Web Computing Specialist with data and tool publication
One year of experience as a Systems Analyst/Programmer II OR a Bachelors Degree in computer science or a job related area OR equivalent education/experience.
Experience in database administration of PostgreSQL database management systems.
Working knowledge of at least one programming language; e.g., Perl, Python.
Working knowledge of at least one scripting language; e.g., bash, sed, awk.
Ability to establish and maintain positive, ethical, and professional interpersonal relationships.
Interest in supporting the scientific process leading to insights and understanding of natural resources and ecological processes to help with conservation, fishery management, research, and collaboration with communities.
Experience with Git/GitHub or other version control systems.
Experience with R.
Experience with machine learning techniques
Company Name: University of Washington - College of the Environment
As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem solving skills and dedication to build stronger minds and a healthier world. UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty.