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