Database Administrator Oracle
Resume:
RAJASHEKAR K Email:**************@*****.***
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 OVERVIEW
• Having 9 years of experience as an ORACLE DATABASE ADMINISTRATOR, Currently working in Infosys Limited.
• 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 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)
• Configuring Oracle enterprise Manager (OEM) for the DEV/QA/PROD databases for monitoring health check of the database on day to day basis.
• Experience on Data Guard switch over and switch back.
• Having exposure and good knowledge on RAC and ASM
• Experience on Change and Incidents Management
• OEM Administration – Monitoring templates creation, Incident rule creation, Agent installation and configuration database into OEM.
• Generating database growth report through OEM and analyzing the growth.
• Managed tickets and provided support as per the SLA
• Administering and maintaining 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 f SR’s with Oracle Support.
GRID TASKS:
10g, 11g GRID & AGENT installation.
Configuring RAC & Non-RAC Database instances and hosts in GRID.
Configuring &monitoring various alerts through GRID console.
Troubleshooting issues regarding GRID.
UPGRADATION TASK:
Worked on 10g Database platform migration
Worked on 10gR3/10gR4 to 11gR3 database upgradation
Worked on R12.0.6 application migration from Solaris to Linux
Worked on upgradation of R12.0.6 to R12.2.3
Employment History:
• Currently Working in INFOSYS LIMITED for HPE (Hewlett Packard Enterprise) from Feb 2021 to Till Date (Onsite).
• ccProject 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 Educational Profile
• M.Tech(CSE) from Abhinav Hitech Engineering College (JNTUH), Hyderabad-2015.
• B.Tech(CSE) from Ramanandatirtha Engineering College (JNTUH), Nalgonda-2013. TECHNICAL SKILLS:
Oracle Products RDBMS 9.x,10g,11g,12c,18c,19c, Oracle Enterprise Manager, Oracle Security Manager (User and Role
administration), RMAN, Oracle 10g/11g/12c/18c/19c RAC, Backup/Recovery, Import/Export, Data Pump, AWR,
ADDM, ASH, Table Online Redefinitions
Operating Systems Sun Solaris, IBM AIX, HP-Unix, RHEL 4, 5& 6 Windows NT/12000/2003.
Tools / Utilities Putty, OEM, SQL Plus, WinSCP, Citrix, Moba Xterm, SQL Developer,Service Now, Onguard, vfire
PROFESSIONAL EXPERIENCE:
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 repeated 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.
Personal Information
Marital Status : Married
Current Location: Houston, Texas
Contact this candidate