SUMMARY

• Over 8+ years of experience as Oracle Database administrator, Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP (multiple instances)/OLAP databases in production.
• Experience in installing, configuring, administering and managing oracle databases & implementing solutions like High availability (HA), Disaster & Recovery, Cloning, and Databasesecurity.
• Installation of Oracle 10g RAC software with ASM & OCFS2 File systems has been implemented.
• Installed & Configured Oracle10ggrid .
• Performed Migration and Up gradation of databases to 11g and 10g.
• Implemented RAC and Data guard on Linux & multiplexing of control files and redo - logs for disaster recovery scenario.
• 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.
• Experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Having good knowledge on EXADATA and involved in moving databases in RAC and EXADATA environment.
• Construction of Catalog Databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performed switchover &failover and monitor using Data Guard manager command line.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Extensively worked in setting up Oracle physical, logical standby database.
• Setup, Configured and Maintained Oracle Data Guardto control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views, import/export and advanced replication methods.
• Experience in maintaining ETL tools for reporting solutions.
• Experience in User Management by granting, Revoking Privileges according to requirement.
• 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.
• Experienced in database reorganization regularly for removing row migrations and fragmentation using export and import utilities. Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Interacting with the Oracle support on Service Requests and implementing the solutions provided for successful completion of the tasks.
• Possess top quality skills in project management, customer support & system maintenance and a Team player with good analytical and communication skills, ability to quickly adapt to new environment.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, Oracle 12C/11gR1 R2/10g

Operating Systems: UNIX, Sun Solaris, Windows XP/2000/2003,Linux Red Hat.

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

Oracle Utility: RMAN, OEM, Export/Import, Data Pump, SQL*Loader, DB Verify, Log Miner, ASM CMD, Data Guard, Golden Gate, Streams

Performance Tuning: Grid control, Toad, Quest SQL Optimizer, STATSPACK, TKPROF, AWR, ADDM, ASH report.

Tools: TOAD, SQL* Loader Utility, OEM Grid Control, RMAN,NETCA,DBCA,SRVCTL,ORCAD

PROFESSIONAL EXPERIENCE

Confidential, Washington

Oracle DBA

Responsibilities:

• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed an application
• Creating primary objects (tables, views, indexes) once application developers have designed an application
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with your Oracle license agreement
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Planning for backup and recovery of database information
• Maintaining archived data on tape
• Backing up and restoring the database Contacting Confidential for technical support.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Scheduling the backups for the database using Enterprise Manager 12C cloud control.

Environment: Exadata, Oracle 11gR2, RAC, Data Guard

Confidential, Pennsylvania

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on SUN SOLARIS.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Installed, configured and maintained Oracle 2 /3 Node Real Application Cluster.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Configured disaster recovery databases using Data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Worked on Active data guard and performed Troubleshooting data guard environment.
• Applied patch set and interim patches whenever required to make the database software up to date.
• Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities.
• Migrated the Database from Non-ASM to ASM.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Configured and Implemented Cold/Hot Backups.
• Taking the RMAN incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Providing Application Support for performance and database related issues.
• Implementation and configuration of Oracle GOLDEN GATE.
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Scheduling the backups for the database using Enterprise Manager 12C cloud control.
• Cloned schemas, objects and data between servers using Data pump.
• Configured Oracle Transparent Application Failover (TAF) setting for Production databases.
• Experience in performing backup and recovery operations using RMAN.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Performed data refresh at Table level, Schema level, Tablespace level using DATAPUMP.
• Performed 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.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performance Tuning for the SQL queries which are Running slow and consuming high resources
• Involvement in day to day activities like Space management, rectification of Lock problems, managing quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Sun Solaris, ASM, Golden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Minneapolis

Oracle DBA

Responsibilities:

• Installing Standalone and RAC environments on various platforms like LINUX and Windows.
• Performing DRdrill activity.
• Appling patches like CPU, security database patches using OPatch utility.
• Worked on Installing OEM 12C agents and Transition of the Project from Architecture to Operations.
• Done up-gradation from 10g to 11g and applied patches when required.
• Creating RAC database with ASM and Data Guard configuration which includes primary and standby database creation.
• Installing, configuring, maintaining and troubleshooting Oracle Cluster ware, databases, Oracle Binaries and Oracle Client on Windows and Linux environment through GUI as well as Silent Installation.
• Refreshing databases using RMAN.
• Patched and upgraded 10.2.0.3 RAC database to 10.2.0.5 RAC.
• Responsible for importing and exporting database and objects as per the requirements.
• Exporting and purging the old data as per the business requirements
• Troubleshooting node eviction issues and applying CRS# bundle patch using OPatch utility for bug fixing.
• Checking DataGuard status of databases and resolving issues like sync with its primary database.
• Analyzing AWR and giving suggestions and recommendations for Performance and tuning.
• Involve in Table Re-organization and Index rebuilding.
• Managing Sync issues in standby database.
• Troubleshooting RAC databases &ASM issues, network&database connectivity issues and Oracle connectivity issues.
• Refreshing databases using RMAN.
• Logical Refreshing of DB (using Export/Import and Data pump).
• Efficiently managing backups and recovery through RMAN which includes RMAN duplication, refresh and cloning in Standalone, RAC and Data Guard Environment.

Environment: Linux, Putty, OEM, ASM, DATA GUARD, RAC, RMAN, Remedy Ticketing Tool.

Confidential, IL

ORACLE DBA

Responsibilities:

• Installation and Maintenance Oracle 10g databases IBM-AIX and Windows environments providing24*7 Production Support.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Used Oracle Streams for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases.
• Using the tools such as TKPROF, EXPLAIN PLAN, and TRACE FILE to tune SQL Queries.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Migrated data from production to test using data pump expdp/impdp utilities.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Administration and Management of Oracle 10g RAC database storage using ASM by creating failover groups.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Done Point-In-Recovery (PIT) Database recovery for testing purpose and again recovered back to the current state.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Importing data from flat files into database using SQL loader and External Tables.
• Configured and Implemented Oracle Flashback technology to recover tables/database.
• Performance tuning of corporate databases, using tools like SQL trace, AWR, ADDM, SQL Tuning.
• Perform database capacity planning and growth projection by monitoring the tablespace requirements and ensuring that there is enough disk space available to support the various end-user applications that access the databases.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNS names, SQLNET, V$ and DBA views.
• Mentoring the Database Performance using automated scripts.

Environment: IBM AIX 6.1,Oracle9i/10g,10g RAC, RMAN, Data Guard, RAC, SQLTRACE, TKPROF, explain Plan, AWR, ADDM, TCP/IP, Listeners,, SAN, Data pump.

Confidential

Oracle DBA/Developer

Responsibilities:

• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used STATSPACK, PERFSTAT and TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: Oracle 8i,9i, SQL, Oracle Enterprise Manager Database Control, SQL Developer, PL/SQL, SQL*Loader, NT.