Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling.
Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.Designing logical and physical data models for star and snowflake schemas using Erwin.Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
0 kommentar(er)
