Harshitha H.D

acugu7@r.postjobfree.com

900-***-****

1.0 Profile Summary

Over 7+ years of professional experience in Information Technology industry

that comprises Oracle DBA with hands on administering of Oracle Databases.

Having good exposure to work on critical database.Have good knowledge on

Database Architecture Managing Users, Tablespace,datafiles,Upgradation,Patching

Physical standby configuration,RAC architecture and RAC database creation etc.

2.0 Career Summary

2.1 Wipro Technologies, Jan 08 2014 till date

Worked on creating databases in dataguard and RAC environment

Worked on executing application scripts in databases for development and test

Worked on executing application scripts in production environment and resoving performance issues during this execution

Worked on dataguard for taking backups and monitoring archive space

Worked on adding space,tablespace management,user management,Os level space issues

Worked on attending project meetings and weekend activities

Involved in User management, creating roles and assigning privileges

Work on tickets (User and server generated) for various issues

Change management, Incident management and Problem management

Working on testing,elab/preprod for export and import schemas to go live for production

Working on Dataloading,schema cloning,Schema changes

Monitoring the growth of tablespace, database and file system disk space

Exporting and importing data for schemas objects and tables and resolving issues

Handling Database performance issues based on proactive monitoring and high severity.

Technology

Software tools and Languages

Oracle 10g,11g

Sql, Pl/Sql

Sql*Loader, Import/Export

2.2 Syniverse Technologies, Sep 28 2012 till date 2013.

Working on all database activities like tablespace management, User management, space management for storage.

Database creations in 10g,11g.

Working on application releases like tables creation,synonyms,sequences,partitioning maintainence etc in development,test and production databases.

Creation of changes using change management process for production changes.

Applying patch

Working on database upgrade from 10g to 11g in RAC and standalone databases.

Working on schema refresh ( Export and import – exp,imp and expdp and impdp)

Worked on creation of three nodes RAC instances

2.3 IBM India Private Limited, from AUG 4th 2011 till Sep 2012..

Magna infotech, Client :IBM India Private Limited,April 2010 till July 31 2011,

Bangalore.

Working on Critical project for Financial domain.

Role: Oracle Database Administrator

Responsibilities :

• Monitoring the growth of tablespace, database and file system disk space.

• Involved in Capacity Planning for tablespaces

• Monitoring the system and performing the daily checks

• Performing and monitoring the hot and cold RMAN backup and export utility on daily & weekly basis.

• Exporting and importing data for schemas objects and tables.

• Analyzing tables regular basis and upon request.

• Ensure Availabilty of databases after SAN migration projects.

• Debugging & trouble shooting the various database related issues raised by the user, developer and Application DBA.

• Handling Database performance issues based on proactive monitoring and high severity.

• Applying Patches for quarter according to release from oracle.

• Performing the Database upgrade.

• Involved in User management, creating roles and assigning privileges

• Create, follow-up and implement change Orders for the doing any modifications in database level.

