Postgresql Developer

Job Summary:

PostgreSQL Developer

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.
• Collaborate with QA and DevOps teams to support application testing and deployment.
• Ensure code quality, reusability, and proper documentation of database components.
  

Required Skills:

• 7-12 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.