This position is contingent upon award of a government contract.
Position Overview
GARFO's Technology and Data Management (TDM) division supports fisheries management operations for approximately 16,000 internal and external users across the Greater Atlantic region. The Database Specialist will support enterprise fisheries data modernization initiatives involving Oracle and PostgreSQL database environments, legacy system analysis, data architecture, migration activities, and PL/SQL development supporting NOAA Fisheries mission systems.
This position supports the modernization and consolidation of Fisheries Dependent Data (FDD) systems collected pursuant to federal fisheries regulations. The selected candidate will work within agile development teams to analyze legacy NOAA Fisheries databases, design modernized database architectures, develop Oracle database objects and PL/SQL solutions, and support cloud-aligned data management initiatives.
Key Responsibilities
Analyze and assess legacy NOAA Fisheries database environments and data structures
Design and implement modernized Oracle database architectures and supporting solutions
Develop, optimize, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and database objects
Support data migration and consolidation efforts from legacy systems into modernized platforms
Create and maintain Oracle DDL scripts and database deployment packages
Support Fisheries Dependent Data (FDD) management initiatives and regulatory reporting systems
Collaborate with software developers, business analysts, and project managers in agile development environments
Ensure all database solutions comply with GARFO software development and database design standards
Participate in troubleshooting, root cause analysis, and performance optimization activities
Support documentation development for database architecture, schemas, migration processes, and operational procedures
Assist with cloud and data modernization initiatives aligned with NOAA and Commerce strategic objectives
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, Engineering, or related technical field, or equivalent professional experience
5+ years of hands-on Oracle database development experience
Strong expertise with Oracle PL/SQL development and performance tuning
Experience designing and implementing relational database architectures
Experience analyzing and modernizing legacy database systems
Experience with data migration and ETL methodologies
Experience developing Oracle DDL and database deployment scripts
Experience with Oracle Unit Testing
Strong understanding of SDLC processes and version control practices
Ability to work independently and collaboratively within distributed agile teams
Strong written and verbal communication skills
Required Technical Skills
Oracle Enterprise Database 19C and above
Oracle PL/SQL development
SQL Developer/Data Modeler
Oracle APEX
Toad
PostgreSQL
Database performance tuning and optimization
Data modeling and database architecture design
Preferred Qualifications
Experience supporting Federal Government or NOAA/NMFS environments
Familiarity with fisheries management systems or regulatory data environments
Experience with cloud-based Oracle implementations
Experience working within AWS-hosted database environments
Experience with Git, JIRA, and Confluence
Knowledge of Section 508 compliance considerations
Experience supporting enterprise modernization initiatives
Work Environment
Primarily remote position
Collaboration with geographically distributed teams supporting operations from Maine through North Carolina
Standard operating hours are Monday through Friday, Eastern Time, with occasional support outside standard hours for critical production issues
Security and Compliance Requirements
Ability to obtain NOAA credentials and comply with DOC IT security policies
Completion of required NOAA security and compliance training upon onboarding
Adherence to Federal information security and data handling requirements
Why Join This Program
This effort directly supports NOAA Fisheries mission-critical modernization initiatives that impact fisheries management, regulatory reporting, conservation efforts, and data-driven decision making across the Greater Atlantic region. The role offers the opportunity to work on large-scale enterprise database modernization initiatives supporting nationally significant marine resource management systems.
Benefits: Competitive benefits package including health, dental, vision, life insurance coverage, 401(k) plan, training programs, accrued paid time off (PTO), performance based monthly & quarterly awards, paid holidays and customer kudo rewards.
Equal Opportunity Employer/Veterans/Disabled
