SUMMARY

• Competent & talented professional with commendable 10 + years of experience as an Oracle DBA.
• Proficiency in Oracle RAC,ODI, Exadata, Dataguard,ASM, Database Migrations including Cross Platform Database Migrations using transportable tablespace, Database restorations, Storage Management, RMAN Backup & Recovery Strategies, Upgrades, Patches, Database refreshes, Cloning, Datapump and Performance Tuning.
• Expertise in supporting critical production database environments, highly critical applications, environment with zero downtime.
• Experience working with various domains like Pharmaceutical, Healthcare, Financial, Telecommunications, Manufacturing to deliver new product Resolve application problems to maintain high level of customer satisfaction.
• Proficiency in Oracle RAC, Exadata, Dataguard,ASM, Database Migrations including Cross Platform Database Migrations using transportable tablespace, Database restorations, Storage Management, RMAN Backup & Recovery Strategies, Upgrades, Patches, Database refreshes, Cloning, Datapump and Performance Tuning.
• Multitasking credentials with excellent planning, execution, monitoring and resource balancing skills as well as the ability to handle multiple tasks in high - pressure environments and under tight deadlines.
• Acknowledged troubleshooter and well-known skill set in collaborating with cross-functional teams and deploying technology to build successful solutions. Articulate communicator with strong analytical and interpersonal skills.
• Won of 8 Certificate of Appreciation in Takeda project in from 2010-2014 as an Oracle DBA.
• Won 2 times most prestigious Confidential excellence Award (ACE Award) in FY 2013-14.
• Individual (Non-Executive) - Award for Excellence in Business Operations
• Team - Award for Delivery Excellence
• Successfully completed 400+ database migrations where database size is more than 800 GB
• Successfully completed 100+ database Production and non-prod restorations.
• Maintaining RMAN backup where database size is 40 TB ( Tera byte )

TECHNICAL SKILLS

• HP-Unix, Red Hat LINUX, Aix, Solaris WINDOWS
• Sun Solaris 8/9/10,Sparc,Opteron - AIX4.3), Linux, Oracle Enterprise Linux 5.5
• Oracle EXADATA, Oracle 11g RAC, 12c, 11g, 10g and Oracle 9i, RMAN,
• SQL Server, SQL, PL/SQL
• Installation, Patching, Upgrade and Reorganisation of databases.
• Database Migrations cross platform migrations using transportable tablespaces
• Disaster Recovery, Production database restorations, Backup planning
• Performance Monitoring, Analysis and Performance Tuning
• Database Recovery (DR) strategy planning and implementation
• Capacity Planning and implementation
• Partitioning, Replication and Database Administration
• 12c Grid Control, RMAN,Datapump, DataGuard
• TKPROF, AWR, ADDM, OEM
• SQL Navigator
• PL/SQL Developer 7.0, SQL *PLUS
• Oracle Enterprise Manager (OEM)
• Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump)
• Quest Toad 8.5, BMC
• VERITAS Netback up 5.3/6.0/6.5
• UNIX Shell Scripting, SQL, PL/SQL, Perl
• Siebel, Galaxy, Argus safety, Argus Insight, Oracle EBS

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Handling 140+ databases including 20+ RAC two nodes and 20 + Dataguard
• Working on EXADATA X3-8 and X2-8 Full RAC machines and super cluster server.
• Successfully completed 11g to 12C database migrations for 50 + databases.
• Implemented database refresh architecture using from storage snap copy.
• Implemented database backup and refresh process.
• Successfully completed 11g to 12C DATAGUARD migrations (10+ standby databases).
• Configured standby databases and hands on experience in building DR environment
• Responsibilities included installing, upgrading, migrating and applying patches to Oracle
• Daily Support, Regular Maintenances on Dev/QA/Prod RAC / Non RAC Environments
• Performed many database reorganization activities for database space management.
• Installation, configuration and administration of Oracle 9i/10g/11g
• Configuration/Scheduling maintenance RMAN logical backups

Confidential

Oracle DBA

Responsibilities:

• Handling 150+ databases including 65 RAC two nodes environment.
• Working on EXADATA X3-8 and X2-8 Full RAC machines
• Handling 20+ DATAGUARD two nodes RAC standby databases.
• Successfully completed 11g to 12C database migrations for 100+ databases.
• Successfully completed 11g to 12C DATAGUARD migrations (20+ standby databases).
• Maintaining RMAN backup where database size is 46 TB ( Tera byte )
• Performed many database reorganization activities for database space management.
• Installation, configuration and administration of Oracle 9i/10g/11g
• Configuration/Scheduling maintenance RMAN logical backups.
• Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups
• Configured standby databases and Hands on experience in building DR environment
• Responsibilities included installing, upgrading, migrating and applying patches to Oracle
• Daily Support, Regular Maintenances on Dev/QA/Prod RAC / Non RAC Environments.
• Done 24*7 On Call Support.
• Administration of ASM, Disk Addition in diskgroup, mount/dismount of diskgroup, Co-ordination with storage/Unix team, disk addition after checking and confirming candidate disk in ASM.
• Experienced production database restoration by moving Prod Database to new server.
• Management of Database storage structures at physical and logical levels - Data Blocks, Segments and Extents.
• Exposure to SQL Server 2008/2012
• Installed SQL Server 2012 on Windows 2008.

Confidential

Oracle DBA

Responsibilities:

