Oracle DBA Resume

Oracle DBA Resume

Title: Oracle Database Administrator
                           
Sri Harsha Kandula

Mobile No: +91 **********
E-Mail: *********@*******.***

Experience Summary:

•    A competent professional with over 5+ Years of experience in I.T. Industry with experience as Oracle DBA with over 3+ Years and  had the pleasure of working with Oracle application EBS suite 11i/R12.

•    Extensively worked on production database using Oracle 8i, 9i, 10g, 11g as well as on almost all the major operating systems flavours; Sound understanding of ITIL guidelines.

•    Oracle Certified Professional OCP-DBA-9i, 10g, 11g, RAC and ITIL Certified, deft in handling Project Management activities.

•    Attained cross cultural experience while working at Ipswich, Cardiff, Apsley, UK & Edinburgh in Scotland.

•    Sound expertise in Oracle Database Administration activities encompassing Database planning, Design, Installation, Configuration, Monitoring, Health-Check, System Audit Services, Disaster Recovery Planning, Back up and Recovery (using RMAN), configuration of standby databases for ensuring business continuity & patch management.

•    Extensive hands-on experience on Oracle installation, configuration, administration, shell scripting, Performance Tuning of databases, PL\SQL Code review & approval, applying database patches, upgradation, migrations, Database Cloning, User Management, Space Management ,troubleshooting on Sun Solaris, Red Hat Linux, HP-UX, Sco-Unixware and Windows platforms; handling physical database design & creation.

•    Strong technical acumen in handling different types of UNIX OS including Sun Solaris 5.8, SCO UNIX and AIX.

Certifications:

•    Oracle 9i Certified Professional (OCP-DBA) in Nov’08.
•    Oracle 10g Certified Professional (OCP-DBA) in Sep’09.
•    IT Service Management Foundation Certified in Oct’09.
•    Oracle Database 10g R2: Administering RAC in Mar’10.
•    Oracle 11g Certified Professional (OCP-DBA) in Dec’10.

Technical Skills  (Set as a DBA)

•    Hot and Cold Backup.
•    Oracle EBS Suite 11i & R12.
•    Oracle Data Guard Configuration.
•    Oracle resource consumption at OS level.
•    Monitoring recovering manager jobs & its performance.
•    Failover and Switchover of Primary and Standby databases.
•    Failover of Oracle application using OS clusters.
•    Complete and Incomplete recovery with RMAN and UMAN.
•    Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.

Project Details:

Employer        : THOMSON REUTERS
Project           : Oracle BPM
Client            : In-House   
Technology/Software    : Solaris, Oracle11g RAC, Active Dataguard, OEM 12c

Role:     Database Administrator

This is a Markets-wide initiative, a coordinated effort to leverage the latest Business Process Management (BPM) and Automation Technologies to scale the organization’s content collection processes to a new level and help prepare for future challenges in Investment Research Content Segment.

Responsibilities:

•    Major responsibility of deployment & Implementation.
•    24x7 DBA support and Troubleshooting.
•    Leveraging Database knowledge for the architectural reviews for the BPM project.
•    Representing the team in discussions with Oracle corp. on technologies – EMC storage, oracle clusterware, ASM, MPIO, virtual provisioning.
•    Presiding and giving valuable inputs on whiteboard sessions and BCR.
•    Setting kernel parameters & the required packages for Solaris OS
•    Used cluster verifier for pre-oracle RAC installation.
•    Configuration of 2 node RAC on 11g for PROD, DR & PPE environment.
•    Setting Active Dataguard with HA mode on geographically apart Datacenters.
•    Setting and configuration of OEM 12c, add-on management components Weblogic, SOA
•    Setting and Monitoring OEM target- database/host/cluster/listener/ASM/etc using SNMP trap


D.P. Jindal Group:

Working as Oracle DBA/Apps DBA and solely responsible for the availability and response time of the Oracle EBS suite 11i /R12 databases for Jindal Group at Jindal Corporate Centre from October xxxx till xxxx.


