Previous Job
Previous
PLSQL SQL DB Developer
Ref No.: 18-57366
Location: Pleasanton, Texas
Start Date: 08/09/2018
Role: PLSQL SQL DB Developer
Location: Pleasanton, CA
Duration: Full time /Permanent
Job Description:
  • Expertise in SQL and PL/SQL programming, developing complex code unitsSolid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
  • Unit Testing, Business Requirements Analysis and stakeholders communication.
  • 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.
  • Migrated data from flat files to tables using sql*loader.
  • Developing PL SQL Code Working with business users to understand the requirements.
  • High level and low level design Unit Testing, functional testing Performance test of code written Analysis Design Development Test case execution