Search by job, company or skills

F

SQL Tuning ,database tuning

3-6 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted 12 days ago
  • Over 50 applicants
Quick Apply

Job Description

Roles and Responsibilities

  • Very Good Experience in SQL Tuning (indexes, partitioning, pruning, joints , filter predicate etc.,) weightage is more than 50%.
  • Optimizer/Stats/Explain Plan/Wait events/locks/Partitioning/ Dead blocks/Index/Hints etc.
  • Very good Exposure to code analysis From Database Tuning Point Of View.
  • Approach to identify issues caused due to Database (SQL+ Configuration + Hardware).
  • AWR Report Analysis Very good experience in identifying issues caused due to wait events.

NESTED LOOPs vs HASH JOIN.

  • Performance tuning core and working knowledge with a certification in the area is good to have.
  • Production support knowledge with regards to proactive and reactive tuning Mandatory skills.
  • Very Good Experience in SQL Tuning (indexes, partitioning, pruning, joints , filter predicate etc.,) weightage is more than 50.
  • Optimizer/Stats/Explain Plan/Wait events/locks/Partitioning/ Dead blocks/Index/Hints etc.
  • Very good Exposure to code analysis From Database Tuning Point Of View.
  • AWR Report Analysis Very good experience in identifying issues caused due to wait events.

More Info

Job Type:
Industry:
Function:
Employment Type:
Open to candidates from:
Indian

About Company

At Fusion Plus Solutions Inc, we believe that it’s an exceptional company - a company of people proud of the work they do and the solutions they provide. By understanding what drives our specialty industries, becoming involved in our communities on a professional and personal basis, following a disciplined process of identifying quality candidates, partnering with employers to understand their core business and their employment requirements, and delivering exceptional service, we achieve great results for all concerned.

Job ID: 121825089