Talent.com
Qentelli - PostgreSQL Developer

Qentelli - PostgreSQL Developer

Qentelli SolutionsHyderabad
10 days ago
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.
  • 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.

    • (ref : hirist.tech)

    Create a job alert for this search

    Developer Postgresql • Hyderabad