Professional Summary Over 7 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation. * Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD * Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems. * Wrote scripts to inform the DBA's regarding the status, performance and space management of the database. * Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11g and 12c. * Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments for high availability and load balancing. * Participated in planning and implementation of off-site Disaster-Recovery planning and testing * Worked with development and operations staff in resolving problems quickly and efficiently * Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures. * Experienced in maintaining large Production, UAT, IST and DEV environments. * 24/7 support for Production databases and responsible for round-the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important. * Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments. * Experience with various Oracle concepts/tools including RMAN, OEM Grid Control. * Performed Installation, Configuration, troubleshooting, performance tuning, Backup and Recovery and production support of Oracle 11g, 12C databases (Single Instance and RAC) on Red Hat Linux. * * Implemented ASM on RAC and single instance databases. Managed disks and disk groups with ASM. * Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms. * Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs. * Planned and Implemented DR & High Availability oracle solutions using Data Guard, Streams. * Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM) * Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM. * Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) * Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups. * Experience in Cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment. . General ODI development, troubleshooting
Description
