nepalfere.blogg.se

Pl sql developer roles and responsibilities
Pl sql developer roles and responsibilities










pl sql developer roles and responsibilities
  1. #PL SQL DEVELOPER ROLES AND RESPONSIBILITIES SOFTWARE#
  2. #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.
  • pl sql developer roles and responsibilities

  • 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.
  • pl sql developer roles and responsibilities

    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.












    Pl sql developer roles and responsibilities