
- #PL SQL DEVELOPER ROLES AND RESPONSIBILITIES SOFTWARE#
- #PL SQL DEVELOPER ROLES AND RESPONSIBILITIES WINDOWS#
Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables. Performance Tuning of Oracle Applications using TKPROF. Created programs to transform data from Legacy systems into Oracle database. Used Materialized Views, Packages and Dynamic SQL.
Automated SQL*Loader to load the data from the flat files. Used SQL*Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packages. Wrote Audit programs for data consistency check and validation. Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization. Granted resources, privileges and roles to users. Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms. Applied Database Tuning and Optimization, Normalization in the new database design. Created logical and physical Database Design, data structures, Data Modeling, Schema Design.
Feasibility study, planning, implementation, testing, deployment and close-out.Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.
#PL SQL DEVELOPER ROLES AND RESPONSIBILITIES WINDOWS#
Over 2 years of experience in DW/ETL Technologies.Ĭreated Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment
#PL SQL DEVELOPER ROLES AND RESPONSIBILITIES SOFTWARE#
5+ years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server.