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… 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

Responsibilities:• Check Alert Log errors and make necessary actions to rectify them.• Frequent analysis of objects or schemas to improve the speed of the database • Maintenance support for the mission critical Production database’s• Tuning SQL statements for the application• Logical standby database configuration and maintenance for a production database• RMAN configuration and recovering database’s on a different hosts for reporting purpose• 24X7 support for the… Show more Responsibilities:• Check Alert Log errors and make necessary actions to rectify them.• Frequent analysis of objects or schemas to improve the speed of the database • Maintenance support for the mission critical Production database’s• Tuning SQL statements for the application• Logical standby database configuration and maintenance for a production database• RMAN configuration and recovering database’s on a different hosts for reporting purpose• 24X7 support for the production databases.• Scripting monitoring scripts for the database and backups.• Responsible for maintenance and improvement of production, archive Oracle database.• Enrolling users and maintaining system security• Controlling and monitoring user access to the database• Monitoring and optimizing the performance of the database• Planning for backup and recovery of database information• Maintaining archived data• Backing up and restoring databases• Generating various reports by querying from database as per need• Backup the Database or logical/user objects for securing the data and database structure. Build up plans for cumulative or incremental backups using RMAN, Exp/Imp and Shell scripts. Show less

Worked as Oracle Database Support• Controlling and monitoring user access to the database• Planning for backup and recovery of database information• Maintaining archived data• Generating various reports by querying from database as per need• Analysing the SQL Query using Explain plan.• Schema Refresh using Export & Import.

Responsibilities: transferred Ensuring user notification of maintenance requirements and system availability. Maintaining confidentiality with regard to the information being processed and also providing on-the-job training to new department staff members. Installing and configuring computer hardware operating systems and applications; Installation and Configuration ( Linux 4, 5, Windows Server 2008). Monitoring and maintaining computer systems and networks; Talking… Show more Responsibilities: transferred Ensuring user notification of maintenance requirements and system availability. Maintaining confidentiality with regard to the information being processed and also providing on-the-job training to new department staff members. Installing and configuring computer hardware operating systems and applications; Installation and Configuration ( Linux 4, 5, Windows Server 2008). Monitoring and maintaining computer systems and networks; Talking staff or clients through a series of actions, either face to face or over the telephone to help set up systems or resolve issues; Troubleshooting system and network problems and diagnosing and solving hardware or software faults; Providing support, including procedural documentation and relevant reports; Following diagrams and written instructions to repair a fault or set up a system; Supporting the roll-out of new applications; Setting up new users' accounts and profiles and dealing with password issues; Responding within agreed time limits to call-outs; Working continuously on a task until completion (or referral to third parties, if appropriate); Prioritized and managed many open cases at one time; Testing and evaluating new technology. Testing and evaluating new technology. Responding within agreed time limits to call-outs. Communicating technical information to non-technical person Show less