RAJASHEKAR K Email: ad48ai@r.postjobfree.com

Oracle DBA Mobile: +1-281-***-****

CAREER OBJECTIVE

My objective is to secure a responsible position, achieve goals in a professional, organizational environment where my skills, contributions, abilities, accuracy, and efficiency are valued and can benefit organization growth and success.

PROFILE

Oracle DBA with experience around 8.10 years as Oracle DBA in 10g/11g/12C/18c/19c Database Administration including RAC. Supporting Oracle Database, thoroughly conversant with Application & Database Upgrade, Support, Maintenance on 24/7 environments supporting multiple databases. Experience ranges from RMAN Backup, Cloning, Patching, Registering concurrent programs.

WORK SUMMARY

Expertise in Installation of Oracle software (9i,10g,11g,12c,18c,19c) on Windows, Red Hat

Linux platforms and IBM AIX.

Analyzing and resolving the issues related to table spaces (Non-system, Undo &Temporary)

in Oracle10g/11g/12c/18c/19c

Worked on Database Upgrades.

Worked on CPU patch analysis as per the Base scores provided by Oracle.

Worked on Applying Critical Patch updates i.es RU and OJVM patches on Grid and DB

homes.

Creating databases (manually / using DBCA) for Testing, Development and Production.

Creation of DR databases and configuring DG Broker.

Installation of ASM and hands on Experience in ASM like creating and managing Disk

groups with Mirroring and Stripping. Worked on Dropping and Adding Candidate Disks to Disk Groups.

Worked on Index and Table Reorgs for Space optimizations.

Worked on Table Online Redefinition.

Good experience in Installation and administration of oracle 10g/11g/12c/18c/19c Real

application cluster (RAC).

Expertise in Logical backup (Export& Import, EXPDP & IMPDP) and Physical backup

(Hot & Cold).

Experience in creating Database links (Public, Private) and Materialized views.

Experience in Oracle Data guard for high availability, Standby builds and DG issues.

Good experience in Managing Cluster ware components using SRVCTL and CRSCTL

utilities.

Worked on generation AWR, ASH, AWR SQL reports.

Worked on Installing OSWatcher and analyzing OSWatcher logs.

User management – Creating and maintaining users, assigning profiles, granting and revoking roles.

Backups - Cold, Hot, Logical (table/schema/Tablespace level).

Managing Users, Password Security, Roles, Privileges and Resources.

Monitoring database space requirements and performing Database health checks.

Configuration and working with RMAN (Recovery Manager)

Experience on Data Guard switch over and switch back.

Having exposure and good knowledge on RAC and ASM

Experience on Change and Incidents Management

Managed tickets and provided support as per the SLA

Administering and maintain Oracle database instances, 24X7 Production Database Support.

Worked for multiple clients on different environments.

I have basic knowledge on Golden Gate. Worked on basic GG tasks.

Worked on Creation of SR’s with Oracle Support

PROFESSIONAL EXPERIENCE

Currently Working in INFOSYS LIMITED for HPE (Hewlett Packard Enterprise) from Feb 2021 to Till Date(Onsite).

Worked as Oracle Database Administrator (Technology Analyst) in INFOSYS LIMITED for Project KROGER from January 14th 2019 to Feb 2021.

Worked as Oracle database administrator in Soniks consulting services as Oracle Database Administrator from April 15th 2015 to January 13th 2019

EDUCATION & CERTIFICATIONS

M.Tech(CSE) from Abhinav Hitech Engineering College (JNTUH), Hyderabad-2015

B.Tech(CSE) from Ramanandatirtha Engineering College (JNTUH), Nalgonda-2013

SKILL SETS

Oracle Application and Database Administration

Databases

:

Oracle 11g, 12c,18c,19c

Operating Systems

:

RHEL, OEL, AIX & Windows

Languages/Scripting

:

SQL, Shell scripting,C,Java

Application Servers

:

11g & 12c SOA, 11g Discoverer, Oracle Application Express 4.0 & 5.0 with ORDS Tomcat & Weblogic, Oracle Demantra

Tools

:

SQL Developer, SQL * Loader, Export/Import, RMAN, TKPROF

Projects

Client

Hewlett Packard Enterprise (HPE)

Version

Oracle 12c,18c,19c

Role

Core DBA

Duration

Feb, 2021 to present

Activities

Working with Oracle Support in case of any emergency help required to fix the issue by raising Service Requests.

Performing Table and schema level refreshes

Database refresh using Rman Duplicate

