RAJ

ORACLE DATABASE ADMINISTRATOR

Over *+ years of experience in Oracle Database Administration encompassing Installation,

Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery,

Cloning, Replication, Database Security, Memory Management, Data Modelling,

Performance Monitoring and Tuning, RAC, Data Guard, Grid Control and Enterprise

Manager.

Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, HP-Unix, IBM-

AIX and Sun Solaris in OLTP and OLAP environment.

Performed Migration and Upgrade of databases to 11g and 10g

Up gradation of databases applying patches, patch sets and critical patch updates.

As a DBA we use to give permissions to access the LDAP databases.

Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g

and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).

Experience on Oracle 12c/11g/ASM/RAC and up gradation of standalone databases to 11g RAC

environment and 12c standalone environment

Installed and Configured Enterprise manager OEM12C and 11g.

Configuration of Automatic Storage Management (ASM)

Configuration and Management of Data Guard on RHEL, OEL and Windows.

Experience with Data guard broker configuration and switchover.

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 on Data Replication using Snapshot, Materialized views, import/export.

Regular database synchronization for test database environments through automation.

Installation and configuration of RMAN with and without Recovery Catalog.

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, and data pump export/import.

Migration of the databases from one platform to another platform.

Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.

Knowledgeable on Oracle Streams.

Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data

loading.

Knowledge on Exadata Smart Scan technology which improves query performance by intensive query

processing and data mining scoring to scalable intelligent storage servers.

Worked on Oracle Exadata X3-2, SuperCluster M6-32 Servers.

Knowledge and working experience of working on Oracle 12c Databases.

Detecting and diagnosing production system performance problem by analyzing STATSPACK reports,

Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database

activity, Querying Oracle dynamic performance views.

Monitoring and Optimization of database performance through database tuning, system tuning and

application tuning.

Experience in SQL Tuning, Optimization, cost based optimization and Hints

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,

TKPROF, STATSPACK, and SQL TRACE.

Proficient in INDEX REBUILDING and INDEX TUNING

Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux

monitoring using NMON and TOP commands.

Experience working with Database Resource Manager

Working experience in creating materialized views.

Experience using Erwin as a Data Modelling tool & Designing the ETL processes

24*7 on-call production database support and maintenance including remote database support

Assisting in implementation of change control process in production.

Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS:

Operating Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x, 6.x HP-UX 10.x, 11.x, Sun Solaris

Systems 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Data Bases Oracle 12c/11gRAC/10gRAC/10g/9i, EXADATA

Languages SQL, PL/SQL, C, C++, UNIX Shell Scripting, JAVA

Tools/Utilities RAC, OEM Grid Control, SQL Navigator, SQL* Loader, ASM, SQL Server,

Export/Import, RMAN, SQL Developer, DB Artisan, TOAD, Patch

Management, SQLNET, ODBC, Export/Import, Data pump, Data Guard,

VERITAS Net Backup, AVAMAR,VMware, Log miner, Crontab, Oracle

Golden Gate, Streams

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

Terminal Putty, Telnet, FTP

Emulation

PROFESSIONAL EXPERIENCE:

Pepsico/HCL America Inc., Frisco, TX July 2016

Till Date

Role: Sr. Oracle DBA

Responsibilities:

Upgraded databases from 11g to 12c in multiple platforms like Suse Linux, HPUX Itanium.

Resolved invalid components after the upgradation of database.

Resolved backup issues reported in the DBR report that includes both netbackup/tape and disk

related backups.

Applied patch set updates to database and grid homes.

Daily activity includes resolving the SRs raised through service manager tool and pro-active

involvement of any P-1 and P-2 incidents.

Maintained Datagaurd standby databases across all the environments.

Migrated databases in RAC environment by setting up RAC to standalone physical standby and

activating the standby during the cutover window.

Resolved db link issues for the migrated databases.

Worked closely with the application teams to tune the sql statements and achieve the desired runtime.

Setting up the OID entries for all the databases to accomplish the application connectivity.

Environment: Oracle 9i/10g/11g/11gR2/12c, RAC EXADATA, AIX, SOLARIS, HP-UX, Redhat

Linux, OEM 12c, RMAN, NETBACKUP, OID

Este Lauder Companies, Melville, NY Oct 2015 Jun

2016

Role: Sr. Oracle DBA

Responsibilities:

Database Technologies like Oracle Data Guard /fast start failover, Oracle Internet Directory, Oracle

Enterprise Manager, Oracle RMAN were implemented.

Experienced in switching primary database to standby and standby to primary during regular

maintenances of catalog databases and DR databases.

Performed switchover and failover in a data guard environment.

