SUMMARY

• Database Administrator with 8+ years of experience in installation and administration ofOracle databases (8i/9i/10g/11g/12c), backup and recovery, performance tuning, performance monitoring, schema maintenance in platforms includeSun Solaris, HP - UX, AIX, LINUXandWindows 2000/NT in Production and development.
• Expertise in logical backups,Hot/Cold Backup, RMAN Backups, Recoveryand Cloning of databases.
• Implemented RMAN for backups andPoint-In-Time Recovery strategy.
• Experience in ConfiguringRMANwith Catalog for Differential, compressed Backup and Recovery.
• Expertise in data transfer using Export/Import using command line as well as in interactive mode and throughData pump.
• Experienced in features likeDatabase Replay, Log MinerandFlashback data Archive, Schema Management, Data guardandRMANinOracle 11g/ 12c
• Implemented Database cloning to disaster recovery database using physical standby database.
• Successfully installed, configured and supportedGolden Gate& Streams Replication.
• Experience in configuringData guard 10g R2, 11g and 12cfor physical standby databases.
• Configured and implemented physical standby database for switch over and failover operations usingActive Data guard.
• Successfully configured and implemented Physical Standby Database usingOracle DATAGUARDfeature for High availability configuration and reporting.
• Experience inPerformance Tuning (I/O, Memory & SQL Tuningetc) by using tools/utilities byAutomated Workload Repository (AWR),Automatic Database Diagnostics Monitor (ADDM),Explain Plan, Auto trace, TKPROF and Stats pack.
• Extensive experience on Partitioning
• Extensively usedOracle Enterprise Manager-Database Control, Grid Control for monitoring and tuning the databases in all environment
• Expertise in upgrading and migrating of oracle database to higher version
• Cross PlatformUpgrades/Migrationof Databases from Oracle 10g to 11g and 11g to 12c
• Extensively usedSQL*Loaderand External Tables to load data from flat file to oracle server.
• UsedSQLAccess Advisor, SQL Tuning advisor, Segment Advisor.Experience in Data transfer betweenSQL Server and Oracle.
• Extensively used Advance Replication (Oracle Streams) of oracle databases for high availability.
• Installations and Configuration of 10g/11g/12cRACwith ASMandVCFS.
• Converted single instance databases to multi node RAC environment for high availability and load balancing.
• Extensively worked on Oracle10g/11g/12c Real Application Clusters (RAC)environment on different nodes with Automatic Storage Management (ASM) to support large volume.
• Specialized in tuning onRACdatabases and monitoring for high availability.
• Experience on 11gR2RACnew feature SCAN.
• Experienced in utilizingGolden Gate replicationtechnology for ORACLE Upgrades.
• Expertise in usingGolden Gateto support data replication in the Oracle database environment.
• Expert in writingUNIXshell scripts and assigning Cron jobs for day to day activities.
• Extensive experience in writingSQL, PL/SQL packages, functions, stored procedures, triggers
• Responsible for working on database design and data requirement analysis usingERWINdata modeler andToadfor Data Analysts.
• Worked in database design, logical and physical modeling of the database using CASE tools likeERWIN, and normalization/de-normalization of database tables and object sizing.
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Load data from OLTP systems intodata warehousedatabases.
• Strong knowledge and experience of managing Oracle9i,10g RAC and 11g RAC and 12cenvironments using theOEM Grid Controltools.
• Strong Knowledge of managing EMCC 13C.
• Extensively used Oracle support and Metal ink to troubleshoot the problems and issues.

TECHNICAL SKILLS

Operating Systems: HP-UX 10x, 11.x, Sun Solaris 8,9,10, IBM AIX 5.1,5.2,5.3, 6.1, 7.1, RedHat Linux 4.x,5.x,6.x, Windows 2000/2003/Vista/XP, Windows 7Databases Oracle 12c/11g RAC/10g RAC/9i/8i, Microsoft SQL Server 2005, 2008

DB Utilities: Oracle 12c/11g RAC/10g RAC/9i/8i, Microsoft SQL Server 2005, 2008

Scripting: Shell Scripting Korn& Bourne

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Tools: OEM/Grid Control, TOAD, SQL Developer, Putty, SQL*PLUS, ERWIN, SQL- Navigator, ERWIN, Golden Gate, Streams,EMCC 13C

Languages: SQL, PL/SQL, C,C++,UNIX Shell Scripting, XML,HTML., Data modeling, Erwin, Apache Tomcat, Java

