Job Details
1Having experience in MS SQL SQL&PLSQL Development 2Finding out the root cause of performance SQL Queries and resolving accordingly 3.
Experience in developing Procedures, Functions, Triggers, Cursors and Packages 4Experience in using advanced features like BULKCOLLECT, FORALL and Ref cursors 5Good exposure to SQL queries and handling Exceptions in PLSQL.
6Good exposure to writing dynamic functions, procedures and packages 7Worked with Tools like SQL*Plus and SQL Developer 8.
Expertise in Dynamic SQL, Collections, cursors, Exception handling 9Experience in stored procedures, functions and packages as per the business Requirement Loaded external files Data into MS SQL Tables using SQL Loader 10.
Good knowledge of key MS SQL performance related features such as Query Optimizer, Execution Plans and Indexes and optimize procedures and packages 11Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) 12Development experience of materialized views for data replication in distributed environments.
13Good to have: Knowledge MS SQL database administration tasks include configuration management, backup/recovery, performance optimization, and space management