SUMMARY:

• Full responsibility and expertise in Database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, database migration of Oracle instances and SQL - server databases.
• Excellent communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing backup, restoration and recovery using RMAN (Full and incremental)
• Resolved/Diagnose Node Eviction.
• Add or Remove Node from RAC
• Remote administration and support of Oracle production and development databases on major operation system with sizes up to 11TB
• Experience in Installation of Oracle databases 9i, 10g, 11g and 12c versions.
• Experience in the Upgrade of Oracle Databases in Patch set level and in version level (9i to 10g), (10g to 11g) and (11g to 12c)
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle streams.
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery full/partial, datapump export/import
• Extensive experience in configuring and implementing ASM and proficiency inn using ASMCMD and ASMLIB
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities
• Experience in applying patches like Critical Patch Updates (CPU), Patch set updates (SPU), and one-off patches, Interim Patches, DST, Patch set as per the Oracle recommendations.
• Handled Multiple issues with Data Block corruption on ASM Disk
• Upgrading and Migration Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with Prod/Pre-prod Databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience in Implementation of enterprise databases on enterprise Storage Solutions using Storage Area Network (SAN) /Network Attached storage (NAS)
• Implementation of Flashback Technology, log Miner, Automatic Database Diagnostic Manager (ADDM)
• Proactive monitoring of the Database’s health and taking preventive or corrective actions
• Proficient in Database Design (Physical and logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN
• Used EXPDP & IMPDP to take backup at Database level or tablespace level and to accomplish table level and full database de-fragmentation
• Proficient in using various database Utilities like Export/Import, Data Pump, TOAD
• Experience in Extracting, Transforming and loading (ETL), data using SQL loader Utility
• Automated many common tasks using crontab including Backups, exports and imports.

TECHNICAL SKILLS:

Operation Systems: Red Hat Linux and Windows

RDBMS: Oracle 12c/ 11g/10g

Languages: SQL, PL/SQL

Software/ Applications/ Tools: DBCA, DBUA, Recovery Manager(RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Cluster (RAC) ASM, SQL Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL*PLUS

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM

WEB TOOLS: HTML, XML

WORK EXPERIENCE:

Confidential, Wilmington, DE

Oracle Database Administrator

• Support development team for all database-related issues and help to manage the ASM disk groups
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux, providing support to the development team and handling release schedules
• Database refreshes using export/import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance
• Maintaining sound backup and recovery policies and procedures using RMAN, Monitoring the scheduled backup procedures for daily basis using crontab
• Database refreshes using export/import and datapump. Use RDA, ADDM and AWR reports to monitor the database performance
• Cloned/ Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11g
• Worked on disaster recovery of Exadata data guard, physical standby, failover/ switchover/ loss of service/ rebuild/ corruption/ loss of datafile.
• Automated monitoring the databases, performance parameters, backup and recovery activities.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuild indexes, query tuning using SQL Trace, TKPROF, Explain Plan, TOAD
• Responsible for network configuration and involved in client-server environment using TNSnames, LISTERNER, Net Configuration Assistant and other configuration files.
• Creating, granting and monitoring user access rights and privileges through roles and profiles
• Providing instances level performance monitoring and tuning for Events waits, sessions, physical and logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic shared Memory Management (ASSM) for performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Support the development efforts by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottleneck by using tools explain plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages DML, DDL, Oracle tablets, stored procedures, functions, cursors, triggers and UNIX shell scripts.
• Generated and automated AWR reports from Oracle database and analyzed the reports for Oracle waits events, time consuming SQL queries, table space growth and database growth
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge Join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Addressed developer/testers requests to clone production databases for the purposes of testing using RMAN
• Applied PSU Patched (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for the loading data to and from databases, logical backups and migration of databases.
• Monitoring and optimizing the performance of the database/application using OEM
• Capacity planning, Allocate system storage and plan future storage requirements
• Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL profiler and SQL optimizer, foglight
• Monitoring rollback segment and temporary tablespace use
• Performing housekeeping tasks like checking log and trace files
• Performing database refreshes, migration and performance tuning of Peoplesoft application environments
• Setup and maintenance of physical standby database using Database using Data Guard Broker and active Data Guard for faster Disaster Recovery.
• Installed and configured OEM grid control for maintenance administering the databases
• Daily Health checkup of all the Databases using Oracle Enterprise Manager 12c
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required
• Performed full and incremental backups using RMAN for development and production databases
• Database cloning from Production to Test and Development environments
• Extensively worked on applying patches (CPU & PSU) whenever required.
• Schema refreshing of database using normal copy method exp/imp utility.
• Cloning database and schemas using Database pump for 10g and 11g versions
• Cloning 10g and 11g databases using RMAN duplication (with and without backup).
• ASM Disk storage and User Management
• Monitoring the Hit Ratios and tuning the system Global Area (SGA) accordingly.
• Performance tuning for optimized results using tools like Explain Plan, SQL* Trace, TKPROF, STATSPACK, AWR, ADDM.
• Troubleshooting of various database performance by proper diagnosis at all level like SQL, PL/SQL, Database design, database talents, indexes, instance, memory, operating system and java calls
• Knowledge in Oracle Data warehouse, DBA skills relating to administration and management of VLDB environments, Oracle OLTP
• Installed and configured Oracle 11g database on a test server using Oracle standard procedure and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/12c RAC/10g, VMS, Windows Server 2003, Red hat Linux, TOAD, RMAN, SQL server, OEM.Tools Used: Oracle 10.2.0.1, Oracle stream, RMAN, Datapump, SQL TRACE, TKPRDF, EXPLAIN PLAN.