Oracle PL/SQL

Role & responsibilities

PL/SQL Developer

EXP: 7+ Years

Responsibility:

Experience in the software development life cycle including Requirements, analysis, design, development, testing and implementation of applications using UNIX, Oracle PL/SQL, HTML, JavaScript, CSS.

Experience in designing, developing, testing, and implementing complex database programs using Oracle PL/SQL, UNIX. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.

Must have:

Experience in the software development life cycle including Requirements, analysis, design, development, testing and implementation of applications using UNIX, Oracle PL/SQL, HTML, JavaScript, CSS.

Experience in designing, developing, testing, and implementing complex database programs using Oracle PL/SQL, UNIX. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.

Experience in managing production support activities, debugging / fixing Oracle objects.

Experience in data mapping / conversion / transformation / integration activities according to third-party (vendor) requirements and integration of legacy applications/tools with the vendor tools.

Optimizing performance of existing Oracle code, Oracle queries, stored procedures, packages, functions using explain plan.

Development of UNIX Shell Scripts for loading Oracle tables from data files using SQL LOADER and automating UNIX scripts through UNIX CRON JOBS.

Experience in creating UNIT Test plans and working closely with QA teams and reviewing test plans.

Preferred candidate profile

Perks and benefits