SUMMARY

• Oracle Certified Database Administrator having 7.9 years of professional experience as Oracle Database Administrator and good experience in Database Installation, Database Administration, Up - Gradation, Migration, Installing Patches & Performance Tuning.
• Extensive knowledge on database administration for Oracle 9i, 10g 11g and 12c, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Hands on experience in Installation of 12C RDBMS S/W, INSTALLATION OF 12C RAC AND HANDY IN CONFIGURING DATAGUARD ON 12C
• RAC Installation and Maintenance, setting up and configuring Data-guard, performing all kinds of Backups and Recoveries, Cloning databases,
• Good experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup
• Handy in Migrating Single Instance databases to RAC Environment.
• Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. ACTIVE DATAGUARD & SNAPSHOT STANDBY
• Maintained Data-guard SERVER and involved in trouble shooting issues.
• Maintained Catalog Server and involved in registering the Databases in Catalog Server.
• Hands on experience in Grid Control 10g & Grid Control (11g) and INSTALLED 12C for database Monitoring/Performance/Diagnostics.
• Experience in Performance Tuning, Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace,Tkprof, Analyze, ADDM and Explain Plan Methods.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table-spaces PATCHING AND UPGRADATION from 10.2.0.x to 11.2.0.4
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

TECHNICAL SKILLS

Databases: Oracle 8.x/9i/10g/11g, SQL Server 2000/2005/2008/2008 R2

Tools: SQL*Loader, OEM, RMAN, SRVCTL, DBCA, BMC patrol, CSSCAN, Data Guard, Instance Manager, Export managers, Data Mover, Import Manager, Object Security, DBNEWID, Toad and Foglight.

Storage Tools: Tivoli Storage Manager (TSM), Veritas Net Backup, Litespeed.

Languages: Shell Scripting, PERL, SQL and PL/SQL.

Job Scheduler: AUTOSYS, SQL Server Agent

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr.Oracle DBA

Responsibilities:

• Worked as operation database administrator (ODBA) and Responsible to provide 24x7 database administrative activities over different database servers.
• Installed RAC on RHEL 5.8 11GR2 and involved in migration of databases to RAC environment.
• Involved in capacity planning, Tuning the RAC interconnect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Maintaining ASM in RAC environment and Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment(11GR2).
• Installed DR for database using Data Guard IN RAC& NON RAC environments.
• Configured Physical Standby databases using data guard and converted Physical standby to Snapshot Standby and active data-guard depend on Business Requirement.
• Maintained DR server and troubleshooting issues in Data Guard environment.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM).
• Installed grid control and registered Databases in OEM.
• Used Oracle Enterprise Manager to protect sensitive data in production databases.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems.
• Applied patching on 10g/11g and Involved in Up-gradation of HP- UNIX databases from 10.2.0.x to 11.2.0.x.(11gr2)
• Used Expdp and Impdp for exporting and importing of database objects between databases.
• Used RMAN for backups and recovery and configured databases in Catalog server and involved in backup of Catalog database.
• Scheduled Oracle Jobs USING DBMS SCHEDULER and Backups using CRONTAB.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Assisting in implementation of change control process in production.
• Handled daily production problems/change requests (DBCRS) with Oracle.
• Performed Zero-Down Time migration from Hp-unix to RHEL.
• Configured Extract and Replicate pumps for Golden gate replication and troubleshootingissues in GOLDENGATE Environment.
• Data Refreshfrom Production to Test and Development environments using RMAN Duplicate Database.
• Performed data refresh at Schema level using EXPDP.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured and Installed Oracle-Wallet-Management (OWM) forData Security.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF and Tuned the SQL’s using TKPROF and STATSPACK reports.
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Involvement in day to day activities like Space management, rectification ofLock problems, managed quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment.
• Scheduled and attended day to day meetings as part of agile methodology.

Environment: Oracle 11g/10g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM,12C(Grid Control), RAC 11gR2, 12C, Explain Plan, DBMS SCHEDULER, Oracle-Wallet-Management, SQL Developer, PL/SQL Tuning, Data Pump.

Confidential, MN

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.
• Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X
• Worked on large databases size greater than 12TB.
• Involved in designing of Disaster Recoveryusing Data Guard and High Availability using 11gRAC.
• Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.
• Performed various tasks on ASM, creating a disk group, Adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Installed Golden gate on source and target side for Replication and implemented load balancing topology using Goldengate.
• Configured Golden Gate Parameter files for Extract and Replica process for replication.
• Used Shareplexto provide Data Accuracy and Integrityto ensure that target instances are accurate representations of the source database.
• Performed automated backups and scheduling using scripting.
• Configured RMAN and registered databases in Catalog server.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases.
• Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Worked on Building schemas, cursors, developedStored procedures and database triggers in PL/SQL.
• Performed Quick System Review by using Education Performance Index (EPI), System Performance Index (SPI), Memory Performance Index (MPI). Disk Performance Index (DPI). And calculated the Total Performance Index (TPI).
• Created User accounts, Roles and granting required access permissions and privileges.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.

Environment: Oracle 9i, 10g, 11g, HP-Unix, Linux, RMAN, DBCA, GOLDENGATE, Dataguard, EXPLAIN PLAN, Cloning, OEM, STATSPACK.

Confidential, NE

Oracle DBA

Responsibilities:

• Installed and configured 2 Node RAC on 10gR2.
• Monitoring Health check in RAC environment.
• Installed 13 standalone servers on ASM and migrated databases to ASM environment.
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converting Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Responsible for Installing, Upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database Performance.
• Restored and Recovery of databases at the times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Identified and fixed the logical block corruption using RMAN.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in configuration files like Listener.ora, Tnsname.ora for Client - Server environment using network configuration assistant.

Environment: Oracle9i/10g, windows, Linux, RMAN, DBCA, Informatica, GOLDENGATE, Data guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK.

Confidential

Oracle DBA

Responsibilities:

• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Performed Auditing on user activities on request and per organization policies.
• Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.
• Configured Recovery Manager (RMAN) and Performed Hot, Cold and Incremental backups for production databases using RMAN.
• Performed Cloning and Refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Identified and fixed the logical block corruption using RMAN
• Involved in taking logical backup using Data pump Exp-dp and Imp-dp Utility.
• Performed Data load on different databases from flat file using SQL*Loader.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.

Environment: Oracle 9i/10g, Red Hat Linux, SQL, TKPROF, STATSPACK, OEM, PL/SQL.