SUMMARY

• Over 7 Years of specialized experience in IT Industry as an Oracle Database Administrator on different flavors of UNIX (Red Hat Linux, HP - UX, Sun Solaris, IBM AIX) and Windows(Windows NT/ 2000/2003/2008 ) in production, development and test environments.
• Experience in installing, configuring, administering, managing oracle databases, implementing solutions like high availability (HA), Disaster & Recovery, Cloning, and Database security.
• Expertise and implemented Oracle 11g RAC software with ASM.
• Good experience in Implementing RAC 10G/11G in different UNIX platforms.
• Having good experience in adding single instance database into cluster.
• Up-gradation of databases to 10g and 11g and applied PSU and CPU patches.
• Having good experience in Migration between AIX, UNIX and Linux Platforms.
• Migrated oracle databases with minimal downtime from 10g/11g Solaris/Unix to 11gR2 Linux platform using Transportable Table Spaces and exude.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Implemented and configuring replication technology using Data guard
• Installed Oracle Golden Gate, configuration and troubleshooting on Linux & UNIX Platforms.
• Setup, Configured and Maintained Oracle Data Guard on 10g /11g to control Primary and Standby Databases and also to ensure disaster recovery
• Implemented RMAN backup strategies for databases sizes ranging from 150gb to 14T databases. Implemented Full, incremental and cumulative using RMAN and used third party tools such as AVAMAR, VERITAS for backup, restore, recover and disaster recovery of databases
• Developed scripts to perform Backups of Large Databases to fit the backup window using RMAN
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like stats pack, TKPROF, Explain Plan, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes. Identifying bottlenecks with memory and disk contentions
• Have good experience in Creating databases & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune system performance.
• Have knowledge on Linux/Solaris administration on OS installations.
• Experienced in database reorganization regularly for removing row migrations and fragmentation using export and import utilities.
• Responsible for table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Prepared documentation for change requests for future
• Interacting with the Oracle support on Service Requests and implementing the solutions provided for successful completion of the tasks.
• Used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN

TECHNICAL SKILLS

Database: 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i.

Oracle Products: Oracle Real Application Cluster 10g/11g, Golden Gate, Data guard, Import and Export, Data pumps, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle Exudate, RMAN, Transparent Data Encryption.

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.x

Languages: SQL, PL/SQL, Unix shells scripting.

Tools: & Utilities SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool.

PROFESSIONAL EXPERIENCE

Confidential, TN

Oracle DBA

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments
• Installed Oracle Grid Control 12c Installation & used OEM 11g/12C for monitoring targets.
• Experienced in Installing OEM agent and hooking up to the grid using OEM 12C.
• Configuring OEM 12C grid for monitoring the Listeners present in the oracle environment
• Worked in troubleshooting RAC and implemented 11g New ASM features.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g
• Extensively worked in setting up physical standby database using Data guard
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases
• Handy in utilizing data pump tool for exporting and importing the data between databases.
• Involved and Upgraded Analytical Databases from 10g to 11g.
• Installation and configuration of Golden Gate on 11g database for the replication.
• Resolving the issues in conflicts between the target and source database in golden gate
• Configured Extract, Pump, Replicate for different tables as per the replication specifications
• Used defend utility to create definition files and helped different application teams to resolve issues in time
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Understood the concepts of AMS (Archival Management System) and implemented successfully in production environment to archive historical data.
• Well Experienced in taking Backup for a very Huge Databases using AVAMAR.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.
• Having good exposure in user management, table space management, session management, undo management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Experience with remedy ticketing tools for resolving the tickets
• Provided 24x7 support and On-Call rotation when needed for very large databases

Environment: Linux, Solaris 10, Hp-Unix, EXADATA X2-2, Oracle 9i,10g,11g,OEM,SQL*Plus, Xing, Putty, ASM, Data Guard, TSM, AVAMAR, Golden Gate

Confidential, Wayzata, MN

Oracle DBA

Responsibilities:

• Installed Oracle 11g on Linux and Worked on RAC 10g and worked on ASM feature.
• Installation and configuration of Oracle 11g RAC 2 node on Linux
• Changed scan port number, troubleshooting cluster ware components, performed HEALTH CHECKS in RAC clusters
• Applied CPU security patches in both RAC and standalone systems in ASM environment.
• Experience with Oracle 10g/11g grid control.
• Responsible for maintaining Oracle 11g/10g standby databases in Solaris and Linux
• Done up-gradation from 10g to 11g and applied patches when required.
• Configured 11g new feature Active Data guard on 11g and maintained standby databases.
• Executed Switchover operation during planned maintenance
• Executed offloading operations on standby
• Involved in conversion of physical standby to snapshot standby for testing purposes
• For the improvement of database performance, implemented database tuning and its requirements and reviewed it.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them as required and Create Database users and roles and implement appropriate user security.
• Experienced with Oracle 10g/11g ASM feature.
• Created disk groups with required redundancy levels
• Migrated Non-ASM databases to ASM environment for high availability on 11g.
• Implemented active-active configurations usually require data conflicts to be managed by the application, suitable for custom applications.
• Implemented Oracle Replication through materialized view.
• 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.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Experience with database partitioning and responsible for daily loads.
• Worked on setting up auditing in databases
• Experience with DDL and DML operations and having sound knowledge.
• Good experience with Oracle performance issues in both application tuning &memory tuning.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, and OS
• Writing UNIX shell scripts to manage Oracle environment and application processes.

Environment: RHEL 5, Sun-Solaris -9, Oracle 9i/10g/11g, 10g/11g RAC, Toad, 10g Grid,, OEM,ASM Oracle Streams, ERWIN, Oracle Gateway, SQL*Plus, Shell Scripting

Confidential

Oracle DBA

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Install, upgrade and maintain Oracle 10g on Sun Solaris/Linux
• Applied Patches on 10g and upgraded to higher versions of Oracle
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Database Restore using RMAN, Cold Backup and Export..
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup.
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.

Environment: RHEL 4, Hp - Unix 7, Linux Oracle 10g, 9i, 10g R1,Toad 8.5.3,RMAN,OEM, PL/SQL, SQL*Loader

Confidential

Junior Oracle DBA

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL & PHYSICAL i.e. Export & import and also having experience with EXPDP & IMPDP
• Implemented Consistent exports using SCN
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, Involved in writing UNIX shell scripting for automating the jobs
• Experience in using automatic monitoring and management processes like batch processing using Confab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment: Oracle 10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting