Oracle PL/SQL Developers

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 8 Month(s)

Skills

Acceptance Testing
Analytical Skill
Analytics
BMC Control-M
Database
Energy
Microsoft Windows
Oracle
PL/SQL
Performance Tuning
Production Support
Retail
SFTP
Scripting
Shell Scripting
Software Development
Stored Procedures
System Testing
Unit Testing
Unix

Job Details

Job Title: Oracle PL/SQL Developer (Batch Applications)

Location: Houston, TX (On-site 3 days per week: Monday, Tuesday, Thursday)

Duration: Through end of 2025

Our client has two open consulting roles for Oracle PL/SQL Developers (batch applications). These applications are used in retail commissions for our client in the energy industry. These roles will work on a hybrid schedule and onsite required Mondays, Tuesdays, and Thursdays in Houston, TX.

Work will include design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.

90% of the work is new PL/SQL development and 10% Unix shell scripting.

Essential Duties/Responsibilities:

  • Develop Oracle PL/SQL applications.
    • 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
    • Perform Unit testing and end to end System testing of the Oracle PL/SQL application. Prior to UAT submission test and compare the reports to Production calc. reports and identify and fix discrepancies.
    • Use analytics skills to troubleshoot and resolve problems quickly
    • Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
  • Perform production support.
    • Monitor batch processes daily/weekly/monthly and resolve job failures as soon as possible to meet established SLAs.
    • Work with ControlM/Redwood group on re-run/re-start instructions.
    • Be willing to perform this off hours during weekdays and weekends.
    • Fulfill ad-hoc requests for data pull, table updates or minor enhancements.

Must:

-Onsite in Houston Mon, Tue, and Thu

-15+ years of experience in Software development

-10+ years of 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

-Strong Analytical and Troubleshooting skills

-Batch applications expertise

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.

About Oxford Global Resources