Overview
Remote
Hybrid
$80,000 - $90,000
Contract - W2
Contract - 12 Month(s)
Able to Provide Sponsorship
Skills
Data Warehouse environment
Oracle 12c or 19c
Software development
OraclePL/SQLcode.
MERGE statements
Oracle Analytical functions
sFTP server
Job Details
PLSQL Developer 9+yrs exp W2 role ( Locals in TX pref & H1b Transfer)
Title: Senior PL/SQL Developer
Job Details
- Create Oracle PL/SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers, types, synonyms based on requirements. Create new applications or enhance existing applications to produce commissions reports.
- Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL/SQL code.
- Optimize code by following performance tuning techniques and coding standards established within the team.
- Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
Experience Must
- 10+ years of experience in Software development
- 10+ years of strong development experience using Oracle PL/SQL including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning
- 10+ years of experience in Oracle 12c or 19c
- 7+ years of experience in a Data Warehouse environment.
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.