Job Description
•Strong experience with oracle functions, procedures, triggers, packages & performance tuning.
•Review existing code and optimize to achieve required performance experienced in application fine-tuning and database fine-tuning using Explain Plan and analysis tool.
•Monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.
•Sound analytical and problem-solving skills with a good exposure on Oracle PL/SQL database objects.
•Develop, design, test and implement complex database program.
•Ensure that database programs follow V3 standards.
•Providing technical assistance, problem resolution and troubleshooting support.
•Strong technical and communication skills to communicate with the client.
Skill and other competency-
- Oracle SQL, PL/SQL, Java, Shell script.
- Oracle Pl/SQL Performance Tuning Developer (8+ Years).
- Operating System : Windows, Linux.
- Tools Experience : Toad / PLSQL Developer/SQL Developer, Job Scheduler etc.
