PROFESSIONAL SUMMARY:

• Accomplished Oracle DBA with 8+ years of experience in Oracle Database Administration in large - scale production environments across multiple platforms. Ability to provide expert-level technical support in all aspects of database administration including Installation, Configuration, Upgrades, Patching, Migration,Capacity planning, Performance Tuning and Backups & Recovery. Hands-on experience with Oracle Clusterware and Real Application Clusters (RAC) 10g/11g/12c, Data Guard and Golden Gate. Ability to work both as an individual contributor and as a member of a team. worked on upgrading of oracle databases from 11g to 12c. worked on building and rolling out new 12c databases for test/dev/qa/prod environments.
• Implemented oracle 12c active standby database for test database environment.
• Implemented oracle 12c flexi asm for pre-prod environment.
• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
• Installed,Configured Oracle 12c Goldengate on Oracle 12c Database.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Documented all Oracle 12c installation/Upgradation work and delived KT to all team peers.
• Contributed as an efficient/reliable team member for all business critical releases and changes.
• Utilized Accurev/Liquibase tool for code version change control activities.
• Performed the code reviews for all the db code coming into the database and fine tuned it before hand.
• Worked with IBM Veritas Active - Passive clusters.
• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Administered the tidal job scheduler for datacenter automation tasks.
• Worked on HP Quality Centre tool for test/dev/qa code drops and environment true-ups.
• Implemented oracle 11g goldengate for replication project.
• Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Worked with HP service guard on top of oracle 10g databases.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Prioritizing db related tasks on daily basis and completing most of them before the close of Business everyday.
• Participated in internal db team meetings with peers and management for db work/project status update.
• Worked with offshore team and co-ordinated with them always for any database changes by means of email/phone communication.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Experience in Applying PSU, CPU Patches to Oracle homes.
• Experience in creating maintenance plans to Index de-fragmentaion,re-indexing and update the index Statistics.
• Recovering the Database from Backup in Disasters,implementing Point-in-time Recovery Solutions.
• Extensively worked on Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for defferent RAC related issue such as Hang check,Split brain,RAC recovery,ASM,OCR corruptions,Voting disk loss,etc
• Backup and recovery issues related loss of OCR,Voting Disk and Oracle clusterware also issues with corruption of individual disk data blocks,loss of OS configuration files,loss of net configuration files.also used the merge backup for backing terabyte database.issues with block change tracking,also flash recovery area.
• Effectively deployed active data guard standby on 11g database for test and production environments and performed switchover drills for immediate availability.
• Implemented FSFO (Fast start failover) on databases through Data Guard Broker. Configured disaster recovery site and Snapshot standby databases.
• Good experience on various methods of backups like Cold, Hot and RMAN backups at different incremental levels including configuring RMAN for optimization, compression of backup sets, auto backups and parallelism.
• Skilled in performing logical backups and migrations using export/import utilities and rolling out extraction and load operations using Data Pump and including remapping of logical structures and transformation of flat-file data into structured logical data entries.
• Comprehensive knowledge and hands on expertise with Oracle Enterprise Manager (OEM) grid control infrastructure and TOAD.
• Expertness in Delivering SQL and Database performance tuning services via Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, OEM and analyzing SQL trace dumps for 10g/11g.

TECHNICAL SKILLS:

Database: Oracle 12c, 11g, 10g,9i,MS SQL Server2014,2012,2008

ERP: Oracle Applications 11i (11.5.10), R 12.1.3, R12.2)

Operating Systems: Windows 2008/2003,Sun Solaris, Linux Server, IBM AIX

Tools: Toad, SQL Developer, SVN, Discoverer Administrator, Discoverer DesktopBackup Utility,putty.Erwin,Sql*plus

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Database Administrator (DBA)

Responsibilites:

• Supported 24x7 mission critical applications which include different versions Oracle 10g/11gR1/11gR2/12c for Standalone and RAC Databases.
• Installation and configuration of 12c Container Databases on standalone servers and cluster on windows and unix platforms.
• Upgraded multiple Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.
• Worked New Features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.
• Experience in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment.
• Applied PSU on standalone TEST environment using OPatch and same PSU(Grid and RDBMS Patching) on production cluster using OPatch Auto.
• Supported in Performing GoldenGate configuration,administration,installation, also configuring pumps and managing trail files by purging old extract files and log files.
• Worked with customer for defferent RAC related issue such as Hang check,Split brain,RAC recovery,ASM,OCR corruptions,Voting disk loss,etc
• Backup and recovery issues related loss of OCR,Voting Disk and Oracle clusterware also issues with corruption of individual disk data blocks,loss of OS configuration files,loss of net configuration files.also used the merge backup for backing terabyte database.issues with block change tracking,also flash recovery area.
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Upgraded oracle goldengate from 11.1 to 11.2 version.
• Configured multiple golden gate environments,few extracting from online redologs and few other extracting always from Archive logs.(ALO Mode)
• Troubleshooting GoldenGate using GGSERR.LOG and logdump utility.
• Implemented oracle golden gate 12c with pluggable database options and validated on enterprise sand box environment.
• Installed goldengate plugin in OEM12c for enabling oracle golden gate monitoring.
• Implemented Physical Standby Databases on 2-node 11gR2 Real Application Cluster and automized scripts to delete archive logs that already applied to standby.
• Experience in creating maintenance plans to Index de-fragmentaion,re-indexing and update the index Statistics.
• Rebuilding the Indexes at regular intervals for better Performance.
• Duplicating Tablespaces And Databases from Production server to Test server as per customer requirement.
• Expertise in Active DataGuard, Snapshot using Dataguard Broker (DGMGRL) and RMAN.
• Generated AWR (Statspack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and also used new tools of 12c for security purpose.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Monitored CPU usage, I/O contention, memory, paging and identify the resource and performance bottleneck in both windows and Unix environment.
• Experience in matching the appropriate SCSI and LUNS and partititoning DISKS using Fdisk and making them ASM disks,
• Great Understanding of Network configuration in RAC environment and responsible for setting multiple clusters and advising network and storage team for using best practices for setting up Oracle RAC.
• Responsible for Logical and Physical data modeling(using Erwin Data Modelling).
• Monitoring Day to Day Backups, Logs & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Worked on database administering tools such as TOAD and OEM Grid control.
• Following Oracle duties for making Cluster Or Standlone Server ready for OS Patching and upgrading and Relinking Binaries once the patching is done.
• RMAN Cloning and Refreshes Using Advanced features of Datapump such as compression algorithm and stopping archive log generation while Imports.

Confidential, Milwaukee,WI

Database administrator(DBA)

Responsibilities:

• Upgrading oracle databases from 11g to 12c and implementing 12c databases for QA/test/dev environments, and applying one off patches and patch set updates as per Oracle upgrade matrix.
• Developing active standby and snapshot standby databases for 12c test database environments through the application of Data guard broker.
• Managed to work with OEM 11g and 12c and active 24x7 On-Call support for mission critical production environments.
• Good Experience with SQL Server 2005 online Indexing and Recovery Features.
• Installation of GoldenGate on 11g databases including implementation of OEM 11g Repository database, OEM 12c Agent and configuring GoldenGate plug-ins and upgraded GoldenGate in Oracle database for real-time data integration.
• Backup and recovery issues related loss of OCR,Voting Disk and Oracle clusterware also issues with corruption of individual disk data blocks,loss of OS configuration files,loss of net configuration files.also used the merge backup for backing terabyte database.issues with block change tracking,also flash recovery area.
• Analyzed goldengate issues from ggserr.log file and used logdump utility for troubleshooting.
• Configured multiple golden gate environments,few extracting from online redologs and few other extracting always from Archive logs.(ALO Mode)
• Upgraded oracle goldengate from 11.1 to 11.2 version.
• Implemented oracle goldengate for database migration worth size 1 TB using export/import data pump as initial load.
• Managing the data volume into SGA with minimal load on RAC interconnects and using the CELLSRV component of Exadata to scan the data blocks thereby minimizing inconsistency over data blocks.
• Worked on Exadata Smart Flash Cache technology for reliable improvements in IO processes through Resource manager for advanced compression.
• Deployed and configured 3 node RAC instances in 11g and performed production support with on-call pager and refreshes from Non-RAC to RAC environments including Faster Application Notification (FAN) and Load Balancing Advisory for RAC
• Performed Range Partitioning as a cause to improve the performance of the database.
• Worked with Database Monitoring tools like TOAD, BMC PATROL and Log Miner.
• Effectively handled primary switchover exercises for planned outages and database migration from SQL Server to Oracle using GoldenGate 11.2.1.
• Working with the GGSCI command interface in GoldenGate including adding, deleting group process including Extract, Replicate, Pump and Collector.
• Monitored the capacity of the Fast Recovery Area and worked on Flashback technology for retrieval of logical structures.
• Performed logical backups, Hot/Cold Backup and Recovery and Cloning using RMAN, VERITAS Net Backup in 12c databases.
• Assisted application developers and IT analysts during resource planning scenarios, change board meetings for change control, solid plans for disaster recovery and backup and effective strategies for storage issues.

Confidential, New york, NY

Oracle DBA

Responsibilities:

• Primary support for Oracle databases for different projects.
• Installed and configured Oracle 10g/11g Database on Sun Solaris and Linux advance Server for Development, Test and Production Systems.
• Installed and Configured 2 node RAC on RHEL with load balancing and using Automatic Storage Management (ASM).
• Configuration of RMAN for the RAC environment for backup and recovery.
• Performed Database Cloning to create TEST /DEV instances.
• Implemented Physical Standby Databases on 2-node 11gR2 Real Application Cluster and automized scripts to delete archive logs that already applied to standby.
• Duplicating Tablespaces And Databases from Production server to Test server as per customer requirement.
• Applied latest releases of the RDBMS Patches from Oracle to the Production and test instances to resolve few technical challenges & issues.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
• Responsible for oracle upgrade and data migration between same and different platforms.
• Responsible for proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, partitioning, installations and configurations on and as needed basis, apply patches and upgrades.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Tuned and optimized SQL Queries, SGA, and Disk I/O using Oracle Enterprise Manager and monitoring the AWR and ADDM reports generated from snapshots taken at the peak business hours.
• Scheduled Cron jobs for multiple database tasks like update table/index statistics, cleanup trace files, weekly development db refresh, daily export jobs etc.
• Created and maintained different database structures including tablespaces, datafiles, redo log files, rollback segments and renaming/relocating of data files on different servers.
• Provided 24x7 support. Willingness and flexibility to work beyond regular hours based on business demands.
• Handled loading operations from bulk flat files into structured tables using the SQL*loader utility.
• Deployed shell scripts using K-shell and scheduled CRON jobs for database regular tasks and opening, serving and managing tickets with Oracle Support Center (Metalink).

Confidential, San Diego, CA

Jr Oracle DBA

Responsibilities:

• Played critical role in Data Centre migration with 24*7 on- call support for mission critical production environments.
• Installation and configuration of Oracle databases (single instance) and installation and configuration of RAC instances in oracle 10g and 11g and Converting single instance databases to RAC databases.
• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Identifying and resolving resource contention issues and monitoring database performance.
• Troubleshooting based on Alert logs.
• Trouble shooting the databases for various dynamic issues during run time.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security. Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Enabled ddl replication in database and enabled supplemental logging.
• Designed multiple extract and replicat parameter files for overall replication.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.
• Worked on developing Korn Shell Scripts for automating backups and restoration. Worked on various recovery scenarios and performed switchover between primary and active standby 12c databases.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures. Worked on creating and managing both system level and object level roles and privileges for various users.
• Generating stats pack reports on regular basis to identify the database performance at peak load
• Tuning the SQL statement by analyzing the AWR and ADDM reports.
• Planning and implementing the maintenance activities to reduce fragmentation and improve performance.
• Performed REDO logs management and tuning by creating new log members and resizing them.
• Administered distributed transactions for a group of databases with distributed architecture and performing archrivals with exchange partition concepts.

Confidential, Hendersonville, NC

Oracle Developer

Responsibilities:

• Coordinated with the business users to collect requirements.
• Prepared requirement specification document that gives the comprehensive details about the requirements
• Worked on logical and physical data modelling.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Wrote form level, block level and item level triggers for validations.
• Prepared unit test cases and executed the same.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Incorporated the various database Integrity Constraints including user-defined ones for the above tables.
• Developed PL/SQL programs and SQL*Loader to export the payroll data to text format for bank purposes.
• Analyzed table and table size and column datatypes and primary/foreign key attributes.