Oracle PL/SQL Developer (Batch Applications)

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

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

Duration: 8 month

Pay Rate: $50/hr-$65/hr (depending on experience)

Drug test and background check required

Job Description:

We are looking for Oracle PL/SQL Developers (batch applications). Project relates to these applications being used in retail commissions in the energy industry. These roles will work on a hybrid schedule and onsite required Mondays, Tuesdays, and Thursdays in Houston, TX.

Work will involve designing, developing, testing, maintaining, and supporting 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 Have Skills:

-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