The PostgreSQL Database Developer is responsible for developing database code powering the our cloud platform to support millions of IoT nodes. This is a central role in our development team that will create the database schema and functions that interface with the schema, build effective APIs that access and manipulate very large data-sets, working with product managers, front end developers and DBAs.

Responsibilities
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Work closely with the CTO to implement effective and maintainable database coding practices that form an architectural foundation
Work with front end developers to define easy yet powerful APIs
Work with DBAs to ensure efficiency of database code, integrity of data structures and quality of data content
Work with product managers to ensure database code meets requirements.
Work with DBAs and data analysts to ensure database code is accurately documented
Participate in the product discussion and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in reviews

Required Skills
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
Post-GIS proficiency and grasp of core geo-spatial 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 rapid-paced setting
Excellent verbal, written, and interpersonal communication skills
Ability to evaluate alternative solutions and/or workarounds

Preferred Skills
Experience with Python/Go Programming
Experience with message queuing, full text indexing, and other other high performance data concepts
Demonstrable experience working with huge, interdependent, complex data-sets and data structures
Bachelors Degree in computer science or relevant field with equivalent experience

Experience
Total Experience : 3 - 7 yrs.
Relevant Experience : 3 + yrs.
Bachelors / Masters Degree in computer science or relevant field with equivalent experience

📌 Postgresql Developer Mumbai
🏢 Vayve Technologies
📍 Mumbai