Company:
INSPYR Solutions
Location: Houston
Closing Date: 30/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Role: Oracle PL/SQL Developer
Location: Houston, TX 77002
Job Location: Hybrid (Monday, Tuesday, and Thursday)
Work Authorization: US Citizen, Green Card, or Authorized to Work in the US
Must be local to Houston or TX and be willing to come into the downtown office Monday, Tuesday, and Thursday of every week
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.
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.
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.
Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
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
Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
Have code reviewed with IT lead prior to moving the code to QA environment
Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
Follow SOX procedures for code deployment.
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.
Work effectively in a team environment.
Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups.
Independently work on tasks without the need for step by step Supervision
Communicate progress or issues clearly either verbally or through email.
Escalate issues or delays that would impact deadline as early in the process as possible.
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
Strong Analytical skills
Troubleshooting skills
Strong Team Player
Additional skills:
Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must.
Our benefits package includes:
Comprehensive medical benefits
Competitive pay
401(k) retirement plan
…and much more!
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at (url removed).
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
Location: Houston, TX 77002
Job Location: Hybrid (Monday, Tuesday, and Thursday)
Work Authorization: US Citizen, Green Card, or Authorized to Work in the US
Must be local to Houston or TX and be willing to come into the downtown office Monday, Tuesday, and Thursday of every week
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.
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.
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.
Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
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
Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
Have code reviewed with IT lead prior to moving the code to QA environment
Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
Follow SOX procedures for code deployment.
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.
Work effectively in a team environment.
Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups.
Independently work on tasks without the need for step by step Supervision
Communicate progress or issues clearly either verbally or through email.
Escalate issues or delays that would impact deadline as early in the process as possible.
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
Strong Analytical skills
Troubleshooting skills
Strong Team Player
Additional skills:
Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must.
Our benefits package includes:
Comprehensive medical benefits
Competitive pay
401(k) retirement plan
…and much more!
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at (url removed).
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
Share this job
Useful Links