SUMMARY:

• Have over 8 years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing.
• Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Comprehensive experience as Oracle DBA; proficient in Oracle 9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i on Unix and Windows NT platform.
• Involved with architect group in designing the logical and physical model of the databases.
• Thorough understanding of the Oracle data dictionary.
• Have good experience in UNIX administration, Shell scripting.
• Have impeccable communication and interpersonal skills and an exceptional team player. Managing the team of Oracle DBAs and actively coordinated with the end user community.
• Real Application Cluster
• Involved with installation and maintenance of ORACLE 10g/11g RAC 2 node and adding a node to this cluster database for high availability.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Clusterware setupand configuration, RAC installation using ASM, Grid Installation)
• Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
• Managed RAC Cluster using SRVCTL and CRSCTL and applied patches in rolling Fashion
• Oracle Enterprise Manager
• Setup Oracle Enterprise Manager (OEM) 11g & Grid Control (12c) for database monitoring/performance/diagnostics.
• Hands on experience in managing databases from Grid control
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• ASM
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash - Back Technology, Log Miner.
• Done migration from non ASM database to ASM database.
• Responsible for maintaining every day backups and also to maintain ASM and disk space.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS)
• GoldenGate
• Configured and replicated databases using oracle Goldengate.
• Experienced with cross site (active-active) data replication using Golden gate.
• Hands on experience working with Golden gate director and configured ODI to use oracle Golden gate for change data capture.
• Implemented zero downtime migration and upgrade of 10g to 11g database using oracle Golden gate.
• Replicated certain columns from a table and also certain values from columns by using oracle Golden Gate.
• Migrated databases using Golden Gate and RMAN for 2node RAC.
• Implemented Broadcasting andBi-directional Replication.
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on Experience in using Active Dataguard and Snapshot standby databases
• Good knowledge on Logical Standby databases
• Upgraded databases from 11gr2 to 12C using DataGuard.
• Extensive knowledge and experience on DataWarehouse using ETL.
• Good experience in PATCHING AND UPGRADATION.
• Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g
• Upgrading of database from lower version to higher version using opatch.
• Upgrading of databases from 10.2.0.x TO 11.2.0.x. and 11.2.0.x to 12.1.0.2
• Installed security patches, performed patching on oracle Database server 10g and 11g using O-patch utility.
• Extensive experience in oracle upgrades, Critical Patch updates (CPU), Patch set updates (PSU) and other oracle patches.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the databaseenvironments
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Performance Tuning and Miscellaneous
• Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQLTrace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Provides platform-specific performance tuning, installation and configuration
• Extensive knowledge on database administration for Oracle 9i, 10g and 11g, with experience in very largescale database environment and mission critical large OLTP and OLAP systems
• Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD for querying databases etc.
• Exposed to Data Warehouse assignments in various domains like Medical services, Sales, Insurance, Financial & Bank, Inventory Distribution, and Production Data warehouses
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams
• Experience as On-Call 24x7 production DBA support, application/development DBA

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.6,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x, 5.x, 6.x and windows 2000/2003/2008

RDBMS: Oracle 11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASM

Tools: and Utilities RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Tivoli Storage, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting, COBOL

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

WORK EXPERIENCE:

Confidential, Norfolk, Virginia

Senior Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Database on 11g and 12c
• Created User accounts, Roles and granting required access permissions and privileges to the databasebased on the applications they are accessing.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading to Oracle 12c to the latest Oracle 12c and applied patches as required.
• Installed, Configured and Administered STREAMS and good knowledge on GOLDEN GATE.
• Performed Schema as well as Table Level Replication using Oracle Streams
• Migrated databases using Golden Gate and RMAN for 2node RAC.
• Implemented Broadcasting and Bi-directional Replication.
• Implemented and Configured Golden gate in 2 node RAC cluster for flow into EDW.
• Resolved replication issues in Golden gate.
• Automating tasks using Cron for GG restart.
• Hands-0n experience in converting integrated to classic extract and vice versa.
• Implemented 12c New Features in Golden gate
• Upgraded Golden gate from v10 to v11.
• Architect Golden gate (10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Implemented and Monitored Data Guard on Oracle 11g and 12c in maximum performance
• Implemented Dataguard and configured standby databases for critical databases using Dataguard and Export and import of database objects using EXPDP and IMPDP.
• Cloned schemas, objects and data on new server using Data pump.
• Involvement in space management, rectification of lock problems, managed quotas.
• Table partitioning to improve I/O access
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database orData Pump
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment
• Perform health checks using crsctl and managing services using srvctl
• Performance Tuning for the SQL queries which are running slow and taking more CPU cost
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Query optimizing using CBO(Cost Based Optimization) and Scheduled Oracle Jobs and Backups using CRONTAB.
• Restoration and Recovery of databases at the times of occurrence of critical failures
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN and Scripts.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf
• Applied Security Patches from Metalink when needed and Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 11g/10g, HP-UX UNIX RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad, Informatica.

Confidential

SR .Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware andresponsible for high availability and load balancing.
• Very good Knowledge on 11g New Features.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical andlogical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storagestructures and objects, databasebackup and recovery, monitoring and optimizing database performance.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Oracle streams AQ (Advance Queuing) in integrated application environments.
• Configured and implemented Oracle Streams (AQ and dequeuer) for high availability.
• Good skills in configuring and implementing down streams, Queues database.
• Very Good Knowledge on oracle streams
• Oracle streams AQ client/ server communication.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN,Hot backups, Cold backups and Logicalbackups.
• Performed automated backups and scheduling using scripting.
• Experienced in dealing with Query execution plan, SQL trace, TKprof.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases,DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(NetworkConfiguration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Working Experience with Latest TOAD having new features HealthPLSQL& SQL Script Debugger, Database Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM),
• Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operationalenvironment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & changerequests for future .

Environment: Oracle 11g/10g, HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, Informatica, VERITAS Net Backup

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11g databases on Linux and also Upgraded Oracle databases from 10g to11g version.
• Implemented Oracle Database 11g Two node Real Application Cluster (RAC) using Oracle Cluster-ware andresponsible for high availability and load balancing. * Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical andlogical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storagestructures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the databasebased on the applications they are accessing.
• Renaming and Resizing the databases and Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logicalbackups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point intime recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases,DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(NetworkConfiguration Assistant) for creating Client-Server environment using Listener, TNSnames etc., * Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database HealthCheckup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operationalenvironment.
• Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reportsfor the management to act in advance.

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0, 5.xRMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Informatica, PL/SQL and Toad.

Confidential

Oracle DBA/ PL/SQL Developer

Responsibilities:

• Performed full and incremental Backup Using RMAN Utility for Production databases.
• Involved in Upgrading the databases using Database Upgrade Assistance(DBUA)
• Performed cloning and refresh of Database from production environment to test environment using RMANDuplicate database and Data pump import export.
• Handling service requests within Service line agreement.
• Involved in configuration files like Listener.ora,Tnsnames.ora for Client-Server environment using networkconfiguration assistant.
• Identified and fixed the logical block corruption using RMAN.
• Performed Data load on different databases from flat file using SQL*Loader.
• Performed Hot backup, cold backup and incremental backup for production database using RMAN.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary action to rectify them. Environment: Oracle 9i/10g, Red Hat Linux, SQL, TKPROF, STATSPACK, OEM, PL/SQL

Environment: Oracle 9i/10g, Sun Solaris, HP-Unix, UNIX, Linux 4.0, 5.xRMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Informatica, PL/SQL and Toad