I have over 6 years of hands-on experience as an Oracle Database Administrator. I have worked on Installing and configuring Oracle 12c, 11g and 10g. Performed Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security. Managed databases running on AIX, Linux, UNIX and Windows environments. I possess complete life cycle knowledge including development, test and UAT environments. I have supported 10g, 11g and 12c Oracle databases. I am versed with Dataguard, Golden gate and Oracle Real Application Cluster (RAC) for high availability solutions. * Implemented various backup strategies for Large / Medium sized databases using RMAN * Worked extensively on Cloning /Duplicate of databases using RMAN. * Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies. * 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. * 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. * Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability. * Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports. * Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments. * Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment. * Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances. * Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM). * Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery. * Experience in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control. * Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc * Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly. * Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities. * Troubleshoot Database performance issues with use of PROCWATCHER, LTOM, ORACHK, Cluster health monitor and Other Oracle support suggested utilities and also used OS related utilities like NMON, SAR, OSWATCHER, pstack, pmap, top, topas vmstat, iostat, prstat, strace etc . * Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes * Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc. * Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups. * 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 Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool. * Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database. * Installing Oracle patches, Migration of database across releases. * Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention. * Expertise in loading data from flat files using external tables, SQL* Loader. * Experience with SQL, PL/SQL, UNIX Scripting. * Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions. * Excellent analytical, problem solving, communication and interpersonal skills

Highlights:

• Database
• Diagnostics
• Enterprise Manager
• Management
• Oracle
• Oracle Database
• Oracle Database Administration
• Oracle Enterprise Manager
• Oracle PL/SQL Programming language
• Performance Tuning