I am Oracle 10g Production DBA managing very large Databases requiring very High Availability and Scalability. I have about 4 years experience in maintaining Oracle 10g RAC Databases and Oracle 10g Data Guard - Logical and Physical
Oracle DBA with nearly 5 years of experience in managing very large databases - Airline Passenger Services Systems, requiring very high Availability (> 99.95%).
My expertise include the following:
• Database administration in Oracle 10g RAC
• Rolling RAC Patch Upgrades - One-Off Patch, CRS Bundle Patch, NCPU, PSU Patching
• Rolling Database Upgrades of RAC DB with Logical Standby Database with minimal downtime
• Streams - Downstream database for application archival.
• Migration of 1TB - 10g Database from one platform to another platform in different Data Center with downtime < 10 min using Local/ Upstream Streams Capture.
• PL/SQL programming in Oracle 10g, 9i, 8i, 8.
• Experienced in Backup and recovery (using RMAN, Flashback Recovery)
• Performance tuning (using AWR Reports, tkprof, SQL Advisor, ADDM and ASMM)
• Hands-on experience in Automatic Storage Management (ASM) with Raw Storage Devices
• Analyzing Automatic Workload Repository Data
• Advanced Automated Job Scheduling (Jobs, programs, windows and priority)
• Database Cloning and Configuration
• Oracle Server installation and patching
• Database Sizing