Oracle Performance Tuner

Title

Oracle Performance Tuner

Duration

Full-time

Location

San Jose, CA (Remote)

Primary Skills

Performance Tuning, PL/SQL

Secondary Skills

SQL Tuning

Oracle Performance Tuner SME (DBA)
San Jose, CA (Remote)

Senior Oracle SME (8+ years' experience), who will provide high quality technology solutions that address business needs by supporting application development team for SQL tuning, Guidance on best practices for SQL coding and perform reviews and documentation. This role will participate in software development and support efforts for large Data Warehouse and financial applications using Oracle 11g / 12c / 19c databases.

Oracle Performance Tuner SME Required Skills:

• Must have extensive experience working closely with the Application Development teams.
• Strong PL/SQL experience, targeting Oracle versions 11g, 12c, 19c.
• "SUPERIOR" level Performance Tuning & Troubleshooting skills.
• Strong understanding of Oracle Cost Based Optimizer
• Proven development of Statistics and Index strategies
• Proficiency in diagnosing performance issues across application tiers
• PL/SQL development experience of all types of SQL DML statements - functions, stored procs, triggers etc.
• Proactive Code Reviews and follow-ups to communicate best practices.
• Will be a part of the Oracle Team supporting a wide array of application development teams developing custom applications.
• Should have experience & ability to work with various teams to resolve performance issues.
• Understand and recommend industry best practices and standards.
• GoldenGate is HUGE PLUS but not a disqualifying skill.
• Experience with developing ETL solutions

Oracle Performance Tuner SME Preferred Skills:

1. Very Strong database development experience using Oracle 19c/12c/11g.
2. Expert: How to interpret and utilize the following
3. SQL Plan Management, Incremental Stats collection, Synopsis, histograms, SQL Access Advisor, Tuning Advisor, Segment Advisor, SQL Plan Baselines, SQL Profiles, Column Groups, Optimizer Statistics Advisor,
4. Expert in SQL & PL/SQL modules such as packages, procedures, functions, and other database objects.
5. Expert in Performance Tuning of application code at the database level.
6. Experience in Unix/Linux and Shell scripting.
7. Excellent oral/written communication.
8. Should have Undergraduate Degree or possess extensive experience in related field.
9. Soft skills such as "team player" "collaborative mentality" etc.
   1. Excellent Communication and collaboration skills required.
   2. Comfortable leading and presenting during discussions.

1. Huge Plus - Not mandatory - Any experience in PostgreSQL, Data Guard Replication Configuration & Troubleshooting and Working closely with Global Support DBA teams in addressing the data issues.

Data Stage added advantage