SUMMARY:

• Expertise in Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database.
• Oracle certified associate with over 7 years of experience in Oracle Database Administration, Applications DBA managing E-Business 11i and R12, tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Oracle Database Administration in a variety of environments like Oracle Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning RAC .
• GoldenGate replication implementation
• GoldenGate Unidirectional and bidirectional replication.
• GG DDL Replication
• GG Heterogeneous replication using Golden gate Oracle 11.2.0.3 to SQL Server 2008 R2
• Experience in installing, maintaining, upgrading and patching Oracle versions 11g/10g/9i.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Experience in database full Backup hot and cold , Incomplete Backup, DataPump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Migrations and Control-M jobs.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in using Oracle Enterprise Manager 10g Application Server Control to manage Oracle Content DB.
• Actively involved in managing the Oracle Content DB instance by starting and stopping the nodes, services, and servers, tuning the system to ensure reliability and performance, creating, modifying, and deletingsites, as well as registering custom workflow processes.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed 10g Grid agent on servers and configure OEM Grid control.
• Tuning with STATSPACK, ADDM, V views, ASH, TOP, netstat, vmstat, iostat and prstat.
• Data Loading using SQL Loader and DBVERIFY for corruption checking.
• Strong SQL development, SQL analytics and tuning skills.
• Used parameters to configure, install and manage ASM instance in 10g RAC.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems DSS Data Warehouse environments.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experience in using oracle Streams for replication of database.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, and Recycle Bin.
• Experience in using System Development Life Cycle SDLC .
• Experience with supporting GxP systems.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experience in ERWIN Data modeling and MS Visio for E-R diagrams and Logical, Physical layout designs.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD, MySQL, PostgreSQL, Cassandra.
• Experience in Very Large Multi Terabyte Database VLDB and also performed migrations in this environment.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Documented all Oracle database installations and database operations
• 24 7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS:

• Database: Oracle 11g/10g/9i, RAC 11g/10g, MySQL, PostgreSQL,Cassandra,SQL Server.
• Applications Oracle EBS 11i/R12, Oracle Application Server 10g AS.
• Operating System: Linux, HP-UX 11/11i, Sun Solaris, AIX and Windows NT/2003/2008R2
• Languages: SQL, PL/SQL, C , C, UNIX Shell Scripting
• Tools/Utilities: SQL Loader, DataPump Export/Import ,OEM, RAC, TOP RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF, Crystal Reports, Oracle Grid Control, Log Miner, ERWIN, Golden Gate.
• Web Tools: HTML

PRACTICAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities: Worked as the Member of Data Management Organization supporting production issues and actively involved in the migrations as a part of upgradation.Responsible for both managing and supporting all Production, Development, Stage instances of Oracle Version 10g and 11g databases.

• Configured Disaster Recovery Environment with 11g Data guard using DATAGUARD BROKER
• Installed and managed 11gR2 RAC database and 10g Database R2 10.2.0.5
• 11g Grid Control
• Responsible for implementing Veritas cluster file system on LINUX OS and 11gR2 database in the production and Test environment.
• Experience in using Oracle Enterprise Manager 10g Application Server Control to manage Oracle Content DB.
• Architect GoldenGate 10.x and 11.x replication solutions to facilitate data flow between
• heterogeneous SQL Server and Oracle environments
• DDL replication using Golden Gate
• Oracle RAC Administration tools.
• RAC all node patching, Rolling patching
• Oracle RAC database configurations utilizing Veritas Cluster Server VCS , GoldenGate
• And Data Guard to ensure maximum availability and data protection.
• Recovering GoldenGate corruptions and managing host/cluster maintenance mode blackouts
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated
• Environments utilizing GoldenGate .
• Installed and Configured 11gRAC with DG setup
• GoldenGate Unidirectional and bidirectional replication
• Managing and setting up the configuration of GoldenGate Director
• Develop custom utilities to automate manually intensive tasks including mass schema changes,
• Responsible for applying patches on database using opatch on GOLD environment.
• GG DDL Replication
• Responsible for applying CPU patches on most of the production databases.
• Worked on cloning instances from production to dev and stage environments.
• Worked with application team and performance team to help them tune their queries.
• Worked extensively on Enterprise manager Doing Blackouts, Adjusting Thresholds etc
• Installed Oracle 10g database and Implemented RAC with Data Guard on HP/UX and Linux.
• Set and document standards for use of databases to use Data guard in Maximum availability mode.
• Responsible for testing the behavior of 11gR2 RAC database using Veritas cluster file system.
• Working collaboratively with teammates across the technical teams.
• Provided support to setup Dataguard and Dataguard Broker on development and test environments.
• Building Clone instances for Development and Test teams.
• Installing and maintaining a 4 node RAC 11gR2 database.
• Installed Oracle Configuration manager on various production environments.
• Experience in Migrations and Control-M jobs.
• Configured, created and Managed Oracle Data Guard in a real Applications Clusters RAC Environment.
• Provide technical assistance to all internal/ external customers and team members during system problems and implementation.
• Experience of working on MySQL, PostgreSQL, Cassandra.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11,

