Candidate Information Title Oracle Dba Database Target Location US-TX-Dallas Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

RAJASHEKAR K Email: EMAIL AVAILABLEOracle DBA Mobile: PHONE NUMBER AVAILABLECAREER OBJECTIVEMy 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.PROFILEOracle 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 SUMMARYExpertise in Installation of Oracle software (9i,10g,11g,12c,18c,19c) on Windows, Red HatLinux platforms and IBM AIX.Analyzing and resolving the issues related to table spaces (Non-system, Undo &Temporary)in Oracle10g/11g/12c/18c/19cWorked 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 DBhomes.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 Diskgroups 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 Realapplication 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 CRSCTLutilities.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 ASMExperience on Change and Incidents ManagementManaged tickets and provided support as per the SLAAdministering 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 SRs with Oracle SupportPROFESSIONAL EXPERIENCECurrently 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 2019EDUCATION & CERTIFICATIONSM.Tech(CSE) from Abhinav Hitech Engineering College (JNTUH), Hyderabad-2015B.Tech(CSE) from Ramanandatirtha Engineering College (JNTUH), Nalgonda-2013SKILL SETSOracle Application and Database AdministrationDatabases:Oracle 11g, 12c,18c,19cOperating Systems:RHEL, OEL, AIX & WindowsLanguages/Scripting:SQL, Shell scripting,C,JavaApplication Servers:11g & 12c SOA, 11g Discoverer, Oracle Application Express 4.0 & 5.0 with ORDS Tomcat & Weblogic, Oracle DemantraTools:SQL Developer, SQL * Loader, Export/Import, RMAN, TKPROFProjectsClientHewlett Packard Enterprise (HPE)VersionOracle 12c,18c,19cRoleCore DBADurationFeb, 2021 to presentActivitiesWorking with Oracle Support in case of any emergency help required to fix the issue by raising Service Requests.Performing Table and schema level refreshesDatabase refresh using Rman DuplicateWorked on Index and Table Reorgs for space optimizationsWorked 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 systemsCreating of standby databases using the prod backups on different serversNew database Creations for application testingTroubleshooting & 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 pointsWorked 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 databasesMonitoring 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, Users login.Applied CPU patches for RAC and standalone databases.Created databases on cluster.Experience in monitoring RAC databasesCloning databases prod to dev databases.Generating and analyzing AWR reports.Provided 24 hours on call support.ClientKROGERVersionOracle 12c,18c,19cRoleCore DBADurationJan, 2019 to Jan 2021ActivitiesProactive monitoring of all Oracle Database instances.Giving support to various instances like Production, Test, & Dev instancesUpgrade database and grid infrastructure from 12.1.0.2 to 12.2.0.2Applying database patches using opatch utility and opatchautoMonitoring 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.ClientUS Concrete, USAVersionOracle EBS R12.2.3RoleOracle Application Database AdministratorDurationAug, 2016 to Jan,2019ActivitiesUpgrade database from 11.2.0.1 to 11.2.0.3.Oracle Applications like ADOP patching and cloning etcPerforming patch analysis and applying recommended patches for EBS applicationApplying 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 DatabasesManaged 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.ClientQuality Care India LtdVersionOracle 11g, Oracle Apps R12+ Linux.RoleOracle Application Database Administrator and Core DBADurationAug, 2016 to Jan,2019ActivitiesProactive monitoring of all Oracle Apps instances.Giving support to various instances like Production, Test, & Dev instancesMonitored & 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.ClientBhukatir, SharjahVersionOracle EBS R12.1.3RoleOracle Application Database AdministratorDurationJun 2017 to Dec 2017ActivitiesUpgrade 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 ODAMigrated 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 RACMigrated 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.ClientConfidentialVersionOracle EBS R12.1.3, R12.2.4DurationMarch 2016 to August 2016RoleOracle Application Database AdministratorActivitiesUpgrade 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.ClientConfidentialVersionOracle EBS R12.1.3, 11g Discoverer, Apex 4.2 & 5.0, Talend 5.6 &6.2DurationJan 2016 to Mar 2016RoleOracle Applications Database AdministratorActivitiesUpgrade 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 DatabasesManaged 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.ClientConfidentialVersion12c Oracle Golden Gate and Talend 5.6,6.2DurationApril 2015 to Jan 2016RoleOracle Applications Database AdministratorActivitiesInstallation of Golden Gate 12cConfigure Golden GateData Replication between Multiple SCHEMASData load between SOURCE and TARGETTalend Installation.Creating the database connection using Talend,and Replicate the data between dif types of Databases(oracle,ms sql server,ms excel)