Jayalakshmi Pallapothula

Experience

• 

  HCLTech

  Jun 2012 - Dec 2014

  Oracle Database Administrator

  • Looking into day-to-day activities of Production database, Monitoring its growth and performance.• Resolved space management issues whenever required.• Created users and roles for privilege management.• Backup database using user managed (Hot/Cold/Export) backups. • Export-Import for table moving and Logical Backup.• Gathering the stats for tables.• Handled regular cleaning of unwanted table from the database after confirmation from developers’ team and freeing the extra space. • Deploying the new procedures, packages, functions, triggers given by Application Teams in QC/Prod environments and recompiling all the invalid objects.• Adding disk space to the disk groups in the ASM. Show less

• 

  InfoSys Ltd.

  Dec 2014 - now

  Oracle Database Administrator

  · Involving in High level activities like performance tuning, DB Installations, Upgradations, Patches & DB decommission activities.· Involving in RAC activities like services management & resolving the RAC DB related issues.· Maintaining the stand by db’s and Make sure to keep primary and stand by db’s are in sync.· Configured the RMAN backup & performing the restore and recoveries whenever required.· ASM disk administration & adding the space whenever required.· Refreshing of Table, Schema, Full Database & Mview refresh as per the requested.· Installing the Full oracle client & Instant client software (Solaris,Linux).· Tablespace management & Encryption of tablespace.· Performing the Gather stats for Table, Schema, Full DB & Index rebuilding.· Enabling ACL creations to access the utl_mail, utl_smtp, utl_http packages.· Changing the DB Parameters as per the requested.· Deploying the Code in Prod & Non Prod environments.· Creating the DB links and resolved the link access related issues.· User management & Granting privileges, roles respectively.· Killing inactive, Locks & long running sessions. Show less