Job Description & Details
This contract role puts you right in the weeds of Oracle OFSC B2B applications, handling critical enhancements and production support. If you enjoy untangling complex database logic and keeping enterprise workflows humming without breaking a sweat, this gig will keep you busy in the best way possible.
What You'll Actually Be Doing
You will spend your days diving deep into application enhancements, custom code modifications, and squashing nasty production bugs. Expect to write heavy-duty PL/SQL, manage file-based batch integrations, and shepherd data processing workflows through system integration testing and user acceptance testing. When a core process slows to a crawl or a batch job fails overnight, you are the person expected to step in, debug the Unix shell scripts, and optimize the execution path.
The Core Tech Stack
Your bread and butter here will be Oracle Database SQL and PL/SQL—we are talking advanced packages, procedures, functions, triggers, and views where sub-second optimization actually matters. Because this revolves around Oracle OFSC B2B, you need to deeply understand how external system integrations and batch processing pipelines interface with the core platform. A solid grasp of Unix/Linux shell scripting is non-negotiable since you will be managing deployments and troubleshooting server-side anomalies.
Interview Expectations
When you jump on the call with the hiring manager, be ready to explain how you approach tuning a query that is dragging down production performance. They want to hear about your methodology for analyzing execution plans, indexing strategies, and isolating whether the bottleneck is in the PL/SQL block or the underlying database structure. They will likely also throw a real-world batch integration failure scenario at you to test your debugging instincts under pressure.
Application Advice
Do not just list keywords on your resume; spell out the exact scale of the OFSC B2B environments and Oracle databases you have supported in the past. Make sure phrases like 'PL/SQL performance tuning', 'batch processing interfaces', and 'Unix shell scripting' stand out prominently in your experience section to clear the automated filters and catch the eye of the technical lead.