Database Specialist V

Ocean Associates, Inc.; Gloucester (MA); On-site; USD 83,000 - 110,000; Full time

Job summary

Ocean Associates, Inc. seeks a Database Specialist to support NOAA GARFO in Gloucester, MA. The role centers on Oracle Databases (on premise and AWS), PL/SQL development, and enterprise-scale data architecture, including DDL delivery and modernization efforts.

Required: Master’s with 8+ years or Bachelor’s with 10+ years of relevant experience, plus familiarity with Greater Atlantic fisheries management data and related applications. This is a full-time role with hourly pay between $60 and $80.

Qualifications

• Master’s degree with 8+ years of relevant experience or Bachelor’s degree with 10+ years of relevant experience.
• Knowledge of Greater Atlantic fisheries management agencies and related systems.
• Experience with Oracle Database 19C+, on premise and cloud, and Oracle tools.

Responsibilities

• Scope data design, architecture, analysis, and PL/SQL development within Oracle Databases (NMFS/NGMOS and AWS).
• Create architectures for databases, modernizing and consolidating where possible.
• Design IT architecture and database systems for NOAA at enterprise level.
• Deliver completed Oracle DDL and PL/SQL into NMFS Oracle DBMS systems.

Skills

PL/SQL development

Oracle database experience

SQL querying

AWS cloud exposure

Data modeling

Education

Master’s degree with 8+ years of relevant experience

Bachelor’s degree with 10+ years of relevant experience

Tools

Oracle SQL Developer

Oracle APEX

Toad

AWS

Job description

If you are unable to complete this application due to a disability, contact Ocean Associates at 703-388-9548 to ask for an accommodation or an alternative application process.

Ocean Associates Inc. (OAI) is seeking an applicant to provide Database Specialist Services to the National Oceanic and Atmospheric Administration (NOAA), National Marine Fisheries Service (NMFS), Greater Atlantic Regional Fisheries Office (GARFO) in Gloucester, MA. OAI is a Virginia corporation established in 2003 that provides consulting and technical services to the U.S. government, non-governmental organizations, international organizations, and the private sector. We specialize in scientific program and project management, strategic planning, professional and technical services, and stakeholder engagement, supporting government contracts. We are seeking applicants for this position prospectively, which is dependent on award of contract

Background

GARFO’s Technology and Data Management (TDM) division is responsible for providing web and mobile based applications, technical services and support for approximately 16,000 internal and external customers (fisheries management councils, state and USCG law enforcement, state fisheries management and other fishery management groups, and commercial fishing industry users). TDM requires Information Technology (IT) Support Services to meet its mission. The services will be provided to GARFO, including all of its field sites on the Eastern Seaboard, from Maine to North Carolina and external customers in the fishing management and fishing communities.

GARFO manages multiple data sets consisting of Fisheries Dependent Data (FDD) collected pursuant to federal fisheries regulations. These are stored in an Oracle DBMS. Multiple projects are underway to support the modernization and management of this data. These involve data architecture, the implementation of Oracle DBMS in Amazon Web Services (AWS), data migration from legacy systems, and PL/SQL development in support of these efforts.

Tasks

Tasks include:

• Scope data design, architecture, analysis, and PL/SQL development working within Oracle Databases located at NMFS facilities and in AWS.
• Create new architectures for the databases, with the goal of modernizing them and consolidating them where possible.
• Designing IT architecture and database systems for NOAA on an enterprise level.
• Define system and application architecture and provide vision, problem anticipation, and problem solving to NOAA Fisheries.
• Deliver a completed Oracle DDL and PL/SQL compiled and implemented into NMFS Oracle DBMS systems.

Start Date

Anticipated August 21, 2026,Contingent upon award of contract.

Salary and Benefits

This is a full-time position with benefits. Salary, commensurate with experience, between $60.00 - $80.00 per hour.

Requirements

Applicants must have the following minimum requirements:

• Master’s with 8 years of relevant experience, or Bachelor’s with 10 years of relevant experience.
• Clearly demonstrating knowledge with Greater Atlantic fisheries management agencies, business rules associated with Greater Atlantic fishery management regulations, and fishery management systems including the Greater Atlantic Fish Online application.
• Ability to work in the following technical environments:
• Oracle Enterprise Database 19C and above, both on premise and cloud-based
• SQL Developer
• Oracle APEX
• Toad

Applicants should submit a resume that includes the following

• Cover letter that briefly describes how you meet the required and preferred qualifications listed.
• Work history for past 10 years or since last full-time education.
• Education.
• Previous experience or training with similar requirements.
• Three professional references.
• Include your name in the document file name.
• Upload your resume in readable, not scanned, PDF or Word format (PDF is preferred).

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States, complete the required employment eligibility verification document form upon hire, and successfully complete a federal government background check. OAI does not discriminate on the basis of any status or condition protected by applicable federal or state law.

OAI is a government contractor and is required by law to invite applicants to voluntarily self-identify their disability status and veteran status. OAI's online application includes check boxes to either voluntarily self identify or decline to self identify. While the information is collected through your application, it is collected anonymously and is not connected to your application. OAI uses the information it collects to track its disability and veteran hiring progress, and to meet its obligations under Section 503 of the Rehabilitation Act and under VEVRAA.

Note: If you are not selected, your materials may be retained for present or future opportunities. We may use your resume in bidding on a project and if we are awarded the work, we will contact you before seeking further applicants. If you do not wish us to retain or use your resume to seek work for you, please let us know in the "Notes" section on the second page of the online application.