Job Description :
Title: Postgres Architect
Location: Hoboken, NJ
Requisition Details:
Deep understanding of PostgreSQL and provide expertise to tune and push our databases beyond their normal limit
Write and maintain complex SQL scripts, spatial queries and stored procedures to read/write/transform data
Prior experience loading/transforming data of different formats such as flat tables
Knowledge of Esri products or similar GIS or spatial software
Develops database solutions using PostgreSQL; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
Prepare design documents and technical specs explaining and motivating the approaches to be taken in the deployment of systems.
Should have knowledge on python and other scripting language
Work closely with engineering teams to design, build, and maintain systems and help them decide on database to use, schema design and query tuning