Professional Summary:

• 8 years of experience in Oracle databases 8i/9i/10g/11g/12C-OEM administration, Golden gate configuration and maintenance, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, Unix, HP-UX, AIX, LINUX and Windows sql server 2000/NT,2008, 2012.
• Expertise in Installation, Maintenance, Upgradation, Administration, Backup and Recovery of Oracle RAC Databases.
• Experience in managing very large multi TB OLTP and Datawarehouse databases
• Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
• Extensively worked on Upgradation databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing and Snapshot physical standby.
• Proficient in implementing and maintaining Database Security Users, Roles, Privileges , space management logical structures such as tablespaces and rollback segments and auditing of users.
• Experience on installation and configuration of Golden Gate.
• Golden Gate DDL Replication
• Ggs Heterogeneous replication using Golden Gate Oracle 11.2.0.3 to SQL Server
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experience in installing and managing Oracle Enterprise Manager Grid Control.
• Expertise in maintenance, upgrades, administration, backup and recovery of OracleExadata systems
• Expertise in Performance Tuning by using tools/utilities like Automated Workload Repository AWR , Active Session History ASH , Automatic Database Diagnostics Monitor ADDM , Explain Plan, sql tuning Advisor, Autotrace, TKPROF and Statspack.
• Successfully configured and managed Physical Standby Database using Oracle DATAGUARD for High availability.
• configured and managed Active Standby Database ActiveDATAGUARD to make replication of production DB in read only mode.
• Experience in basic and advance replication usingOracle Streams.
• Extensive experience on Partitioning tables and creation of the Indexes on large tables to improve the Performance.
• Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers to implement business logics of oracle database.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, capacity planning and documentation.
• Experience in debugging deadlocks and other database inefficiencies using SQL Profiler.
• Expertise in maintaining Database Security and auditing.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Project Documentation, creation and adhering to standards of Implementation and Project management
• Excellent interpersonal skills, team player, hard working and result oriented.
• Supported the system 24x7, Ability to work beyond regular hours.

Technical Skills

• DBMS RDBMS : Oracle 8i, Oracle 9i, Oracle 10gR2, 11g R2 and SQL server.
• High Availability, Tuning : Oracle 10gRAC with ASM, Streams, DataGuard, OEM 9i, 10g, 11g, Golden gate and Monitoring Product LogMiner, Tkprof, Statspack Reports, AWR, ADDM
• and ASSM
• Operating Systems : Solaris 8/9/10 , AIX 5.1, 5.2, 5.3 , Linux RHEL 3x, 4x, 5x ,
• HP-UX 10.x, 11.x and Windows98/NT/2000/XP
• Tools Utilities : Toad, RMAN, EXP/IMP, EXPDP/IMPDP and SQL Loader
• Data Modeling Tools : Erwin and ODI
• ETL Reporting tools : INFORMATICA ,
• Backup Tools : VERITAS, NetBackup and HP OmniBack
• Programming Languages : SQL, PL/SQL, Unix Shell Scripting, C, C , HTML and XML

Professional Experience:

Confidential

Oracle DBA

Responsibilities:

