Sr PLSQL Developer

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

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

Ø  Developing and maintenance of PL/SQL codes.

Ø  Handling client side support.

Ø  Providing client support

Ø  Understand, resolve, test and provide the proper solution of a problem occurred in the system.

Ø  Involved in writing procedures, functions, cursors, triggers and packages for new requirements.