SUMMARY

• 8+ 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
• Experienced in installing, configuring, administering and managing oracle databases & implementing solutions like High availability (HA), Disaster & Recovery, Cloning, and Database security.
• Installation of Oracle 11g/12c RAC software with ASM File systems.
• Implemented RAC and Data guard on Linux & multiplexing of control files and redo- logs for disaster recovery scenario
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes
• Experience in Golden Gate replication - installation, configuration and maintenance
• Installed & Configured Oracle 10g grid and maintained in large environments.
• Migration and Up gradation of databases to 11g and 12c
• Installation, setup, configuration and plugins on OEM12c Grid
• Involved in Installation, Configuration and implementation of Oracle 11gR2 on Exadata Environment.
• Construction of Catalog Databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Installed PSU and CPU patches using OPatch utility.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like statspack, TKPROF, EXPLAIN PLAN, ETL, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Detecting and diagnosing production system performance problem by analyzing Statspack reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Created clone databases for development and test environments using RMAN and user managed cloning and implementation of Flashback Technology.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views, import/export and advanced replication methods.
• Created database & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune the system performance
• Expert in Administering 7X24 OLTP, Data Warehouse, OLAP, and Hot Standby (Data Guard) databases. Ability to analyze, plan and execute to perfection.
• Have knowledge on UNIX administration on OS installations.
• Experience as Oracle DBA in all life cycle of project i.e. production, development and test environments
• Interacting with the Oracle support on Service Requests and implementing the solutions provided for successful completion of the tasks.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i

Operating Systems: UNIX, Sun Solaris, Windows XP/2000/2003,Linux Red Hat, Novell Netware 3.0,Suse Linux

Languages: SQL, PL/SQL, XML,UNIX Shell Scripting

Oracle Products: Real Application Cluster(RAC), Data Guard, Golden Gate, Import and Export, Data Pumps, ASM, RMAN,TDE,Oracle 10g/11g/12c Grid Control,OEM

Performance Tuning: Quest SQL Optimizer, SQL tuning advisory, STATSPACK, TKPROF, Explain Plan, AWR, ADDM, ASH report.

Tools: and Utilities: TOAD, Putty, ERWIN, Sql * plus, Sql Loader Utility, NETCA,DBCA,VERITAS,Log miner,ETL tool, SRVCTL,CRSCTL

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Sr. Oracle DBA

Responsibilities:

• Installed Oracle DB 12c RDBMS, RAC on ASM, Applying Oracle patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning.
• Involved in Implementation of Oracle Grid Control 12C - Installation and Configuration of 3 OMSs for Software Load balancer and 3 node RAC OEM Repository.
• Installation of various plugins supporting Golden Gate, Exadata Machine and Agents
• Implemented Golden Gate for major application for uni-directional, Bi-directional replication includes, installation, configuration and troubleshooting
• Done Installation and configuration of Golden Gate on 12c database for the replication.
• Resolving the conflicts between the target and source database and Implemented Bi-Directional replication in golden gate.
• Implemented Data Guard - creating 2 Standby Databases on production environment.
• Migration of 2-4 TB Database level from non -Exadata to Exadata environment.
• Weekly data refreshes using data pump and RMAN from Production to UAT / BUAT.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance and Well Experienced in taking Cold Backup for a very Huge 64-Tb Database.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.
• Experienced with troubleshooting the failed backups by working closely with TSM and Net Backup Support.
• Applied Patches to 11g and 12g and used datapatch to upgrade 12c databases
• Migration of databases from 11g to 12c using data pump export/import utilities
• Responsible for 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.
• Experienced in Installing OEM agent and hooking up to the grid and Used OEM grid for monitoring the Listeners present in the oracle environment.
• Kept team members and management updated on major issues so they have a clear picture of situation.
• Applied PSU patches as recommended using opatch utility and opatch auto
• Rebuilding Index and reorganizing fragmented tables and Performance tuning of the databases using SQL Tuning, Used Tuning utilities like statspack, Tkprof, Explain Plan, ASH, AWR, ADDM and Tuning of SGA
• Supported more than 120 Production and Development databases
• Experience with peregrine ticketing tools for resolving the tickets.

