Oracle PL/SQL Reliability / Performance Engineer

PL/SQL, Reliability, Performance Engineer, Golden Gate, Python, Shell, Chef, Puppet, Ansible, OS Kernel, SQL, ASH, AWR, 10046, 10053, PGA, SGA
Contract W2, Contract Independent, Contract Corp-To-Corp, 12 Months
Depends on Experience
Travel not required

Job Description

Red Oak Technology is seeking an Oracle PL/SQL Reliability/Performance Engineer for our high tech giant client located in Sunnyvale, CA for a long term Contract position.  

Responsibilities:

  • Create performance tools to avoid issues and blockage scenarios
  • High availability, increased performance, troubleshoot Oracle PL / SQL databases for performance issues.
  • Design partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance
  • Develop logical and physical data models;
  • SQL development, SQL analytics and performance tuning
  • Analytic, troubleshooting and performance tuning
  • Design and implement Database procedures and complex queries
  • Write and code logical and physical database descriptions

Qualifications:

  • 6 years + experience with Oracle PL/SQL (package, procedures, functions, triggers, performance tuning) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing
  • In depth understanding of Oracle Architecture, PGA, SGA, Init. Ora , Wait Events
  • OS fundamentals
  • ASH, AWR, 10046, 10053 based Tuning expertise
  • SQL and Pl/SQL Tuning
  • OS Kernel Level tuning and OS level tracing
  • Very good understanding of SQL Execution Plan
  • Expert in Golden Gate Setup and Troubleshooting
  • Point in time recovery and conflict handling in Golden Gate
  • Python/Shell Scripting
  • Automation tools like Chef, Puppet or Ansible
  • Education Bachelor’s Degree (Preferred Master's Degree)

 

 

Dice Id : redoak
Position Id : 6582747
Originally Posted : 2 weeks ago
Have a Job? Post it

Similar Positions

Performance DBA with expertise in PL/SQL
  • SmartIT Frame
  • Sunnyvale, CA
PLSQL Developer with Procure 2 Pay
  • iTechStack
  • San Jose, CA
Performance Engineer
  • VISION INFOTECH INC.
  • Pleasanton, CA
PL/SQL Developer - Banking
  • TribolaTech Inc.
  • San Ramon, CA
Sr. Performance Engineer
  • Group A LLC
  • Pleasanton, CA
Scalability and Performance Architect
  • VMware Carbon Black
  • Palo Alto, CA
Oracle Application Express (APEX) Developer @ Pleasanton, CA
  • TechTu Business Solutions Inc
  • Pleasanton, CA
Performance Test Lead or Analyst
  • Aventure Systems
  • Foster City, CA
High-Performance Computing Engineer
  • Capital Markets Placement
  • Ca
Power & Performance Software Engineer
  • Cinder Staffing
  • Santa Clara, CA
Oracle Servicecloud Developer
  • Buxton Consulting
  • Foster City, CA
Oracle EBS Distribution Techno-Functional Resource
  • InfiCare Technologies
  • Sunnyvale, CA