← Back to jobs

Ztek Consulting Inc Logo
PL/SQL Developer

Ztek Consulting Inc

 

Cary, NC, USA

Posted On: 13 days ago
Experience: 10+ years
Availability: Hybrid
Openings: 1
Category: PL/SQL Developer
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will manage and optimize large-scale Oracle database environments, focusing on performance tuning and data integrity.

This role is on-site.

Responsibilities

  • Manage large dataset cloning and partition management for complex database structures.
  • Implement table and index compression and defragmentation to maintain storage efficiency.
  • Execute bulk collection processes to improve data handling and query performance.
  • Utilize SQL*PLUS and Unix shell scripting for automated database tasks and maintenance.

Required Skills

  • 10+ years of experience in database development, specifically with Oracle.
  • Expertise in PL/SQL version 12c or higher.
  • Proficiency with Unix shell scripting and SQL*PLUS.
  • Hands-on experience with bulk collection techniques.
  • Experience with partition management and large dataset cloning.
  • Ability to perform table and index compression and defragmentation.
  • Graduate degree in any field.

Preferred Skills

  • Experience with AWR, execution plans, and query tuning.
  • Hands-on experience with Exadata.

Education

Any Gradute

Related Jobs

No related jobs found

← Back to jobs