OptimHire’s Job Auto-Applier that will automatically apply to jobs at 300,000+ Companies.
Job Title: Database Developer (PostgreSQL)
Location: Delhi – Work from Client Site
No. Of Positions- 1 Experience Required: 2-4 Years
Team Size & Reporting- NA
Designation: Database Developer
Database Backend Development: Database Developer with 2–4 years of hands-on experience in PostgreSQL development. The ideal candidate will be proficient in writing complex SQL queries, creating and managing PL/pgSQL functions, working with triggers, and handling JSON data structures within the database. You will work closely with application developers, data analysts to ensure efficient and reliable data flow and database logic.
Key Responsibilities:
●
Design, develop, and maintain PL/pgSQL functions, stored procedures, and database triggers.
●
Collaborate with the backend and frontend teams to support data-driven application development.
●
Write and optimize complex SQL queries for reporting, analytics, and application needs.
●
Analyze and improve database performance including query optimization and indexing.
●
Work extensively with JSON data types in PostgreSQL for storing and retrieving structured data.
●
Assist in schema design, data modeling, and migration of existing data to new structures.
●
Maintain and ensure data integrity, security, and compliance.
Required Skills & Qualifications:
●
Experience in database development using PostgreSQL.
●
Proficiency in PL/pgSQL, including writing and debugging stored procedures and triggers.
●
Strong knowledge of SQL, with experience in writing and optimizing complex queries with a strong understanding of normalization and joins.
●
Hands-on experience working with JSON data in PostgreSQL.
●
Familiarity with performance tuning, query optimization, and analyzing execution plans.
●
Basic understanding of database design principles, normalization, and data modeling.
●
Exposure to version control systems like Git, SVN including branching, merging, and pull requests.
●
Good communication skills.
Job Description- Database Developer – PostgreSQLRequired Skills & Qualifications:
●
Experience in database development using PostgreSQL.
●
Proficiency in PL/pgSQL, including writing and debugging stored procedures and triggers.
●
Strong knowledge of SQL, with experience in writing and optimizing complex queries with a strong understanding of normalization and joins.
●
Hands-on experience working with JSON data in PostgreSQL.
●
Familiarity with performance tuning, query optimization, and analyzing execution plans.
●
Basic understanding of database design principles, normalization, and data modeling.
●
Exposure to version control systems like Git, SVN including branching, merging, and pull requests.
●
Good communication skills.
Job Description- Database Developer – PostgreSQL
Back End Developers
Data Analysts
Database Administrator
Data Engineer
PostgreSQL - 2 years
PL/SQL - 2 years
Database development - 2 years
SQL - 2 years
JSON - 2 years
Database Design - 2 years
Performance Tuning - 2 years
Data Modeling - 2 years
GIT - 2 years
Apache Subversion (SVN) - 2 years
Oracle Performance Tuning - 2 years