Overview
Remote
$50 - $60
Contract - W2
Skills
Production Support
Data Mapping
SQL
SQL*Loader
Scripting
Shell
Stored Procedures
Database
Debugging
Management
cron
Oracle
PL/SQL
Quality Assurance
Test Plans
Testing
Unit Testing
Unix
Job Details
Description
- 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.