Application Database Administrator

Job purpose: 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.

Key Accountability:

• Peak performance of the database from an application perspective
• Batch completes within SLA

2. Troubleshooting and resolving issues in a timely manner to ensure SLA is met at all times

3. Application related patch deployment, testing

4. Ensuring the least costly method of running the application

database

5. Ensuring optimal space utilization

6. Monitor performance and manage parameters to provide

fast responses to users.

7. carry out capacity planning

8. work closely with leads, developers.

9. communicate regularly with technical, applications and operational staff to ensure application database is working at an optimal level.10. work closely with the Database Administrator on application database related activities, Disaster Recovery (Simulation, Actual)

• Information Distribution

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

• Team Development

1. 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.

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

• Quality

1. Consistently deliver quality work with minimal application bugs and independently

• Delivery & Operations

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

Qualification

1. Application Database Administration

2. Analytical

Competencies

1. Logical thinking

2. Problem solving

3. Thinking out of the box

4. Adaptability

Job Types: Full-time, Permanent

Pay: RM9,000.00 - RM10,000.00 per month

Benefits:

• Dental insurance
• Health insurance

Schedule:

• Monday to Friday

Supplemental Pay:

• Performance bonus
• Yearly bonus

Experience:

• Oracle EBS: 5 years (Required)
• Oracle EBS Database 12c: 5 years (Required)
• Oracle SQL or equivalent: 5 years (Required)
• Shell Scripting: 3 years (Required)