Critical applications migrated included SAP etc.

Migrated approx. 500 TB of actual Database storage with Near Zero downtime approach.

Migrated databases using cross platform transportable tablespaces method.

Database migration between physical to physical and physical to VMware virtual machines.

Implemented a new 11.2.0.4 feature - Reduce Transportable Tablespace Downtime using Cross

Platform Incremental Backup.

Successful Disaster Recovery implementation & testing.

Upgraded databases from 11g to 12c and configured standby.

Data migration from old systems to Oracle EXADATA (V2/X3-2) using different methods

e.g. EXPDP/IMPDP, Transport Tablespaces and etc.

Upgrading Oracle Database from 11.2.0.2.0 to 11.2.0.3.0 in Oracle EXADATA.

Ensuring SLA timings by taking and restoring backups from PROD to TEST EXADATA.

Successful implementation & testing of Unique Rolling Maintenance / High Availability design.

Successful Performance, SAP Functional & Integration testing with the newly migrated systems, inside

Isolated Landing Zone.

RMAN / DDBOOST & (EMC Time Finder Clone) were implemented, as the SAP Oracle database

backup methodologies.

Control M jobs along with Nimsoft agents were deployed for automated SAP Oracle DB monitoring

capabilities.

Oracle Data Guard was tested with SAP application tier to provide Rolling Maintenance / Automated HA

failover capabilities.

Worked in BI/BW/PORTAL/SOLOMAN/PI environment like upgrades and check sap marketplaces for

downloads from sap support.

Configured Physical Standby (Data Guard) databases for the Production Databases.

Worked on SAP BRTools Like BRCONNECT,BRRESTORE,BRSPACE,BRARCHIVE

Extensively performed development database refreshes using data pump and RMAN.

Configuring and Monitoring RMAN backups and performing recoveries.

Performed MySQL database refreshes using phpMyAdmin tool.

Implemented bi-directional Golden Gate replication between production and lower environments.

Refresh of the development and Test databases using Golden Gate re-instantiation with datapump

export as an initial load.

Handled new Projects for stabilizing environment like OEM 12 Cloud Control Build with customized

templates and 11G2 RAC Builds.

Creating RAC database with ASM and Data guard configuration which includes primary and standby

database creation

Efficiently managing backups and recovery through RMAN which includes RMAN duplication, refresh

and cloning in Standalone, RAC and data guard Environment.

Troubleshooting node eviction issues and applying CRS# bundle patch using Opatch utility for bug

fixing.

Troubleshooting RAC databases & ASM issues, network & database connectivity issues and Oracle

connectivity issues.

Performed Capacity Planning, Undo segments and Health check reviews in RAC.

Upgraded Oracle Applications 11i e-business suite to R12 for test, development environments.

Performed cloning of R12 Oracle Apps E-Business Suite which includes cloning of both database tier and

application tier.

Involved in Providing KT to team members.

Environment: Oracle 11g/11gR2/12c, RAC EXADATA, HP-UX, Redhat Linux, OEL, RMAN,

DDBOOST, MySQL, Oracle EBS R12

PEPSICO INC, Plano, TX Jan 2015 Sep

2015

Role: Sr. Oracle DBA

Responsibilities:

Support and duties related to ECC, BI, XI and Portal systems and OEM 12c on Oracle & Hana

Platform.

Worked on Brtools integrated with netbackup, HP Data Protector Tools and oracle enterprise manager,

oracle advanced compression.

Applied SBP latest oracle patches from SAP recommended June 2014.

Implementation of Oracle Internet Directory, Secured Oracle profiles / Dormant account locking, World

writable remediation, International security remediation & Guardium security policies / scans for

improved DB security practices.

RMAN / Netback up& Business Continuance Volumes ( EMC Time Finder Clone ) were implemented,

as the SAP Oracle database backup methodologies.

Oracle Enterprise Manager 12C was deployed for automated SAP Oracle DB monitoring capabilities.

Oracle Data Guard Fast Start Failover was tested with SAP application tier to provide Rolling

Maintenance / Automated HA failover capabilities.

Upgraded OEM from 11g to 12c.

Experience in maintaining/working on databases ranging from 5TB to 20TB size large databases.

Installed, Configured Golden Gate and Migrated Oracle databases from hp-ux to linux environment

utilizing Golden Gate.

Implemented Bi-Directional replication in golden gate.

Experience in setting up Golden Gate (11g and 12c) Configuration, Manage, Checkups and Troubleshoot.

Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in

GOLDENGATE Environment using LOGDUMP.

Implemented performance parameters in replicat process and also involved in Splitting replicats

