PART 2: JOB PURPOSE

It is a form of 2 or 3 sentences that sums up what the job is basically about and should

justify the existence of the job. It should clarify three things: a) What the job should do?;

b) To whom or what it should be done? and; c) How it supports the business?

Personnel’s responsibility as an application database administrator (DBA) will be 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. To monitor the database performance during month end batch execution to

ensure SLA’s 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. To manage/assist during DR

activities for the supported application. To provide updates in a timely manner.

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.

Ensure project deliverables to users within the stipulated timeline.

Assist in preparing papers for users during budget planning and also for budget drawdown.

PART 3: KEY ACCOUNTABILITIES & OUTCOMES

It pertains to what are the main areas in which a job must achieve end-results to achieve

the purpose. Maximum of 8 Key Accountabilities only.

Principal Accountabilities

Describe the key activities that you are expected to achieve. Start with the most

important

Outcomes/ deliverables targeted

Major Challenges in achieving the outputs

Accountability

Supporting

Activities

Outcome/ deliverables

Challenges

Peak performance of the database from an application perspective

Meeting Business User’s SLA.

Batch completes within SLA
Troubleshooting and resolving issues in a timely manner to ensure SLA is met at all times
Application related patch deployment, testing
Ensuring the least costly method of running the application database
Ensuring optimal space utilization
Monitor performance
Understanding the batch complexities (dependencies) and SLAs
Understanding user requirements from a business perspective.
Managing people.
Document management.
Scope of

testing, all

and manage parameters to provide fast responses to users

carry out capacity planning
work closely with leads, developers,
communicate regularly with technical, applications and operational staff to ensure application database is working at an optimal level
work closely with the Database Administrator on application database related activities,

Disaster Recovery (Simulation, Actual)

scenario was not fully covered during the testing.

Information Distribution

Share information with supervisors , team member on a timely basis via email or during discussion.

Ability to articulate what was understood to the team in order to ensure there is a backup available.

Team Development

Encourages teamwork among team members on a continuous basis throughout any activity assigned. Training and/or coaching performed to enhance the technical competency and skills of fellow team members.

b) Coach juniors (Band I's) with tangible results of improved productivity

Aligning the team and dealing with team members who may have different opinions.

Quality

Consistently deliver quality work with minimal application bugs and independently

Ensuring consistent

quality during peak times where multiple requests come in at the same time.

Delivery & Operations

Lead in formulating an operational or tactical plan for a small to mid size team to address a mid or complex problem

Aligning the team as well as keeping them engaged throughout the activity.

PART 4: EDUCATION, EXPERIENCE, CERTIFICATIONS, SPECIFIC SKILLS & COMPETENCIES

State the acceptable requirement for the job in terms of education, professional

experience, certifications and job specific skills & competencies for satisfactory performance of the job.

EDUCATION

Key-in the required educational background / level required for the Job

Graduate with experience in Oracle Enterprise Business Suite, Oracle SQL.

Minimum 5 year experience.

EXPERIENCE

Key-in the required experience/s for the job and specific number of years (if any)

< 3yrs

3-5yr

6-10yrs

10yrs

Oracle EBS Database 12c, 19c and above

< 3yrs

3-5yrs

6-10yrs

10yrs

Oracle SQL or equivalent

< 3yrs

3-5yrs

6-10yrs

10yrs

Shell Scripting

CERTIFICATIONS/REGULATORY CERTIFICATIONS

Key-in any certification/s required for the job (if any)

Optional – Oracle Certification

JOB SPECIFIC SKILLS & COMPETENCIES REQUIRED

Key-in (if any) Job Specific Skills and Competencies required not mentioned in the Skills Family Competency Framework.

Qualification

Application Database Administration
Analytical

Competencies

Logical thinking
Problem solving
Thinking out of the box
Adaptability