PLSQL Developer

Orange Services Nagpur; Nagpur District; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Orange Services Nagpur is seeking a database developer specialized in PL/SQL for Oracle and PostgreSQL. The role involves designing, testing, and deploying PL/SQL programs, along with creating stored procedures, triggers, views, and packages to meet business needs.

Responsibilities include optimizing performance via indexing and tuning, managing migrations, and handling replication between Oracle and PostgreSQL. Tools used include pgAdmin, SQL Developer, and DBeaver.

Qualifications

• Proficient PL/SQL development for Oracle and PostgreSQL.
• Experience with stored procedures, triggers, views and packages.
• Strong SQL tuning and query optimization skills.

Responsibilities

• Design, develop, test, and deploy PL/SQL programs for Oracle and PostgreSQL.
• Create and maintain stored procedures, functions, triggers, views and packages.
• Optimize database performance through indexing and query tuning.
• Migrate data and manage replication between Oracle and PostgreSQL.
• Hands-on with pgAdmin, SQL Developer, and DBeaver.

Skills

PL/SQL

Oracle

PostgreSQL

Stored procedures

Triggers

Views

Packages

Tools

pgAdmin

SQL Developer

DBeaver

Job description

Roles and Responsibilities

• Design, develop, test, and deploy PL/SQL programs for database management systems such as Oracle and PostgreSQL.
  
• Create stored procedures, functions, triggers, views, and packages to meet business requirements.
  
• Optimize database performance by implementing indexing strategies and query tuning techniques.

• Expert in Oracle & Postgresql database development & administration.

• Strong experience in store procedures, trigger, view.

• Database migrations and replication between oracle & postgre sql.

• Hands on with pgAdmin, SQL Developer, DBeaver.