PROFESSIONAL SUMMARY:

• 9+ years of experience as an Oracle Database Administrator having hands on experience in database creation, administration, production support, configuration and upgrades.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g & 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Expertise in different environments like HP - UX, SUN SOLARIS, AIX, Linux and Windows.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), and monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Hands On Experience in installing, configuring and managing Oracle 11g RAC with ASM and 11g CRS.
• Hands on experience in 11g R2, 12c grid infrastructure.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in regular DBA activities such as Upgrades, Patches, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning and documentation.
• Experience in using Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and 10g Grid Monitoring.
• Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• On call 24x7 Production Support Worked beyond regular hours.
• Dealing with database security and auditing.
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems: MS Windows NT/XP/Vista, HP-UX 10.x, 11.x,Sun Solaris 2.5, 2.6,5, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 2.1, 3.x, 4.x, 5.x, 6.x

Programming Languages: SQL, PL/SQL, Unix Shell Scripting.

RDBMS: Oracle 8i/9i/10g/11g/12c

Software’s, Applications and Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential

ORACLE DBA

Responsibilities:

• Upgraded Oracle databases 11.2.0.4 to Oracle 12c (12.1.0.2) on RHEL.
• Applying Patch Updates (PSU, One-off Patches) to the databases & Clusterware.
• Monitoring and optimizing the performance of the database, capacity planning and sql tuning.
• Perform switchover activity between primary and standby to verify business continuity in the event of disaster.
• Refreshed schemas from Production environment to Dev/Test/SIT environment using expdp/impdp utilities.
• Creation of restore points and flashback the database to restore points to support testing requirements.
• Worked closely with data Modelers/data Analysts to create the logical/physical data model using Erwin tool and successfully deploy the changes to databases.
• Extensively worked on GG log dump utility to troubleshoot extracts trail file information.
• Setting up Golden gate integrated capture to current classic capture by creating downstream mining database and documentation.
• Solving production issues when there are any discards and when databases are out of sync, reading trail files using GG log dump utility.
• Used Explain Plan for monitoring and troubleshooting long running query’s for cost determining and better performance.
• Responsible for maintenance of databases using SRVCTL, OEM, maintaining Oracle Cluster using CRSCTL.
• Applying one off patches and PSU's to fix software related bugs, security related bugs and patchset upgrades using optach utility.
• Daily Health Check Up and performance statistics of the Database using Statspack, AWR and ADDM.
• Production support and providing 24/7 on-call support.
• Work with Oracle Support on SR’s to resolve database issues.

Confidential

ORACLE DBA

Responsibilities:

• Performed various tasks like administering RAC using SRVCTL, CRSCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Installing ASM environment and migrating databases from NON-ASM to ASM.
• Extensively worked with ASMCMD for managing ASM environment.
• Upgrading Database from 10g to 11g using DBCA and manual method and applying patches using optach utility whenever required.
• Experience in reorganizing database, indexes and tables thereby tuning the performance of a database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database & Data Pump.
• Used Export/Import, Data Pump utilities to move the data between different databases and for backups.
• Conduct data model reviews with project team members.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for Wisdot.
• Created and implemented ER models and dimensional models (star schemas).
• Experience in Installation and configuration of Oracle Golden Gate for replication of data.
• Analyzed logical and physical design requirements of the applications.
• Troubleshoot user related and database related issues using Oracle Support Services.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• 24x7 production support

Confidential

ORACLE DBA

Responsibilities:

