PL/SQL Developer

Job Description: 5+ Years of exp. In all phases of SDLC including requirement gathering, Analysis,
application design, development, testing, implementation, and Maintenance.
● Extensive SQL and PLSQL programming exp. Including packages, stored
procedures, functions, triggers, indexes, and exception handling. Create Database
objects like tables, views, sequences, synonyms, and indexes using Oracle tools like
SQL*Plus, SQL Developer, Toad.
● Strong working knowledge of loading data using SQL*Loader and PLSQL using
different file formats.
● Extensive experience in troubleshooting, Query optimization, and performance Tuning
use of Explaining plans.
● Experience in using features Ref-Cursors, PLSQL Tables, Materialised Views,
Dynamic SQL and Oracle RAC.
● Experience to write scheduler jobs and troubleshoot issues if any failures.
● Analyse application requirements and provide recommended design. Support code
migration from development to staging environment.
● Write complex SQL queries and PLSQL procedures to extract Data from various
source tables.
● Ability to work independently and as part of a team, deliver under pressure and tight
deadlines