• This project involves Support of various Cisco application production databases which are hosted in 10g/11gR1/11gR2 real application clusters RAC . This involves24x7 transactions. As part for this job I am responsible for
• Capacity planning, hardware evolution and recommendations
• .responsible in Maintaining SQL server 2008/2012 day to day production issues
• Installation of application code following release management process.
• Upgraded production, Development databases from Oracle 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Implemented and worked extensively on 12C OEM on daily basis by configuring various monitoring metrics across all production and non-production Databases
• Implementation of CISCO MVDC Activity Data Gard, to make replication read-only access of critical production databases for failover.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Configuring and maintenance of physical Standby database using Active Data Guard
• Oracle Golden Gate experience in configuration and maintaining, troubleshoot day to day production issues lags .
• Golden Gate 10.x and 11.x replication solutions to facilitate data flow between heterogeneous SQL Server and Oracle environments
• Migrated SQL Server 2008 to oracle 11g using Golden Gate initial loader
• And Configured 4 node Golden gate Full mesh bi-directional replication
• Worked on multiple Databases consolidation into a single database in Exadata.
• Worked on moving Oracle 10g database of a Specialty company which Cardinal bought into Oracle 11gExadata
• Managed patching and upgrade of Exadata Storage Server's.
• Worked on setting up Data Guard on RAC in Oracle 11g Exadata.
• Deploying and testing application releases in various staging/pre-production environments and to ensuring there is no performance impact in production.
• Implementing User Defined matrix UDM in 11g Grid to custom monitor the database.
• Planning and implementation of Physical/Logical backups using RMAN-Export/Import-Data pump utilities.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR Statspack , ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects tables indexes and tablespaces to improve the performance.
• Tested the Dataguard DR SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Conducted sizing capacity planning for Oracle databases.

Confidential Oracle Apps DBA

Responsibilities:

• Administering more than 50 Production databases of size ranging from 100GB to 7 TB on RHEL and Solaris with E-Business suite 11i
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Provided 24x7 on call DBA support for Oracle 9i/10g/11 g productions, QA, DEV databases on RHEL, HP-UX, IBM-AIX.
• Involved in the installation, configuration of multi node 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Upgraded production, Development databases from Oracle 10.2.0.2, 10.2.0.4 to 11g/11g RAC..
• Migrated and implemented 10.2.0.4 windows DB's to 11.2.0.3 with Linux OS.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR Statspack , ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects tables indexes and tablespaces to improve the performance.
• Installed Golden gate as replication process for the Client's Data Store method.
• Monitored Replication Issues using Golden Gate Director, Golden gate logs and Supplemental Logging.
• Expertise in configuring Golden gate Extract, Pump Replicate.
• Used Golden agate to achieve zero/minimal downtime migration for large databases.
• Tested the Dataguard DR SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, Iostat, Sar, glance, Vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, Cumulative and differential Incremental Backups.
• Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
• Monitored performance of queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace SQL Tuning Advisor
• Performed Database backups and recovery using RMAN, Import/Export, Hot/ColdBackups, and Data Pump tools.
• Managed Oracle inHigh Availability environments using Real Application Cluster RAC , Failovers, Data Guard and Cloning technologies.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Tuned database parameter, PL/SQL scripts and query received from the STATSPACK report, AWR, ADDM or through the end users. Used Materialized Views when possible to reduce network load.
• Handled complete and incomplete recovery in case of database failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Managed schemas, user privileges, suggested and implemented external tables instead of SQL Loader to reduce time and resources.
• Enabled database audit on entities to monitor certain ambiguities observed in the process flow.
• Experienced in working Onsite-Offshore model projects.

Environment: Solaris 5.X, Windows NT, Oracle11g R1/10g R2, Golden gate ,7x HP UX 10.2/11.X, IBM AIX, RAC, AWR, ADDM, SQL trace, TKPROF,E-bussiness suite 11i.

Confidential Oracle DBA

Responsibilities:

