Oracle PL/SQL Developer (Hybrid)

Description

Oracle PL/SQL Developer

Charlotte, NC

Hybrid

Position Summary:

Looking for a strong hands-on exp on Oracle PL/SQL programming with performance tuning knowledge.

Responsibilities

• Hands-on experience in designing and developing complex solutions using Oracle.
• Hands-on experience with Oracle 12c/19c or later versions of Oracle.
• Hands-on experience with SQL Developer or similar development tools.
• Proficient in writing complex SQLs and generation of reports. Oracle Keys and Constraints,
• Strong experience in Oracle PL/SQL programming. Collections - Nested Tables
• Strong experience in performance tuning and developing high volume data loads. Should be strong with Exception Handling
• Must have experience in table/index partitioning and data purging techniques.
• Extensive experience in data loading techniques, SQL Loader.
• Possess basic DBA knowledge and manage DB space across databases.
• Performance Tuning and Analyze and study AWR and TKPROF reports.

Required Qualifications

• Hands-on experience in designing and developing complex solutions using Oracle.
• Hands-on experience with Oracle 12c/19c or later versions of Oracle.
• Hands-on experience with SQL Developer or similar development tools.
• Proficient in writing complex SQLs and generation of reports. Oracle Keys and Constraints,
• Strong experience in Oracle PL/SQL programming. Collections - Nested Tables
• Strong experience in performance tuning and developing high volume data loads. Should be strong with Exception Handling
• Must have experience in table/index partitioning and data purging techniques.
• Extensive experience in data loading techniques, SQL Loader.
• Possess basic DBA knowledge and manage DB space across databases.
• Performance Tuning and Analyze and study AWR and TKPROF reports.

Preferred Qualifications

• Hands-on experience in designing and developing complex solutions using Oracle.
• Hands-on experience with Oracle 12c/19c or later versions of Oracle.
• Hands-on experience with SQL Developer or similar development tools.
• Proficient in writing complex SQLs and generation of reports. Oracle Keys and Constraints,
• Strong experience in Oracle PL/SQL programming. Collections - Nested Tables
• Strong experience in performance tuning and developing high volume data loads. Should be strong with Exception Handling
• Must have experience in table/index partitioning and data purging techniques.
• Extensive experience in data loading techniques, SQL Loader.
• Possess basic DBA knowledge and manage DB space across databases.
• Performance Tuning and Analyze and study AWR and TKPROF reports.

Qualifications

Technical Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 Database and SQL PL3 Required 2 Oracle Reports PL3 Desired 3 Oracle Forms PL3 Desired 4 Oracle PL3 Required 5 PL/SQL PL2 Required

* Proficiency Legends

Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.