Pratyaksh

Oracle-DBA
placeholder
Location Noida
view-icon
Total Views162
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 9.5 Year
  • Cost
    Hourly Rate$20
  • availability
    AvailabilityImmediate
  • work from
    Work FromAny
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnNovember 27, 2022
Key Skills
OracleRMANRACDataguardInstallation ConfigurationSQL PL/SQL and Unix Shell ScriptingPL/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.


Copyright : 2022 – OnBenchMark All Right Reserved.