13.3333px; background-color: rgb(255, 255, 255);">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.