Title : Oracle DBA and Oracle EBS

Duration : 12 Months

Location : Remote

End Client :: Not Revealed

Implementation Partner: IBM

JD:

S2RFSX: Responsible for diagnosing and resolving Oracle system administration related Incidents.-Coordinate with functional analysts / developers to perform technical trouble shooting-Handle alerts raised by alert monitoring system from application / database-Perform nightly monitoring of key Oracle EBS batch jobs using Avista batch monitoring tools-Patch Impact analysis, where patch needs to be applied.-On a monthly basis, and with Avista’s approval, up to four patches to be applied across production and two other non-production environments•-Perform database tuning, SQL tuning and monitor database performance to maintain system health.- Logical DB maintenance.-Work with Oracle Support by raising SRs on relevant issues-Assist developer(s) in database activities

S2RFSV: - Deep understanding and knowledge of Oracle projects module and its integrations with other modules in Oracle EBS.- Oracle Project Accounting & Project Costing moduels- Oracle projects and Oracle HRMS integrations- Oracle projects and Inventory integrations- Interfacing of Purchasing module, Payables module, Receivables with projects- Excellent understanding of Generate Cost, Cross charge and Budget Accounting Events and Create Accounting process for Subledger Accounting integration and transfer and post to General Ledger- Expenditures process flow: Labor Costs, Burden Costs, Lobour Costs adjustments- Budget baseline process flow, Burden for POs, AP Invoices- Period Close process and Exception reports to run to troubleshoot issues.