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.Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.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.Looking for drafting your winning cover letter? See our sample PL SQL Developer Cover Letter. While a Bachelor’s degree in the field of IT or computer science is considered ideal for this job role, some employers oversee work experience and skills over formal education. The normal skills that are expected from a PL SQL developer are SQL expertise, working knowledge of various operating systems, programming language skills, familiarity with ETL tools and a good grip of Oracle, Java and D2K forms. A PL SQL developer takes charge of maintaining and building computer databases using Pl/SQL packages, the various other roles and responsibilities that are normally executed and included in the PL SQL Developer Resume are – developing and providing support to system interfaces, coordinating with other developers and project managers for evaluation of applications, developing various SQL packages, monitoring and recommending changes in PL/SQL packages, developing relational database, testing and troubleshooting databases, ensuring data security and merging database information.

Oracle 9i pl sql software download