*VACANCY FOR THE POST OF PLSQL DEVELOPERS*  

1. Position:   PLSQL Developers (Manager Role – Project Lead[IIRM])

2. Experience :   5 Years of experience

3. Qualifications :

• Experience in Oracle SQL & PLSQL Development.
  Procedures, Functions, Triggers, Cursors and Packages.
  
  
• Good exposure to writing dynamic functions, procedures, and packages.
  Worked with Tools like SQL*Plus and SQL Developer.
  
  
• Version control systems like SVN Git
  
  
• Expertise in Dynamic SQL, Collections, cursors, Exception handling.
  
  
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  
  

4. Male/Female :  Both

5. Age range :  N/A

6. Salary range : Up to <12 LPA (INR)

7. Work Locations : Colombo 02

8. Working Days : Mon - Fri

9. Industry : Manufacturing

10. Job role :

Responsibilities:
1. Having experience in Oracle SQL & PLSQL Development.
2. Experience in developing Procedures, Functions, Triggers, Cursors and Packages.
3. Experience in using advanced features like BULKCOLLECT, FORALL and Ref cursors.
4. Good exposure to SQL queries and handling Exceptions in PLSQL.
5. Good exposure to writing dynamic functions, procedures and packages.
6. Worked with Tools like SQL*Plus and SQL Developer.
7. Expertise in Dynamic SQL, Collections, cursors, Exception handling.
8. Experience in stored procedures, functions and packages as per the business Requirement. Loaded external files Data into Oracle Tables using SQL Loader.
9. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and optimize procedures and packages.
10. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
11. Development experience of materialized views for data replication in distributed environments.
12. Good to have: Knowledge Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management.

Send your CV : sales11@diligroup.com

Contact: 0759338807