Overview
0.0
Contract - W2
Skills
FOCUS
Data Management
Streaming
Workflow
Storage
Reporting
Web Applications
API
Collaboration
Quality Assurance
Business Analysis
Business Analytics
Preventive Maintenance
Performance Management
Project Management
Extract
Transform
Load
Data Migration
Knowledge Transfer
Profit And Loss
SQL
Geospatial Analysis
PostGIS
PostgreSQL
Management
Database
Git
Version Control
Atlassian
Requirements Management
JIRA
Confluence
Job Details
Role: PostgreSQL Database Developer
Location: Remote
Duration: 6 months contract
Description 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 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)
--
Thanks & Regards,
Pallavi Reddy| Technical Recruiter
Thoughtwave Software and Solutions
Desk: , EXTN:167
Email:
Location: Remote
Duration: 6 months contract
Description 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 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)
--
Thanks & Regards,
Pallavi Reddy| Technical Recruiter
Thoughtwave Software and Solutions
Desk: , EXTN:167
Email:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.