Other: EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale CA

Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database Administration Support. Installing and configuring several Oracle 10g, 11g and 12c databases on Linux andUNIXplatforms.
• Installed and implemented 10gR2/11gR2 and 12cRAC.
• Performed Import and Export usingOracle Data Pump, storage migration, data migration.Upgrade/Migrated the production and development databases from 11g to 12c.
• UpgradedRACdatabases from11g to 12c with CRS upgrades. Written shell scripts for backups, cloning of databases.
• Applying Patches, Patch sets, PSU patch apply where ever necessary.
• Enabled client applications to automatically reconnect to the database if the connection fails usingTAF (Transparent Application Failover).
• Setup FAN mechanism inOracle RACto quickly alert applications about configuration and workload service level changes.
• Setting up and monitoring the Data Guard for Production servers.
• Working Closely with System administrators, developers, technology Stack team and Server Tech team
• ConfiguringTNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity. Writing of UNIX shell scripts to manage the health of database proactively.
• PerformedSQL tuning, System tuning, Database and Instance tuningby root cause analysis.
• Data partitioning & tuning queries on largeOracle RACdatabases.Monitoring the instance statistics and tuning the database to improve performance.
• Use of tools likeOEM, STATSPACK,TKPROF, SQL Trace, Explain Plan, AWRandADDMreports to proactively monitor performance.
• Backup procedures usingRMAN.
• Recovery of Database usingRMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups usingRMAN.Monitoring experience includesOracle Enterprise Manager Grid Control.
• Establish standards, policies, andprocedures forGolden Gate replicationadministration.
• PerformedGolden Gate replication monitoring, tuning, and capacity planning.

Environment: Oracle 12c, 11gR2 RAC, 10g, RedHat Linux, HP - UX, IBM AIX, SUN SOLARIS, WINDOWS, OEM/Grid Control, RMAN, ASM, DataPump, SQL*Loader, GoldenGate, Oracle Streams, ERWIN,EMCC 13C

Confidential, Raleigh NC

Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database Administration Support
• Manage and lead Off Shore team for implementation of day to day activity. Setup weekly meeting with offshore team for knowledge transfer and game plan to complete the task in scheduled time.
• Installing and configuring several Oracle 10g, 11g databases on Linux andUNIXplatforms.Installed and implemented 10gR2/11gR2RAC.
• Performed Import and Export usingOracle Data Pump.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g and 11g to 12c
• UpgradedRACdatabases from10gR2 to 11gR2.Written shell scripts for backups, cloning of databases.
• Applying Patches, Patch sets, CPU updates where ever necessary.
• Enabled client applications to automatically reconnect to the database if the connection fails usingTAF (Transparent Application Failover).
• Setup FAN mechanism inOracle RACto quickly alert applications about configuration and workload service level changes.
• Setting up and monitoring the Data Guard for Production servers.
• Working Closely with System administrators, developers, technology Stack team and Server Tech team
• ConfiguringTNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity. Writing of UNIX shell scripts to manage the health of database proactively.
• PerformedSQL tuning, System tuning, Database and Instance tuningby root cause analysis.
• Data partitioning & tuning queries on largeOracle RACdatabases.
• Monitoring the instance statistics and tuning the database to improve performance.
• Use of tools likeOEM, STATSPACK,TKPROF, SQL Trace, Explain Plan, AWRandADDMreports to proactively monitor performance.
• Backup procedures usingRMAN.
• Recovery of Database usingRMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups usingRMAN.Monitoring experience includesOracle Enterprise Manager Grid Control.
• Establish standards, policies, andprocedures forGolden Gate replicationadministration.
• PerformedGolden Gate replication monitoring, tuning, and capacity planning.

Environment: Oracle 9i/10gR2 RAC/11gR2 RAC, 12c, RedHat Linux, HP - UX, IBM AIX, SUN SOLARIS, WINDOWS, OEM/Grid Control, RMAN, ASM, DataPump, SQL*Loader, GoldenGate, Oracle Streams, ERWIN

Confidential, NY

Oracle DBA

Responsibilities:

• 24x7 Database Administration Support. Installing and configuring several Oracle 10g, 11g databases on Linux andUNIXplatforms.
• Installed and implemented 10gR2/11gR2RAC.Performed Import and Export usingOracle Data Pump.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• UpgradedRACdatabases from10gR2 to 11gR2.
• Written shell scripts for backups, cloning of databases.Applying Patches, Patch sets, CPU updates where ever necessary.
• Enabled client applications to automatically reconnect to the database if the connection fails usingTAF (Transparent Application Failover).
• Setup FAN mechanism inOracle RACto quickly alert applications about configuration and workload service level changes.
• Setting up and monitoring the Data Guard for Production servers.
• Working Closely with System administrators, developers, technology Stack team and Server Tech team
• ConfiguringTNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity. Writing of UNIX shell scripts to manage the health of database proactively.
• PerformedSQL tuning, System tuning, Database and Instance tuningby root cause analysis.
• Data partitioning & tuning queries on largeOracle RACdatabases.
• Monitoring the instance statistics and tuning the database to improve performance.
• Use of tools likeOEM, STATSPACK,TKPROF, SQL Trace, Explain Plan, AWRandADDMreports to proactively monitor performance.
• Backup procedures usingRMAN.
• Recovery of Database usingRMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups usingRMAN.
• Monitoring experience includesOracle Enterprise Manager Grid Control.