• Handling oracle 500+ databases including 25 RAC environments.
• Handled more than 25 Major migration projects within Takeda including ISIS, Siebel, Argus, Cars, Trackwise, Meddra, C&P, and Galaxy etc.
• Successfully completed 300+ Migrations in project ISIS - DB size 800GB.
• Successfully completed 100+ database restorations including Production Databases.
• Maintaining RMAN backup where database size is 20 TB ( Tera byte )
• Defined DB refreshes process for various environments from production to Dev/Uat databases
• Extended nodes in RAC Cluster. RAC Rolling Patching.
• Installing Oracle RAC 11g Databases.
• Cross platform database migration using transportable tablespace.
• Performance tuning, hot standby databases, database cloning and patch management.
• Cloned databases using RMAN and cold backup
• Performed disaster recovery for production databases using RMAN backup
• Managing RMAN backup where database size is 20 TB ( Tera byte )
• Database capacity planning for a new application deployment.
• Implemented scripts and performed switchover/failovers with DATAGUARD as required.
• Installation, configuration and administration of Oracle 9i/10g/11g
• Configuration/Scheduling maintenance RMAN logical backups.
• Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups
• Configured standby databases and Hands on experience in building DR environment
• Responsibilities included installing, upgrading, migrating and applying patches to Oracle databases.
• Ability to manage high availability solution centres using Oracle Real Application Clusters (RAC) with several nodes.
• Proactive monitoring, identifying areas that need to be improved in the application and
• Database using Statspack, AWR, ADDM, and OEM Grid Monitoring.
• Clone/Refresh of Production databases to Testing and training environments
• Performed daily service management activities related to change, incident and problem management, as well as coordinate and/or participate in team and customer meetings.
• Analysed and tuned Oracle database / instances using EXPLAIN PLAN, AWR Reports,
• Advanced Database Diagnostic Monitor (ADDM), StatsPak, SQL*TRACE and TKPROF.
• Design and implementation of database backup strategy and performed full, incremental and
• Cumulative backups using RMAN.
• Provide 24/7 monitoring of database operations to ensure top operating efficiency
• Installed and implemented Physical Standby Dataguard using ASM and non-ASM file systems.
• Worked on different kind of storages like ASM, OCFS2.
• Perform Full database refresh and imp/exp tables from production database to Dev/Uat/Stg Including refresh of Oracle data warehouse tables (Table size 900GB)
• Daily maintenance work and administration of Oracle RAC.
• Space management at database level & OS level. Co-ordination with Storage/Unix/Windows team, space addition in existing drive/mount point after considering future database space requirement.
• Daily Support, Regular Maintenances on Dev/QA/Prod RAC / Non RAC Environments.
• Done 24*7 On Call Support.
• Administration of ASM, Disk Addition in diskgroup, mount/dismount of diskgroup, Co-ordination with storage/Unix team, disk addition after checking and confirming candidate disk in ASM.
• Experienced production database restoration by moving Prod Database to new server.
• Management of Database storage structures at physical and logical levels - Data Blocks, Segments and Extents.
• Generated Database Performance Reports and Global, Global Difference AWR Reports, done comparisons, created Baselines.
• Exposure to SQL Server 2008/2005.
• Installed Sql Server 2008 on Windows 2008.
• Management of logical Database objects including Tablespaces, Tables, Constraints, Roles etc.
• Performed production database restoration from tape backup.
• Performance tuning of Oracle 9i/10g database.
• Restoration of tables using flashback recovery.
• Daily maintenance activities of database.

Confidential

Oracle DBA - Team Lead

Responsibilities:

• Cloned databases using RMAN and manual copy.
• Database restoration, disaster recovery.
• Installation and configuration of Oracle 9i/10g/11g single instance database as well Real Application Clusters (RAC)
• Database Migrations using datapump and cold backup.
• Database Installing, upgrading, migrating and applying patches to Oracle databases.
• Responsible for creating standard database creation scripts, installation, upgrades, contacting Oracle collaborative support for critical issues.
• Proactive monitoring, identifying areas that need to be improved in the application and
• Database using Stats pack, AWR, ADDM, and 10g OEM Grid Monitoring.
• Analysed and tuned Oracle database / instances using EXPLAIN PLAN, AWR Reports,
• Advanced Database Diagnostic Monitor (ADDM), StatsPak, SQL*TRACE and TKPROF.
• Installation of Oracle 9i & 10g and creation new database on Linux/windows.
• Creation and management of tablespaces, tables, indexes, views, synonyms, user accounts, space allocation, roles privileges and tablespace quota.
• Administration of ASM, Disk Addition in diskgroup, mount/dismount of diskgroup, Co-ordination with storage/Unix team, disk addition after checking and confirming candidate disk in ASM.
• Experienced production database restoration by moving Prod Database to new server.
• Management of Database storage structures at physical and logical levels - Data Blocks, Segments and Extents.
• Import export and managing Archive Logs.
• Created tablespaces and managed tablespaces adding/deleting/ resizing data files.
• Experience in creating necessary Documentation for Change Control according to company's standards.
• Upgraded the database from Oracle 10.1.0.3 to 10.2.0.1 on Linux platform.
• Extensively Installed Oracle10g on Linux Platform.
• Doing space management work by adding or resizing datafile.
• Performing user managed and RMAN backup and recovery.
• Troubleshooting, managing large transactions, Monitoring Sessions and other database issues
• Analysing alert log for oracle errors.
• Technical team member in IT department in application support and hardware support.