We provide IT Staff Augmentation Services!

Oracle Dba & Golden Gate Administrator Resume

WORK EXPERIENCE:

Confidential

Oracle DBA & Golden Gate Administrator

Responsibilities:

  • Coordinate various efforts in maintaining a vast environment of over 70 databases.
  • Successfully migrated databases from 9i - 10g and 10g-11g.
  • Implemented classic Golden gate replication as well as integrated replication.
  • Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
  • Recovered databases from corrupted/lost datafiles in realtime on production systems.
  • Configure Goldengate high availability using oracle DBFS and Active DataGuard.
  • Configure GoldenGate downstream mining and Integrated Component for active passive and active replication
  • Cloning of databases using RMAN using latest RMAN features.
  • Implementing backup scheme through RMAN.
  • Performance tuning of SQL's and procedures. This involved using trace dumps, TKPROF, Statspack, Net Trace. Also used specific Oracle performance parameters on a selected basis.
  • Installation, configuration and administration of Oracle RAC on Development boxes in 9i/10G.
  • Configured ASM on Windows on development boxes and recommended implementation on Production sites as a High Availability feature.
  • Implemented Data Guard on Production with Disaster-Recovery and Standby database modes.
  • Writing shell scripts for hot backup and setting up cron jobs to automate backup procedures, cleaning up of archives.
  • PL/SQL script with mapping and validation to insert / update data from one instance to other oracle Applications base tables using DB link.
  • Analysing and understanding the Specifications and Business Requirement documents.
  • Worked on SQL and PL/SQL which involves all the custom objects migration from 11.0.3 to R12.
  • Implemented audit features to locate culprit processes and unauthorized logins.
  • Setting up and maintaining Golden Gate on 10g databases.
  • Fixing of Trouble Reports related to functional changes and fine-tuning of sql scripts and releasing them as new patch release.
  • Opening SR with Oracle support on issues not readily solvable and critical to production.

Confidential, Atlanta

Oracle Database Administrator

Responsibilities:

  • Worked on many performance issues like sudden sql plan change due to different reasons like Bad
  • Histograms, Bind variables, functional indexes etc.
  • Support migration of data from stand - alone db to one centeral db.
  • Proactive monitoring of production databases to find out potential issues that can cause high severity issues and outages.
  • Support in new db designs and structures and fixing the design issues.
  • Support, Maintenance, Installed and configured 2 node server side load balancing Oracle RAC 10g, 11g databases on Linux with ASM and Data Guard.
  • Work directly with development and testing teams to perform load tests before every release.
  • Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
  • Creation and configuration of Oracle database of various sizes 200GB, 400 GB, 2TB and 6TB in Dev, test, Prod Model and Production environments.
  • Upgraded databases from 9i to 10g, 11g and 10g to different 10g versions.
  • Migration of databases using various ways like building a COB and import/export.
  • Implemented Golden gate to replicate data and keeping databases in sync until the time of cutover.
  • Implemented classic Golden gate replication as well as integrated replication.
  • Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
  • Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
  • Creating and Managing stored procedures and triggers, distributed data, server tuning, automation of administrative tasks, database.
  • Worked on Auditing and security with Oracle databases.
  • Created standby database and worked with data guard to provide high availability.
  • Monitor and Configured Oracle 10g databases using OEM

Confidential

Oracle Database Administrator

Responsibilities:

  • Serve as direct technical support liaison to 100+ users to ensure proper maintenance of workstations, printers and peripherals. Respond to user service requests and expediently resolve trouble tickets to maximize system uptime.
  • Install, configure and upgrade PC software and operating systems. Deploy new workstations and printers, installing operating systems, applications and drivers, and configuring network properties and hardware.
  • Provide remote help desk to troubleshoot, diagnose and resolve complex issues.
  • Support disaster recovery by performing regular backups and creating ghost images of workstations.
  • Provide general network, groupware, hardware and software support functions.
  • Maintain equipment and inventory tracking systems with respect to physical item transfers. .
  • Regulate the dispositioning and disposal of corporate and customer property consistent with stated contractual requirements, applicable regulations, corporate policies and procedures.

Hire Now