Banner Image

All Services

Programming & Development

Oracle Database/Golden Gate Administrato

$5/hr Starting at $25

• With an experience of 6.9+ years in IT field currently I am working Wipro Technologies Company as Oracle Database Administrator and Golden Gate Admin. • Having good knowledge of Oracle Architecture (SGA, PGA and Background Process). • 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 more than 2.5+ years of 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 more than 3+ years of 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.

About

$5/hr Ongoing

Download Resume

• With an experience of 6.9+ years in IT field currently I am working Wipro Technologies Company as Oracle Database Administrator and Golden Gate Admin. • Having good knowledge of Oracle Architecture (SGA, PGA and Background Process). • 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 more than 2.5+ years of 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 more than 3+ years of 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.

Skills & Expertise

DesignImportManagementOracleOracle DatabaseProcessingReportsSoftware DesignSoftware InstallationSQLStatistics

0 Reviews

This Freelancer has not received any feedback.