Environment: Oracle 12c, 11gR2 RAC, 10g, RedHat Linux, HP - UX, IBM AIX, SUN SOLARIS, WINDOWS, OEM/Grid Control, RMAN, ASM, DataPump, SQL*Loader, GoldenGate, Oracle Streams, ERWIN

Confidential, Buffalo NY

Oracle DBA

Responsibilities:

• 24x7 Database Administration Support. Installing and configuring several Oracle 10g, 11g databases on Linux andUNIXplatforms.
• Installed and implemented 10gR2/11gR2RAC.Performed Import and Export usingOracle Data Pump.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• UpgradedRACdatabases from10gR2 to 11gR2.
• Written shell scripts for backups, cloning of databases.Applying Patches, Patch sets, CPU updates where ever necessary.
• Enabled client applications to automatically reconnect to the database if the connection fails usingTAF (Transparent Application Failover).
• Setup FAN mechanism inOracle RACto quickly alert applications about configuration and workload service level changes.
• Setting up and monitoring the Data Guard for Production servers.
• Working Closely with System administrators, developers, technology Stack team and Server Tech team
• ConfiguringTNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity. Writing of UNIX shell scripts to manage the health of database proactively.
• PerformedSQL tuning, System tuning, Database and Instance tuningby root cause analysis.
• Data partitioning & tuning queries on largeOracle RACdatabases.Monitoring the instance statistics and tuning the database to improve performance.
• Use of tools likeOEM, STATSPACK,TKPROF, SQL Trace, Explain Plan, AWRandADDMreports to proactively monitor performance.
• Backup procedures usingRMAN.
• Recovery of Database usingRMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups usingRMAN.Monitoring experience includesOracle Enterprise Manager Grid Control.
• Establish standards, policies, andprocedures forGolden Gate replicationadministration.
• PerformedGolden Gate replication monitoring, tuning, and capacity planning.

Environment: Oracle 9i/10gR2 RAC/11gR2 RAC, RedHat Linux, HP - UX, IBM AIX, SUN SOLARIS, WINDOWS, OEM/Grid Control, RMAN, ASM, DataPump, SQL*Loader, GoldenGate, Oracle Streams, ERWIN

Confidential, St. Louis, MI

Oracle DBA

Responsibilities:

• 24x7 Database Administration Support.
• Supporting both production and development Database activities.Creating databases for Testing, Development and Production.
• Performed database cloning to setup test, development database and Disaster Recovery Database using Physical Standby.
• Performance tuning for optimized results using toolsEXPLAIN PLAN, SQL*TRACE AND TKPROF, STATSPACK.,AWR, ADDM
• Migration of Database from HP-UX to AIX. Upgraded databases from Oracle 9i to 10g, 10g to 11g
• PerformingSQL*Loader jobs for data loading.Data refresh from production to test and development.
• Configured and installed oracle 10g Data guard for Physical standby Databases on Linux.
• ImplementedData Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Linux environments.
• PerformedRMANBackups and Conventional Hot/Cold backups, logical Backups.
• Worked on recovering data files, table spaces, control files, block corruption etc.
• Implement"Stored Procedures, Packages, Functions and Triggers"based on business requirements usingPL/SQL
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers withPL/SQLcoding.
• Installed, configured and performed the maintenance ofSQL Server.Rebuilding of Indexes for better performance, maintenanceof Oracle Databases.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• ImplementedActive DATAGUARD (Standby)for high availability/disaster recovery purpose.
• Takingperiodic Backup of the Database and the software usingRMAN and VERITAS.
• Written shell scripts for digitization the process.
• Hands on experience injava database connectivity (JDBC)with oracle thin driver.Scheduling jobs through Oracle Job Scheduler.
• SQL Tuningsfor Performance of Objects and providing support to end users.OS level activities like space monitoring of Mount point.
• UsingERWINfor Creating and managing the logical and physical Data Models.
• Working with system administrator to monitor CPUusage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.
• Recovery of Database (Recovering from Media Failure, Recoveringtables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: Oracle 11g, Oracle 10g RAC, Oracle Data Guard, Sun Solaris, Red Hat Linux, IBM AIX, HP-UX, WINDOWS, RMAN, ASM, SQL*Loader, DataPump, Oracle Streams