which improved performance of Golden Gate environment.

All the SAP databases were moved from physical to VMware virtual machines.

Performed ASM disk remediation i.e., moving the underlined storage from vmdk to RDM disks.

Implemented Enterprise Manager Grid Control 12c to provide monitoring and management of the Oracle

database estate.

Performed a zero downtime cross platform database migrations using Oracle Golden Gate.

Configured and maintained Physical Standby databases for all Production Databases.

Configured RMAN backups and performed recoveries. Also worked on BCV snapshot technology.

RMAN cloning of multi TB databases from tape to development.

Installation of Oracle EBS R12 on RHEL platform both 12 and 12.2 versions

Patched Oracle Apps EBS R12 using ADPATCH utility.

Environnent: Oracle 9i, 10g/11g/11gR2/12c RAC, HP-UX, RHEL, OEL, GoldenGate, Oracle EBS

R12

FedEx Corp., Colorado Springs, CO Jan 2014- Dec

2014 Role: Sr. Oracle DBA

Responsibilities:

Installation, Configuration and administration of Oracle 11g/10g database on Red Hat Enterprise Linux

(RHEL) and also Up gradation from Oracle 10g to 11g.

Configured 3-node Real Application Cluster (RAC) and monitored RAC instance with Oracle

Enterprise Manager Grid Control.

Installed and Configured Oracle Enterprise Manager Grid Control 11g.

Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3-node RAC

environment.

Configured and Implemented Oracle 11g ACTIVE DATA GAURD for Database Disaster Recovery by

using DATA GUARD (DGMGRL) broker

Involved in configuration files like Listener.ora, Tnsname.ora for Client-Server environment using

network configuration assistant.

Configured Physical Standby databases and logical Standby database for ACTIVE DATA GUARD.

Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system

with two or four RMAN channels allocated per instance.

Scheduling the backups for the database using EM 12C cloud control.

Migration of database from one server to another server.

Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for

production database.

Installed, Configured and Administered Golden gate.

Configured parameters for the Bi-directional replication.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Performed day to day administrative tasks by analyzing the database like checking for failed processors,

verifying the query for particular issues and validating disk space.

Develop and enforce both database and OS-level security policies for data protection. Administer all

databases in the areas of maintenance, tuning, performance, and troubleshooting.

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER,

STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Developed Scripts for transferring data from production server to testing/development servers.

Shell scripting and PL/SQL programming to resolve business problems of various natures.

Managing databases on multiple servers.

Environment: Oracle 11g, 10g, Linux 4/5, OEM, DBUA, RMAN, Golden Gate, Grid, RAC, ASM,

Exadata X2-2, Data Guard, SQL* LOADER, AWR, ADDM, ASH, TTS, Data Pumps, Exports/ Imports.

Nintendo, Seattle, Washington Feb 2012 Dec

2013

Role: Sr. ORACLE DBA

Responsibilities:

Installed, configured and maintained databases on high availability systems like Data Guard and

Real Application Cluster environments

Involved in fresh installation of 11.2.0.3 RAC on Automatic storage Management and created

databases in RAC environment

Installed OEM repository database, 12c agents on hosts and discovered targets and created new

Groups, Templates, Incident Rule sets in OEM 12c

Configured Physical standby, Snapshot Standby and Active data-guard and performed

Troubleshooting data guard environment

Performed various activities on ASM, including partitioning, managing raid levels and performed

proactive capacity planning.

Up-gradation / MIGRATION of dev/test/prod databases from 10g to 11g

Migrated applications from Unix to Linux using golden gate with minimum down time and resolved

issues in golden-gate

Installed golden gate 11g version and upgraded golden gate from 10 to 11.1 on AIX

Applied patch set and interim patches whenever required to make the database software up to date

Involved in measuring smart scan, storage index and measuring offload statistics for individual SQL

Cursors on Exadata

used Flashback mechanism for logical corruption of databases

Installed and Implemented Backup & Recovery procedures, Implement Hot, Cold and Logical

backup plans

Performed tasks like Database Sizing, Table space Management and Rollback Tablespace

Management, Transaction Management and Security Administration

cloned databases for development and test environments using RMAN

Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS

Net-backup Team

Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in

space management, rectification of lock problems, managed quotas

Managed Oracle space, performed Oracle table space management tasks, maintained tables,

database objects and Rebuilding indexes for better performance of Oracle database.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning,

Database performance tuning

Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better database

performance

Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices

Involved in Writing SQL scripts to monitor table space and extent growth

Familiar with ORA-600 error & Involved with this ERROR

Provided support to Application Database Administrators in designing the database

