Senior Oracle Apps Database
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
- Install, configure and support for Oracle databases and Oracle E- Business System environments.
- 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.
- Setup, monitor, and maintain disaster recovery solutions for production databases.
- Manage database space and capacity strategy.
- Manage, coordinate and implements security measures and backup strategy.
- Review & tune complex SQL statements.
- Clone the E-Business Suite from RAC to RAC and RAC to Non-RAC environments.
- Assume ownership of database and E-Business suite related problems; pursue short and long-term problem resolution and root cause analysis.
- Collaborate with application and infrastructure teams to solve database level issues including availability and stability of the database environment.
- Work with vendors and internal support representatives to gather information, determine and implement resolutions.
.
- Proactively research and identify database level patches and upgrades.
- Provide advanced level technical support in 24x7 on call rotation.
- Maintain standard operating procedures specifically focused on stable E-Business environments.
- 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 |
|
2 |
Technical competency level
|
Technical Competencies |
Level |
|
I |
Specifications: Qualifications, Experience, skills
|
Specifications (Qualifications, Experience and Skills): |
|
|
Education |
Specialization:
|
|
Experience |
|
Conditions of Employment
- Days Off: 2 Days/Week
- PPEs / Health, Safety, and Environment requirements: No
- Working Environment: 98% standard office work & 2% out of office.
- Working Hours : From 9:00 AM till 5 PM.
- Working Days: 5 Days/week