Profile image of heyraam86
@heyraam86
Flag of India Trivandrum, India
Member since January 30, 2011
0 Recommendations

heyraam86

Online Offline
I have been working as Senior DBA for last 6 years and having very good experience in core DBA related tasks in Oracle,MySQL and PostgreSQL databases 1) Implementation & 24*7 support projects including RAC, ASM 2) Setting up Data Guard 3) Migrating database across platforms 4) Configuring RMAN backup and recovery 5) Applying Patches 6) Rebuilding indexes 7) Gathering statistics for schemas and tables 8) Re-sizing tablespaces above high water mark 9) Defragmentation of tables, 10) Taking logical backup using Datapump and original export/Import utilities 11) Cloning oracle home and database from one server to another server 12) Configuring Cloud control 13c OEM and deploying agent on servers to be monitored 13) Troubleshooting database issues
$15 USD/hr
3 reviews
2.9
  • 67%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • N/ARepeat Hire Rate

Portfolio

Recent Reviews

Experience

Team Lead - Oracle DBA

Feb 2017

Implementation of RAC,ASM and DATAGUARD Managing Oracle 11G R2 RAC databases with Automatic Storage Management Performance tuning Restoring and recovering the database hot and logical backup on servers based on client requirement. Installing Oracle Cloud control control 13c and Oracle Management Agents Patching and Upgradation analyzing AWR and ADDM report and preparing reports Backup and restoring the MySQL databases Adding ASM disks to diskgroup

Senior Database administrator

May 2016 - Jan 2017 (8 months)

ROLES AND RESPONSIBLITIES: Handling Mysql production & UAT servers mainly Backup and restoring the mysql databases based on business requirement Making data changes through sql query as directed by development team and operations team

Oracle System Monitoring & Support Engineer

Mar 2013 - May 2016 (3 years)

Analyzing the reason for high CPU load on DB servers Performing logical backup and restore using Datapump and Original Export / import utility Defragmentation of tables and indexes & recovering unused space from the objects Cloning oracle 10g ([login to view URL]) Oracle homes & databases from one server to another server Managing tablespaces and datafiles Shell scripting Upgrading Oracle 10g R2 ([login to view URL]) to Oracle 12c R1 ([login to view URL]) Managing tablespaces and datafiles and reclaiming unused space

Oracle DBA – Trainee

Feb 2012 - Mar 2013 (1 year)

ROLES AND RESPONSIBILITIES: Monitoring RAC databases, checking clusters health & sending reports Maintaining standby databases & moving log files from two node RAC database to standby database and applying on it to keep standby db updated Monitoring space usage on servers mount points Managing tablespaces and datafiles Monitoring RMAN jobs and running RMAN reports

Education

Bachelor of Engineering

2003 - 2007 (4 years)

Qualifications

Oracle 10G Certified Professional (2012)

Oracle University

Oracle 10G database administration Certified Professional

Verifications

  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

My Top Skills

Browse Similar Freelancers