PROFESSIONAL SUMMARY:

• Having overall 8 years of IT experience as Oracle Database Administration and production support.
• Excellent experience in managing large - scale OLTP databases 15+TB size in HA and DR setup.
• Worked on 24x7 support and troubleshooting.
• Testing and Validation of Oracle 12c/11g RAC databases on Dell Hardware Stack which include PowerEdge RAC and Blade Servers with networking Force 10 switches and storages like EMC, Compellent and Equal logic.
• Performing Fault Injection Test Cases for verifying High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
• Laid hands on tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. As part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.2).
• Expertise in Migration and up gradation of Oracle databases and Oracle cluster ware.
• Experienced in applying patches including Patch sets and CPU/PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Data guard.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Auto trace, TKPROF and Stats pack.
• Proficient in logical backups Export/Import and Data pump.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Extensive experience in writing SQL, PL/SQL packages, functions, stored procedures, triggers
• UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• Solved many Network related problems in a database using Oracle Net Configuration Assistant (NETCA), Oracle Net Manager, Net stat and ping utility, providing Oracle Networking Solutions (tnsnames.ora, sqlnet.ora).
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Databases: SQL Server 2005, 2008R2, 2012, 2014 Oracle 9i, 10G, 11 G, 12C

Languages: SQL, TSQL, PL-SQL, C, C#

ETL Tools: SSIS, DTS

Model: Erwin r7.1, r9.1, 9.2

Backup tools: TSM, Commvault, Net backup

Ticketing Tools: Maximo, BMC Remedy

Monitoring tools: Site scope, Tivoli, Nagios, Fog light, BMC remedy, HP open view

Configuration tools: Puppet, chef

Storage: EMC, Netapps, Hitachi, IBM, HP

Reporting: SSRS

OLAP: SSAS

Tools: Management Studio, BIDS, SSDT, SQL Profiler, Red gate, Tivoli, Team Foundation Server (TFS) Visual Studio, Erwin, PLSQL Developer, TOAD, Xmanager, VNC.

Operating Systems: Windows NT/2000/XP/2003, 2008/2008R2/Windows 2012R2, LINUX (RHCE), Windows XP / 2007, Server 2008R2 / VISTA

Domain: Finance, Healthcare & Insurance

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Roles and responsibilities:

• Set up Active Data guard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Applied the Cluster ware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using opatch.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. As part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.2).
• Created, Configured and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Data pump and Normal ) for restoring the specific objects at the database level.
• Configured Oracle Stand by databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Extensively worked on new builds of 11gR2 RAC / RAC-ONE / Data guard environments with ASM on Linux/AIX platforms.
• Performed various tasks like Administered RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Setup and Configuration of OEM 12c, Agent installations using various methods & configuring target hosts/databases for monitoring. Set up alerts and notifications from 11g OEM.
• Used UNIX shell scripts to automate and systemize the load process at nightly cycles.
• Developed several reports that help track down an order.
• Worked in 10G/11G/12c RAC Installation/Maintenance and Troubleshooting CRS/Grid Infrastructure and ASM issues.
• Replication using Golden gate, Zero-downtime migrations, setup Uni-directional CDC and Bi-Directional.
• Configuration of RMAN backups for databases using TSM/Commvault. Design and Optimize backup & recovery strategy, refresh stage databases.
• Monitored and supported the database using Amazon RDS.
• Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Auto trace, TKPROF and Stats pack to fix the instance and query tuning.
• Handled Change Requests, its Process and Its Implementations.
• Installed Golden gate version 11 and version 12 with latest patches applied on ACFS file system also working testing new OGG 12.2 new features available.
• Implemented Golden gate integrated replicate and coordinated replicate (available from OGG 12c) to improve the performance of data replication to targets.
• Involved in implementing Oracle Golden gate on the Oracle 11g instances for replicating the schemas, tables and various Database objects.
• Installed and implemented the Tivoli agent on the Golden gate servers for monitoring the Lag of the replicating processes, groups as well as heartbeat lag.
• Involved in implementing the Director for the Golden gate which is a GUI tool makes thing easier with one click.

Environment: Solaris 10, Suse Linux, RHEL, AIX, Oracle DB 10g RAC,11g RAC,12c RAC Oracle 12c,11g, 10g, 9i, 12C OEM, Oracle Golden Gate, TSM, Commvault, Tivoli.

Confidential

Oracle DBA

Roles and responsibilities:

• Created and supported Oracle RAC/ASM in 11gr2.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Performed converting single node instance to RAC and Adding instance to the existing RAC.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, STATSPACK, ADDM, ASH, EXPLAIN PLAN, SQL TRACE, TKPROF, OEM Grid Control.
• Installed 11.2.0.3 RAC (3 node) from the Scratch and the maintenance of the high available Databases.
• Handled Change Requests, its Process and Its Implementations.
• Recovery of Database using RMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Partitioned Large tables to execute queries in finite window and fine tune the response time of database. Refreshing Dev. and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Worked in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Configured Golden Gate replication in 11gR2 in unidirectional method.
• Installed, upgraded, configured and patched RDBMS software.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Worked and implemented Database Wallet for Oracle 11g also called as key store from 12c and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and table space encryption, also used TDE for Golden gate replication too.
• Tested disaster recovery with database failover and switchover also tested Golden gate replication after that using ACFS file system.
• Implemented Oracle Golden gate (both Classic and integrated capture) and Shareplex for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.
• Worked on Oracle Golden Gate to implement Change Data Capture (CDC) and replication between the primary and secondary databases.
• Involved in implementation of different high availability solutions using Oracle 11g RAC, Physical and Logical Standby database using Active Data Guard and Oracle Golden Gate.
• Performed GGSCI commands using the utility ggsci to setup, manage, monitor and troubleshoot the different components of the golden gate replication configuration.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Configured Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Performed Database migration using Golden gate replication and trouble shooting.

Environment: Solaris 10, Suse Linux, RHEL, AIX, Oracle DB 10g RAC,11g RAC,12c RAC Oracle 12c,11g, 10g, 9i, 12C OEM, Oracle Golden Gate, TSM, Commvault, Tivoli.

Confidential

Oracle DBA

Roles and responsibilities:

• Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases and Assisted application team whenever requested.
• Supported & Maintained Production/Development Databases on various servers with 24x7 on-call support for Production applications.
• Performed Capacity planning, Space management, Storage allocation and different type of storage structure (SAN/NAS)
• Configured and build Golden Gate Extracts/replicate for multiple database
• Worked with Oracle support to resolve critical issues like ORA-600, ORA-4030, Ora-4031 errors.
• Created & Managed Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Extensively worked on multiple 10g/11gR2 RAC environments on ASM, 10g/11g physical standby setups & RMAN.
• Installed and configured Oracle 10g RAC, Oracle 11g RAC.
• Involved in Migration of Non RAC single instance to Real Application Cluster (RAC) database instances.
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guerdon both physical/logical standby databases in high availability mode.
• Helped in Performing Golden Gate replication monitoring, tuning, and capacity planning.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Installed the oracle data guard on 11g (physical standby database) on IBM-AIX- 5.3for high availability, disaster recovery and used data guard broker for switchover and failover using utility DGMGRL.
• Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.
• Worked on Automatic Storage Management (ASM) for managing data in SAN. Worked with ASMCMD utility for
• Monitored ASM and performed task like adding new disks, creating new disk groups and configuring these disk groups into ASM on AIX-5.3.

Environment: Solaris 10, Suse Linux, RHEL, Aix, Oracle DB 10g RAC, Oracle DB 11g RAC, Oracle 12c, 11g, 10g, 9i

Confidential

DBA

Roles and responsibilities:

• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Supported development and test environments and production environments.
• Migrated databases using RMAN cross platform transportable table space.
• Developed SQL Loader scripts to migrate large amount of data for capacity planning for users and table space.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Administered 10G RAC, 11G RAC databases and experienced with ASM (Automatic storage management).
• Performed regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Involved in resolving the issues as assisted by Oracle Support.
• Performed oracle software installations and created standalone and cluster instances as required.
• Prepared Documentation for Data Migration from Legacy systems to Oracle.
• Created the installation Document and submitting to customer.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.

Environment: Solaris 10, Suse Linux, RHEL, Aix, Oracle DB 10g RAC, Oracle DB 11g RAC, Oracle 12c, 11g, 10g, 9i

Confidential

SQL Server DBA

Roles and responsibilities:

• Installed database and giving permission to the users.
• Managed Data files and table spaces and backing them periodically.
• Exported and imported tables, schemas and table space periodically.
• Implemented Backup & Recovery procedures and took Periodic Backup of the database and the software.
• Solid experience in Oracle Recovery Manager (RMAN), standby database using Data Guard 9i/10g with ASM.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Performed flashback recovery process to recover the dropped table or table spaces.
• Good at programming skills, possess ability to write SQL scripting.
• Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Actively participated in Database replication (Golden gate), Application Tuning, which includes SQL Tuning, Database design tuning and tuning at Instance level.
• Planned, Implemented and Validated various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7)upgrades on all the environments (in a procedural approach Dev., Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Cloned Multi node system to single node system (Rapid Clone).
• Performed Patching to overcome the bugs in database.
• Managed the clients more effectively and efficiently.

Environment: Solaris 10, Suse Linux, RHEL, Aix, Oracle DB 10g RAC, Oracle DB 11g RAC, Oracle 12c, 11g, 10g, 9