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.