PROFESSIONAL SUMMARY:

• Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL - server databases.
• Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Resolved/Diagnose Node Eviction.
• Handled Multiple issues with Data Block corruption on ASM Disks.
• Add or Remove Node from RAC.
• Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.
• Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.
• Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c).
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• 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.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g..
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
• Upgrading and migrating 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 Networks (SAN) /Network Attached Storage (NAS).
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
• Proactively monitoring 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, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Expert in setup of environment and installation of Oracle Golden Gate.
• Automated many common tasks using crontabincluding Backups, exports and imports.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

Hardware/Software: MySQL 5.1, PHP, Shell Script, Apache, NDB Cluster, LINUX 5.0,5.1, OSX

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 Clusters (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 - Salt Lake City, UT

Oracle Database Administrator

Responsibilities:

• Support development teams for all the database-related issues and help to manage the ASM diskgroups.
• Performed Replication using materialized views with a complete refresh/Fast refresh.
• Development of policy and procedures as they relate to database maintenance, security and archiving.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Increased database performance by utilizing MySQLconfig changes, multiple instances and by upgrading hardware.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• 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. Used RDA, ADDM and AWR reports to monitor the database performance.
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks 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 tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Configure and Install Oracle Exadata Databases Machine, performing Initial Elastic Configuration of Oracle Exadata Database Machine.
• Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
• Setting the Subnet Manager Master on Oracle Exadata Database Machine Full and Half Rack
• Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait 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 developers/testers requests to clone production databases for the purposes of testing using RMAN.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• 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 table space 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 Data Guard Broker and active Data Guard for faster Disaster Recovery.
• Installed and Configured OEM grid control for maintenance administering the databases.
• Worked on Oracle Golden Gate. Involved in environment setup and Installation of Oracle Golden database and Oracle Golden Gate.
• Successfully worked on the data replication between operational and analytical enterprise using Golden Gate.
• Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.
• UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 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 databases using normal copy method and exp/imp utility.
• Cloning database and schemas using Data 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 performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, 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.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/12c RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - Dayton, OH

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapumpexport/import utilities in Oracle 10gR2.
• Worked on disaster recovery of exadatadataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• 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 rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Installed, security, and maintenance of Linux based systems including Apache and MySQL 5.0.22 configuration.
• MySQL database administration on a large scale MySQL installation.
• MySQL database backup and recovery strategies and Replication and synchronization.
• Created, tested, and maintained PHP scripts, MySQL programming, forms, reports, triggers and procedures for the Data Warehouse.
• Created database application using PHP and MySQL as the database to monitor customer profiles and complaints.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN