Sign in

Oracle Application DBA / Oracle Database Administrator

Company:
Aspiree, Inc.
Location:
Cainta, Pasig, Philippines
Salary:
120,000
Posted:
November 06, 2018

Description:

ORACLE APPLICATIONS DBA

Responsibilities:

• Manages the Oracle e-business suite release 12.

• Execute the following activities:

o Database refresh to non-production DB

o Daily database health check monitoring, tuning and minor SQL reviews

o Capacity planning and execution

o Quarterly access review

o Database optimization

o Database security admin

o Deployments to production

o Performance test planning and execution

o Apply patches as mandated by project/vendor

o Monitor and fix table locking/blocking; monitor alerts and fix issues

o Creates, updates delete SSI packages and stored procedures

o Cloning Oracle applications using rapid clone

o Patching Oracle applications using adpatch

o Performing database upgrades, including upgrading Oracle applications from 11i to R12

o Setting up multi-tier Oracle Application environment

o Installing/upgrading/administering Oracle RAC databases

o Cloning databases from RAC to NON RAC

o Set up and administer ASM

o Back-up and recovery of Oracle databases using RMAN utility

o Unix Shell scripting/SQL/PL SQL

Qualifications:

• Experience as Oracle Application DBA

• Skilled in using Oracle e-Business Suite Release 12

• Bachelor’s Degree in Computer Science, Information Systems or equivalent

ORACLE DATABASE ADMINISTRATOR

Must Have Skills : Oracle Database Operations (with at least 2 years of experience)

Job Requirements :

• Experience in implementation, configurations and administration of Oracle database 10g, 11gR2 and 12C on different platforms

• Proficient with database backup/restore methodologies using RMAN, hot and Cold backups with point-in-time recovery

• Implement and maintain database security

• Experience on Logical backup using Data pump EXPDP and IMPDP

• Experience in database cloning using different approaches such as cold/hot style and RMAN duplication

• Experience in configuration of data guard with active dataguard and managing physical Logical Standby Databases

• Experience in database upgradations

• Experience in tablespaces management

• Experience in handling performance issues

• Experience in user and access management Routine checks of space utilization and adding space to database when its needed Planning, testing, tuning and efficiency of databases Experience on patching using Opatch utility.