Oracle PL/SQL Developer

  • Pleasanton, CA
  • Contract

Company Description

Ranked as the fastest growing IT services company in the U.S. by Inc. Magazine and selected as a Global Services 100 Provider, our proven success have enabled us to work with some of today's most influential companies while cultivating an environment in which our employees and consultants can continue to learn, grow and pave their own path both personally and professionally.

ProKarma offers an entrepreneurial work environment and the opportunity to work on a vast array of projects. Our competitive compensation and benefit plan includes: Health, Dental, Vision, and Life Insurance, Relocation Packages, Paid time off, and 401(k) investment opportunities.

In order to provide equal employment and advancement opportunities to all individuals, employment decisions at ProKarma are based exclusively on merit. ProKarma does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, national origin, age, or any other characteristic protected by law.

Job Description

Senior Oracle PL/SQL Developer

Location: Pleasanton, CA

Project: one year

Pay Rate: $70-$90 hr DOE


Seeking seasoned Senior Oracle PL/SQL professional with over 10 years of extensive hands-on experience with performance tuning of SQL and PL/SQL for Oracle 10g DB-based applications in fast-paced, dynamic optimization projects.  

 

  • Must have strong analytical skills with solid design and development skills implementing complex business logic, with experience in converting nested PL/SQL into plain SQL, addressing performance impacts with functional indexes and different types of joins, and using Hints for Query Optimizer.  

 

  • Must have experience performing extensive Sql tuning utilizing SQL Trace, TK Prof, Explain plan, V$ views to optimize database and application performance.  

 

  • Experience with design and development of automated text scripts for verification of business logic is a plus.

 

Top 3 - 5 Daily responsibilities are:  

 

a) Analysis of Oracle PL/SQL code for performance impacts

b) Reviewing execution plans and identifying potential problems

c) Coding and unit testing application code to address performance impacts

d) Create and enhance stored PL/SQL routines, triggers, and SQL*Loader scripts for data loads/data validations/summaries and business rule implementation, and

e) SQL and application tuning using SQL Trace, Explain, etc.

 

Must have strong Performance Tuning and not just basic development experience.

 

 

Kathleen Noonan | Resource Manager | ProKarma, Inc.

Portland, OR

 

 

Qualifications

Strong Performance tuning and very strong experience with Oracle PL/SQL. 10 + year required.