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
• SUMMARY OF QUALIFICATIONS
• DataGuard, Golden Gate Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery Standby/Failover Administration
• Database migration and cloning Database - Backed Web Solutions
• SQL Tuning in an Oracle Environment Data Profiling, querying and reporting on multiple RDBMS
• Oracle RAC (Real Application Cluster) setup and tuning. Backups and recovery using shell scripting and RMAN
• Migration/ Import,Export Advanced performance tuning & monitoring

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential

Environment: Oracle 9i/10g/11g,12c, TOAD, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Guard, Grid Control, Linux, IBM AIX, RHEL, Windows, ASM.

Responsibilities:

• installation, setup, and creation of two node cluster RAC Oracle 12c database using GRID infrastructure with ASM file systems on RHEL.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle10g Automatic Storage Management (ASM).
• Install, patch and upgrade Oracle 10g/11g and 12c to support internal production and test environments.
• Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4, 12.1.0 and 12.2.0 and tools including: TOAD, ASM, Cloud Control 12, Oracle Grid, Database Cluster RAC 11g and 12c
• Designed and build Data Guard
• Strong applicable skills with DataGuard ( Disaster Recovery )Technology
• 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.
• Involved in performance tuning and logical administration of application objects.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Implemented proactive monitoring using tuning pack such as EXPLAIN PLAN, Diagnostics Pack, and STASPAACK, SQL Trace and alerlog
• Used ASH, ADDM and AWR report to monitor the database performance.
• Automatic shared memory management (ASMM) for performance diagnosis/tuning and automatic segment space management (ASSM).
• Created physical standby databases using RMAN with zero downtime,
• Performed failover and switchover using Data Guard broker and manually as when required.
• Setup and maintenance of DATA GUARD for Disaster Recovery and reporting purpose with various modes.
• Database Cloning for Logical and Physical Standby server
• Database refreshes using export/import and datapump.
• Migrate Oracle databases with datapump or transportable tablespace
• Perform schema REMAP using exp/imp data pump utility
• Refresh tables, schema and other database objects with exp/imp
• Backup database, schema and tables with exp/imp datapump
• 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.
• Restore of database by script. Recovery of full database by applying archive and redo logs. implementation of Data Guard and RAC technologies in critical systems, configured switch over and failovers with physical standby database on UNIX environments.
• Upgrade/migrate databases from Oracle 9i to 10g.
• Installing Oracle Goldengate on RHEL and setup table level replication as well as DDL replication.
• Successfully configured physical standby database with Oracle 11g/12c RAC database.
• Researched and recommended Oracle Goldengate for migration/replication.
• Installed and configured Oracle Goldengate into development environment.
• Installed and configured Oracle Goldengate Director, Client and Monitor.
• Managed Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, and Trace files for the database.
• Creating automate scripts to take backup of database by RMAN, imp/exp at data file and user level.
• Restore of database by script. Recovery of full database by applying archive and redo logs.
• Frequently monitored database level parameters for performance issues and tuned SGA, Optimizing SQL Queries.
• Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding indexes and gathering Stats on a timely basis
• Maintained cluster servers to provide high availability.
• Responsible for data integrity and concurrent data, locks and deadlocks.

Oracle DBA

Confidential

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

Responsibilities:

• 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.
• 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
• 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.
• 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.