Oracle PL/SQL Analyst

Job description

Technical Skills:--

-Job Functions

Design, Development, Documentation, Maintenance, Coordination,

Support.

-Languages

Oracle PL/SQL, Advanced PL/SQL

-Platforms

Windows

Database

Oracle 19c

-Advance

Tools/Technologies

Oracle 19c, Toad, Pl Sql Developer

-Domain Knowledge

Finance, Insurance, Music

Responsibility -

Ø Must have worked on oracle Pl/Sql

Ø 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.

Ø 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.