Oracle PL/SQL Developer

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., * 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

• 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, * 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

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.