Description
ASM, adding, deleting disks to the disk group. * Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster. * Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth. Oracle Database Administrator Honor Health - Phoenix, AZ Sept 2013 - Feb 2015 Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2. * Performed disk and disk group management in ASM while installing 11gR2 RAC. * Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2). * Ensured that oracle database systems operate securely and efficiently. * Managing databases from planning and testing stages through implementation and support. * Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning. * Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control. * Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances. * Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN. * Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs. * Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups. * Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries. * Maintained the data integrity and security using integrity constraints and database triggers. * Provided 24X7support for all the production and development databases. Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK. * Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams. * Proficient in database concepts with rich experience in database design, development and management. * Excellent knowledge of Oracle architecture, Golden Gate architecture, SQL Performance tuning, SQLT and eager to explore any unknowns. * Good working knowledge of troubleshooting Infrastructure issues related to Oracle database server such as memory, CPU, I/O, Disk etc.
Accomplishments
Highlights:
Job Skills
Keywords
