Nascent Info Technologies Pvt. Ltd.

SQL Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Pune, Ahmedabad
  • Experience: 3-8yrs
  • No. of Positions: 1
  • Salary Range: 3-9 lac
  • Primary Skills: Postgresql SQL Development Database Development Query Optimization Design Principles Views
  • Secondary Skills: Stored Procedures Database Design Postgres PL Skills highlighted with ‘‘ are preferred keyskills
  • Job Location: Pune, Ahmedabad
  • Posted Date: 10 days ago
Job Description

Role description:

 

The PostgreSQL database developer is responsible for developing database code. This is a central

role in our development team that will build effective APIs that access and manipulate very large

datasets, many of them geospatial, working with product managers, front end developers, GIS

analysts and DBAs as needed.

 

Responsibilities:

 

  • Implement and maintain database code in the form of stored procedures, scripts, queries,
  • views, triggers, etc.
  • Owning all Postgres database architecture and design
  • Owning all Postgres database production and non-production implementation to ensure
  • performance, stability, and scalability. Establishing all Postgres support processes and
  • standards.
  • Creating appropriate scripts/code for production and non-production Postgres DB updates
  • Work with front-end developers to define simple yet powerful APIs.
  • Work with GIS analysts to implement geospatial processes, queries, and reports.
  • Work with DBAs to ensure the efficiency of database code, the integrity of data structures, and
  • the quality of data content.
  • Work with product managers to ensure database code meets requirements.
  • Review the existing Postgres implementation and propose/implement improvements

 

Critical skills required:

 

  • 3+ years working as a database developer working with PostgreSQL
  • Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
  • Knowledge of JSON and PostgreSQL support for JSON.
  • PostGIS proficiency and grasp of core geospatial concepts.
  • Ability to efficiently write database code without compromising data quality, privacy or
  • security.
  • Knowledge of database design principles, query optimization, index management, integrity
  • checks, statistics, and isolation levels
  • Able to handle multiple tasks in a fast-paced environment



Relevant Skill Jobs
PHP Developer
PHP Developer
Senior Full Stack Angular Developer
Senior Full Stack Angular Developer
Java Developer
Senior Software Engineer