SUMMARY:

• To offer my skills and experiences in the field of Information Technology in a creative and collaborative environment where my analytical and technical skills will contribute to the overall goal of the organization
• DataGuard, Performance Tuning & Capacity Monitoring.
• Data Security, Backup & Recovery Standby/Failover Administration.
• Database migration and cloning Database - Backed Web Solutions.
• Data Profiling, querying and reporting on multiple RDBMS Oracle RAC (Real Application Cluster) setup Backups and recovery using shell scripting and RMAN Migration/ Import,Export

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential

Environment: Oracle 11g,12c, Exadata, TOAD, (OEM), RMAN, RAC, Data Guard, Grid Control, Linux, Confidential AIX, RHEL, Windows, ASM.

Responsibilities:

• Replicated to a disaster recovery site for increased server manageability and availability.
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Configured Confidential for active-active configuration in a multi master replication environment
• Installation, setup, and creation of four node cluster RAC Oracle 18c database using GRID infrastructure with ASM file systems.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle10g Automatic Storage Management (ASM).
• Upgrading Oracle databases from 11.2.0.4 to 12.1.0 to 13c etc in an Production and Test environment
• Applying Oracle Patches (patching the storage servers, compute nodes, grid, databases and infiniband switches)
• Created physical standby databases using RMAN with zero downtime,
• Performed failover and switchover using Data Guard broker and manually.
• Worked on disaster recovery of physical standby failover/switchover/loss of service rebuild/corruption/loss of datafile testing.
• Active Data Guard configuration on servers ( production and standby )
• Database refreshes using export/import and datapump.
• Analyze and resolve Wait Events for performance tuning
• Install, patch and upgrade Oracle 10g/11g and 12c 13c etc to support internal production and test environments.
• Strong skills in applying security patches (patch set, critical patch updates (CPU) / Patch Set Updates (PSU)Developed procedures, functions and different forms.
• Oracle Enterprise Manager OEM Grid Control GC for various database activities like monitoring Target databases servers, scheduling jobs, monitoring performance issues implementing suggestions, setting up alerts, patch implementation, Data Guard management.

Oracle DBA

Confidential

Environment: Oracle 11g, Grid Control, Confidential AIX, RHEL, Windows, ASM, RAC, RMAN

Responsibilities:

• Creating automate scripts to take backup of database by RMAN, imp/exp at data file and user level.
• Frequently monitored database level parameters for performance issues and tuned SGA, Optimizing SQL Queries.
• Maintained cluster servers to provide high availability.
• Responsible for data integrity and concurrent data, locks and deadlocks.
• Installed, configured and maintained Oracle Databases on Linux, UNIX and Windows Platforms.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Installation and Configuration of 11g Grid Control. 12c 13c
• Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.
• Managed user accounts and assigned appropriate privileges
• Performed Database duplication with RMAN
• Installed, configured Oracle Database Software using Oracle Universal Installer
• Performed Database Backup, restore and recovery using RMAN
• Carried out bulk inserts using SQL*Loader
• Upgraded database using patchset
• Migrate Oracle databases with datapump or transportable tablespace
• Perform schema REMAP using exp/imp data pump utility
• Perform partition maintenance like truncating partitions and adding new partitions.
• Perform database level 0 or level 1 backup with RMAN backup
• Restore and recovery database from disaster from RMAN backup
• Scheduled RMAN backup procedure for daily basis using CRONTAB.
• Perform cloned, migrated databases using RMAN
• Setting up schedule RMAN Backup using DBMS SCHEDULER and CRONTAB in Sybase or Oracle environment.
• Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.
• Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.
• Disaster recovery implementation using physical standby databases for high availability.
• Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Created, Upgraded, and Cloned Oracle databases for Development and testing databases.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms. .
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose's.
• Implemented proactive monitoring using tuning pack, Diagnostics Pack, and STASPAACK, SQL Trace and EXPLAIN PLAN.

Oracle DBA

Confidential

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL, RAC, ASM,, DataGuard, AIX 5.x/6.1, Linux RHEL 4.x/5.x, Windows, TOAD.

Responsibilities:

• Tuning database for optimal performance using AWR, ADDR and Advisors.
• Diagnosing and resolving issues associated with the Database
• Setup and configured database network connectivity
• Resolved issues related to database connectivity, user quota and storage issues
• Effectively applied knowledge of database architecture, logical and physical database structures for design, planning and problem solving
• Schedules backups with Enterprise Manager.
• Monitored alert log and trace log files daily for potential problem identification and resolution
• Documented all important database related topics, issues, resolution and changes
• Creation, management and modification of database objects - Tables, indexes and synonyms
• Delivering accurate and timely logging of issues and resolution in ticketing system (Contactual 8x8)
• Participated in seminars, workshops and continuous learning events
• Implemented Oracle Database 11g, 2 node Real Application Cluster(RAC) using Oracle Clusterware for achieving high Availability on ASM.
• Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.
• Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.
• Used ASH, ADDM and AWR report to monitor the database performance and start with wait events.
• Implemented ASM disks and disk groups on RAC and stand-alone/two node database and defined TAF policy for RAC instances.
• Efficiently performed installation, setup, and creation of two node cluster RAC Oracle 12c database using GRID infrastructure with ASM file systems on RHEL 6 and 7.
• Planned, tested and implemented backup strategy using RMAN, Oracle utilities (expdp/impdp) and OS methods.
• Maintaining sound backup and recovery policies and procedures using RMAN
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Created physical standby databases using RMAN with zero downtime, performed failover and switchover using Data Guard broker and manually as when required.
• Implemented DataGaurd (Standby) for high availability/disaster recovery purpose and configured the database to Switchover and failover.
• issues implementing suggestions, setting up alerts, patch implementation, Data Guard management.
• Provide necessary technical support for fixing the bugs in interacting with end users.
• Involved in testing, integration system test, implementation and documented the entire project.
• Worked on disaster recovery of physical standby failover/switchover/loss of service rebuild/corruption/loss of datafile testing.
• Implemented proactive monitoring using tuning pack, Diagnostics Pack, and STASPAACK, SQL Trace and EXPLAIN PLAN.