Browse
Employers / Recruiters
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
Role: Senior Oracle PL/SQL Developer
Location: Houston, TX 77002
HYBRID 1-2 DAYS IN OFFICE
Work Authorization: US Citizen or Green Card Holders ONLY

Qualified candidates should send an updated, Word version of their resume to Cara Mason at CMason@inspyrsolutions.com.


Job Description:
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.
  • Code packages, stored procedures, functions, objects, tables, views, synonyms based on requirements. Understand functionality of existing applications and either incorporate new functionality to automate the calculations process or build new applications for the calculations process.
  • Work with IT Technical Lead to understand requirements/technical design, understand the source tables and relationships, adhere to consistent coding/SVN standards, do code reviews, 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, oracle partitioning, job logging, exception handling, performance tuning and so on in the Oracle PL/SQL code.
  • Optimize code by following performance tuning techniques considering limitations of current environment.
  • Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code. 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 Technical 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 quickly as possible.
  • 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 pulls, 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 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.
  • Work in an office environment twice a week
Education:
  • Bachelors degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.
Experience:
  • 15+ years of experience in Software development
  • 12+ years of experience in Oracle 12c or 19c
  • 12+ years of experience in Oracle PL/SQL development including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning
  • 3+ years of experience in a Data Warehouse environment
Our benefits package includes: 
  • Comprehensive medical benefits
  • Competitive pay, 401(k)
  • Retirement plan
  • …and much more! 
About INSPYR Solutions:
As a leading information technology partner, we connect top IT talent with our clients to provide innovative business solutions through our IT Staffing, Professional Services, and Infrastructure Solutions divisions. We understand and value the unique needs of highly-skilled information technology professionals in the industry and always strive to stay above the curve. Our company was founded on the following core values: Be the Best, Understand the Urgency, Never Ever Give Up, Have the Courage to Excel, and Make a Contribution. We take pride in our business model and strive to create a positive workplace environment through an exemplary culture.
 
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 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

  •

Last updated on Nov 16, 2023

See more

More jobs at icjdnwgi8i2v6ws8hm4k26gwwozs8k0120mqwy37s7qipwgifho37syov497b8ia

Analyzing

Medley, Florida

 · 

30+ days ago

Los Angeles, California

 · 

30+ days ago

Grapevine, Texas

 · 

30+ days ago

Appleton, Wisconsin

 · 

30+ days ago

Columbia, Maryland

 · 

30+ days ago

More jobs like this

Analyzing

Rensselaer, New York

 · 

30+ days ago

Java lead
R
rqjdnwbs34lmixfu3kkfd08vmgygir029fesnaptym1rbs1iivifcavlyk16brnc

San Francisco, California

 · 

30+ days ago

Burlingame, California

 · 

30+ days ago

Java Developer
C
crjdnwsnowo2i4nz45b1teboszrxlg0351vr73gpqw7yanury9u287prckhdnkww

Wilmington, Delaware

 · 

30+ days ago

Lee's Summit, Missouri

 · 

30+ days ago

Lee's Summit, Missouri

 · 

30+ days ago

Remote

 · 

30+ days ago

San Mateo, California

 · 

30+ days ago

Boston, Massachusetts

 · 

30+ days ago

Remote

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status