Database and Applications Developer
$82,000–$102,000 year
On-sitePascagoula, Mississippi, United States
Job Summary
Centralize scientific and administrative data by building automated pipelines to migrate plankton and groundfish survey data into a unified Oracle Enterprise environment. Design database architecture and normalized relational schemas to house complex fisheries survey structures, while developing front-end applications for internal staff and external partners to securely manage and validate records. Engineer extract, transform, and load workflows using PL/SQL, Python, or Informatica to address inconsistent data formats and maintain integrity through parsing algorithms and validation rules. Optimize performance via indexing and query tuning, ensuring adherence to federal security standards and PII protocols. Support data analyses, prepare reports and publications, and participate in public outreach and scientific workshops as needed.
Required Qualifications
- Master of Science degree in Computer Science, Information Systems, Engineering, or a related field of study
- Bachelor of Science degree in Computer Science, Information Systems, Engineering, or a related field of study plus five years of relevant experience
- Ability to translate real-world scientific processes into logical and physical data models, including Entity-Relationship Diagrams
- Ability to write complex stored procedures, triggers, and packages using PL/SQL to support business logic and edit-approval workflows
- Knowledge of implementing Role-Based Access Control (RBAC) to differentiate user and access requirements
- Skill in preparing technical documentation, data dictionaries, and user manuals
- Expert-level proficiency with Oracle RDBMS 12c/19c or later
- ETL and scripting proficiency using Python, including Pandas and NumPy; PL/SQL; Informatica; or FME
- Front-end development proficiency using HTML5, CSS3, JavaScript, and AJAX techniques for responsive user interfaces
- Experience with Git, GitHub, or GitLab for version control
- Must be able to lift 50 lbs
Desired Qualifications
- Proficiency with Oracle Application Express (APEX) is highly desired
- Proficiency with Java/Spring Boot, Python/Django or Flask, or .NET
- Knowledge of PostgreSQL or SQL Server
- Documented experience working with geospatial data, including GIS, Oracle Spatial, or ArcGIS
- Documented experience in database development and administration
- Documented experience building workflows incorporating approval gates and audit trails
- Ability to communicate with fisheries scientists to understand their data requirements and translate those requirements into technical specifications
- Previous experience supporting NOAA or other federal agencies
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.