Banner Image

All Services

Administrative & Secretarial

Production Oracle Database Admin (DBA)

$10/hr Starting at $200

• Experience in Oracle software installation, cloning, patching, and up gradation of oracle database. • Schema Management. • Monitoring space related issues of (data files, tablespaces, and Disk/Disk group). • Creating Database users and granting appropriate privilege. • Generating Reports (AWR/TKPROF/Explain Plan/Auto Trace/Sql Advisor/ADDM). • Creating and managing DB links for distributed database operation. • Design, Implementing and maintaining Backup policies using RMAN, Import/Export, hot/cold backup and data pump (EXPDP/IMPDP). • Having experience of RAC database • Installation, Configuration and Implementation of Data guard/Standby/RAC. • Having experience on DR Drills (switchover) from Primary Database to Physical Standby Database. • RAC Instance Monitoring • RAC Instance Startup/Shutdown • Good Knowledge of Oracle Cluster Registry (OCR) and Voting Disk • Good knowledge about global resource directory (GRD) • CRS manage with CRSCTL and server control utility (SRVCTL). • Monitoring ASM and database instance availability. • Monitoring the ASM disk group and adding the disk to the disk group when required. • Monitoring Information on all Golden Gate processes running on a system (Source/Target) • Monitoring processing volume &View processing rate in Oracle golden gate. • Having experience of Oracle Golden Gate Implementation and able to Configuring the Manager, extractor, replicator and data pump process, initial data load. • Knowledge about optimizer statistics, optimizer, query execution plan, Type of optimizer, optimizer, mode of initialization parameter. • SQL Tuning

About

$10/hr Ongoing

Download Resume

• Experience in Oracle software installation, cloning, patching, and up gradation of oracle database. • Schema Management. • Monitoring space related issues of (data files, tablespaces, and Disk/Disk group). • Creating Database users and granting appropriate privilege. • Generating Reports (AWR/TKPROF/Explain Plan/Auto Trace/Sql Advisor/ADDM). • Creating and managing DB links for distributed database operation. • Design, Implementing and maintaining Backup policies using RMAN, Import/Export, hot/cold backup and data pump (EXPDP/IMPDP). • Having experience of RAC database • Installation, Configuration and Implementation of Data guard/Standby/RAC. • Having experience on DR Drills (switchover) from Primary Database to Physical Standby Database. • RAC Instance Monitoring • RAC Instance Startup/Shutdown • Good Knowledge of Oracle Cluster Registry (OCR) and Voting Disk • Good knowledge about global resource directory (GRD) • CRS manage with CRSCTL and server control utility (SRVCTL). • Monitoring ASM and database instance availability. • Monitoring the ASM disk group and adding the disk to the disk group when required. • Monitoring Information on all Golden Gate processes running on a system (Source/Target) • Monitoring processing volume &View processing rate in Oracle golden gate. • Having experience of Oracle Golden Gate Implementation and able to Configuring the Manager, extractor, replicator and data pump process, initial data load. • Knowledge about optimizer statistics, optimizer, query execution plan, Type of optimizer, optimizer, mode of initialization parameter. • SQL Tuning

0 Reviews

This Freelancer has not received any feedback.