Currently working with Oracle Applications Release 11i/R12 and 11g Databases.
Managing and Purging of obsolete workflow data as per business requirement.
Creating users as well as responsibilities and assigning required responsibilities.
Failover and Switchover of Oracle Application 11i/R12 & 11g databases using OS clusters.
Oracle EBS database cloning from production to test, development instance to test servers simulate few technical challenges, coordinate with testing     and development team.
Oracle Application Cloning EBS Suite 11i/R12 from Multi-Node to Single Node Cloning as well as Single Node to Single Node Cloning from production to     test, production to development servers.
Monitoring the Concurrent Manager, Apache & its operations and troubleshooting problems using AOL/J Test and viewing the log/out files to resolved     issues of concurrent requests, forms & web servers.
Managing Oracle Application Utilities like Adadmin, AD Controller, Autoconfig, ADrelink, AutoPatch. Applying patches on Oracle application EBS 11i     Suite.
Optimizing Oracle Apps security by periodically changing Apps and schema passwords using FNDCPASS.
Reduced the timelines of patching using features like defaults file and merge patch.
Troubleshooting several worker issues while patching using Adctrl.
Purging of old concurrent requests data and old ICX sessions data.
Monitoring trace files and backing up periodically.
RMAN Backup on disk as well as on tapes using Netvault.
Perform regular database activities like space management, index rebuilt, database health check-up etc.
Forms & Database Session maintenance (killing sessions as and when required).
Performance tuning of databases using AWR, ASH & ADDM reports.
Cloned Oracle database binaries & apps binaries for creating new oracle application instance.
Raising Service Requests for Production issues with Oracle Support and follow up till resolution.
Raising Service Requests with Net vault Support as well as IBM support as per requirements.


Hospital Equipment Technologies Inc.

Worked as Technical Support Engineer supporting system and network administration activities from January XXXX to February XXXX.

Installation and troubleshooting of Win 2000 Server, Win XP, Win2k, Win98.
Assembling & Maintenance of Desktop PCs and Laptops Inventory.
Provided desktop support with application installs, configurations, and hardware moves.
Technical knowledge of network printers troubleshooting.
Troubleshoot Lan issues and manage network infrastructures.
Installation & Administration of MS Outlook, Outlook Express, NMSAPP Tool.
Automating systems update of windows workstations with latest service Packs, hot fixes.
Exposure to Cisco specific hardware switches / routers as well as industry standard equipment.
Installed hard disks, floppy drives, CD drives, sound blaster cards, CPU, memory, power supply unit, network card, video graphics card, external cards on PC systems.
Applying the security updates through the anti-virus to protect the desktops from viruses, Trojans and worms on windows platform for the smooth functioning.
Maintaining and controlling the machine down time by troubleshooting problems in the desktops and network and preparation of Machine downtime reports.
Experience in providing support to clients and helping resolving their issues related to hardware and network connectivity.


Project Title: Global Database Administration (GDBA).

Duration     : 1.2 yrs
Company    : KPIT Cummins Infosystem Ltd, Pune
Client         : Hewlett Packard Co. (HP), USA. (Onsite Singapore)
Designation    : Database Administrator.
Environment    : Oracle 8i, 9i,10g, RAC, RMAN, HP UNIX 11, Windows 2K series Servers.

Description:
The project involves 24X7 production support for all HP’s mission critical,
legacy and all other production databases on Oracle and DB2 UDB. Responsibilities include refreshing of test/development databases as per requirement, versioning of patches as per release, managing security, integrity and backups and restoration, scheduling and monitoring jobs, knowledge transition, performance tuning for Production, Test & Development environment. Work also includes stabilizing the current databases issues and also adding new strategies to enhance the operations better.   

Role and Contribution:

•    As a member Oracle DBA team of Production Support, responsible for all system level DBA tasks which include general administration and backup recoveries.
•    Troubleshooting on backup problems with hot backups, RMAN backups. Also to troubleshooting DP ( Data Protector) backup problems which is configured using RMAN
•    Installing oracle patches as per requirement.
•    Responsible for L3 – L4 level DBA support for different instance located in APJ, EMEA and America region.


Professional Qualification / Certifications / Training:

•    Bachelor of Engineering (BE) in Computer Science from Dr. Ambedkar Institute of Technology Bangalore University.
•    Diploma in Web designing and E-commerce from KCC New Delhi.
•    Microsoft Certified Professional Visual basic 5.0, MS-SQL 6.5 
•    MOC 6461A Windows Communication Foundation.
•    MOC 6462A Windows Workflow Foundation
•    ITIL V3 Foundation

Awards:

•    Received the Certificate of Appreciation for splendid and team work shown during MNP Launch by Glodyne Technoserve Limited.
•    Received the Letter of Appreciation in recognition of exemplary work from Hospital Equipment Technologies Incorporation.

Personal Details:

Date of Birth         :         11th March 1980
Language Known    :    English, Hindi, Telugu
Marital Status        :    Married
Nationality            :    Indian

0 comments:

Post a Comment