SUMMARY

• Over 7 + years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like pharmaceutical, Finance, and Insurance industries.
• Hands on experience onOracle(8i/9i/10g RAC/11g RAC)databaseadministration, schema implementation, backup, recovery, cloning, performance monitoring and tuning on different platforms like Windows, Unix /Linux (IBM AIX, Sun Solaris, HP - UX).
• Experienced in maintaining databases on large Production environments.
• Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of thedatabase.
• Experience in Installation and administrations ofOracle10g RAC, 11g RAC.
• Implemented Dataguard and configured both the physical and logical standbydatabasein the production environments.
• Also responsible for well functioning of thedatabaseby Checking and Applying Patch set and Interim patches, Upgradations there by making thedatabasesoftware up-to-date. Upgraded databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Worked extensively onOracleMigrations. Migrateddatabasefrom Windows to Linux, HP-UX to AIX.
• Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & AutomaticDatabaseDiagnostic Manager (ADDM).
• Monitoring and optimizing the performance of thedatabasethroughDatabaseTuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Developeddatabasemonitoring/health check alert scripts
• Experience in using OEM/Grid Control
• Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in taking backup and performing recovery.
• Experience in performing point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Implemented data transfer using Data Pump, Export/Import utilities.
• Experience in Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
• Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
• ConfiguredOracleon different Operating Systems for OLTP & Data Warehousing environments.
• Experienced in loading data from flat files intodatabasetables using SQL*Loader, ETL Tools and External Tables.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call productiondatabasesupport.

WORK EXPERIENCE

OracleDBA

Confidential, Charlotte, NC

Responsibilities:

