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

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.