Data Systems Developer/Database Administrator
Job Description
The Gulf States Marine Fisheries Commission is seeking a developer and database administrator to maintain and improve SEAMAP data systems. This onsite role supports database management, data integration, validation, and ongoing application support while preserving the meaning and traceability of scientific submissions.
Responsibilities
- Maintain relational databases supporting Groundfish, Bottom Longline, Reef Fish, Plankton, and related SEAMAP products.
- Develop data-loading and transformation tools for partner submissions, including Access databases, spreadsheets, CSV files, and historical formats.
- Design and document schemas, identifiers, relationships, reference tables, and submission specifications; investigate performance and data integrity issues.
- Preserve original submissions and document transformations; verify record counts, relationships, and outputs after imports and changes.
- Maintain validation tools for new and historical records, including structural, temporal, spatial, biological, and cross-table checks.
- Differentiate confirmed errors from unusual but valid observations, missing information, and items requiring source-owner review.
- Coordinate with state and federal partners to clarify definitions, resolve findings, and track reviewed exceptions and corrected submissions.
- Apply approved corrections through controlled processes, including backups and verification, and communicate data limitations clearly.
- Maintain the SEAMAP website, interactive mapping and query tools, downloadable datasets, and supporting application services.
- Develop and support staff applications for intake, validation, database operations, reporting, and export.
- Maintain compatibility with partner workflows, including Access and spreadsheet products; verify fixes in distributed applications and published datasets, not only source code.
- Maintain version-controlled code, automated tests, deployment instructions, data dictionaries, and user documentation; test changes before production release.
- Maintain documented backup, recovery, configuration, and release procedures in coordination with GSMFC technical staff.
- Monitor automated intake and notification workflows and investigate failures; maintain accurate project status, dependency, limitation, and decision-tracking records.
- Support data requests, technical reporting, and related GSMFC projects as assigned and prioritized by the supervisor.
- Take ownership of existing systems, resolve problems, and develop improvements that preserve scientific data meaning and traceability.
Requirements
- Bachelor’s degree in computer science, information technology, data science, or a related field, or equivalent education and relevant professional experience.
- Demonstrated ability to develop database-backed applications and data-processing workflows, with strong SQL and relational database skills.
- Practical Python experience and ability to maintain existing PHP and JavaScript applications.
- Ability to troubleshoot unfamiliar systems, validate imported data, investigate discrepancies, and preserve source information.
- Working knowledge of Git, testing, configuration management, and controlled deployment, with clear communication and the ability to work independently while seeking clarification when needed.
Technology Stack
- SQL, relational databases
- Python, PHP, JavaScript
- Git, Access, ODBC, CSV
- React, HTML, CSS
- GIS and spatial data, Oracle, Oracle APEX
Education and Language
- Education: Bachelor’s (Required)
- Language: English (Required)
Benefits
- 401(k)
- 401(k) matching
- Flexible spending account
- Health insurance
- Paid time off
Preferred Qualifications
- MySQL
- Access/ODBC and legacy-data interoperability
- HTML, CSS, JavaScript, React, and PHP web applications
- Python-based Windows applications
- GIS and spatial data
- Multi-organization data standards and review
- Oracle or Oracle APEX for legacy or cross-program support
- Experience with fisheries or environmental datasets would be helpful but not necessary
- Candidates do not need to know every component of the existing stack
Pay and Work Location
- Salary: USD 65,000 - 85,000 per year
- Work location: In person
- Location: Ocean Springs, MS (onsite)
- Ability to commute: Ocean Springs, MS 39564 (Preferred)
- Ability to relocate: Ocean Springs, MS 39564 (Required)