![]() Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.Expertise in Dynamic SQL, Collections and Exception handling.Experience in SQL performance tuning using Cost-Based Optimization (CBO).Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.Worked extensively on Ref Cursor, External Tables and Collections. ![]() Partitioned large Tables using range partition technique.Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.Loaded Data into Oracle Tables using SQL Loader.Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.Developed materialized views for data replication in distributed environments.Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Good knowledge on logical and physical Data Modeling using normalizing Techniques.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).Strong experience in Data warehouse concepts, ETL.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |