SUMMARY OF SKILLS:

• Over 8 years of experience as an Oracle Database Administrator.
• Good knowledge on Oracle Apps 11i R12, Oracle Database 8i, 9i, 10g and 11g.
• Expertise on Installation, Upgradation, maintenance and administration of Oracle 9i, 10g RAC, 11g RAC Database.
• Supporting for Exadata machines
• Expertise on implementation golden gate for replication.
• Expertise in installing different versions of Oracle on Linux and Solaris.
• Good knowledge on Oracle advanced Technology RAC, Data guard, OEM, Grid Control, ASM and Replication using Materialized Views, Oracle Streams.
• Good in Migrating databases
• Good knowledge on VERITAS, NetApp Backup's, BCV and EMC Storage Backups.
• Configured Golden Gate.
• Upgraded the database from 9.2.0.1 to 10.2.0.1 and 10g to 11g.
• Installed oracle 11g client and server software.
• Having experience in database cloning using RMAN,HOT,COLD backups
• Working in 24X7 on-call production database support and maintenance including remote database support.
• Experienced in development and production on Stand Alone and RAC
• Extensive knowledge in Oracle standalone, RAC database architecture.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Having experience in applying patches for database and applications.
• Capable of troubleshooting the troublesome sql statements.
• Generated ADDM for taking the advisories of a database performance.
• Configured Data guard and tested for failover and switchover
• Monitoring index usage and Performed Rebuilding of Indexes.
• Performed table and table space level defragmentation.
• Having experience in cloning and migrating database from Linux to windows.
• Applied latest patches and bug fixes for 11g .
• Experienced in taking regular off-line, online and logical Backups.
• Good Knowledge on languages C, Java, SQL, PL/SQL, UNIX Shell and Perl.
• Experienced in taking an RMAN backups to tape and disk.
• Experienced in assigning user level issues.
• Good Exposure on Performance Tuning and database design.
• Proficiency in creating business and technical project documentation
• Expertise is working with distributed and global project teams
• Project Resource planning and allocation
• Ability to work as a strong team leader to ensure quality and timely project execution

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Supporting for Exadata machines and Golden Gate.
• Supporting for oracle application R12.
• Installation, Configuration and administration of Oracle 11g/10g database on Red Hat Enterprise Linux RHEL and also Upgradation from Oracle 10g to 11g.
• Configured 3-node Real Application Cluster RAC and monitored RAC instance with Oracle Enterprise Manager Grid Control.
• Installed and Configured Oracle Enterprise Manager Grid Control 11g.
• Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3-node RAC environment.
• Migration of database from one server to another server with zero downtime.
• Migration of Application Databases from SQL to Oracle.
• Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Performed conversion Non RAC single instance to Real Application Cluster RAC database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, testing, QA and development databases.
• Installation, configuration and administration of Oracle RAC and Standby Databases DataGuard for High Availability and Disaster Recovery.
• Supporting for Exadata machines and Golden gate.
• Patching and upgrading to 11g
• Monitoring and maintaining cluster DB's for their Optimal Performance and
• Trying to ensure 100 availability of the DB's.
• Implemented 4-Node RAC with raw devices and ASM Library Interface.
• Allocating and reorganization of tablespaces.
• Incorporating user's requests as per Emails.
• Job scheduling using dbms job and crontab.
• Backup database using export/import.
• Taking backups using RMAN.
• Performed Database Cloning from Production to Test environment.
• Performance monitoring and tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM..
• Maintenance of Database and Listener.
• Moving data between databases using utilities like Import, Export, SQL loader

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, testing, QA and development databases.
• Installation, configuration and administration of Oracle RAC and Standby Databases DataGuard for High Availability and Disaster Recovery.
• Supported for both oracle databases and applications.
• Providing 24/7 Support on production instances
• Configuration Recovery Manager RMAN , Dataguard, Distributed Database
• Database version Upgrades from 10.2.0.1 to 10.2.0.4
• Moving the Database across the platforms
• Cloning databases through RMAN with Auxiliary
• Configured the Clone databases from Production to reporting databases
• DBA support for Production, QA and Development teams.
• Perform regular database activities like space management, database health check-up etc. Troubleshooting and resolving numerous production issues.
• Implementation of Scheduled Change Control requests on Productions.
• Involved in migration of database from 9i to 10g.
• Allocating system storage and planning future storage requirements for the database system.
• Refreshing test database with production database when required.
• Administered databases remotely.
• Monitoring Alert log System log files.
• Created users privileges with appropriate roles and levels of security.
• Troubleshooting Oracle connectivity issues.
• Implementation of Backup and Recovery Strategies.
• Planning performing hot and cold backups.
• Moving data between databases using utilities like Import, Export, SQL loader and Transportable Table spaces.
• Installed configured 2-Node RAC using OCFS as cluster file system and ASM lib.
• Configured high availability services for Transparent Application Failover TAF
• Taking backups using RMAN
• Performed Node Eviction issues
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
• Performed Database Cloning from Production to Test environment
• Monitoring and maintaining cluster DB's for their Optimal Performance and

Responsibilities:

• Monitoring and maintaining cluster DB's for their Optimal Performance and
• Trying to ensure 100 availability of the DB's.
• Allocating and reorganization of tablespaces.
• Incorporating user's requests as per mails.
• Job scheduling using dbms job and crontab.
• Backup database using export/import.
• Taking backups using RMAN.
• Creation of DB LINKS.
• Performed Database Cloning from Production to Test environment.
• Monitoring and optimizing the performance of the Database through

Responsibilities:

• Providing 24/7 Support on production instances
• DBA support for Production, QA and Development teams.
• Perform regular database activities like space management, database health check-up etc.
• Troubleshooting and resolving production issues.
• Refreshing UAT QA with Production Database.
• Implementation of Scheduled Change Control requests on Productions.
• Involved in upgradation of database from 9i to 10g.
• Administered databases remotely.
• Monitoring Alert log System log files.
• Created users privileges with appropriate roles and levels of security.
• Managing privileges and roles to ensure database security.
• Troubleshooting Oracle connectivity issues.
• Implementation of Backup and Recovery Strategies using RMAN.
• Planning performing hot and cold backups.