Environment: Linux, Solaris 10, Oracle 11g,12c OEM 11g /12C, SQL*Plus, Xming, Oracle database links, ACFS, Partitioning, Datapump, Putty, opatch, ASM, Data Guard, Peregrine, Golden Gate, DDL, DML, Exadata, Unix HP

Confidential, St. Louis, Missouri

Oracle DBA

Responsibilities:

• Created and maintained databases for Production, Development and Test using Oracle 10g,11g.
• Installed Grid Infrastructure Software on new Linux Servers for 2 nodes and 3 node RAC and Failover environments.
• Install Oracle DB 10g,11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Oracle Grid Control 12c Installation and Configuration and Experience with 11g ASM Features and environment and applied necessary Patches during installation.
• Handy in utilizing data pump tool for exporting and importing the data.
• Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases in maximum performance modes
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Done Installation and configuration of Golden Gate on 11g database for the replication.
• Resolving the conflicts between the target and source database
• Implemented active-active configurations, data conflicts to be managed by the application, suitable for custom applications.
• 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, 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.
• Configured 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
• Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.
• Managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level and user management, Table space Management, Session Management, undo Management issues.
• Experienced with troubleshooting the failed backups by working closely with TSM and Net Backup Support.
• Experience with BMC tools for resolving the tickets.

Environment: Linux, AIX, Oracle 10g,11g, OEM, SQL*Plus, Xming, Putty, RAC, ASM, Golden Gate Data Guard, VERITAS, HINTS, TOAD, BMC, OPATCH, TDE, Datapump, OLAP, OLTP, Materialized views, UPGRADING, AWR, ASH, ADDM, STATSPACK

Confidential, San Jose, California

Oracle DBA

Responsibilities:

• Provided 24x7 support and On-Call rotation when needed for very large databases.
• Installed Oracle 11g on Linux and RAC 10g and worked on ASM feature of Oracle.
• Estimate the size of the database and its objects (in large database of 1 to 2 Terabyte).
• Upgraded database from Oracle 10g to 11g, obtained good exposure to Oracle11g.
• Installation and configuration of Oracle 10g RAC 2 node on Linux.
• Applied CPU security patches in both RAC and standalone systems in ASM environment.
• Experience with Oracle 10g/11g grid control and 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.
• Create Database users and roles and implement appropriate user security.
• Experienced with Oracle 11g ASM features and Implemented Oracle Replication through materialized view.
• Responsible for maintaining Oracle 10g data guard standby databases in Solaris, Linux and Aix platforms.
• 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.
• Experience with DDL and DML operations and having sound knowledge.
• Good experience with 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, Instance, memory, operating system and java calls.
• Writing UNIX shell scripts to manage Oracle environment and application processes.

Environment: Linux 4, AIX 5, Oracle 9i/10g/11g RAC, Toad, 10g Grid, OEM, Oracle Streams, Oracle Gateway, Dataguard, GoldenGate, SQL*Plus, Shell Scripting

Confidential

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.
• Installation and customization of Databases (10g&11g) 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
• 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 and Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Involved in writing UNIX shell scripting for automating the jobs and Manage users, privileges, profiles, schemas.
• Experience in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block Corruption Errors.
• 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, Informatica, Exp/imp

Confidential

Oracle Developer / DBA

Responsibilities:

• Involved in fine tuning stored Procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Produced DB Links in Oracle for communicating with external databases.
• Creation of database users, monitoring the roles and granting/revoking the privileges on the database objects like tables, indexes, etc.
• Experience with monitoring alert log files and determining data errors
• Implemented Backup & Recovery strategies for OLTP systems
• Worked as Support Database Administrator. Responsibilities include creation & maintenance of table spaces, data files, rollback segments, etc.
• Involved in optimizing SQL statements using Indexes and Hints.
• Involved in writing complex SQL statements.
• Responsible for administering and supporting production and development Oracle 10g databases and Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Taking care of regular activities like Space management issues, capacity planning, back up status and any user management issues.
• Implemented Hot, Cold and physical backups.
• Enrolled users and applications, setup them with the integration of database to access their applications easily.

Environment: MS Server -2000/2003, VMware, Novell Netware, Oracle 10g, RHEL 4, Database tools/utilities, SQL, PL/SQL