SUMMARY

• Over 8 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Hands on experience on Oracle (9i/10g/11gR1/11gR2, 12C), installed and configured on different platforms like Windows, Linux, RHEL, Oracle Solaris, HP-UX., IBM-AIX
• Worked on Different operating systems for OLTP & OLAP environment on Very Large Databases (VLDB)
• Experience in configuring high availability systems like Real Application Clusters (RAC)
• Experience in installation of Oracle RAC with ASM and manage RAC instance using CRSCTL and SRVCTL utility
• Involved in migrating production databases single instance to RAC environment
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Data guard
• Having good experience in migrating databases with zero downtime across the cross platforms
• Hands on experience on Oracle Exadata Database Machine Implementation and Maintenance
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Experience in installation and configuration of Oracle Gloden gate (GG) (both unidirectional and bidirectional)
• Proficiency with Installation and maintenance of replication tool Gloden Gate by creating extract process, extract pump, and replicate
• Implemented Gloden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Gloden Gate issues such as extract, replicate rebuild and abend
• Experience in using Gloden Gate in moving large volumes of transactional data, with minimal impact to online systems
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports using OEM
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance
• Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, data files and databases using RMAN
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology
• Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems
• Utilized SQL* Loader to migrate or load data to Oracle
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage
• Worked on different types of storage structures (SAN/NAS)
• Expertise in SAN/NAS migration and Re-IP
• Good written and verbal communication skills, self-motivated team player and good analytical thinking
• 24*7 on-call production database support and maintained remotely
• Leading, Motivating and coordinating team of developers with excellent interpersonal skills.

TECHNICAL SKILLS

Operating Systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

RDBMS: Oracle 11gR2 RAC, 10gR2 RAC, 9i, 8i, SQL Server 2005.

Languages: C, C++, UNIX shell scripts, PL/SQL

DB Management: TOAD, OEM 10g/11g and 12c

Tools: /Utilities: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control, SQL and ETL tools for above database environment, Export/Import, RMAN, Data Pump, Winscp3 and ERWIN. HTML and XML, SQL NET, ODBC, TCP/IP

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM and ASH

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Installed and configured 11.2.0.3, 11.2.0.4, 12.1.0.2 RAC on the Linux servers with ASM as a storage for the database files
• Worked on cluster builds by installing the Grid Infrastructure and RDBMS Homes
• Migrated 12c RAC databases to Exadata Full Rack with Container and multiple pluggable Multi-Tenant architecture
• Upgraded databases from 11.2.0.4 to 12.1.0.2 Multi-tenant architecture.
• Migrated databases with Zero downtime using Glodengate.
• Worked on converting Standby databases to Snapshot standby for application testing and rollback.
• Configured physical standby databases using Oracles Data guard technology for the high availability
• Involved in the BCP (Data guard switchover) testing to see if the application can function on the standby site
• Worked on Gloden gate repoint while supporting BCP testing.
• Worked on Glodengate High availability like installing and configuring DBFS and ACFS
• Supported Uni-Directional Gloden gate replication with 6 source and 1 target database.
• Supported Heterogeneous Gloden gate with MS SQL and Oracle environments.
• Involved in Exadata CELL patching.
• Applied Oracle quarterly released patches (PSU’s) to the CRS & RDBMS homes which fixes the bugs in the Cluster and database environment in a rolling fashion
• Extensively involved in the ASM san add, like expanding the Diskgroup and removing disks from the Diskgroup and creating new Diskgroups
• Optimized query result cache for best performance.
• Involved in the performance tuning and troubleshooting of the database with lower performance and checking the AWR & ADDM reports and analyze them.
• Worked with OBIEE, Web Sphere, Informatica and IBM teams for troubleshooting and optimizing database performance.
• Supported Application BAU deployments across all environments.
• Worked on Flashback Guaranteed restore point to support as a rollback mechanism for high level code changes to application.
• Upgraded the Grid infrastructure (CRS & ASM) from lower version (eg: 11.2.0.2) to 11.2.0.3 & 11.2.0.4
• Installed and created the Databases on the clusters and cloning the RDBMS homes across the clusters
• Expanded the clusters from 3 node to 4 node & 2 node to 3 node using Oracle best practices
• Installed Glodengate software of versions 12.1.2.1.0 and 11.2.1.0.22
• Cloning Production databases to the SIT & UAT environments for testing using snapshot backup process
• Worked on auto refresh scripts to refresh Pre-Production with Production data.
• Worked on Data pump API for Expdp and Impdp.
• Used RMAN for taking backups of the databases (Full and Incremental)
• Worked on compliance management - Set of rules defined to all the databases, which must be compliant as per the company policies
• Retiring the database once the application is no longer functioning and reclaiming the space Confidential the OS level and the database level
• Involved in capacity management - Annual growth of databases and estimating the SAN required for the upcoming year with co-ordination with the application team
• Worked on the change management ticketing process to create CR (change request), PT (Problem tickets) to make any configuration changes and issues encountered in the database and cluster
• Worked with My Oracle support (MOS) for various issues across the environment
• Working with the off-shore team and coordinating the work with them
• Handled on-call support (14 X 7) on a rotation basis

