Sr PL/SQL Developer

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. 
 

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