Position: Разработчик SQL
Category: SQL
English level: upper
Years of experience: 0.5


Now i am working in a company
My duties:
Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
Designing logical and physical data models for star and snowflake schemas using Erwin.
Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.
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.
Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling.
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.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables