Oracle Dba
CurrentResponsibilities:• Installation, Upgrade and patching of Oracle Database (10g & 11g).• Performing Backup (Hot Backups and Cold) and Recovery Using RMAN• Checking the Datafiles consistency using DBVerify Utility.• Analysing the SQL Query using Explain plan.• Schema Refresh using Export & Import.• Provide assistance to Development staff for issues relating to performance tuning and SQL creation. • Creating Materialized View for Improving Performance.• Database… Show more Responsibilities:• Installation, Upgrade and patching of Oracle Database (10g & 11g).• Performing Backup (Hot Backups and Cold) and Recovery Using RMAN• Checking the Datafiles consistency using DBVerify Utility.• Analysing the SQL Query using Explain plan.• Schema Refresh using Export & Import.• Provide assistance to Development staff for issues relating to performance tuning and SQL creation. • Creating Materialized View for Improving Performance.• Database Cloning using RMAN and User managed Backup.• Loading data in to the Database using SQL Loader.• Manage database network setup, distributed database setup, and trouble-shooting (e.g. SQL statements, locking issues, network and performance problems)• Monitoring the database for Memory and I/O utilization. Show less