Previous Job
Previous
PL/SQL Developer
Ref No.: 18-15710
Location: Seattle, WA, Washington
  • Having 8-12 Years of IT experience as an ORACLE PL/SQL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing , Production Deployment and Support.
  • Expertise in SQL and PL/SQL programming, developing complex code units.
  • Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
  • Understanding and Collecting requirements from Business user side or Business Analyst and try to convert that requirement to SQL queries or PL/SQL.
  • Convert the Business need in to Technical complex queries.
  • Use different strategies of database development to meet the client functional requirement.
  • Experience in data migration/conversation using SQL*Loader.
  • Experience in Data migration using import and export.
  • Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
  • Expertise in writing procedures, functions, views, materialized views as required.
  • Responsible for performance tuning activities in the project.
  • Having good experience on Client Interaction and Presentation Skills.
  • Ability to write complex sql queries for reporting purpose.
  • Customizing the application using PL SQL techniques.
  • Support the users of application with using multiple SQL and PL/SQL techniques.
  • Can assist in developing and implementing new technologies.
  • Support all day to day activities related to database like data consolidation, data migration scripting.
  • Creating complex views, materialized views on multiple table as per customer requirement.
  • Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.