Tested many scenarios in RAC, Dataguard and RMAN environment

prepared documentation for maintenance, knowledge transfer and Mentoring level 2 DBA's

24 X 7 Production database administration, support and monitoring to ensure Proactive problem

recognition and resolution of database issues

Environment: Oracle 10g/11gR2, Sun Solaris 5.9, RHEL 5.x, IBM-AIX 6.1, OEL 6.3, OEM 11g/12C,

EXADATA, RAC 10g/11g, ASM, Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH,

TTS.

Morgan Stanley, New York city, New York Mar 2010 - Jan 2012

Role: Oracle DBA

Responsibilities:

Installation, configuration and maintenance of Oracle 11g databases

Estimated growth of database size by detail analysis of the company's future policies and generating

reports for the management to act in advance.

Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3

Performed health checks of RAC instances using Crsctl and Srvctl utility

Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g

Configured pfile, Listener and Net service names manually for production and physical standby databases in

Data-guard environment

Migrated databases from File system to ASM & troubleshooting issues in ASM 11g

Installed Golden Gate for replication between cross platforms

Configured parameters files for extracts, replicat's and

Applied patches on standalone servers using Opatch utility

Performed Migration of databases from 10g Unix to 11g on Linux

Implemented data transfer using Data Pumps and Export/Import utilities

Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test

and dev. Environment

Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN

Configured listener for external procedure calls, Worked closely with ETL applications team

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas

configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective

management of Oracle networking

Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports

Develop and enforce both database and OS-level security policies for data protection.

Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with

ACFS access controls

Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data

Encryption

Involved in administration of all databases in the areas of maintenance, tuning, performance, and

troubleshooting and debugging SQL/PL SQL involved in Application development

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER,

STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN

Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups

and Developed Scripts for transferring data from production server to testing/development servers

Environment : Oracle 10g, 11g, RHEL 5.5, HP-Unix 7i, OEM, DBUA, RMAN, People-soft, Golden gate, Grid,

RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Oracle Wallet, TDE, Data pumps

Comerica Bank, Detroit, MI Nov 2009 Feb 2010

Role: Oracle DBA

Responsibilities:

Responsible for setup and implementation of 2 NODE RAC on 10g.

Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load

balancing by minimizing the interconnect traffic

Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.

Responsible for capacity planning, database security, recovery planning and installing patches

Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris

Installed 10.2.0.4 agent and involved in registering of databases in OEM

Installed STANDALONE servers on ASM and migrated databases to ASM

Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing

listeners, and adding them to the grid control

Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's

Implemented Disaster Recovery Plan for critical databases using DATAGUARD

Worked on physical and snapshot standby 11gR1 databases in Data-guard environment

Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD

Performed Database Refresh from production to testing and development environment and used EXPDP for

schema level

Worked closely with PL/SQL developers for fine performance tuning

Supported development teams by providing SQL statement tuning and removing load and query performance

bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF

Experienced in scheduling the database backup jobs using Crontab

Created a Clone database using RMAN on remote server

Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes

Involvement in space management, rectification of lock problems, managed quotas

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O

and Memory Usage.

Created and monitored database objects like Tables, Indexes, Views, Users and DB links

Conducted time to time analysis and monitoring of the software and hardware requirements and act

accordingly.

Environment: Oracle 11g/10g, Windows 2008, Sun Solaris 5.x, Oracle RAC, TOAD, VERITAS, OEM,

LOGMINER, Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

CAPITAL IQ, Hyderabad, India Aug 2008 - Oct 2009

Role: Oracle Developer/DBA

Responsibilities:

Involved in Up-gradation of databases from 9i to 10g

Configured listener and TNS names manually

Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.

Achieved High availability, Data protection and maximum performance by maintaining physical standby

databases

Implemented Oracle database backup & recovery solutions using RMAN

Configured and Tuned RMAN for better performance and backup strategies

Involved in writing for shell scripts for taking RMAN backups

Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition,

indexing and use of statistics

Restored and Recovered database at the times of occurrence of critical failures.

Created user accounts, roles and granting required access permissions and privileges to the database based on

the application they are accessing

Performed large batch jobs and tuning of SQL queries and database systems

Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs,

Archived Redo-logs and Alerts

Performed automated backups and scheduling using scripting

Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved

in gathering requirements from end users

Estimate growth of database size by detail analysis of the company's future policies and generating reports for

the management to act in advance

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change

requests for future reference

Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 7.x,OEM 10g, Shell Scripting, TOAD, putty,

STATSPACK,EXPLAIN PLAN.

EDUCATION

Bachelors of Technology from Acharya Nagarjuna University.

Contact this candidate