Worked on Index and Table Reorgs for space optimizations

Worked on Installing ASM, creation of new Disk groups, adding and dropping CANDIDATE Disks to Disk Groups.

Exposure in working and troubleshooting Standby (Physical)database issues.

Installation and database configuration of Oracle 11g/12c/18c/19c databases.

Routine DBA activities like refreshing schemas on demand, scheduling cronjobs, taking care of alerts pertaining to production systems

Creating of standby databases using the prod backups on different servers

New database Creations for application testing

Troubleshooting & resolving all kind of errors & Bug related errors (ORA-600 & ORA07445) by collating with Oracle support through raising Service Requests (SRs).

Performed House Keeping on the mount points

Worked on Oracle High Availability services like Dataguard, Streams, and GoldenGate.

Preparing the RCA for repated issues.

Resolving client connectivity issues.

Extended Table spaces by resizing/adding data files using quick I/O method when needed.

Supporting Production and Development databases

Monitoring and performing daily incremental backups, weekly full backups using RMAN.

Performed daily activities like monitoring OS File system usage, Alert logs, Trace files,tnsnames & listener.ora files to understand the health of database.

Generated performance reports using utilities like AWR, Stats pack to gather performance statistics.

Refresh QA/DEV databases with production.

Monitored Overall System Performance and Database growth.

Checked alert logs and background trace files on daily basis and resolved problems.

Decommission of databases.

Served as a member of 24-hour on call support staff.

Troubleshooting general issues like DB connectivity, User’s login.

Applied CPU patches for RAC and standalone databases.

Created databases on cluster.

Experience in monitoring RAC databases

Cloning databases prod to dev databases.

Generating and analyzing AWR reports.

Provided 24 hours on call support.

Client

KROGER

Version

Oracle 12c,18c,19c

Role

Core DBA

Duration

Jan, 2019 to Jan 2021

Activities

Proactive monitoring of all Oracle Database instances.

Giving support to various instances like Production, Test, & Dev instances

Upgrade database and grid infrastructure from 12.1.0.2 to 12.2.0.2

Applying database patches using opatch utility and opatchauto

Monitoring mount point, table spaces, archive files destination & alert log files.

Database creation as per Build sheet and also per settings specified by the requester.

Worked on Oracle High Availability services like Dataguard, Streams.

Installed 12c RAC and Data Guard setup.

Analyze existing trace files & Generate trace output files using TKPROF utility.

Adding/removing Disks in ASM.

Moving data files from one mount point to other mount point.

Database and Schema migration across platforms.

Configuring database links & materialized views, troubleshooting related issues.

Shrinking tables, tablespaces and schemas to reclaim unused space.

Client

US Concrete, USA

Version

Oracle EBS R12.2.3

Role

Oracle Application Database Administrator

Duration

Aug, 2016 to Jan,2019

Activities

Upgrade database from 11.2.0.1 to 11.2.0.3.

Oracle Applications like ADOP patching and cloning etc

Performing patch analysis and applying recommended patches for EBS application

Applying patches to 10.1.2, oracle_common, webtier, weblogic homes.

Worked with functional & technical team during the support.

Monitoring table spaces, archive files destination & alert log files.

Monitoring Oracle Applications Instance and Oracle Databases

Managed Oracle EBS Database backups using RMAN, Hot Backup, Cold Backup.

Managed Oracle EBS Application backup.

Monitoring, Creating, Scheduling the db & appl alerts regularly.

Cloning Production instance to DEV, TEST.

Creating, managing application users & assign responsibilities.

Migrating of Application Users, Responsibilities, Menus, Functions using FNDLOAD from one instance to another.

Configuration changes and running autoconfig.

Analyse existing trace files & Generate trace output files using TKPROF utility.

Well versed in AD utilities like adident, adadmin, adpatch, adctrl, adrelink.

Creating Database links from DEV to TEST & vice-versa.

Performing databases backup & cloning using rman backups.

Using data pump for performing export/import of schema & database, also used compression option which reduced the dump file size.

Migrating of Application Users, Responsibilities, Menus, Functions using FNDLOAD from one instance to another.

Changing passwords using FNDCPASS.

Using data pump for performing export/import of schema & database, also used compression option which reduced the dump file size.

Client

Quality Care India Ltd

Version

Oracle 11g, Oracle Apps R12+ Linux.

Role

Oracle Application Database Administrator and Core DBA

Duration

Aug, 2016 to Jan,2019

Activities

Proactive monitoring of all Oracle Apps instances.

