SUMMARY:

• Over 8+ Years of experience in Oracle DBA with proficiency in GoldenGate, RAC, RMAN and Data guard.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM - AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transitive and Very large databases (VLDB) and mission critical large OLTP, OLAP systems.
• Experience in configuring and managing Oracle Real Application Cluster databases with ASM technology.
• Installed and Configured the GoldenGate software and created manager, extract, replicate trail files and tested the data is flowing from source to target database.
• Technical expertise in Oracle DB implementations, maintenance, trouble shooting and administration.
• Excellent experience in Installation and configuration of Oracle 12c,11g, 10g, 9i, in UNIX/RHEL, Sun Solaris, AIX and Windows environment.
• Implementation and Administration of Oracle Data guard.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Upgraded Databases from to 10g, 10gto 11gand 11g to 12c on various platforms.
• Established standby/cloned production database via Data Guard for Database Disaster Recovery
• Configuring and Administering Oracle 10g Automatic Storage Management (ASM).
• Working knowledge in Oracle GRID control (Oracle Enterprise Manager).
• Experience in applying Oracle PSU, CPU Patches on 9i, 10G and 11G.
• Experience in Patching Grid Infrastructure home.
• Experience includes Reorganization of database, monitoring tablespaces, indexes, extents and performance tuning.
• Exposure of working on OEM and Strong in Database Backups using RMAN, Export/Import, and Data pump, SQL Loader.
• Backup, Recovery and Cloning of databases using RMAN also profound in using the new Oracle 11g features in these utilities.
• Strong Experience in Cloning of databases using RMAN, VERITAS Net Backup.
• Creating and maintaining user accounts/profiles as well as well as managing security like Roles, Privileges and Passwords.
• Carried out logical backups using full/ partial export/import and Data Pump.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• OracleExadataAdministrator(MaintenancesofExadataSystem,installingExadata software offline androllingmode,bundlepatching,performancetuning,exacheck processes, migration to Exadata (RMANRestore,switchover,databroker,export/import dump,transportabletablespaces).
• Creating multiple Listeners for load balancing and using LSNRCTL to Manage Listeners.
• Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
• Worked on 24/7 environments, responsible for monitoring, upgrading, configuring, managing and troubling shooting over 300 oracle 10g and 11g databases.

PROFESSIONAL EXPERIENCE

Confidential, Florida

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle database 11g RAC Databases using Oracle Clusterware for achieving high Availability.
• Configured & Installed Oracle RAC One Node databases and have experience working on moving Oracle ONE NODE RAC instance from one node to another (Instance Relocation) Using OMOTION Utility.
• Configured Oracle Restart feature to automatically restart the database, the listener, and Other Oracle components for sudden hardware or software failures.
• Implemented Active Data Guard, creating both Logical and Physical Standby databases in 10g, 11g RAC & 12c environment for the Production databases.
• Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.
• Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.
• Cloning/duplicate of database with RMAN and user managed (hot/cold) backups.
• Migration of databases to Oracle 11g from Oracle 9i & 10g on AIX to Linux using RMAN.
• Migration of databases to 12c from Oracle 10g & 11g.
• Experience in patching RAC databases in rolling fashion to maintain high availability.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail over purposes.
• Migrating the databases from non Exadata environments to Exadata environments using Data Guard switchover.
• Manage Oracle RAC database configurations using GoldenGate and Data Guard to ensure maximum availability and data protection.
• Install, Configure and support Uni directional and bi directional Oracle to Oracle replicated environments utilizing GoldenGate.
• Installed and implemented GoldenGate to replicate data between databases.
• Configure and build heartbeat monitoring in GoldenGate.
• Identified and produced necessary documentation of best practices for GoldenGate.
• Implemented necessary monitoring scripts for GoldenGate in unix/perl scripting.
• Used Oracle’s Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.
• Helping other DBAs in RAC, standalone installation of databases with ASM.
• Performed cross Platform 11g database Migrations from AIX to linux platforms.
• Monitored the RAC database using OEM 12c Cloud control configured with RMAN database backup and recovery.
• Development of shell scripts, scheduling the jobs using Autosys.
• Creating procedures for database backups and restoring using EXPDP/IMPDP, RMAN and Shell Scripts
• Point In Time Recovery of the database, or individual tablespace, datafile.
• Responsible to Install and configure 11g RAC environment / load balancing and maintenance.
• Worked on Data migration from SQL databases to Oracle Databases through MS Access.
• Provided 24x7 Support for Production/Development databases.
• Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components.
• Migrating data between different database instances whenever required, using Datapump or exp/imp utilities and RMAN cloning.
• Involved in full/ partial logical backup using DataPump.
• Expert in setting up the Transparent Data Encryption Feature in 11g as a security feature.
• Used the Feature of using SQL baselines and stored outlines for performing the database tuning in 11g & 10g.
• Experience in performing GoldenGate Replication with source and target on the same physical host.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Created Materialized views to make query response faster
• Troubleshooting on various problem and generic errors in daily routine.
• Collaborated with project managers, application developers, and system quality assurance to ensure the database integrity, high availability and security.
• Experience in Enabling and Disabling Oracle Database Vault.
• Monitored Security violations attempts by a user using Oracle DB vault.
• Documented backup and recovery plans and tuning procedures.
• Participation in Logical Design discussions and designing physical database.
• Prepared documentation for ongoing maintenance and support.
• Key role in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR, ADDM etc.

Environment: Oracle 10/11g,12c, SQL Server, AIX 5, Confidential UX 11, SLES 11, RHEL (Red Hat Enterprise Linux) v4.5,5.2,6, PL/SQL, RMAN, TOAD, OEM GRID, Data Guard, GoldenGate.

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

• Handleddatabasesizeofmorethan8TB.
• ManagedandmaintainedtheOracle10g/11gRACOLTPProduction,Pre­Productionand DevelopmentDatabasesonLinuxPlatforms.
• Configured,MaintainedandmonitoredthePhysicalstandbydatabases,alsoenabledActive Data Guardforreportingtools.
• Migrated10gdatabasesfromNon­ASMtoASMfilesystemandlaterupgradingthemto11g.
• ConfiguredandmonitoredOracle10gGridcontrol.
• Providedfulltechnicalsupporttovariousapplicationteamsbeforethedatabasesgoto Production.
• Experienceininteractionwiththetopmanagementandescalationsofthecomplexissues.
• Performedentriescapacityplanningrequiredcreatingandmaintainingthedatabases.
• UsedTriggersfordatabaseactivities,likedelete,updateanduserslogon.
• Allocatedthesystemstorageandplannedfuturestoragerequirementsfortheproduction databasesystem.
• Done the Migration Review required before the database migration and QA after the databaseismigrated.
• MaintainedtheRMANrepositoryandcustomizedrecoverycatalog.
• Worked with BI/Cognos team to tune various ad­hoc queries in the data warehouse environment.
• CreatedPartitions,materializedviews,indexes,undo&tempspacesinthewarehouse environment.
• CreationofUsersandGrantingthemprivilegesandroles.
• MaintainedtableandindexPartitions.
• ImplementedHighavailabilityusing GoldenGateReplication,ImplantedBi­directional replication usingGoldenGate.
• HandsonexperienceinDatawarehousedatabases.
• Involvedinsessionmanagementandmonitoredthecriticalwaiteventsinthedatabase.
• InvolvedInqueryoptimizationusingcostbasedoptimizers.
• PerformedsqltuningusingEXPLAINPLAN,SQLTXPLAIN,SQLADVISOR,ADDMandAWR reports.
• Proactivedatabasemonitoringusing11ggridcontrol.
• PerformedlogicalandPhysicaldatamodelingusingErwintool.
• Useddifferentoracletraceeventsforperformancetuning.
• Responsibleforconducting weeklymeeting,tele/videoconferencewithclients, development teamsbothonsiteaswellasoffshore.

Environment: Oracle10g/11g,SUSE10,RMAN,RAC,ActiveDataGuard,OEM, AWR/ADDM, UNIXShell Programming, GoldenGate,TOAD 10,PL/SQL Developer.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• 24x7 Database administrations,support and monitoring to ensure aproactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrading development and production databases to Oracle10g.
• Proactive database monitoringusing 10g grid monitoring tool.
• Database tuning using SQL Trace,STATSPACK,EXPLAINPLAN and TKPROF.
• Extensive Performance Tuning,Memory(SGA)Tuning,netbackup, EMC(Timefinderand SRDF),RAID,RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery.Performed Hot,Cold and Logical backups.And performed backup validations using RMAN.
• Management of schemas,objects partitioning the tables &i ndexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible forsetting and managing user accounts,and granting required privileges to users.
• Performed other DBA activities like including space management and performance monitoring.
• Experienced in Oracle Database monitoring,troubleshooting and resolvethe issues.

Environment: Oracle10g/9i, SQLServer2000,SunSolaris8.0,SUNSPARC,HPUNIX, Windows98/NT/2000,OracleEnterpriseManager,SQL*Loader,T SQL,STATSPACK, TKPROF,EXPLAINPLAN.