What are the responsibilities and job description for the Sr. Oracle PL/SQL Lead Developer position at StarTechs Inc.?
Job Details
Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.
Essential Duties/Responsibilities:
- Develop Oracle PL/SQL applications.
o 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.
o Work with Manager/IT Lead to understand requirements, create technical design, analyze source tables and relationships, adhere to consistent coding/SVN standards, and provide daily status updates.
o Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
o Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL/SQL code.
Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
o 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.
o Use analytics skills to troubleshoot and resolve problems quickly
o Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
o Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
o Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
o Follow SOX procedures for code deployment.
- Perform production support.
o Monitor batch processes daily/weekly/monthly and resolve job failures as soon as possible to meet established SLAs.
o Work with Control M/Redwood group on re-run/re-start instructions.
- Must be local to Houston or TX and be willing to come into the downtown office Monday, Tuesday, and Thursday of every week
Education:
Bachelor s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university.
Experience:
- 15 years of experience in Software development
- 12 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
- 12 years of experience in Oracle 12c or 19c
- 5 years of experience in a Data Warehouse environment
