Skip to content

 

Irvine, California - USD Full Time Posted: Friday, 8 November 2019
 
 
Job Description Role: Oracle Pl SQL Developer
Location: Irvine, CA
Contract: 3-6 months

Summary: Looking for Oracle PL SQL Developer with Informatica and following skills:

Required Skills:
  • 7+ years of experience in designing, creating and developing Oracle database systems
  • Experience writing stored procedures in PL/SQL and working in a hands-on capacity with Oracle 11g/12c
  • Have worked with recent versions of Oracle and written Stored Procedures in PL/SQL extensively.
  • Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing;
  • Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance;
  • Experience in developing logical and physical data models;
  • Experience designing OLAP systems;
  • Strong SQL development, SQL analytics and tuning skills;
  • Excellent analytic, troubleshooting and performance tuning skills;
  • Detail orientation with strong problem solving skills;
  • Ability to analyze large amounts of complex data; and
  • Strong communications skills (both verbal & written).
Responsibilities include:
  • Develop complex database processes with PL/SQL containing batch or ETL functionality;
  • Gather requirements and design, develop, test and document solution;
  • Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation;
  • Leverage Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system;
  • Assist Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements;
  • Participate in project work groups with Subject Matter Experts and stakeholders to understand data specific needs;
  • Provide production deployment and production support as needed;
  • Analyze and convert business requirements to technical requirements, followed by designing and implementing the solutions;
  • Be involved in all aspects of the software development life cycle;
  • Work on sprint team in agile, rapid development and deployment environment; and
  • Support production application by investigating and resolving production inquiries and issues.


Irvine, California, United States of America
IT
USD
OSI Digital
OSI Digital
JS2365_E99F13E810E152418E048356D781E05E/787442369
11/8/2019 11:46:09 AM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

Los Alamitos, California
USD
Los Alamitos, California
Costa Mesa, California
USD
Huntington Beach, California
Huntington Beach, California
USD