SUMMARY

• Over 12 years of experience as Oracle Database Administrator, providing 24/7 support of both development and production Oracle 12c/11gR2/11gR1/10gR2/10gR1/9i/8i RAC and Non-RAC databases on Various physical and virtual Platforms
• Over 7 years of experience working with Oracle RAC Real Application Cluster have successfully completed 6 projects on Oracle RAC Configure, implement, and support
• Over 5 years of experience installing, configuring and supporting SAP Databases that host Business Solutions like MDM, ECC, BW, SM, EP, PI etc on various flavors of unix,
• Over 5 years of experience SBP Patching, upgrading and migrating Oracle Databases for SAP Business Solutions
• Over5 years of experience maintaining SAP Databases using BR Tools, Dashboard.
• Over 6 years of experience working with Oracle Data Guard Physical Logical have successfully completed 5 projects using Oracle Dataguard Implement support
• Over 6 years of experience working with EMC SRDF Replication as DR Strategy
• Over 5 years of experience working with Oracle Golden Gate, Quest SharePlex, Oracle streams with complete end-to-end support for Basic Advanced Replication Configure, Setup, Install, support
• Over 2 years of experience configuring Exadata and erecting RAC POC DBs on Exadata.
• Over 9 years of experience in performance tuning of production and development databases
• Over 9 years of experience in developing efficient database backup recovery strategies
• Proficient in Database Administration activities such as Upgrades, Patches, CPUs, PSUs,TAR support, Cloning, duplicating, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Excelling experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c in HP-UX, SUN SOLARIS, UNIX/LINUX and Windows environment
• Provide DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ADDM, and 11g OEM Grid Monitoring
• Experience in Installation and configuration of Oracle 11g on HP-UX, Solaris and Linux
• Hands-on Automatic Memory Management for an ASM instance
• Experience in using SQL Performance Analyzer to tune the database
• Knowledge in using Database Repair Advisor - a wizard/expert system that guides DBAs through the fault diagnosis and resolution process
• Experience in Installation, configuration of Oracle 11g RAC also used Oracle 11g features like RAT, Database Replay, SPA, SPM, Real-Time SQL Monitoring, Data Pump, Flashback technology, AWR, ADDM, Grid Monitoring, Recycle Bin and Transportable Tablespaces
• Experience using enhanced features in 12c like Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Experience using 12c pluggable and container databases PDBs and CDBs .
• Excellent experience in using OEM, TOAD, Data Migrations using Export/Import,Data Pump benchmarking using load testing tools
• Highly proficient in SQL, PL/SQL
• Experience with Data Modeling, Logical and Physical database design
• Management of schemas, objects Partitioning the tables indexes
• Performed backups and tested crash recoveries using conventional cold, hot RMAN backups
• Proficient in performance tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, ADDM
• Effective troubleshooting of database and performance problems
• Efficient and best business practice RMAN Backup Strategy to Disk and Tapes
• Experience in Oracle Fail-safe and third party cold failover and clusters
• Excellent experience in OLTP/DSS database systems, implementing and managing Large Oracle databases VLDB
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA Developer

Environment: Oracle 9i, 10g /11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3,, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11, Control-M, Autosys, PCS, SRDF Replication, DBArtisan, Aqua studio

• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
• Build POC for Exadata RAC DBs on X3-2 from scratch.
• Administration of SAP Business Solution Application databases like ECC, BW, SM etc
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team
• Develop upgrade roadmap and perform upgrade of Database from 10g to 11g and then to 12c.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Thorough understanding of architecture and operational mechanism of CRS, GNS, GPNP.
• Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism
• High Level Evaluation and Performance Tuning, Load Balance and TAF Failover..
• Active member in making enterprise hardware infrastructure related decisions with IT management
• Involve in meetings with top IT management to discuss extremely complex platform migrations
• Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
• Migrating from Oracle 11g Sun Solaris 10 to Oracle 11g RHEL 6
• Storage Migration: Migrated OCR, VD and ASM data from one SAN storage array to another
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• DR Exercise: Perform planned switchover and failover to physical standby database with and without Data Guard Broker and SRDF Failovers to ensure high availability
• Oracle Golden Gate and Shareplex for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Performed SQL Server Replication, Database Mirroring and Log Shipping
• Experienced with SQL Server DTS Data Transformation Services .
• Experience using enhanced features in 12c like Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Extensively used Oracle 11gR2 features Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Configured Oracle Internet Directory OID
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Timely application of PSUs.
• Data refresh from production to test and development
• Installing and configuring Recovery Manager RMAN efficient backup strategy to disks and tapes using best business practices
• Migrating backup strategy from TSM to HPDP
• Setting and Installing Oracle 11g Enterprise Manager OEM , 12c Cloud Control and Enterprise Backup Utility
• Setting up new Development Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Tuning.

Confidential

Sr. Oracle DBA

Environment: Oracle 9i, 10g /11gR1/11gR2 with RAC, Oracle Streams, Oracle Data Guard, HP-UX 11, Sun Solaris 10, RHEL 5.x, TOAD, SUSE 9,10, Windows NT / 2000 / XP, CA Wily Introscope

• Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC, Physical and Logical Standby database for Test, Development and Production
• Involved in 24x7 on-call support for 940GB 2 Node production 10g and 11g RAC database using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
• Install, configure and support Oracle Databases for SAP Applications like MDM, BW, EP
• Upgrade Oracle Databases and Client software for SAP Applications from 9i 10gR2 11gR2, applying SBPs and using BR Tools for administration
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team
• Upgrading of Database from 10.2.0.5 and then to 11.2.0.1
• Apply Patchset update to 11.2.0.2
• Active member in making enterprise hardware infrastructure related decisions with IT management
• Involve in meetings with top IT management to discuss platform migrations
• Installed, Setup, Configured Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11
• Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux SLES 10
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status
• Oracle Streams and Shareplex for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Extensively used Oracle 10gR2 new features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update CPUs every quarter in rolling mode with no downtime
• Data refresh from production to test and development
• Installing and configuring Recovery Manager RMAN efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager OEM and Enterprise Backup Utility
• Setting up new Development Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects

Confidential

Senior Principal Consultant

Environment: Oracle 9i / 10g with RAC 11g, Oracle Dataguard, Sun Solaris 9,HP-UX 11, OEM, TOAD

• Configure, implement 10gR2 RAC with ASM on Sun v890 servers
• Providing support to the SA team for Oracle RAC compatible hardware configuration
• Installed and configured Oracle 11g on HP-UX and Linux
• Tune the database using SQL Performance Analyzer
• Demonstrate Database Repair Advisor - a wizard/expert system that guides DBAs through the fault diagnosis and resolution process
• Create physical standby database from hot backup of primary database
• Create logical standby database from hot backup of primary database
• Resolving gaps between primary and standby databases Gap Resolution mechanism FAL
• Setting and Installing Oracle Enterprise Manager OEM and Enterprise Backup Utility
• Extensive Performance Tuning, Memory SGA Tuning, etc on 10g RAC
• Performance tuning of existing 9i RAC database using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK,
• Real Application Clusters monitoring, tuning, load balanced using OEM Oracle Enterprise