PL-SQL Developer (7-16 yrs)

About The Company :

ARA's client is a premier IT &ITeS Organization for the last 50 years with a pan India footprint. Founded as Computer Maintenance and Services Company in 1976, Client is a pioneer and leader in the Indian ICT industry. With more than 4000 employees spread across 100 locations in India, they are adding value to every industry through its products, services and offerings.

Over the last 40 years, we have played an integral role in helping clients succeed through many economic cycles by providing expertise and experience in delivering governance services, transportation & traffic solutions, energy management solutions, surveillance & workforce management, broadcasting solutions as well as software services aligning technology with client businesses.

The Role : PL SQL Developer

Key Responsibilities :

- Experience of writing complex PL/SQL Procedures, Functions, Trigger and complex queries on largescale database.

- Responsible for enhancement and support of ECCS application and other related application.

- Responsible for writing DB procedure, functions, triggers, DB tuning etc.

- Responsible for development and enhancement in ECCS application

Skills Required :

- Minimum 7 years of experience SQL and PL/SQL

- Solid experience in writing SQL queries and PL/SQL programming.

- Implementation of Stored Procedures, Functions and Packages.

- Solid experience in writing SQL queries and PL/SQL programming.

- Implementation of Stored Procedures, Functions and Packages.

- Good Knowledge in writing Cursors, Triggers.

- Experienced in using Tables, Synonyms, Sequences, Joins and Sub Queries, Analytical Functions.

- Wrote complex queries using joins and sub queries to retrieve data from database.

- Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.

- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

- Creating Views and materialized views based on reporting requirement.

- Experience in database creation, Table space creation and maintenance.

- Experience in implementation of backup and recovery strategies.

- Having good Knowledge in Bulk Loading, Exception Handling, Dynamic SQL, Ref-Cursors.

- Working with collections and Records and reports.

- Basic knowledge in UNIX.

- Having working experience on MySQL.

Qualifications & Experience :

- B.E/B.Tech/MCA/M.Tech/M, SC

- 7+ Years of Experience