PROFESSIONAL SUMMARY:

• 6 years of experience as an Oracle Database Administrator, having hands on experience in database administration, production support, projects, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Extensively worked on Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Good experience in installation and rolling out operations on 12c databases for test, development and QA environments.
• Expertise in upgrade process from 10g, 11g to 12c and data migration from Non - ASM to ASM and Non-RAC to RAC.
• Highly skilled in administering Oracle ASM disk groups (mirroring, compatibility, and configuration) with Oracle ASM Configuration Assistant (ASMCA) including installation of Oracle ASM library modules.
• Effectively deployed active data guard standby on 11g database for test and production environments and performed switchover drills for immediate availability.
• Implemented FSFO (Fast start failover) on databases through Data Guard Broker. Configured disaster recovery site and Snapshot standby databases.
• Configured and administered 10g and 11g 2/3 node RAC database clusters through Oracle Clusterware utilities and High Availability Services.
• Efficient understanding on Oracle Cluster Resources and configuring the hosts with appropriate cluster service tools like CVU, OCRCONFIG,CRSCTL and SRVCTL, Private Network for Interconnect and Public Network (VIP, SCAN), monitoring the cluster resource daemon and the status of CRS.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Strong Knowledge of 11g advanced features like ASM, AWR, ADDM and FLASHBACK.
• Excellent Experience in installing and maintaining Oracle Data guard to implement physical Standby Databases for Disaster Recovery.
• Experienced in Installation of high availability RAC environment (2, 3 node clusters) and upgraded standalone databases to 11g RAC environment.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, data pump & Transportable Tablespace (TTS).
• Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Comprehensive knowledge and hands on expertise with Oracle Enterprise Manager (OEM) grid control infrastructure and TOAD.
• Expertness in Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, OEM and analyzing SQL trace dumps for …
• Well experienced in Query Optimization and identifying high load SQL statements methods through PL/SQL stored procedures, (DBMS *, UTL *)), SQLPLUS, SQLloader, with triggers and indexing strategies.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL, AIX, Solaris, Windows 2010

RDBMS: Oracle 12c/11g/10g (RAC, Golden Gate, Data Guard & Streams)

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp, impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Oracle Database Administrator

Responsibilities:

• Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
• Performed Replication using materialized views with a complete refresh/Fast refresh.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces
• Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration
• Development of policy and procedures as they relate to database maintenance, security and archiving.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used ADDM and AWR reports to monitor the database performance.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Assisted SQL developers to optimize the SQL queries and PL/SQL package stored procedures
• Developed DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Efficiently performed installation, setup and creation of 3 node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• SQL tuning and Database performance tuning based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.
• Experienced in documentation, provided documentation for database design, analysis, modifications, schemas refresh etc.

Confidential, Dublin, OH

Oracle Database Administrator

Responsibilities:

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Plan and schedule RMAN backups (hot, cold and incremental backups)
• Setup 12c Oracle Enterprise Manager (OEM)
• Implemented Transparent Data Encryption (TDE) for database security.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Hands on experience in troubleshooting RAC environment, using SRVCTL, CRS STAT and CRS profile.
• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.