Senior Oracle DB Architect - NOAA Fisheries Data

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

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.