Oracle EBS Technical Consultant

Technical Design & DevelopmentDevelop and maintain RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) consistent with internal technical design standards.Build and optimize PL/SQL programs, including custom packages, procedures, views, and database objectsImplement and support concurrent programs, validations, and staging-table frameworks for inbound/outbound integrations.Support OIC integrations, file-based data pipelines, schedulers, REST/SOAP integrations, and error-handling frameworks consistent with OIC patterns.Create OTBI/BIP reports and EBS XML Publisher components.Technical Architecture & StandardsEnsure compliance with EBS 12.2 online patching (ADOP) requirements and coding standards.Conduct performance tuning of SQL, PL/SQL, workflows, and interface programs.Maintain custom objects in line with technical governance processes and RICEW development life cycle.Adhere to internal environment, migration, and deployment standards.Testing & Release SupportBuild unit test plans, conditions, and test data based on technical specification patterns.Perform debugging and root-cause analysis across interfaces, APIs, custom objects, and workflows.Support integrated testing, regression cycles, and release validation for quarterly patches and ERP upgrades.Production SupportInvestigate and resolve technical issues involving custom code, integrations, concurrent programs, and database performance.Analyze staging-table errors, interface failures, and OIC orchestration logs following the enterprise error-handling framework.Provide on-call support for batch failures, data corrections, and system performance issues.Collaboration & DocumentationWork with functional teams to validate requirements and translate them into detailed technical designs and MD70 documents.Provide impact analysis for patches, customizations, SLA changes, table updates, and integrations.Maintain code documentation, configuration files, and migration trackers consistent with internal TDD expectations.EEO Employer LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.