About Me

Have 6+ years of experience with 6 years as Oracle DBA and been involved in Migration, Installation, Configuration, Upgrades, Patching, Backup and Recovery, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, ...overy, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control. Migrating databases to EXADATA RAC environment. Experience as on-call 24x7 production DBA support, handle incidents & business service requests using BMC Remedy and WPBN tool. Alone handled critical application databases with size varying from 500 GB to 30 TB. Have been part of Storage array migration. Involved in critical database migrations with minimal downtime. Experience in installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster & Recovery, Cloning, and Database Security. Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), PSU Patching, RAC Backup, adding/deleting a node to cluster database for High Availability and Recovery. RMAN Active cloning from ASM to non-ASM and vice versa. Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g/11g/12c. Effectively used Data Guard Broker utility for switch over/back operations. Configured and maintained replication using Oracle Golden Gate. Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN. Experience in Cumulative and Differential Incremental backups using RMAN. Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning. Good knowledge on Streams. Experience in Database Upgrades in 10g/11g/12c. Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM. Database Refresh from Production to Development and from Development to Test environments. Experience in maintain of production and Non-production batch servers using Autosys scheduler. Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints. Planning and scheduling Physical Backups (offline/online) and Logical Backups. Experience in implementing Flash Back Technology. Experience in User Management by Granting, Revoking Privileges according to requirement. Experience in Space Management by Monitoring and Managing Tablespaces. Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility. Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls. Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze STATSPACK and Dynamic Performance Views. Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables. Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer. Monitoring Alert log for any errors and issues. Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues. Hands on experience working on High Availability Environments. Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.