Oracle PL/SQL Analyst

Job description

Job Description Summary--

Our Mumbai Office – being our Offshore Development Centre, NetReach Software Pvt

Ltd, is seeking a highly motivated Oracle PLSQL Developer to help design, develop,

review and deploy complex solutions. One of this team's role is new development of

financial modules for copyright societies in the Asia Pacific.

You will be working under a Team Leader, analyzing challenging requirements, flying to

client offices in Asia Pacific, attending meetings and interacting with end users,

preparing specifications, undertaking development of complex application functions in

PL/SQL. You will additionally participate in code review and testing.

We are looking for smart, self-learning problem-solvers who are not only knowledgeable

in enterprise technologies but also know how to work collaboratively with others to apply

technologies in creative, practical and efficient ways. Three important qualities we seek:

∙Ability to work in a fast paced team environment with constantly changing

priorities.

∙Ability to design, develop and implement multi threaded PL/SQL code for OLTP

and reporting solutions to meet business needs.

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.

Ø