Description

You will develop and maintain database solutions using Oracle PL/SQL.

Responsibilities

• Gather requirements, analyze, and design applications through all phases of the SDLC.
• Write complex SQL queries and PL/SQL procedures to extract data from source tables.
• Create database objects including tables, views, sequences, and indexes using Oracle tools.
• Optimize queries and troubleshoot performance issues using explain plans.
• Write scheduler jobs and support code migration between environments.

Required Skills

• 5+ years of experience in SDLC.
• Extensive experience with Oracle PL/SQL, including packages, stored procedures, and triggers.
• Strong proficiency in SQL and Dynamic SQL.
• Experience with Oracle RAC and Ref-Cursors.
• Proficiency in SQL*Plus, SQL Developer, or Toad for database object creation.
• Knowledge of data loading using SQL*Loader and various file formats.
• Experience with Materialized Views and PL/SQL Tables.
• Ability to troubleshoot and tune database performance.

Key Skills

Education

Any Graduate