PLSQL devloper

Job description

Must have worked on oracle Pl/Sql code in a production support
role.

Ø  Must have experience in Packages, Procedures, Functions,
Triggers, Views, Cursors, PL/SQL Table, Nested Tables, Arrays, Sequences,
Indexes, synonyms, file handling, DBMS Scheduler, oracle text, Subqueries,
Inline views, Materialized view in oracle database

Ø  Experience in writing and tuning complex and large SQL
queries with the help of explain plan, trace files, tkprof.

Ø  Good at debugging and testing code

Ø  Experience in Database Design, Modeling And Normalization.

Ø  Experience with data flow diagrams, data dictionary
techniques, Entity relation modeling.

Ø  Knowledge of DBA activities like Import, export, Users
creation, Tablespace creation, grant and revoke roles to users.

Ø  Sound analytical, problem solving and trouble shooting
skills.

Ø  Good spoken and written communication skills.

Ø  Ability to work well in both a team and individual
environment.

Ø  Experience in data migration from legacy system to new
system.

Ø  Sound Experience in Toad, SQL developer.

Ø  Knowledge of Windows Operating System

Ø  Integral member of team, which is responsible for database
development of various modules of core financial application.

Ø  Responsible for understanding the all aspects of systems
and resolving numerous technical issues.

Ø  Coordination with testing department for preparation of
test cases required for testing the modules.

Ø  Developing and maintenance of pl/sql codes.

Ø  Handling client side support.