Oracle PL/SQL Developer

oracle pl/sql developer, etl, olap schema, erd, oracle 11g/12g
Contract W2, 1 Years
Depends on Experience
Work from home not available Travel not required

Job Description

Please note that this is a 1 year contract position.

"Provides Oracle PLSQL development for enterprise application that integrates data from multiple data sources into a cohesive analytical data warehouse to support business intelligence applications. Specific responsibilities include:
Develop complex database processes with PL/SQL containing batch or ETL functionality;
Develop and enhance an existing Data Mart in an OLAP schema;
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;
Demonstrate abilities to learn both the business processes as well as new and existing technologies;
Work on sprint team in agile, rapid development and deployment environment; and
Support production application by investigating and resolving production inquiries and issues.

Required skills/experience:
" 5+ years of experience in designing, creating and developing Oracle database systems;
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).

Desired/Preferred Skills/Experience:
Postal or mailing industry experience

A minimum of ten (10) years experience in software development or related field;
A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
Able to perform all functional duties independently on high-visibility programs, or mission critical aspects of a given program;
Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job;
Experience training/mentoring less experienced personnel;
Able to obtain Postal clearance;
Excellent communication skills.

Applicants must provide their phone number. Reference Job Number 4662

Posted By

San Francisco, CA

Dice Id : NETSO
Position Id : 4662
Have a Job? Post it

Similar Positions

Oracle APEX Applications Developer
  • Technology Recruiting Solutions,Inc.
  • Little Rock, AR
Oracle PL/SQL Developer
  • Eliassen Group
  • Brentwood, TN
Oracle Developer
  • Apetan Consulting
  • Goodlettsville, TN
PL SQL Developer
  • Kforce Technology Staffing
  • Marlyand Heights, MO
Oracle Architect
  • MATRIX Resources, Inc.
  • Birmingham, AL
PL/SQL Developer
  • Shakti Group, Inc.
  • Alpharetta, GA
Oracle Applications Technical Developer.
  • Pegasus Knowledge Solutions
  • Alpharetta, GA
Oracle AIA Consultant
  • Cortex Consultants
  • Alpharetta