Giving support to various instances like Production, Test, & Dev instances

Monitored & Managed RMAN backup with application tar backups.

Performing Patch Analysis for oracle home and application patches along with french language patches.

Worked on adident, adadmin, adpatch, adctrl, adrelink utilities for Oracle Applications.

Upgrade of EBS suite from 12.1.3 to 12.2.4 & database from 10.2.0.4 to 11.2.0.3.

Solving application & database issues.

Worked with functional & technical team during the support.

Migrating of Application Users, Responsibilities, Menus, Functions using FNDLOAD from one instance to another.

Client

Bhukatir, Sharjah

Version

Oracle EBS R12.1.3

Role

Oracle Application Database Administrator

Duration

Jun 2017 to Dec 2017

Activities

Upgrade database from 11.2.0.1 to 11.2.0.3.

Created and managed the project plan for migrating EBS 12.1.3/11.2.0.3-multi-node RAC/ASM from HP-ux to EBS 12.1.3/11.2.0.4-multi-node RAC/CFS with shared appstier,load balancer,PCP configuration in ODA

Migrated the Oracle EBS from HP-ux platform to OEL platform using Transportable Tablespace method in ODA.

Upgraded the Database from 11.2.0.3 to 11.2.0.4 with RAC

Migrated the Application 12.1.3 from single node to shared appstier of 2 nodes with Load balancer and PCP configuration.

Experienced in converting the single node database to RAC database using rconfig.

Supporting to functional testing team during testing cycle.

Completed the 4 iterations project.

Client

Confidential

Version

Oracle EBS R12.1.3, R12.2.4

Duration

March 2016 to August 2016

Role

Oracle Application Database Administrator

Activities

Upgrade of EBS suite from 12.1.3 to 12.2.4 & database from 10.2.0.4 to 11.2.0.3.

Enable French language in existing R12 instance.

Performing patch analysis and applying recommended patches for EBS application along with french language patches.

Applying patches to 10.1.2, oracle_common, webtier, weblogic homes.

Worked with functional & technical team during the support.

Monitoring table spaces, archive files destination & alert log files.

Monitoring Oracle Applications Instance and Oracle Databases.

Managed Oracle EBS Database backups using RMAN, Hot Backup, Cold Backup.

Managed Oracle EBS Application backup.

Monitoring & Management of tablespace by resizing or add data files.

Monitoring, Creating, Scheduling the db & appl alerts regularly.

Creating & Registering of custom top in R12.

Managing Concurrent Managers and Increasing Java heap size, increase process, threads for FNDOPP concurrent manager.

Creating, managing application users & assign responsibilities.

Configuration changes and running autoconfig.

Creating Database links from DEV to TEST & vice-versa.

Client

Confidential

Version

Oracle EBS R12.1.3, 11g Discoverer, Apex 4.2 & 5.0, Talend 5.6 &6.2

Duration

Jan 2016 to Mar 2016

Role

Oracle Applications Database Administrator

Activities

Upgrade of EBS suite from 12.1.3 to 12.2.4 & database from 10.2.0.4 to 11.2.0.3.

Installation, Up-gradation of EBS suite from R12.1.1 to R12.1.3 and R12.2.0 to R12.2.4.

Integrating oracle Discoverer 11g stand alone with Oracle Applications R12.1.3.

Monitoring & Managing table spaces, archive files destination.

Install 11g Oracle Database & 4.2 Apex.

Install 12c Oracle Database & 5.0 Apex.

Monitoring Oracle Applications Instance and Oracle Databases

Managed Oracle EBS Application backup using tar & Database backups using RMAN.

Cloning PROD instance to CRP.

Creating, managing application users & assign responsibilities.

Applying database patches using opatch utility.

Performed installations of Oracle Database 11g and 12c, Oracle ASM, Oracle EBS R12.1.1, R12.2 and R12.2.0 single-node and multi-node installations, Oracle Cloud Control (OEM) Installations, Oracle Rest Data Services (ORDS), Weblogic, Soa.

Client

Confidential

Version

12c Oracle Golden Gate and Talend 5.6,6.2

Duration

April 2015 to Jan 2016

Role

Oracle Applications Database Administrator

Activities

Installation of Golden Gate 12c

Configure Golden Gate

Data Replication between Multiple SCHEMAS

Data load between SOURCE and TARGET

Talend Installation.

Creating the database connection using Talend,and Replicate the data between dif types of Databases(oracle,ms sql server,ms excel)

Contact this candidate