Apply now »

Senior Oracle Apps Database

HQ

Job Details

Job Title:

Sr. Oracle Apps DBA

Section:

GFMIS

Functional Level:

Senior

Department:

GFMIS

Sector

GFMIS

Reporting Lines

Reporting Lines:

Reports directly to:

Oracle Apps. Database Sr. Manager

No. of subordinates:

0

Job Purpose

Provide the second line support and system planning, managing, and troubleshooting of all E-Business Suite systems and all database instances and perform benchmarking analysis to properly size hardware platforms, and maintain technical documentation relating to database management.

Job Responsibilities

  1. Install, configure and support for Oracle databases and Oracle E- Business System environments.
  2. Provide users with access to the required information when they need it and database is protected and that any chance of data loss is minimized.
  3. Setup, monitor, and maintain disaster recovery solutions for production databases.
  4. Manage database space and capacity strategy.
  5. Manage, coordinate and implements security measures and backup strategy.
  6. Review & tune complex SQL statements.
  7. Clone the E-Business Suite from RAC to RAC and RAC to Non-RAC environments.
  8. Assume ownership of database and E-Business suite related problems; pursue short and long-term problem resolution and root cause analysis.
  9. Collaborate with application and infrastructure teams to solve database level issues including availability and stability of the database environment.
  10. Work with vendors and internal support representatives to gather information, determine and implement resolutions.

.

  1. Proactively research and identify database level patches and upgrades.
  2. Provide advanced level technical support in 24x7 on call rotation.
  3. Maintain standard operating procedures specifically focused on stable E-Business environments.
  4. Develop and maintain shell scripts required for database and application monitoring and performance metrics.

KPIs (Key Performance Indicators)

  • Meeting OLAs / SLAs  35%
  • Application’s performance 30%
  • Client’s satisfaction 20%
  • Reporting 5%
  • Team members’ satisfaction. 5%
  • Team members’ performance 5%

Competency Model

Core Competencies

Level

  1. Working Strategically
  2. Customer Orientation
  3. Critical Thinking
  4. Agility 
  5. Innovation
  6. Leadership

2
2
2
2
2
1

Technical competency level

Technical Competencies

Level

  1. Oracle Database Tuning.
  2. knowledge of SQL/SQL.
  3. Unix/Linux Platforms.

I
I
I

Specifications: Qualifications, Experience, skills

Specifications (Qualifications, Experience and Skills):

Education                   

Specialization:

  • Bachelor’s Degree in Computer Science or equivalent experience.
  • Basic knowledge of Oracle Database Tuning.
  • knowledge of Tuning and security methods of the overall Oracle E-Business Suite System.
  • Knowledge of Database Backup and recovery using RMAN and logical backups.
  • knowledge of SQL/SQL.
  • Understanding of PL/SQL and stored procedures/pkgs.
  • Knowledge of Unix/Linux Platforms.
  • Working knowledge of Data Guard & Grid Control.

Experience                 

  • Minimum 3 years of relevant experience.

Conditions of Employment

  1. Days Off: 2 Days/Week
  2. PPEs / Health, Safety, and Environment requirements: No
  3. Working Environment: 98% standard office work & 2% out of office.
  4. Working Hours : From 9:00 AM till 5 PM.
  5. Working Days: 5 Days/week

Apply now »