Plsql SQL Performance Tuning

Sampoorna Computer People
  • Chennai, Pune
  • Confidential
  • 5-10 years
  • Views
  • 30 Oct 2018

  • IT/ Information Technology

  • Consumer Durables/ Semi Durables
Job Description

Highly-skilled software development professional in software design, development and integration. Advanced knowledge of Oracle SQL, PL/SQL.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, TOAD, External tables and SQL*LOADER.
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and table spaces.

Good knowledge of Oracle 11g architecture
Good knowledge on logical and physical Data Modeling using normalizing techniques.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored Procedures, Functions, Packages and triggers using SQL and PL/SQL with proper coding standard. Developed materialized views for data replication in distributed environments.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP.
Experience in Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
Partitioned large tables using range partition technique.
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such as Query Optimizer, analyzing Execution plans, and Indexes.


Exp: 5 to 11 Yrs
Location of posting: Chennai or Pune
Desired Candidate Profile: Candidate Experience Should Be : 5 To 11 Candidate Degree Should Be : BE-Comp/IT


Competencies/Skill sets for this job

Performance Tuning

Job Posted By

Kamal
Account Manager

About Organisation

Sampoorna Computer People