oracle dba Archives

Good Experience in Dataguard Disaster Recovery (standby testing) and Configuration of Standby Databases (Dataguard), Active Dataguard and Snapshot.
Performed Standby Rebuild activity using RMAN.
Experienced in migrating database from non ASM to ASM
Experience in administration of Oracle 11g RAC Database in 4 node cluster.
Experienced in RAC database Patchset and Upgradations.
Conversion of non RAC database to RAC database in 11g.
Monitoring CRS components like CRSD, OCSSD and EVMD for any kind of cluster related exceptions/errors at synchronization level.

Monitor the backups, recovery errors, respond to the request regarding the restoration of the DB
Monitoring and Configuring Backup (RAMN) for database
Monitor the database related activities, respond calls from the Application support and developments teams.
Managing the network listeners

Involved in Oracle11g installation in Dev/QA servers, ASM configuration, Creating Raw disks (LUN’s).
ORACLE Backup & Recovery, Query Optimization, Database performance Tuning (database & session level tuning), Database Monitoring using OEM.
Creating Users, Profiles, Managing Sessions, Privileges and Roles.
Monitor database alerts & incidents.

Installation & maintenance & Tuning of both Oracle RAC 10g databases and Data Guard in High Availability mode
Unix system administration around Oracle environment
Shell scripting -Support of Testing Team
Backup & Recovery procedure using RMAN and HP Data Protection tool
Export & import procedure of large amount of data
Crystal Reports installation & configuration
Oracle RAC Switchover & Failover procedures

Server management, Database installation and configuration, Database backup & cloning (Import / Export / RMAN), Upgrade & update, Data Guard, Security, Enterprise Manger.
Setup backup recovery procedures using RMAN. Performed hot and cold backups using RMAN.
Experience in cloning/duplicate databases and restorations through RMAN, Hot and Cold backups.
Handled Severity 1, Severity 2 and severity 3 issues to fix the database issues through Bridge/conference call.

Monitoring availability of Production, Standby and UAT database.
Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
Execute deployments on Production and test databases Installation of 12c database and grid software
Schema/table refresh from production to UAT and vice versa
Creation of public and private database link
Creation of clone with RMAN duplicate and masking data before release
Table reorganization using table movement method and release wasted space.

Installing, configuring & Troubleshooting Oracle clusterware & Database Software.
Upgrade of 11g R2 RAC to 12c R2 RAC.
Migrate over 700 GB data from Across the Platform ( From AIX to Linux)
Migrated Non-ASM Single Instance to ASM RAC Instance
Apply the latest hot fixes and security patches released by Oracle.
Work with application team to test the application before going into production special focus on load testing for interconnect traffic.
Providing High Availability using Active Dataguard.

Monitoring disk space on Production, Standby and UAT databases Preparing Daily Checklist reports and sending it to client
Installation of oracle softwares such as database,client and grid
Manual Database creation on Linux and windows server. Creation of services on windows server using oradim utility
Rman backup of Production and standby database
Database restoration using RMAN backup.
Perform Incremental backup using RMAN and restore same on Standby database.
Perform Cold Backup of Database.

Installed, configured and maintained Oracle 9i/10g/11g Databases on Linux, UNIX and Windows Platforms.
Involved in the complete SDLC, Database design, System analysis, design and development.
Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
Installation and Configuration of 11g Grid Control.
Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.
Implemented Oracle Database 11g, 2 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.
Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.

Provided end to end administrative support on applications which involves Oracle databases.
Experience on Database level and object level Reorganization.
Coordinating with Application team on a daily basis for the implementation of production and non production changes.
Implemented and maintained database through DBA activities include database backup (Cold, Hot and Import/Export).

Building New database from Scratch including database design tasks, requesting Space from Storage ,creating & scheduling scripts.
Work with developers and change management team to ensure smooth life cycle process from development through testing and production implementation
Writing SQL scripts for different purposes like monitoring the user’s processes and space management. Use existing scripts for daily database maintenance .
Performing data management tasks as required – loading, editing, restoring and removing data at the requests of our clients, in accordance with data retention policies.
Allocate storage and develop plans for future storage requirements.
Resolving incidents with proper resolution via ticketing tool.
Resolving user queries via one to one mail & also through on call support.

Checking of Alert log and Trace files to monitor the database on a daily basis.
Experience in working on tickets as part of regular database administration in Remedy tool.
Checking CRON Jobs and rescheduling process and monitoring.
Experience in vulnerability and remediation.

Oracle 10g/11g Installation & database creation on Rhel 5.4, Windows 2008/XP and client on terminals.
Managing 11g/10g Datagaurd (Physical Standby Databases).
Applying CPU/bug patches.
Database 9i to 10g upgrade + platform migration using export / import.
Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.Reorg, index rebuilding.
Schema refresh, cloning.
Standby database creation.

Database backup/restore activities
Monitor and optimize the performance of the databases
Performing daily maintenance including monitoring backups, managing disk space, and maintaining database objects
Production database support and issue resolution
Providing database security administration such as User ID’s, Passwords, roles, etc.

User management, Table space Management and regular maintenance activities.
Network configuration like Listener, Tnsnames.
Database Replication (Db links and Materialized views and downstream captures, Streams).
Monitoring growth of tables and undertaking necessary re-organization of tablespaces and indexes when required.
Space management of data files according to Tablespace growth.
Creating Users and Profiles, roles. Managing object and system privileges, granting, revoking privileges.
Created tables, indexes, back-end triggers, stored procedures, and functions.

oracle dba