Qentelli - 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.

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