Title: Database Developer (18-1046)
Location: Seattle, WA (98112)
Anticipated Start Date: August 1, 2018
Position Type: Full Year, Full Time, Hourly/Non-Exempt
Benefits Eligible: Yes | www.psmfc.org/benefits
Salary Target: $3,875 semi-monthly
Job Number: 18-1046
How to Apply: Online at www.psmfc.org/careers
Closing Date: July 17, 2018
Database Software Specialists develop and administer complex solutions involving large scale, multi-agency database and data mart systems. Functions include analyzing and refining relational and multidimensional data models and system requirements; translating data models and requirements into solutions utilizing ETL automation, data marts, dashboard portals, web services, and reports. They have responsibility for coordinating project deliverables with team members, focus groups and consultants; assuring data, software and system quality and functionality; writing and maintaining program documentation. Develop R packages that integrate a number of existing functions. Convert programming routines developed in Matlab and Stata into R With other developers, develop an R Shiny Application. Oversee the integration of large databases, perform statistical analyses as relevant part of fishery data integration, assist the NOAA project manager in the coordination of activities across diverse subcontractors and NOAA scientists.
NOAA Fisheries and partners have developed the Spatial Economics Toolbox for Fisheries (FishSET) to improve analyses of how fisheries will be impacted by such factors as marine closures, a changing environment, management actions, and fish and fuel prices. FishSET provides information to mangers and the public about the economic tradeoffs among different uses of our marine resources. The FishSET framework allows us to make better economic models and to integrate these models with diverse ecosystem models.
FishSET has several elements. First, it develops tools to better integrate data on fishing, fuel and fish prices, environmental conditions, and other factors that might influence fishing decisions. Second, we develop best practices for spatial economic modeling that we directly integrate into FishSET to ensure that practitioners follow these practices. Finally, FishSET brings together a broad suite of standard and cutting-edge models. An expanding number of tools are being developed and included.
The main focus of this programming position is to move the toolbox of fisher location choice and related models and data integration and visualization tools from Matlab to R and to expand the features and models in the toolbox. An important element of the work will also be the integration of data to utilize in the FishSET toolbox.
• Design, develop, and maintain data management and high-performance reporting systems that meet current and future business requirements.
• Develop data dictionaries, relational and multidimensional data models, metadata repositories, key performance indicators, and other data management tools.
• Define and analyze technical and functional requirements and specifications. Assure they are consistent with current and planned infrastructure and data environments.
• Develop service-oriented and web-based application interfaces to database and data marts.
• Maintain engineering control processes as a mechanism for software modifications. The process provides capabilities to solicit input from users, prioritize major and minor bugs and software enhancement requests, and the ability to track these changes from the time they are reported to the time they are implemented in production code.
Knowledge Required by the Position:
At the lower end of the range, the employee has broad knowledge, abilities, and skills as follows:
• Knowledge of relational database management systems and structured query language.
• Ability to develop complex software applications and reports.
• Ability to create entity relationship models, process data flow models.
• Knowledge of effective technical writing techniques.
• Ability to communicate clearly and effectively, both orally and in writing.
• Ability to interact effectively with individuals and groups having diverse backgrounds (biologists, engineers, statisticians, economists, fiscal specialists, computer specialists, etc.) to translate their needs to software functionality. At the upper end of the range, the employee uses mastery-level knowledge and abilities to develop state-of-the-art technology and functionality.
• Software development in a Microsoft Windows or Unix environment M-database query language (e.g. SQL, MDX):programming language (e.g. C#, Java, Perl, C, Visual Basic): _R and R Studio (M), Matlab(Some knowledge M); STATA (D);
• other programming languages (D)relational database management system (e.g. SQL Server, Ingres, Oracle, Sybase, Informix): R&R Studio M, Matlab, STATA, relational database management,
• web authoring tools
• Awareness of fisheries management laws and data.
• Experience with diverse statistical methods (D)
The work is sedentary with moderate walking between workstations and carrying folders, reports, and similar light loads.
The work is performed in an office setting with adequate lighting, heating and ventilation. There are the normal risks of an office environment.
Pacific States Marine Fisheries Commission is an Affirmative Action (AA) and Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, gender identity, age, mental or physical disability, sexual orientation, veteran status, genetic data, or other legally protected status.
If you have a disability and need assistance completing the application form, you may call the PSMFC human resources office at (503) 595-3100 between the hours of 8 a.m. and 5:00 p.m. PST, Monday-Friday. Reasonable accommodations for interviews will be provided upon request to individuals with disabilities.
We maintain a drug-free workplace.
Minimum Qualification Requirements:
• Candidates must present one year of Specialized Experience which demonstrates:
• Knowledge of the customary approaches, techniques, and requirements appropriate to systems and applications, software design and development
• Knowledge of planning sequences necessary to accomplish assignments where this entailed coordination with others outside the organizational unit and development of project controls; and
• Adaptation of guidelines or precedents to the needs of the assignment.
• The Specialized Experience must equip the candidate with the particular knowledge, skills, and abilities to perform successfully the duties of the position, and is typically in or related to the work of the position to be filled. To be creditable, the Specialized Experience must have been equivalent to at least the next lower level in the normal line of progression position.