Oracle Performance Tuner SME (DBA)

Atlanta, GA 30346

Posted: 10/18/2023 Job Category: Oracle DBA Job Number: 2788

Job Description

Oracle Performance Tuner SME (DBA)

***This role will be hybrid onsite 4 days per week***

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
  10. 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.
  11. Data Stage, added advantage
Candidates requiring visa sponsorship WILL NOT be considered at this time.


Meet Your Recruiter

Sam Slonkosky
Technical Recruiter

I'm happy to connect with you on your next career challenge. Whatever your needs are, we at Resolution Technologies promise to provide unrivaled quality and service. Please don't hesitate to contact me if you have any questions about this position.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.