Postgresql Developer

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.