AIX 5,Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, GoldenGate, OEM, RMAN, SQL Loader, Oracle Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP, Tivoli Access Manager, SQL Server.

Confidential

Oracle DBA

Worked as a Confidential team to solve customer's most pressing problems. This project deals with Data Center Migration and Delivery and Hosting Operations. It includes installation of oracle 11g RAC, upgrades, Dataguard reconfiguration and improving the performance of database, maintenance of standby database, ASM, backup and recovery using RMAN and applying patches.

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.1.0.6 by applying patches using Opatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Performed performance tuning using Explain Plan, SQL Trace, TKPROF, Statspack, ASH.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Cloned database for test environment.
• Migrated 10 databases 14TB from SQL Server 2000/2005 to Oracle 11g database.
• 24x7 on-call production database support.
• Administering Real Application Cluster RAC databases running on Cluster File system.
• Migrated database objects from database to other server by using Export/Import, Datapump.
• GoldenGate Unidirectional and bidirectional replication
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX KShell Scripts.
• Experience of working on MySQL, PostgreSQL, Cassandra.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup's logs and alert logs.
• Experience in using Oracle Enterprise Manager 10g Application Server Control to manage Oracle Content DB.
• Created Materialized views, groups for performing SQL Loader jobs for data loading and use datapump jobs for loading the subscriber and history related data at replicated site.
• Configured user log on load balancing and failover on RAC database
• Database Capacity Planning configuration redo and stream sizes , design staging schema and use of DBMS STREAM ADM packages.
• Handful of experience with ERWIN tool for data modeling.
• Actively involved in managing the Oracle Content DB instance by starting and stopping the nodes, services, and servers, tuning the system to ensure reliability and performance.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager OEM .
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Assisting developers in getting database connection from the client using SQL net and Net8.
• System wide tuning using UTLBSTAT and UTLESTAT stat pack .
• Maintained Very Large Multi Terabyte VLDB around 14TB in Data Warehouse Environment for DSS.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.
• Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11,
• AIX 5,Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, GoldenGate, OEM, RMAN, SQL Loader, NetAPP NFS,Oracle Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP, Tivoli Access Manager.

Confidential

Oracle Database Administrator

Worked on one of the largest and most sophisticated business intelligence and marketing database. The project deals with installation of Oracle 10g RAC with ASM, migration of database, setup and maintain standby database, RMAN backup and recovery and performance tuning.

Responsibilities:

• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• 24 x 7 production support group member supported by our team.
• Installed, Created and maintained 3 Node 10g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• Migration of Database from 9.2.0.6 to 10.2.0.2 RAC
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces TTS , Export/Import and Datapump expdp/impdp .
• Manage and maintain database and user security using OEM Grid Control,SAN.
• GG DDL Replication
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager OEM .
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Writing backend procedures, functions, packages and triggers using PL/SQL and also kshell scripts for automatic recovery
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Data Loading using SQL Loader and DBVERIFY for corruption checking.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX servers using IOSTAT, NETSTAT, VMSTAT, TOPAS and PRSTAT.
• Designed physical and logical database structures and created, managed Tablespaces.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures
• Applying upgrade patches, maintenance and interim patches on all the databases
• Applied High priority patches downloaded from Metalink.
• IBM IAM Products Tivoli Access Manager, Tivoli Identity Manager .
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathering schema stats and monitoring the index usage.

Documented backup and recovery plans and tuning procedures.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11,Windows 2003, AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL Loader, Grid Control, GoldenGate, RMAN, ASM, Dataguard, TOAD, Datapump.

Confidential

Oracle Administrator

This project deals with installation, migration, and RMAN backup setup standby database and performance tuning.

Responsibilities:

• Installing Oracle 9i/10g RAC on AIX and RHEL creating database for production, development and test environments.
• Assisting developers and 24 7 production database supports.
• Backup of database Logical and Physical hot and cold procedures and also using RMAN, Complete and incomplete recovery of database
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Migration of database from 9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN's New Features and Data guard stand by database
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL Loader jobs.
• Periodically uploading data from flat files using SQL Loader
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Estimation and creation of Control file, Log file including multiplexing , Data files, Tablespaces and rollback segments.

Environment: Oracle 10g/9i/ RHEL, IBM-AIX, Windows NT, RMAN, Datapump, SQL, PL/SQL, exp/imp, TOAD, OEM, RMAN, SQL Loader.

Confidential

Oracle Administrator

The work involves overall Maintenance of Oracle Database, Performance Tuning, Backup, Recovery and other database related activities.

Responsibilities:

• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Diagnose and Troubleshoot Database Problems and failures
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Wrote PL/SQL subprograms Packages, Procedure, functions and DB triggers.
• Debugging of PL/SQL Procedures, Functions, Packages, Views and Triggers in order to rectify errors
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the Better performance.

Environment: Oracle 10g/9i , IBM-AIX, Windows 2003, RMAN, Datapump, exp/imp, SQL, PL/SQL, TOAD.