Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Washington, DC, United States
Posted
3 weeks ago
OraclePL/SQLSOAPSQLREST
Job Description
Job Summary
The Senior Oracle Technical Developer designs, develops, and supports custom components across Oracle E-Business Suite (EBS) R12 environments. Partnering with functional analysts and architects, you will deliver robust, scalable, and audit-compliant RICEW components, OIC integrations, custom PL/SQL packages, and workflows across Financials and Procurement modules.
Key Responsibilities
- Technical Design & Development: Build and maintain RICEW components, optimized PL/SQL packages, procedures, concurrent programs, and database staging-table frameworks.
- Integrations & Reporting: Develop Oracle Integration Cloud (OIC) pipelines, REST/SOAP APIs, scheduled interfaces, OTBI/BIP reports, and XML Publisher components.
- Architecture & Compliance: Ensure all custom code, forms, and workflows comply with EBS 12.2 online patching (ADOP) and Edition-Based Redefinition (EBR) standards; conduct deep SQL/PL/SQL performance tuning.
- Testing & Release Support: Create unit test plans, debug integration and API failures, and support integrated testing and regression cycles for quarterly patches.
- Production Support & Troubleshooting: Investigate and resolve batch failures, custom code errors, interface logs, and data discrepancies.
- Documentation: Collaborate with functional teams to translate requirements into detailed technical designs (MD70s) and maintain code migration trackers.
Qualifications & Requirements
Required Experience & Skills
- 8+ years of hands-on Oracle EBS technical development experience, with robust proficiency in R12.2.
- Deep expertise in PL/SQL, SQL tuning, Oracle Forms/Reports, OA Framework (OAF), and XML Publisher.
- Proven experience building and managing interfaces using OIC, Web Services (REST/SOAP), and FBDI/staging tables.
- Strong understanding of EBS Concurrent Processing, Workflows, and Application Object Library (AOL).
- Familiarity with EBS 12.2 online patching (ADOP) requirements for custom code development.
- Excellent analytical, troubleshooting, and documentation skills.
Similar jobs
- DR
Principal Full Stack Web Developer with Security Clearance
NewDraper
Saint Petersburg, FL🇺🇸$95k - $245k/yrHybridYesterdayDockerExpressGCP+17Technology - BO
Salesforce Developer with Security Clearance
NewBlu Omega LLC
Arlington, VA🇺🇸$70k - $125k/yrRemoteYesterdayAWSAgileGit+1Technology - DI
Junior ServiceNow Developer with Security Clearance
NewDirectViz, LLC
Alexandria, VA🇺🇸HybridYesterdayTechnology - DR
Senior Full Stack Web Developer with Security Clearance
NewDraper
Saint Petersburg, FL🇺🇸$82.3k - $220k/yrHybridYesterdayDockerGCPNode.js+16Technology - SC
Associate / Staff Python Developer with Security Clearance
NewSciTec, Inc.
Boulder, CO🇺🇸$88k - $107k/yrHybridYesterdayDockerFlaskMySQL+11Technology - GO
Sharepoint/Power Platform Developer
NewGovCIO
United States🇺🇸$110k - $125k/yrRemote6 hours agoPower BITechnology