• Creating Service Request (SR's) with Oracle Metalink for various issues.

• Work on tickets (User and server generated) for various issues.

• Take care of daily on call issues.

• Change management, Incident management and Problem management.

• Perform database Migration & Upgrades

Technology

Software tools and Languages

Oracle Server 8i/9i/10g,11g

Sql, Pl/Sql

Sql*Plus, Sql*Loader, Import/Export, RMAN

2.4 ASM Technologies : Client Oracle India PVT limited, Bangalore 14th Nov '08 to

July 09.

ASM Technologies Limited., established in 1992, is a pioneer in providing world Class Consulting Services in Enterprise Solutions for the Packaged ERP Products and in Enterprise Product development for SMB Segment and in Technology Solutions covering Embedded Systems and System Software to its Global Clientele.

ASM offers a broad spectrum of enterprise services such as configuration, implementation, customization, end-user training and documentation, Post Implementation Support & Maintenance across leading commercial off-the-shelf products like SAP,oracle Applications, PeopleSoft, JDEdwards and Microsoft Enterprise products.

Role: Oracle Database Administrator

Client : Oracle Corporation,Bangalore

Monitoring Job failures and reporting respective teams

Database management

Creating Tablespaces,Adding Datafiles,Resizing Datafiles

Cloning Database using Coldbackup

Schema Refresh

Trouble shooting connection issues for Client connections

Tuning the Table Query

Monitoring Backup’s & Resubmitting failed backup’s of RMAN,

HOTBACKUP & EXPORT

Working on Mount point issues

Troubleshooting the list of queries which is taking long time to execute

Working on User Managements

Technology

Software tools and Languages

Oracle Server 8i/9i/10g

Sql, Pl/Sql

Sql*Plus, Sql*Loader, Import/Export, RMAN

Hardware and Operating Systems

RHEL Advance Server 3/4/5, RHEL Linux 8, Windows 2000, NT

Database

Oracle8i/9i/10g.

2.5 Q-soft Systems & Solutions (P) Ltd, Bangalore 17th Dec ’07 to 31st Aug ‘08

Q-Soft is a ten year old company having its base in Bangalore. The company provides service, support and training in the field of Oracle database & Application Servers. Q-Soft develops ERP solutions for SMBs. The client of Q-Soft include Airtel, Spice Telecom, Ocwen,Standard Chartered Bank,JSW etc..

Role: Oracle Database Administrator/Oracle Database Consultant

Oracle database support and maintenance

Installation of 9i & 10g Oracle Software on various OS

Design Backup strategy depending on database workload.

Troubleshooting database related problems

Monitoring Segments for fragmentation

Configure Oracle networking and Troubleshooting

Provide recovery solutions Suggesting tuning solutions for SGA

Providing Corporate presentations & workshops on Oracle9i and 10g DBA concepts

Users Administration (Roles and Profiles)

Worked on OEM (Oracle Enterprise Manager)

User/ Role management

Configuring new databases for development & testing

Restoring/cloning of Oracle database for development team.

Upgrading databases using Export & Import utility, implementing

schemas & modifications,managing user security & Profile.

Regular DBA activities including monitoring databases using db health scripts

Taking Backup Using Hot Backup, Cold Backup, Export utilities for NT servers.

Creating primary database storage structures (tablespaces) once developers have

designed an application.

Creating Primary Objects (Tables, Views, Indexes, Stored Procedures, Triggers)

once developers have Designed an application.

Troubleshooting of Oracle database issues

Tablespace maintenance like adding and resizing datafiles

Installation of Red Hat Linux Advance Server 3.0.

Patch up-gradation for the Oracle Database Server.

Ensuring Health of DB by Monitoring alertlog and Archive Generation on

primary & standby Databases.

Tuning of production database.

Sizing tables and indexes.

Security Auditing (Roles,Privileges,Grants).

Analyzing the database on weekly basis.Performing the health check on interval.

Migration of Database from 8i To 9i.

Patch Up-Gradation for the Oracle Database Server.

Establishing Connection Between Client and Server through Application.

Technology

Software tools and Languages

Oracle Server 8i/9i/10g

Sql, Pl/Sql

Sql*Plus, Sql*Loader, Import/Export, RMAN, OEM,TKPROF,LOGMINER,STATSPACK

Hardware and Operating Systems

RHEL Advance Server 3.0, RH Linux 8, Windows 2000, NT.

Database

Oracle8i/9i/10g.

2.6 Academic Profile

1) 2002 To 2006

BE: Information Science from KVGCE Sullia, Belgaum University with 60%

2) 2000 To 2002

H.S.S.C : DVS Composite Pre-University College, Shimoga with 61% Karnataka

University Board

3) 1999 To 2000

S.S.L.C : Vasavi Vidyalaya, Shimoga with 79%,Karnataka University Board

2.7 Accomplishments

Oracle9i Certified Associate from ORACLE University (Prometric Testing

Centre from NIIT,Bangalore 2007)

Oracle Certified Professional from ORACLE University (Prometric Testing

Centre Qsoft Systems & Solutions Pvt Limited,Bangalore 2008)

Oracle9i DBA,SQL,PL/SQL,Red Hat Linux Training, from Q-Soft Systems

& Solutions (P) Ltd, Bangalore.

Oracle 10g New Features Training,Q-Soft Systems & Solutions (P) Ltd, Bangalore.

Completed Certification course in C++, Linux programming from NIIT

2.8 Personal Information

Date of Birth : 1-July-1984

Marital Status : Married

Passport Number : F4076530 valid till 20/07/2015.

Contact this candidate