Oracle Pl SQL Developer - Dublin, OH

Position ID: NAL-1408-11
Interview Type: Phone & Skype

Job Type: Contract 

Responsibilities:

• Oracle 11g/10g/9i Database Enterprise Edition
• SQL *Loader, SQL *Plus
• Programming ORACLE PL/SQL 11g/10g/9i
• Third Party Tools PL/SQL Developer,TOAD 8.6
• Windows batch scripting 

Required Skills:

• Good understanding of database objects and ability to triage issues.
• Design, develop and modify tables, views, materialized view, stored procedures, packages functions and triggers.
• Code PL-SQL package and procedures to perform data loading, error handling and system statistics. 
• SQL Loader to load the data from the files provided by other application
• Create new procedures, functions, triggers, Materialized views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions.
• Create external tables to handle huge volumes of data which is not used frequently.
• Optimized SQL Statements and PL/SQL Blocks by analyzing the execute plans of SQL Statement and modified triggers, SQL queries, stored procedures for performance improvement.
• Develop various back end application programs, such as views, functions, triggers, procedures and packages using SQL and PL/SQL Language.
• PL/SQL code review and modification for the development of new requirements.
• Window batch scripting

Interested candidates can send resumes to jobs@nallas.com with position ID in subject line