Job Title : Oracle PL/SQL – Analyst Programmer Production Support Company : Netreach Software Pvt Ltd Location : Andheri West, Mumbai, India Experience At least 1.5 to 4 years of experience, Responsibilities : Ø Must have worked on oracle Pl/Sql code in a production support role. Ø 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. Ø Knowledge of DBA activities like Import, export, Users creation, Tablespace creation, grant and revoke roles to users. Ø 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. Ø Coordination with testing department for preparation of test cases required for testing the modules. Ø Developing and maintenance of pl/sql codes. Ø Handling client side support. Ø Providing client support Ø Understand, resolve, test and provide the proper solution of a problem occurred in the system. Ø Involved in writing procedures, functions, cursors, triggers and packages for new requirements. Ø Write and tune SQL Queries used in the application. Ø Export and import dump according to client requirement. Ø Support to client in specific situation. Ø Implementation of the product for the new client site. Ø Exception Handling Ø Data migration for the client.
