PostgreSQL Database Developer

of Project:The focus of the Biological Data Management project is the development of a data system to support MPCA field biologists in their work collecting fish, invertebrate, and physical data in streams, through the complete workflow of storage, analysis, and reporting on that data.

Development of the system is already underway.

The advanced PostgreSQL database developer under this engagement will work on a large project team to develop, optimize, and troubleshoot database objects (functions, procedures, views) to support this functionality.

The system includes complex synchronization between schemas that support the mobile field applications and the schemas that support the internal web application.

The system also incorporates significant geospatial functionality in the database using the PostGIS database extension for PostgreSQL.

Sample Tasks:Translate business requirements to technical solutions documented as tasksDevelop PostgreSQL database objects (functions, procedures, views)Optimize PostgreSQL database objects (functions, procedures, views)Troubleshoot PostgreSQL database objects (functions, procedures, views)Manage database code in Git version control following project proceduresCollaborate with front-end and API developers on development of database objectsCollaborate with Quality Assurance (QA), Business Analyst (BA), Project Manager (PM), and other developers to resolve issues identified during developmentDevelop ETL processes for data migrations and importsFollow secure coding practicesTest database code prior to deployment to the Test database instanceDocument code and processesProvide knowledge transfer to State staffPerform other related duties as assignedDesired Qualifications:Experience in PostgreSQL PL/pgSQL developmentExperience in PostgreSQL SQL developmentExperience optimizing PostgreSQL databases, queries, and objectsExperience implementing geospatial functionality using the PostGIS database extension for PostgreSQLExperience managing database code in Git version controlExperience working on large managed project team(s)Experience using Atlassian project and requirements management tools (Jira and Confluence) Apply tot his job