What are the responsibilities and job description for the PostgreSQL Database Developer position at Performix?
· 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 client’s 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)