Oracle PL/SQL Developer
About The Position
This position is contingent upon award of a government contract. 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.
Requirements
- 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
- 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
Nice To Haves
- 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
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
Benefits
- health, dental, vision, life insurance coverage
- 401(k) plan
- training programs
- accrued paid time off (PTO)
- performance based monthly & quarterly awards
- paid holidays
- customer kudo rewards
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
