"PL/SQL developer"

Overview

Remote
$50+
Contract - W2

Skills

UNIX CRON

Job Details

Experience in designing, developing, testing, and implementing complex database programs using Oracle PL/SQL, UNIX. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.
Experience in managing production support activities, debugging / fixing Oracle objects.
Experience in data mapping / conversion / transformation / integration activities according to third-party (vendor) requirements and integration of legacy applications/tools with the vendor tools.
Optimizing performance of existing Oracle code, Oracle queries, stored procedures, packages, functions using explain plan.
Development of UNIX Shell Scripts for loading Oracle tables from data files using SQL LOADER and automating UNIX scripts through UNIX CRON JOBS.
Experience in creating UNIT Test plans and working closely with QA teams and reviewing test plans.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.