Oracle Database Administrator
Nityo Infotech
Total years of experience :10 years, 1 Months
Working on 10g/11g R2 RAC Database.
•Creating and Resolving The Tickets according to the priority.
•Performed taking backups of OCR and VOTEDISK files.
•Adding of Node to Existing Cluster.
•Successfully cloned Non-Rac database to Rac databases.
•Applying database Patches using Opatch Utility on Production Environment.
•Having experience in creation and maintenance of the users along with Security Roles and Privileges.
•Monitoring AWR and ADDM reports to identify Performance Issues and optimized CPU, Memory, I/O and Network resources utilization.
•Creation and Maintenance of Database Instance, database objects, Database Links.
•Create users, assigning Profiles and allocation of default table spaces.
•Involved in Oracle database Upgrade from 9i to 10g.
•Backup database using export/import.
•Supporting to RAC environment and maintenance activity.
•Creating database Links and Materialized Views.
•Creating Tablespaces, Users and Roles for test environment.
•Monitoring Alert log files.
•Capacity Planning and future Database Growth allocation.
•Maintain client relationships by providing timely, Superior Quality Services.
•Refresh activities on Testing & Development databases with Production data using.
•Export, Import, and cold backup and hot backup restore
•Running Packages and Scripts in the databases as per application requirement.
•Good hands on knowledge of Oracle Recovery Manager (RMAN) for Backup and recovery.
•Report Database Health status to the Management.
•Involved in Oracle installations, Database Administration, Backups & Recovery through RMAN, Database Tuning, Table space Management, Security, Import & Export and Auditing.
•Preparing documentation and reports.
•Having extensive experience in installation, migration, upgradation and troubleshooting
•Designed and implemented various high availability solutions for a diverse group of clients running Oracle9i, Oracle10g, and Oracle11g using Data Guard, RMAN
•Provided training & knowledge transfer to new team members and developers on Oracle architecture, Oracle new features, tuning methodologies, database replication, RMAN backups
•Configured standby and redesigned a thorough backup and recovery strategy for all major production systems to overcome from media failure, user failure, and system crash.
•Configured physical standby database through RMAN, configured and observer processes, experience in Data Pump, export & import, physical hot backup, RMAN, experience in regular DBA activities such as database refresh, schema refresh & DB alerts, Database migration and database up gradation
•Raising SR to Oracle and contacting them for critical error
•Fulfilled DBA daily activities including user management (creating users, privileges, roles, quotas etc.), object creation & space management
•Maintaining peak performance of all production databases by AWR & other tuning methods
•Handling 24x7 on-call production database support and ensuring smooth running all production DBs
•Maintaining standby Databases for high availability and disaster recovery purpose.
•Upgrading Oracle Database from 9i to 10g, 10g to 11g
•Apply CPU (Critical Security Patches) Patch’s on quarterly basis on database’s
•Performing database tasks like adding the data file, resizing the data file, User/Role creation, privileges and maintenance
•Import and Export, RMAN Backup, Database Cloning, Backup and Recovery
•Management of Undo segments, Table / Index segments & Monitoring Fragmentation
•Providing On-Call Production Support
•Experienced in different types of Recovery
Database Oracle 10g, various Releases & 11gr2.
Operating System : Windows 2003/2008/2012
courses: Oracle
courses: Oracle
courses: Oracle Certified Professional (OCP): ORACLE
courses: Oracle
i am an computer science engineer ,working in Wipro Technologies as Oracle Database Administrator . Please let me know if you have any such requirement