Source description
About the role
We are looking for an Oracle Apps Technical with SQL / PLSQL and DBA knowledge expertise. Job Description Details: - Looking for Candidates with high level of proficiency of implementation using SQL and PL/SQL related technologies on Oracle Database as a PLSQL Developer. - 610 years of experience in Oracle EBS and/or Oracle ERP Cloud. - Strong command of SQL and PL/SQL, with proven experience in writing complex queries and procedures. - Should be knowledgeable and experienced in SCM and/or Order to Cash Modules, SCM tables / packages and technical details. - Familiarity with Oracle Cloud tools such as OTBI, FBDI, and ADF is a plus. - Ability to work independently and manage multiple priorities in a fast-paced environment. - Collaborate with business users and functional teams to gather requirements and translate them into technical solutions. - Provide techno-functional support for Oracle EBS (R12) and Oracle ERP Cloud modules, especially in SCM, Inventory, and Finance. - Analyze and troubleshoot issues related to Oracle applications, including performance tuning and data integrity. - Strong knowledge of Oracle Applications architecture. - Must have strong experience on CURSORS, STORED PROCEDURES, PACKAGES, FUNCTIONS AND TRIGGERS - Should have extensive knowledge of Oracle database and PL/SQL programming, Performance tuning Using HINTS, table partitions, Indexing. - Must have worked on Dynamic SQL, Collections and BULK COLLECT. - Should have Knowledge Oracle prebuilt Packages of PL/SQL. - Proficient in writing Complex SQL Queries. - Must have Excellent Communication Skills - Technical understanding of various E-Business Suite modules such as (Financials, Receivables / Payables /GL) WMS (Warehouse Mgmt System) SOA Gateway). - Very good understanding of Oracle core database architecture and concepts - Knowledge on Concurrent managers in Oracle EBS and robust AOL concepts. .