Environment: Oracle Exadata, Red Hat Linux RHEL 5.x and 6.x, Windows 2007/2010, Oracle 11g/12c, Active Dataguard, SQL, PL/SQL, UNIX Shell Scripting, EXPLAIN PLAN, STATSPACK, AWR, ADDM, EMC, DAN Sql Developer, RMAN, OEM, SQL* Loader, Expdp, Impdp, TOAD 12.6

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Worked on Migrating the databases to AWS environment.
• Worked on installing Oracle 12c in AWS environment.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Configured and supported INB applications using Oracle Fusion Middleware.
• Worked on migrating Oracle databases to Exadata as POC.
• Involved in troubleshooting issues related to Oracle Discoverer.
• Installed and configure Glodengate on 11g and 12c databases.
• Worked in supporting Deployment and Code releases.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Troubleshooting and maintenance of RMAN backups and user managed backups.
• Experienced in configuring and troubleshooting Banner ODS application.
• Supported in scheduling Job submission and SSB applications.
• Applied CPU/PSU patches for oracle database version 11.2.0.4.4.
• Supported 24x7 Oracle Production Databases using Oracle 11g/12c databases
• Worked on server builds which includes GI and DB home installation applying the latest PSU patch for both standalone and RAC databases
• Worked on planning and implementing PSU patching
• Worked on database of size 40 TB on a 5 node RAC in production environment.
• Setting up refresh jobs from production to non-production
• Migrated Oracle database from Solaris to Linux using XTTS
• Implemented downstream integrated capture method for the cross-platform migration of an Oracle database
• Worked on Glodengate and Dataguard setup and maintenance
• Worked on Glodengate unidirectional replication
• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Installation of Oracle Enterprise Manager (OEM) Grid Control for environment standardization
• Implemented scripts, which monitor database health check Confidential regular interval, upon error, send email to the concerned person.
• Cloning the database for test environments which is used for release testing
• Provided DBA support for load tests and endurance tests during release testing in lower environments
• Participated in DR exercise discussions, PSU patching and rollback strategy planning
• Setting up automated jobs for flashback database to facilitate release testing using Shell scripting
• Performance monitoring and performance tuning using different tools like AWR, SQL trace, TKPROF, Explain plan
• Working with application programmers, developers and contributing to the development process
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Configuring and monitoring daily backups using RMAN and Data Pump export

Environment: Oracle Server 12c and 11g/10g, SQL, PL/SQL, RAC, RHEL6, Oracle Discoverer, AWS EC, Oracle Dataguard and Gloden gate.

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Installed and configured 11.2.0.3, 11.2.0.4, 12.1.0.2 RAC on the Linux servers with ASM as a storage for the database files
• Worked on cluster builds by installing the Grid Infrastructure and RDBMS Homes
• Configured physical standby databases using Oracles Data guard technology for the high availability
• Involved in the BCP (Data guard switchover) testing to see if the application can function on the standby site
• Worked on 12C OEM by installing agents on the servers. Adding targets to the OEM once the cluster and DB’s are created
• Extensively involved in the ASM san add, like expanding the diskgroup and removing disks from the diskgroup and creating new diskgroups
• Upgraded the Grid infrastructure (CRS
• & ASM) from lower version (eg: 11.2.0.2) to 11.2.0.3 & 11.2.0.4
• Installed and created the Databases on the clusters and cloning the RDBMS homes across the clusters
• Expanded the clusters from 3 node to 4 node & 2 node to 3 node using Oracle best practices
• Installed Glodengate software of versions 12.1.2.1.0 and 11.2.1.0.22
• Worked on Glodengate High availability like installing and configuring DBFS and ACFS
• Cloning the Prod databases to the SIT & UAT environments for testing using the snapshot backup process
• Upgraded the databases from lower version to higher version
• Worked on Flashback Guaranteed restore point to support as a rollback mechanism for high level code changes to application.
• Applied the Oracle quarterly released patches (PSU’s) to the CRS & RDBMS homes which fixes the bugs in the Cluster and database environment in a rolling fashion
• Worked on the compliance management - Set of rules defined to all the databases, which must be compliant as per the company policies
• Retiring the database once the application is no longer functioning and reclaiming the space Confidential the OS level and the database level
• Involved in capacity management - Annual growth of databases and estimating the SAN required for the upcoming year with co-ordination with the application team
• Used RMAN for taking the backups of the databases (Full and Incremental)
• Worked on the change management ticketing process to create CR (change request), PT (Problem tickets) to make any configuration changes and issues encountered in the database and cluster
• Involved in the performance tuning and troubleshooting of the database with lower performance and checking the AWR & ADDM reports and analyze them
• Worked with My Oracle support (MOS) for various issues across the environment
• Working with the off-shore team and coordinating the work with them
• Handled the on-call support (14 X 7) on a rotation basis

