Enabling Load Balancing in a Multi-Tier Architecture * Import/Export and Expdp/ Impdp utilities. * Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability. * Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics. * In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS_STATS in Performance Tuning. * Creating roles, profiles, privileges and assigning roles to users. * Extensively worked on monitoring and optimizing the database by performance tuning. * Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM). * Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades. * Proactive Monitoring identifying areas that need to be improved performance in the application and database using 11g/10gOEM Grid Monitoring. * Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM. * Creating extracts, data pumps and replicats on production servers, splitting replicats for efficient data transfer between servers, performance tuning using BATCHSQL, KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS &troubleshooting extract/replicat ABEND issues. * Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable tablespaces). * Migrated databases from Non-ASM file system to ASM file system using RMAN. * Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS). * Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database. * Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise. * Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option. * Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication. * Strong experience in RMAN, fail-over fail-back switch-over of stand by databases * Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC * Experience in multi-node and RAC environments including configuration of PCP. * Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies. * Troubleshooting the production databases (RAC, Non-RAC) within less time. * Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance. * Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup. * Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications. * Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback. * Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility. * Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor). * Used TKPROF utility and Explain Plan for tuning SQL queries. * Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation. ASM, adding, deleting disks to the disk group. * 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. * Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth. * Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries * Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2. * Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2. * Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2. * Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN. * Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration * Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process. all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design. * Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines. * Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations. * Installed & configured Oracle Management Server (OMS) & Oracle Grid Control. * Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation. * Create database Objects, Tablespaces, Schemas as needed. * Schema migrations from Development to Production via Tech Test environments. * Database refresh from Production to Tech Test as needed. * Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11. * Create oracle databases on configured servers using both the DBCA & Database creation scripts. * Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems. * Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfil the storage needs. * Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures. * Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups. * Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate. * Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control. * Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails. * Migrated data to a new ASM Diskgroup to improve the IO performance of the database. * Export/Import, Datapump, Transportable tablespaces to migrate databases from one database to another. * Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files. * Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups. * Performed capacity planning, space monitoring like tablespace growth, ASM disk space.

Highlights:

• Configure
• Oracle
• Oracle Database Administration
• Sun Solaris Operating System
• Support
• Transcope DataPump
• Triggers
• Utilities
• Application Development
• Architect