SUMMARY

• Over 5 years of hands - on experience as an Oracle Database Administrator.
• me has worked on Oracle 10g, 11g, and 12c versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK and High ability to analyze and understand teh AWR reports and can fine tune teh databases for maximum performance.
• Planned and implementing High Availability solutions wif Oracle 11g RAC, Oracle Data Guard and replication using Gloden gate.
• Knowledge in configuring Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill teh storage needs.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup including full, incremental and cumulative using RMAN and Cloning/Refresh of databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Proficient in complete, incomplete recovery of teh database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning,) on tables and indexes for high performance. .
• Performed Database Administration, Production Support, Installation, Configuration, Upgrades, Patches, Migration, Backup and Recovery, Performance Tuning, And Cloning on teh above said versions.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM) and maintaining Database Security using auditing.
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for teh purpose of monitoring multiple databases and application servers.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g wif Oracle Enterprise Manager (OEM) 12C cloud Control.
• Experience in configuration and administration of Data Guard (Physical/Logical standby) databases for switch-over and fail-over purpose.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1. RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, Winscp.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

Oracle Database Administrator

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Installed Oracle 11g on Linux platform using ASM and performed oracle Software's Installations, Creation of new standalone and Knowledge in setting up of 11G RAC and 10G RAC clusterware and instances. .
• Developed compliance reports and performed auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, truss and also used Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.
• Converting Standby database to Snapshot standby database for pre-go live activities.
• Implemented Oracle TDE(Transparent data encryption) to provide transparent encryption of stored data to support submission efforts wif release of Oracle 11g R2.
• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to teh Optimal Flex Architecture
• Created a Clone Database using RMAN on remote Server
• Implemented Data Guard wif high availability and performance configurations and participated in Data Guard Fail over tests.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups and point in time and instance recovery,
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS (visual memory system) and UNIX environments.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - Redwood Shores, CA

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases and Involved in teh installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) wif ASM file system on AIX platform.
• Monitored and maintaining different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Performed Database Upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database and Successful in applying RDBMS Patches, security patches for improving teh security and functionality of teh databases.
• Involved in teh installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) wif ASM file system on AIX platform.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve teh performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Expertise in Performing Tuning Database - Tuning involved me/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk me/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, AWR, ADDM, ASH, SQL tuning advisor etc.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Performed Full & Incremental Backup (cumulative and differential) using RMAN and implemented recovery strategies and Implemented Flashback technology of teh Oracle 11g, 10g along wif Recyclebin for a faster recovery of teh databases and database objects.
• Refreshed/cloned databases using RMAN utility.
• Used TOAD for database management.

Environment: Oracle 11.1.0.7, 10.2.0.5, AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential - Saint Petersburg, FL

Oracle Database Administrator

Responsibilities:

• Creation of schemas, controlled access, managing tablespaces
• Rebuild indexes, gathering statistics, Password and Profile management
• Transferring data from one server to another server by Export/Import Data Pump and Normal Export /Import utilities
• Refresh Test/Dev/Quality/Training/Sandbox environment from Production for Apps Team
• Regularly applying all CPU & PSU Patches to All Oracle Databases using Opatch
• Monitoring all Oracle Database backups using job scheduler like TIDAL(HP)
• Proficient in Performing Tuning Database - Tuning involved me/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk me/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF, AWR, ADDM. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload teh data into teh server using SQL loader.
• Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.
• Separated teh indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored teh buffer cache hit ratio and teh dictionary cache miss ratio. Teh DB BLOCK BUFFERS and SHARED POOL SIZE were increased, resulting in tremendous improvement in performance.

Environment: Oracle 11.1.0.7, 10.2.0.5, AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.