Environment: Oracle 11g/10g, RAC, Active Dataguard, 12c OEM, Linux, Solaris, Compliance management, PAC2000, Gloden gate.

Confidential, Richardson, TX

Oracle DBA

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Configuration and maintenance of Oracle 11gR1/11gR2 on Linux, and Solaris.
• Configuration and maintenance of 11g RAC and Single Instance database environments.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Configured and implemented Oracle 11g Active Data Guard for Database Disaster Recovery by using DATA GAURD broker (DGMDRL).
• Performed cross platform migration from Solaris to LINUX and AIX to LINUX using RMAN convert database.
• Experience of installing, configuring Glodengate Replication from OLTP databases to Data warehousing environments.
• Troubleshooting Glodengate issues in both development and production environments.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Troubleshooting and maintenance of RMAN backups and user managed backups.
• Implemented Backup-using RMAN (Recovery Manager) as media management layer
• Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using data pump and Gloden Gate replication.
• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Exp/Imp) and Data Pump Database backup (Hot & cold).
• Performed Range Partitioning as a cause to improve the performance of the database.
• Installation of Oracle Enterprise Manager (OEM) Grid Control for environment standardization
• Implemented scripts, which monitor database health check Confidential regular interval, upon error, send email to the concerned person.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Created a process using Maven and Shell scripts to build new environments in less than 30 min.
• Writing PL/SQL triggers, procedures, and functions.
• Strategic content infrastructure for managing documents, images, rich media files, and records in Management
• End-to-End content lifecycle management from creation to archiving.
• Contacting different teams like developers, data architects, release management for database changes and deployment activities.

Environment: Oracle 10gR1, 10gR2, 11gR1, 11gR2, 12c with RAC, Data Guard, ASM, Gloden Gate, SQL, PL/SQL, Erwin, SVN, GIT, Maven, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager.

Confidential, SFO, CA

Oracle DBA

Responsibilities:

• Configured and Upgraded to Oracle 11gR2 from 10g.
• Installed OEM Grid Control 11g and configured it server targets for a centralized monitoring system.
• Configured Physical Standby databases and logical Standby database for Active Data Guard.
• Upgradation of databases applying patches, patch sets and critical patch updates.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Optimized the query result cache for best performance.
• Troubleshooting RAC ASM and Oracle Cluster ware related issues.
• Proficient with Standby Database, Data Guard and Replication.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Extensively used AWR, ADDM for database performance statistics.
• Worked on TSPITR using RMAN.
• Oracle Database and SQL Tuning using EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Written SQL scripting to monitor the extent growth.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Solid discipline in providing end-users timely updates on their problems and installing server software.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Monitor Maintain/administer existing databases security with Oracle database environment.
• Worked on Load balancing and performance tuning on RAC environment.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.
• Performing automatic product deployments and repeated database maintenance and monitoring tasks.
• Implemented scripts, which monitor database health check Confidential regular interval, upon error, send email to the concerned person.
• Importing of dumps using Impdp/Expdp utilities.
• Loading bulk data from flat files using sql*loader and external tables.

Environment: Oracle 9i/10g/11g/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP/2003/2008, HTTP, F-Secure SSH, F-Secure FTP, Oracle Enterprise Manager, TOAD.