Job Description

Experience: 3 to 7 Years Role & Responsibilities: Design, analysis, coding, testing & support for solutions. Feasibility study, planning, implementation, testing, deployment and close-out Able to Interpret / analyze business requirements & functional specifications and create the Impact analysis documents. Able Determine the impact of proposed functionality on current system. Develop interfaces to load data into targeted database and extract data from flat files. Tune SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization Use Collections, Bulk Binding, Materialized Views, Packages and Dynamic SQL Develop the PL/SQL Procedure / Functions/ Packages / Triggers. Tune SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization Use Collections, Bulk Binding, Materialized Views, Packages and Dynamic SQL Applied Tuning and Optimization, Normalization in the database design Create the database design and modeling. Create data base design and modeling. Develop ER/Diagram, Functional documents. Completes independently efficient coding on complex applications. Primary Skills: Oracle DBA PL/SQL Secondary Skills (Nice to Have): Oracle ASM & Data Guard Swing – Java