Apply Now View All Jobs by this Recruiter

  • Job View 1387 Views
  • Applicants Less than 5 Applicants

Job Description

Job Title : Oracle PL/SQL – Analyst Programmer (Development and Production Support)

Location : Andheri West, Mumbai, India

Key Skills PL/SQL, Production support, Packages, procedures, functions, triggers, Views, cursors, SQL queries, subqueries, debugging and testing code

CTC : 5 to 7 Lacs per annum, with at least 4 to 5 years of experience

Job Responsibilities : - Should have sound experience in functional analysis, design, development, coding, implementation, maintenance and support in different domain with different technologies like java, jsp, Servlet, forms, reports as frontend and oracle as backend.

- Must have worked on oracle plsql code development and production support

- knowledge and experience in packages, Procedures, Functions, Triggers, Views, Cursors, PL/SQL Table, Nested Tables, Varrays, Sequences, Indexes, sysnonyms, 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.

- 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 Linux.

- 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.

Key Skills


Computer / IT

Functional Area

IT Software - System Programming

Number of Vacancy



About Netreach Software Pvt Ltd

NetReach Asia, Singapore with its offshore office in Mumbai is a diversified offshore Business Solutions and IT Services provider. Our competencies lie in setting up dedicated offshore software development teams for product development, Application Maintenance and Testing, for Life sciences, Financial Services, and Music Industries.
Our enterprise solutions are running in corporations in Asia. Our team is committed to quality and is made up of highly skilled professionals encompassing a broad range of technology disciplines. Using our proven Project Management and mature development methodology we help emerging software leaders bring superior products to market.
Our Technology services range from complete design and development of custom software applications to maintenance of existing applications by leveraging innovative technologies, techniques and assets. Our Application development (AD) services are designed to address the business needs of our clients.

Learn more...

read more
Apply Now

Similar Jobs

Career Insights For Your Growth