Pratyaksh

Oracle-DBA
placeholder
Location  Noida
view-icon
Total Views 75
availability
Shortlist 0
back in time
Member since 30+ Days ago
 
Candidate Information
  • User Experience
    Experience  9.5 Year
  • Cost
    Hourly Rate $20
  • availability
    Availability Immediate
  • work from
    Work From Any
  • check list
    Category Information Technology & Services
  • back in time
    Last Active On January 15, 2022
Key Skills
Oracle RMAN RAC Dataguard Installation Configuration SQL PL/SQL and Unix Shell Scripting PL/SQL Unix Shell Scripting
Summary

 Overall 7.10 years of IT experience with 6+ years as a Database Administrator.

 Implementing and administering Oracle 11g and 12c RAC & standalone Databases.

 Troubleshooting RAC startups, crashes, node evictions, reboots, corruptions, failover.

 Adding/deleting disk to/from asm diskgroup.

 Locating & using the log files for CRS, RAC.

 Installation of Oracle 11g & 12c database.

 Migrating databases from 11g to 12c platform.

 Taking database backups and performing recovery when necessary.

 Applying latest patch set's for CRS & RDBMS home.

 Installing and Configuring dataguard.

 Installing OEM 13c, deploying agents, discovering targets, configuring Incident rules/metrics and scheduling reports and jobs.

 Configuring and scheduling alerts for proactive monitoring using automated scripts and foglight.

 Setting up Statspack,TFA. Automated TFA upgrade across environment.

 Carried multiple DR activities which includes conversion of physical standby to Snapshot standby database, in order to check the processing and load statistics from a new application module.

 Setup OSwatcher for monitoring base operating system statistics and logs.

 Automating backup , purging and monitoring jobs using shell scripting.

 Monitoring and Maintaining User and its activities.

 Managing schema objects, such as tables, indexes, and view.

 Moving data between database using utilities like Export/Import.

 Query optimization using XPLAIN Plan and performance tuning.

 Experience in working in ITIL process environment.

 Managing and configuring master-slave replication in mysql/Mariadb databases.

 Troubleshooting issues in mysql database

 Managing database backup using Mysqldump and xtra backup.

 Experience in setting up new mysql servers,installation and upgradation.

 Experience in Installing and configuring Cassandra database and cluster.

 Troubleshooting and tuning Cassandra environment.Ø Overall 7.10 years of IT experience with 6+ years as a Database Administrator.

 Implementing and administering Oracle 11g and 12c RAC & standalone Databases.

 Troubleshooting RAC startups, crashes, node evictions, reboots, corruptions, failover.

 Adding/deleting disk to/from asm diskgroup.

 Locating & using the log files for CRS, RAC.

 Installation of Oracle 11g & 12c database.

 Migrating databases from 11g to 12c platform.

 Taking database backups and performing recovery when necessary.

 Applying latest patch set's for CRS & RDBMS home.

 Installing and Configuring dataguard.

Installing OEM 13c, deploying agents, discovering targets, configuring Incident rules/metrics and scheduling reports and jobs.

 Configuring and scheduling alerts for proactive monitoring using automated scripts and foglight.

Setting up Statspack,TFA. Automated TFA upgrade across environment.

 Carried multiple DR activities which includes conversion of physical standby to Snapshot standby database, in order to check the processing and load statistics from a new application module.

Setup OSwatcher for monitoring base operating system statistics and logs.

 Automating backup , purging and monitoring jobs using shell scripting.

 Monitoring and Maintaining User and its activities.

 Managing schema objects, such as tables, indexes, and view.

 Moving data between database using utilities like Export/Import.