Postgresql Developer

5 - 10 years

20 - 25 Lacs

Posted:4 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Summary:

We are looking for an experienced PostgreSQL Developer with a strong background in Oracle database development. The role involves designing, writing, and optimizing SQL and PL/pgSQL code, migrating database logic from Oracle to PostgreSQL, and working closely with application teams to implement data-driven solutions.

This is a development-focused role, not a database administration position.

Roles and Responsibilities:

  • Develop and maintain functions, stored procedures, triggers, views, and other database objects in PostgreSQL.
  • Understand and translate existing Oracle PL/SQL code to PostgreSQL PL/pgSQL.
  • Analyze and improve query performance and execution plans.
  • Work closely with application developers to implement and test database logic.
  • Participate in database design, data modeling, and schema optimization.
  • Handle data transformations and migration from Oracle to PostgreSQL.

Required Skills:

  • 712 years of experience in SQL development with a focus on PostgreSQL.
  • Strong hands-on experience in PL/pgSQL and writing complex queries.
  • Solid experience with Oracle PL/SQL, including procedures, packages, cursors, and exception handling.
  • Experience in migrating business logic and data from Oracle to PostgreSQL.
  • Good understanding of relational database design, joins, indexing, and normalization.
  • Ability to troubleshoot and tune slow-running SQL queries.
  • Familiarity with tools for comparing schemas and code between Oracle and PostgreSQL.

Preferred Skills:

  • Experience working with Oracle to PostgreSQL migration tools (e.g., ora2pg, AWS SCT).
  • Familiarity with cloud-based PostgreSQL (e.g., AWS RDS, Azure PostgreSQL).
  • Knowledge of scripting languages like Python, Shell, or Perl for automation tasks.
  • Exposure to version control systems (e.g., Git) and working in agile teams.
  • Basic knowledge of JSON, array types, and full-text search in PostgreSQL.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Qentelli logo
Qentelli

Software Development

Dallas Texas

RecommendedJobs for You

hyderabad, pune, bengaluru