• Experience in 10g/11g Oracle RDBMS installation on Linux platforms (RHEL4/5, SOLARIS, AIX 32 and 64 bit), migration, upgrade, configuration, backup, recovery, database clone, patching, archiving and purging activities.
• Monitoring and optimizing the performance of the database, capacity planning and sql tuning.
• Refreshed schemas from Production environment to Dev/Test/SIT environment using expdp/imp and expdp/impdp utilities.
• Used Explain Plan for monitoring and troubleshooting long running query’s for cost determining and better performance.
• Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, Active cloning, recovery and restore of database.
• SQL and PL/SQL Performance Tuning: Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER) and Auto trace.
• Troubleshoot database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Worked in various areas of Data guard i.e. Recovery, RTA (Real Time Apply), Tuning, Switchover and Failover.
• Analyzed logical and physical design requirements of the applications.
• Configured Physical standby for high availability and for disaster recovery (Data Guard).
• Experience with streams in enqueuing and dequeuing messages. Troubleshooting with streams capture, Propagation and apply processes.
• Database population using SQL*Loader.
• Production support and providing 24/7 on-call support.
• Work with Oracle Support on SR’s to resolve customer issues.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Designed, configured and installed Oracle Real Application Clusters on a 2 node Cluster.
• Performed backup and recovery activities on the RAC databases.
• Experience in taking backup of OCR.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Applied patches or upgrades to the database as needed.
• Created number of LINUX shell scripts for various tasks.
• Worked on Oracle Metalink in case of problems.
• Experience in using Veritas volume manager on UNIX.
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Configured ASM for RAC setup and non RAC databases.
• Assist application developers to meet their day to day requirements related to performance.
• Handled databases with size more than 1 TB.

Environment: Oracle 9i/10g, RHEL 4, IBM-AIX 5L, Veritas volume Manager, OEM (Grid Control), RMAN, RAC, ASM, PL/SQL, TOAD and SQL *PLUS.

Confidential, Tampa, FL

Oracle DBA

Responsibilities:

• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
• Installation, configuration, maintenance of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• Having good experience with memory structures such as the database buffer cache, shared pool and library cache.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Cloning & duplicating databases using scripts as well as RMAN.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Monitoring the database storage and day-to-day activities.
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Performing SQL*Loader jobs for loading data from text files

Environment: Oracle 11g R2, RHEL 5.6, IBM AIX 5.3, Shell Scripts, TOAD 8.5, SQL*Loader, RMAN, OEM, Grid Control.

Confidential

Oracle DBA

Responsibilities:

• Worked in Oracle 10g, 11g R2 Sun SOLARIS 5.8 RHEL, HP UX 11.23
• Worked on 11g R2 grid infrastructure in RAC environment.
• Implemented Data Guard for Disaster recovery system using Oracle 10g
• Setup and configure Standby database for high availability by using Data Guard.
• Created new 10g Database and performed regular RMAN backups for all the databases.
• Patch Analysis, Patch Installation.
• Documented instructions for migrating & upgrading databases.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles.
• Worked as part of a team and provide 24x7 supports when required.
• Created and configured Data guard.
• Implement and maintain database security.
• Took remote export of a database residing on a remote server using tns entry (same oracle version) due to non availability of space in legacy server.
• Created db link for inserting large tables directly without taking export.
• Managed databases of various sizes ranging from 1 GB to 50 GB.
• Online index rebuilds and storage recovery.
• Taking Hot and cold backups.
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using STATSPACK and AWR.
• Increased performance of sql queries by creating materialized views and by enabling query re-write.

Environment: Oracle 10g, 11g R2 HP-UX 11.11, 11.23, Sun Solaris 5.8/5.9, data guard, oracle streams, OEM grid control 10g, Sql developer.

Confidential

Oracle DBA

Responsibilities:

• Responsible for maintenance and improvement of production, archive Oracle databases.
• Replicated tables, views and triggers using SNAPSHOT and MATERIALIZED VIEWS.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments and Rollback segments.
• Monitored Alert Log Report and system Error Logs.
• Cloned database from PRODUCTION to create TEST, DEVELOPMENT and UAT instances.
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Installed and Upgrade database with help of patches to maintain environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Worked with Data Guard to protect a standby database from corruptions that attempt to propagate from a primary database.
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
• Extensively worked on Full/Incremental backup with the Block Change Tracking utilities.
• Drastically reduced unscheduled downtime and improved performance.
• Monitoring and tuning database performance using STATSPACK, TKPROF and DBMS STATS.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.
• Worked in a 24/7 supporting environment with ON-CALL rotation

Environment: SUN SOLARIS 8, Oracle 9i, PL/SQL, Windows NT, shell scripting.