Oracle PLSQL Programmer

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.