 Having OCE and OCP with 7 years of experience that includes developing, deploying, administration, and managing Databases in Production environments ranging in size up to 5 TB on various platforms such as Solaris, Linux etc. Versions include 10g and 11g.
 Area of Expertise mainly includes Database support & maintenance, installation, configuration, administration, security management, memory management, backup, recovery, cloning, up-gradation, database design in RAC and Non RAC environments.

Oracle Database
V – 9i / 10g / 11g / 12c
2/3/4 Nodes RAC / ASM
 4 Node 11g RAC with ASM in Linux 6.4 Platform using GUI
 3 Node 11g RAC with ASM in Linux 6.4 Platform using Silent Deployment(CLI)
 Oracle Cluster Service deployment with 3-Node 11g RAC
 Oracle RAC callout script configuration to relocate the services
 Oracle OEM Custom deployment on specific node with 3-Node RAC
 2+ locations Production deployment with Oracle10g 2-Node RAC with ASM on Solaris Platform
 11+ locations Production deployment with Oracle11g 2-Node RAC with ASM on Linux
 Production silent deployment with Oracle11g 2-Node RAC with ASM on Solaris Platform
 2 Locations – Oracle11g – 2 Node RAC Deployment with Oracle Standard Edition
 Hands on Silent and Manual Method to Database Creation for RAC and NON-RAC.
 Handling multiple Oracle RAC Databases on Single Server with 10g and 11g
 Oracle RAC Support for IP address and hostname Reconfiguration
 Configure Second Public Network in existing Oracle RAC deployment
 Add and Delete Node in existing Oracle RAC deployment
 Oracle RAC – Increase the size of REDO logs and Resize Undo Tablespaces
 Oracle RAC – Migration from ASMLib to UDEV Configuration
 Development Lab – Oracle RAC Setup using shared NFS without SAN Storage
 Oracle11g 2-Node RAC Setup using Single Bonding interface

Oracle Data Guard
 Scripting / Atomization for Manual Data Guard / Log shipping on Oracle10g Standard Edition
 Implement and administer Oracle Data Guard in 10g and 11gR2 on single Instance Database Environment.
 Implement and administer Oracle11g Data Guard between 11g 2-Node RAC to 11g 2-Node RAC Environment.

Oracle Streaming
 Implement and administer Oracle Data guard / Streaming in 10g and 11gR2.
 Implement and administer Oracle10g Streaming between 10g 2-Node RAC to 10g 2-Node RAC Environment.

Performance tuning
 Application response time tuning challenges
 End to End troubleshooting on Database / Operating system / Networking and Storage Layer

Backup and Recovery
 Performed backup and recovery using RMAN and DATA PUMP
 Oracle RMAN to reconfigure the new standby database
 Oracle RMAN Scripting and Alert Log Maintenance Automation on Data Guard Environment
 Oracle RMAN Scripting and Alert Log Maintenance Automation on Streaming Environment
 Oracle RMAN Scripting Automation for daily incremental and weekly full backup on standby database to offload the backup load from primary site.
 Database Cloning using Oracle RMAN
 Oracle Datapump Scripting Automation for daily backup
 Oracle Datapump backup using NETWORK_LINK option to periodic sync the reporting tables from primary to reporting database during off peak hour.
 Oracle Datapump: Import partition table in XE
 Optimize the Datapump backup on RAC Database

Data/Code Migration
 Data Migration from legacy database system to Oracle Database using various tools like
exp/imp, expdp/impdp, SQL LOADER, EXTERNAL TABLE, Scripting , Keep Tool, Sybase Tool , csv , text file
 Oracle PL-SQL to Sybase/MSSQL T-SQL
 Oracle PL-SQL to Postgres PL/pgSQL

Upgrade Database
 Oracle10g 10.2.0.1.0 to 10.2.0.4.0 using DBUA
 Oracle RAC10g 10.2.0.1.0 to RAC10g 10.2.0.4.0 using DBUA
 Oracle 10g to 11g using manual method

Monitoring
 OEM
 NetXMS
 Manage Engine
 vmstat / sar / iostat / top

MySQL Database
V-4.x / 5.x / 7.x
 Lab Development MySQL Cluster Setup using three servers on Oracle Linux Platform.
 Lab Development MySQL Replication Setup using two servers on Oracle Linux Platform.

PostgreSQL Database
V-8.x / 9.x
 Oracle to PostgreSQL Database Migration
 Oracle to PostgreSQL – ETL using ora2pg Utility
 Oracle PL-SQL to Postgres PL/pgSQL

Sybase Database
V-15.x
 Data Migration from Oracle10g Database to Sybase ASE 15.x Database
 Oracle10g Database Blob Migration to Sybase ASE 15.x Database
 Code Migration from Oracle PL-SQL to Sybase T-SQL
 Primary Sybase ASE to Secondary Sybase ASM Log Shipping every 15 minutes
 Sybase ASE Replicator Deployment
 Production Sybase ASE Deployment / Administration / Troubleshooting and Tunning

MSSQL Database
V-2000/2005/2008
 MSSQL 2005/2008 Database Blob Migration to Oracle10g Database
 MSSQL Database to Oracle Database
 Oracle PL-SQL to MSSQL T-SQL