Description

You will develop and optimize database logic using advanced PL/SQL techniques.

Responsibilities

• Write and maintain PL/SQL stored procedures, functions, packages, sequences, and triggers.
• Implement advanced PL/SQL concepts including table functions, collections, and analytical functions.
• Manage database objects such as indexes, materialized views, and table partitioning.
• Perform SQL performance tuning using Cost-Based Optimization and query re-write techniques.

Required Skills

• Extensive experience writing PL/SQL stored procedures, functions, and packages.
• Proficiency with SQL Developer.
• Expertise in table functions, collections, and analytical functions.
• Experience with table partitioning and materialized views.
• Strong knowledge of logical and physical data modeling and normalization.
• Proven ability in SQL performance tuning and Cost-Based Optimization.
• Experience with .NET development.

Preferred Skills

• Degree in any field of study.

Key Skills

Education

Any graduate