Oracle DBA

ORACLE DBA

DURATION: 6 months (Possible Extension)

LOCATION: Helsinki, Finland

JOB DESCRIPTION:

o Installation Pre-requisites
o Kernel Parameters
o Database Cloning
o Initialization Parameters
o Backup and Recovery Strategies* C23
o Flash Recovery Features & Flash back query
o Managing Alerts and Notifications
o Black-out Administration
o Cross platform transportable Tablespaces
o Oracle RAC (Real Application Clusters)*
o Knowledge of Advanced Replication*
o Planning and scheduling Backups, Database Recovery, taking Logical Backups & Physical Backups.
o Hands on experience of Recovery scenarios.
o Experience in cloning using cold backup, hot-backup and RMAN backup.
o Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump.
o Upgrading and applying security patches to the databases.
o Experience in Capacity Planning, Space Management, Database Upgrades/Migration Data Extraction.
o Hands on experience of configuration & administration of Oracle High Availability Solutions.
o Good Working experience of Installation & administration of RAC 9i, 10g (Real Application Clusters).
o Having experience of DR setup through various synch methods.
o Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage.
o Experience in Performance Tuning and Monitoring using various tools such as Statspack, TKPROF, SQL Trace and Explain Plan.
o Good knowledge of 10g features as OEM, Data Pump, ASM and Flash back recovery.
o Support to team members for any database related issue
o Designing strategy towards Capacity Management for DB tracks.
o Experience in oracle migraiton, consloidation projects