SQL Tuning ,database tuning

3 - 6 years

4 - 7 Lacs

Posted:1 week ago| Platform: Foundit logo

Apply

Work Mode

On-site

Job Type

Full Time

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Fusion Plus Solutions logo
Fusion Plus Solutions

Information Technology & Services

Innovation City

RecommendedJobs for You

hyderabad, telangana, india

hyderabad, telangana, india

hyderabad, telangana, india