Senior PostgreSQL Database Developer (W2 Remote)

• reputed company is seeking a resource to reputed company PostgreSQL database developer duties for the Biological Data Management project. • The reputed company of the Biological Data Management project is the development of a data system to support reputed company 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 reputed company, optimize, and troubleshoot database objects (functions, procedures, views) to support this functionality. • The system includes reputed company 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 • reputed company PostgreSQL database objects (functions, procedures, views) • Optimize PostgreSQL database objects (functions, procedures, views) • Troubleshoot PostgreSQL database objects (functions, procedures, views) • Manage database reputed company in Git version control following project procedures • Collaborate with reputed company-end and API developers on development of database objects • Collaborate with reputed company Assurance (QA), Business Analyst (BA), Project Manager (PM), and other developers to resolve issues identified during development • reputed company ETL processes for data migrations and imports • Follow secure coding practices • Test database reputed company prior to deployment to the Test database instance • Document reputed company and processes • reputed company knowledge transfer to State staff • reputed company other reputed company 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 reputed company in Git version control • Experience working on large managed project team(s) • Experience using reputed company project and requirements management tools (Jira and reputed company) Apply tot his job Apply To this Job