PL/SQL – Analyst

Job opening at Mumbai

Location

Mumbai

Address

Mumbai

Employment

Full Time

Qualification

Bachelor Of Engineering - Bachelor Of Technology (B.E./B.Tech.)

Payment

600000 to 700000

Date Posted

2024 Apr,03

HR

Harshita Chouksey

Contact

harshitawhiteforce14@gmail.com

Mobile

9300520707


Job description

























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.



Job requirements

  • Experience: 2 to 5 Year.
  • Education : Bachelor of Engineering - Bachelor of Technology (B.E./B.Tech.)
  • Specilization : computer...
  • Skills :
  • Industry Type : IT-Software / Software Services
  • Status : Not Disclose.

Company Name : NetReach Software Pvt Ltd

Website

About Company

NetReach is a successful eBusiness Solutions consulting firm built on a strong foundation of business fundamentals and profitability. We implement high value solutions across several core industries.

We work with our customers as a team, identifying their business challenges, finding quick hit ways to increase productivity and corporate revenue.

Using new technology channels - including Web, Read more