Oracle PLSQL Developer

Oracle PL/SQL Developer Glen Allen VA 1 year

$69.50/hr w2 locals highly preferred

Its Client W2 role no C2C allowed

Job Description:
In this contingent resource assignment candidate may:

• Consult on complex initiatives with broad impact and largescale planning for Software Engineering.
• Review and analyze complex multifaceted larger scale or longerterm Software Engineering challenges that require indepth evaluation of multiple factors including intangibles or unprecedented factors.
• Contribute to the resolution of complex and multifaceted situations requiring solid understanding of the function policies procedures and compliance requirements that meet deliverables. Strategically collaborate and consult with client personnel.

Required Qualifications:

• Experience with large partitioned tables and query optimization.
• Ability to read write debug tune and maintain large complex queries including analytic and aggregation clauses.
• Experience with PL/SQL including Oracle Object types and Pipelined Table Functions.
• Familiarity with the Oracle privilege model and how to use PL/SQL procedures to enable specific privileged operations while restricting the privileges of the application user accounts.
• Experience with partition operations/maintenance including creating merging dropping and exchanging partitions.

Desired Qualifications:

• Excellent verbal written and interpersonal skills.
• Experience building and supporting large batch systems.
• Familiarity with DBMSPARALLELEXECUTE.
• Familiarity with partition based procedural parallelism.

Additional Skills:

• Experience with Unix scripting languages
• Ability to work hybrid work model of at least 3 days in the office and the remaining days remote.

prarallel,plsql