An application database administrator (DBA) needs to ensure application related critical patches, database security patches are up to date.
Ensure the database performance is as expected, plan out housekeeping activities and execute them in a timely manner to prevent any disruption to the business due to lack of space or any other database issues.
Monitor the database performance during month end batch execution to ensure SLAs are met.
To advice the developers on any long running jobs and advice on any execution plans or tuning required.
To address database related issues if it impacts business users and to see it through to resolution, keeping track of the issue, resolution and prevention steps taken.
To work closely with the infrastructure team to ensure Vulnerability findings reported by Security are managed and addressed up to resolution.
Assist team members in providing support on issues faced by users for the General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), Financial Accounting Hub (FAH), application Database related issues, monitoring batch loads & ensuring system's stability for daily operation.
To provide support for Oracle Application Database and any new application database acquired.
Analyze and provide ideas & recommendations on system's enhancement / integration in relation to the performance/database/application.
Assist in preparing papers for users during budget planning and also for budget drawdown.
Job Requirements :
Graduate with experience in Oracle Enterprise Business Suite, Oracle SQL.
Possessed technical skill in Oracle EBS Database (12c, 19c and above), Oracle SQL and Shell Scripting.