• Implementation and support of 11g migrations and upgrades fromOracle10g toOracle11g databases including RAC databases on HP - UX and Linux.
• Installation, configuration and support ofOracleRAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
• PerformedDatabaseRefresh from Production to QA, UAT and Development databases.
• Implemented 11G Data Guard Physical and Logical Standby using DG Broker, experienced with 11G Data Guard new features Active Dataguard and Snapshot Standby.
• Implemented backup/recover strategies using Hot backup, Cold backups, RMAN and Export/Import utilitites.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Experienced in installing Golden gate replication and developing monitoring scripts for extracts, replicates and pumps.
• Experienced working on Golden gate replication issues like extract/pump abends and resolved them affectively.
• Extensive use ofOracleData pumps Exp/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries anddatabasesystems.
• Usedoracleconfiguration assistants like DBCA(DatabaseConfiguration Assistant) for Creating databases, DBUA(DatabaseUpgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, tnsnames etc.,
• Performed Replication setup between 2 Node RAC ASM Databases and 3 Node Databases.
• Performeddatabasemigration from SQL toOracleplatforms.
• Creating and managingdatabaseobjects such as tables, indexes, partition tables, views, rebuilding indexes and optimizing the code to improve the performance.
• PerformedDatabaseupgrades from 10.2.0.4 to 11.2.0.4.
• Implemented Shell scripting for managing day-to-day activities and automation of backups and replication.
• ManagingDatabaseLocks and blocking sessions. Defragmentation of tables an indexes for improve performance and efficient.
• Performed daily backup jobs, cleanup jobs using Autosys job setup.
• Implemented Materialiazed views,databaselinks on 11g Environments.
• Tablespace Monitioring, Performance monitoring and tuining for performance improment using OEM monitoring tool.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reoraganized tables and indexes within databases when needed.

Environment:Oracle10/11g, 11g RAC,OracleEnterprise Management(OEM),OracleGolden Gate, RMAN Data Guard 11g Active Data Guard, Toad 10.6, DBArtisian 9.0.1, HP-UX 11.31, Linux 6.5, Solaris, ASM, OEM Grid Control 11.x

OracleDBA

Confidential, Permanente, CA

Responsibilities:

• 24x7 productiondatabaseand applications support
• Installation, configuration and maintenance ofOracle10g and 11g databases.
• Implementation multi node RAC onOracle10g andOracle11g.
• Involved in construction of DR sites for all the Production databases.
• Experienced in a multi - platform environment supporting varying databases of 40+ TBs.
• PerformedDatabaseRefresh from Production to QA, UAT and Development databases.
• Upgraded theOracle10gdatabaseto 11g version and also applied patch set and interim patches whenever required to make thedatabasesoftware up to date.
• Monitoring Day-Day Backups, Log's.
• Successfully implemented Backup & Recovery using RMAN, Conventional Hot and Cold backups.
• Managing backup strategy for all production databases.
• Taking the RMAN incremental (Differential & Cumulative) backups.
• Extensive experience in recovery.
• Cloning of Databases from Production to Development and Test.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Installed GoldenGate, upgraded from 10 to 10.4
• UtilizedOracleStreams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Implemented DRP (Disaster recovery plan) for critical databases.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, TKPROF, AWR and ADDM.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Createddatabaseobjects like Tables, Indexes, Views, and DB Links etc.
• Responsible for capacity planning,databasesecurity, recovery planning and installing patches
• Setup and implementation ofOracleFinancial Analyzer.
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment:Oracle9i/10gR2 RAC/11g R2 RAC, Red Hat LINUX, Solaris 10, HP-UX, Windows 2003, MS, SQL Server 2000/2005/2008, OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL, OID (LDAP), SSO, DB2.

OracleDBA

Confidential, Milwaukee, WI

Responsibilities:

• 24*7 ProductionDatabaseAdministration Support
• Installation, configuration and support ofOracleRAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
• Cloned/RefreshedOracleDatabases for development and testing
• Upgraded databases fromOracle9i to 10g,Oracle10g to 11g.
• Experienced in a multi - platform environment supporting varying databases of 20+ TBs
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Involved in construction of DR sites for all the Production environments.
• PerformedDatabaseRefresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physicaldatabasedesign (tablespaces, datafiles, extents, redo logs, archive logs) and assesseddatabasecapacity by monitoring online storage, growth and file system space.
• Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Backup and recovery, Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
• Monitoring Day-Day Backups, Log's.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental Backups, Differential, and Cumulative Backups).
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Databasecloning for development, testing from production
• Responsible for capacity planning,databasesecurity, recovery planning and installing patches
• Writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Installed and configured Golden Gate
• Replication using Materialized Views,OracleStreams and Golden Gate.
• Partitioned large tables for better performance and manageability
• Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
• Experience in LogicalDatabaseDesign, PhysicalDatabasedesign

Environment:Oracle11g RAC/10g RAC/Oracle9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Sybase, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF EXPLAIN PLAN, AWR

OracleDBA

Confidential, Irving, TX

Responsibilities:

• 24x7 productiondatabaseand applications support
• Installed and ConfiguredOracle10g RAC and 11g RAC databases
• UpgradedOracledatabases from 9i to 10g and 10g to 11g version.
• Maintenance of around 200 databases combined on all the production, development and testing environments.
• ConfiguredOracleStandby Databases (Dataguard) forOracleDisaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring theOracleenvironment by creating databases, storage structures and objects,databasebackup and recovery, monitoring and optimizingdatabaseperformance.
• ImplementedOracledatabasebackup & recovery solutions.
• Extensive use ofOracleData pumps Exp/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries anddatabasesystems.
• Created User accounts, Roles and granting required access permissions and privileges to thedatabasebased on the applications they are accessing.
• Configured and implementedOracleStreams.
• Performed Schema as well as Table level Replication usingOracleStreams.
• Implemented downstream capture at the destinationdatabaseusingOracleStreams.
• Responsible in configuring and backing updatabaseusing Hot backups, Cold backups, Logical backups and RMAN incremental backups
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written PL/SQL functions, stored procedures, packages and triggers
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery.
• Usedoracleconfiguration assistants like DBCA(DatabaseConfiguration Assistant) for Creating databases, DBUA(DatabaseUpgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client - Server environment using Listener, tnsnames etc.,
• Used AutomaticDatabaseDiagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoringdatabaseperformance.
• Testeddatabaseperformance issues (monitoring and tuning) to ensuredatabaseoptimization.
• Performed administrative maintenance, monitoring onOracledatabasesystems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth ofdatabasesize by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment:Oracle11g/10g,Oracle11g RAC,Oracle10g RAC, Dataguard, RedHat Linux, HP-UX, Sun Solaris, IBM AIX, Windows, Sybase, TOAD, Grid Control, ERWIN, SQL, PL/SQL.

OracleDBA

Confidential

Responsibilities:

• Installation and configuration ofOracle9i, 10g software
• Installed and configuredOracle10g RAC
• Upgraded databases from 8i to 9i, 8i, 9i to 10g. Applied CPU and PSU patches
• Adjusted data models when necessary under direction of data architects.
• ImplementedOracleDataguard in order to achieve the high availability of thedatabaseby maintaining the Standbydatabase.
• Used Recovery Manager (RMAN) and Created recovery catalog on separate server.
• Responsible for backups and recoveries
• Assured Daily Backups and Archiving were done accurately and consistently.
• Implemented and maintainedDatabasesecurity.
• Created / Altered / Dropped Users as and when required and administer their respective quotas and profiles.
• Cloned thedatabaseusing RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery
• Restoration of dropped tables using Flashback technology.
• CreatedDatabaseLinks and Snapshots (Materialized views).
• Performed Hot Backups and maintaineddatabaseavailability to support non - stop Business operations.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Knowledge in Data warehousing and implementation and supported asOracleDatabaseadministratorin Data warehouse projects.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.

Environment:Oracle10g/9i/8i,Oracle10g RAC, Dataguard, RedHat Linux, Sun Solaris, TOAD, Grid Control, ERWIN, SQL, PL/SQL., SQL*LOADER