• Involved in administering more than 50 Production databases of size ranging from 200GB to 10 TB on RHEL.
• Provided 12x7 on call support for mission critical databases and worked closely with Offshore team.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 16 nodes per cluster.
• Implemented Oracle 11g new features like Real Application Testing RAT , RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 RAC databases on ASM and NFS file systems.
• Migrated oracle RAC databases from 10.2.0.4 to 11.2.0.2.
• Responsible for Migrating a 4TB 3 node RAC database from 10.2.0.4 to 11.2.0.2 on NFS storage
• Performed capacity planning to create and maintain the database environments.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Installed and configured Data Guard 10g, 11g using physical and logical standby for high availability databases.
• Migrated oracle 9.2.0.8 databases to 10.2.0.4 from windows to Linux
• Migrated 4TB 10.2.0.4 standalone database to 2 node RAC
• Responsible for adding a node to a 4 node Cluster.
• As part of BCP certification did switchover and switchback
• Installed 11g 11.1.0.1 Grid control on RHEL 5U3
• Installed agents on database servers and configured enterprise manager.
• Configured UDM's for monitoring the databases.
• Involved in administering Oracle Streams bi-directional replication at table level.
• Configured Oracle Streams bi-directional replication at schema level between databases located in different colo's.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30 production databases.
• Migrated database from ASM to Non-ASM using RMAN.
• Recovered datafiles from block corruption using RMAN.
• Created Partition's, estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Proficient in troubleshooting node reboots in Oracle RAC Environment
• Presented White paper on upgrading 10.2.0.4 RAC databases to 11.2.0.1 to United Guaranty DBA team
• Responsible for refreshing Non-prod environment from production and later automated the process through a script.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL Trace.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Responsible for rebuilding and re organization of tables and Indexes for better performance.
• Installed and configured of Golden Gate.

Environment: Oracle 10g RAC, 11g RAC, 9i, SQL server 2005,2008, Golden gate SUN SOLARIS 9,10 and RHEL 5.x, HP-UX 11

Confidential Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Senior DBA, Primary point of contact for client for database and configuration management related issues.
• Installed and Configured Oracle 10gR2 two node RAC.
• Installed, configured and administered Automatic Storage Management ASM .
• Database cloning from Production to Test and Development environments.
• Administered and managed Production, Test, and Stage and Development databases involving more than 100 applications.
• Installed and configured Goldengate.
• Dealt with Web based OLTP systems.
• Review database environments, such as database settings, monitoring oracle user processes.
• Installed and configured Data Guard 10g using physical and logical standby for high availability databases.
• Adding and deleting nodes using Oracle Universal Installer OUI .
• Created Physical standby database from hot backup of primary database and wrote shell scripts for backup and cloning.
• Worked with a team for replicating databases using Quest Shareplex.
• Used Oracle Streams for data replication between oracle databases.
• Responsible for Migrating Oracle database from 9.2.0.7 to 10.2.0.4
• Daily database administration tasks including backup and recovery.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Developed Backup Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Provided all kinds of Production DBA support as well as development team support to various tasks.

Environment: Oracle 11g, Oracle 10g RAC, Oracle 9i, RHEL 4.x, IBM AIX 5.3, HP-UX 11, Goldengate.

Confidential Oracle DBA

Responsibilities:

• 24x7 production database and applications support.
• Coordinating closely with onsite team.
• Upgraded multi terabyte databases from 9i to 10g, Configured disaster recovery site with physical standby database for high availability.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning. Used data pump technology to take the backups.
• Configured Enterprise manager for centralized database monitoring and maintenance.
• Cloning of databases from production to Dev QA Databases using RMAN utility.
• Partitioning of the large tables to reduce the access time and easier management.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for table replication.
• Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Installation of SQL Server 2005.
• Troubleshooting oracle errors fine-tune database parameters and analyze STATPACK reports.
• Installation and creation of 9i and 8i databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Applied High priority, security patches downloaded from Metalink
• Performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
• Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAIN PLAN.
• Administered all database objects, including tables, clusters, indexes, views, sequences, functions, packages, triggers and procedures with PL/SQL hands on experience .
• Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Enabled security in creation of Database users, roles, privileges, profiles.
• Creating primary database storage structures tablespaces once developers have designed an application.
• Perform other regular DBA activities including schema management, space management and performance monitoring.
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Monitoring the database daily activities.
• Database maintaining including backups, recovery, imports/exports.
• Created materialized views, table partition for Tuned databases.
• Involved In query optimization and using rule based optimizers and cost based optimizers.

Environment: IBM-AIX, Sun Solaris, Oracle 8i, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.