MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
1

ORACLE PL/SQL Analyst Programmer (Production Support)

Location Mumbai, India
Posted 25-August-2021
Description
ORACLE PL/SQLAnalyst Programmer (Production Support) Job Title : Oracle PL/SQLAnalyst Programmer Production Support Company : Netreach Software Pvt Ltd Location : Andheri West, Mumbai, India Experience At least 1.5 to 4 years of experience, Expected CTC 1.5 to 6 Lacs Job 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 databaseExperience in writing and tuning complex and large SQL queries with the help of explain plan, trace files, tkprof.Good at debugging and testing codeExperience 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 SystemIntegral 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 supportUnderstand, 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 HandlingData migration for the client.
Experience
Min 5 to 9 Years.

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url