PostgreSQL Database Developer

Client is seeking a resource to perform PostgreSQL database developer duties for the Biological Data Management project.

The focus of the Biological Data Management project is the development of a data system to support clients 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.

Job Responsibilities

Translate business requirements to technical solutions documented as tasks

Develop 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 procedures

Collaborate with front-end and API developers on development of database objects

Collaborate with Quality Assurance (QA) Business Analyst (BA) Project Manager (PM) and other developers to resolve issues identified during development

Develop ETL processes for data migrations and imports

Follow secure coding practices

Test database code prior to deployment to the Test database instance

Document code and processes

Provide knowledge transfer to State staff

Perform other related duties as assigned

Desired Qualifications

Experience in PostgreSQL PL / PgSQL development

Experience in PostgreSQL SQL development

Experience optimizing PostgreSQL databases queries and objects

Experience implementing geospatial functionality using the PostGIS database extension for PostgreSQL

Experience managing database code in Git version control

Experience working on large managed project team(s)

Experience using Atlassian project and requirements management tools (Jira and Confluence)

Required Skills :

PostgreSQL PgSQL database development PostgreSQL databases queries and objects PostGIS database extension for PostgreSQL Managing database code in Git version control Atlassian project and requirements management tools (Jira and Confluence)

Key Skills

Databases,SQL,Database Development,PL / SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1