SUMMARY

• Around 5+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, Disaster recovery management.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g,11g,12c in UNIX/LINUX and Windows environment
• Oracle Golden Gate Replication Expert with knowledge in implementation of Golden Gate on both Standalone and RAC Servers.
• Implemented both unidirectional replication as well as bi - directional replicate using Golden Gate.
• Expert in using tools like Veridata for Data comparison which are involved in Golden Gate Replication.
• Good knowledge on usage of Logdump for debugging.
• Issuing compare/ Repair for Databases using Veridata Tool.
• Oracle DBA proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 9i, 10g, 11g, 12C databases on RHEL, Sun Solaris, HP-UX, IBM-AIX and Windows.
• Building Databases, Standby databases on Oracle 12c.
• Good at installation, upgrade, administration, backup, recovery, performance tuning, patching, network administration of oracle (RAC and grid control) OEM 12c, 11gR2, 11gR1, 10g, 9i, 8i, 7.3.4, primary and standby databases using data guard, enterprise manager and shell scripts.
• Good experience in installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• I've involved in migration of Database and up gradation from Oracle 10g to 11g.
• Exceptional Knowledge of various states of Software Development Life Cycle (SDLC) i.e. System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 8i,9i, 10g, 11g in Production, Staging, and Development environments.
• Developed backup and recovery policy and used new features/technologies to optimize system maintenance and extensive knowledge on Partitions
• Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. table spaces, rollback segments) and auditing of users.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager (OEM).
• Performed backup and recoveries on OLTP database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, SQL TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).
• Expert in Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN.
• Ability to restore and recover databases from file system backup in order to bring to the original state as per the business and user requirement.
• Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions of patches.
• Excellent Communication and responsible team player.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g R2 RAC, 10gR2 RAC, 9i

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and WindowsLanguages SQL, PL/SQL, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Data pump, Share Plex.

Other: VERITAS, Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, NC

Oracle Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Application support.
• Good knowledge on usage of LogDump.
• Building Databases, Standby databases on Oracle 12c.
• Created new users, Roles, Profiles and assigning the required privileges to the users.
• Experience using Export/Import and Data pump for migration of databases.
• Table Partitioning, Creating Locally managed Table spaces.
• Applying Oracle recommended patches.
• Created Standby Databases using Data Guard for Disaster Recovery.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.
• Actively involved in Switchover/ failover processes.
• Installed, configured and maintained Oracle Databases and Applications.
• Used Diagnostic & tuning packs along with AWR, ASH & ADDM reports.
• Creating and maintaining Views on Database objects.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Upgraded Dev and Test instances to 12c.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environment: Oracle EXADATA, 12C, 11g, OEM (Grid Control), Oracle Data guard, performance tuning, ASM, RAC, RMAN, Data pump, Import Export

Confidential, LA

Oracle Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Installed, configured and maintained Golden Gate on Oracle Databases.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Good knowledge on usage of LogDump.
• Issuing compare/ Repair for Databases using Veridata Tool.
• Building Databases, Standby databases on Oracle 12c.
• Created new users, Roles, Profiles and assigning the required privileges to the users.
• Experience using Export/Import and Data pump for migration of databases.
• Table Partitioning, Creating Locally managed Table spaces.
• Applying Oracle recommended patches.
• Created Standby Databases using Data Guard for Disaster Recovery.
• Install and configure Oracle Veridata for comparison of Databases involved in Golden Gate Replication.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.
• Actively involved in Switchover/ failover processes.
• Installed, configured and maintained Oracle Databases and Applications.
• Used Diagnostic & tuning packs along with AWR & ADDM reports.
• Creating and maintaining Views on Database objects.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Upgraded Dev and Test instances to 11g.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Application of patches and security patches downloaded from Oracle Metalink in lower environments before going to Production.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environment: Oracle 12C, 11g, OEM (Grid Control), Oracle Data guard, Sun Solaris, performance tuning, ASM, RAC, RMAN, Data pump, Import Export, HP-UX, and Red Hat.

Confidential, Miami, FL

Sr Oracle Database Administrator

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• System Study & Analysis, Design &Development.
• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Installed, configured and maintained Oracle 11g/10g/9i.
• Upgraded the database from oracle 10g to 11g.
• Complete the work in given time frame without missing any SLA
• Tuned SQL statements to implement 55 concurrent connections to load historical data into the Siebel schema.
• Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Real application cluster (RAC) 11g/10g managing nodes, node addition deletion and monitoring.
• Created Production, Stage and Dev Enterprise data warehouse.
• Also applied Interim (One-Off), Setting up physical and logical standby database/data guard at DR site for operational recovery.
• Creating and maintaining services in RAC for best resources utilization and for high availability
• Implemented weekly cold backup.
• Backup plan designing and implementation using cold/hot backups for database.
• Expertise in non-Exadata to Exadata migrations.
• Expertise in Database Performance and Tuning and SQL Tuning including Exadata.
• Assist ETL, Report developers with performance tuning ETL jobs & report executions.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.
• Implemented Replication of Oracle Databases using Logical Standby and Streams
• Installed & configured Oracle 10g Enterprise Manager (OEM) (grid control) for monitoring of production & development databases.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Standby Database (Data Guard) setup and configuration.
• Expert in creating clone/standby databases via Data guard for Database Disaster Recovery.
• Responsible for CPU and PSU patch management.
• Support application admin and developer groups to define SLA’s, Incident Management and Dashboard reports
• Created Replication database, objects, groups and administered replication environment.
• I/O Tuning and balancing I/O by monitoring file system and table space I/O statistics.
• Extensively worked on Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Developed Shell Scripts for managing day-to-day activities and automation of backup.
• Backup and recovery strategy of Database using RMAN and scheduled manual backups to disks as well as tape drives.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, recovering data files, recovering from Block Corruption).
• Management of Control file, redo log, Undo and table partitioning (Range, List) methods.
• Managed database security by implementing security policy, administering users and password files.
• Used export/import utilities and applied patches.
• Worked on PL/SQL packages, stored procedures, functions and triggers and assisted in generating reports using crystal reports.
• Coordinate with UNIX administrators for space management on various servers.
• Did Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Generated regular Stats-Pack reports for the performance tuning of the databases.

Environment: Oracle 11g/10g/9i, OEM (Grid Control), Oracle Data guard, Sun Solaris, performance tuning, ASM, RAC, RMAN, Data pump, SQL*Loader, TOAD, AIX, HP-UX, and Red Hat.

Confidential, Irving, TX

Sr Oracle Database Administrator

Responsibilities:

• Maintenance of 3 reporting databases, 18 Test/Dev databases and 9 production databases (Includes 10g Dataguard and 10g RAC).
• 10g Real Application Clusters (RAC) installation and maintenance.
• Upgraded databases from 10g to 11g.
• Installed Oracle 11g R1.
• Installed and configured Oracle 10g - Grid control.
• Installed Oracle Quarterly security patches.
• Documented all ongoing on-call issues with approach towards it.
• Responsible for refreshing testing databases with production data using RMAN and Data Pump.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Performed database tuning by using various tools, like GRID, Oracle Enterprise Manager and STATSPACK/AWR Reports.
• Database test environment coordination for various releases with the Test Environment Coordination group.
• Preparing project plan and production deployment packages of database changes for major releases.
• Coordinate and work with System DBAs, SAs, and Storage Teams in their tasks to keep the databases up and running and plan for projects which involves hardware or system level changes.
• Worked on Performance Tuning and Optimization using T-SQL, Execution Plan, Index Tuning wizard, system stored procedures and Tables.
• Monitoring the various database activities by developing shell scripts and using various tools.
• Developed scripts to monitor the storage usage, object status for daily job and for RMAN backups, SQL*Loader, export and import of database.
• Ensures that all Remedy tickets are assigned and resolved in a timely fashion.

Environment: s: Oracle 11g RAC, 10g RAC/9i, IBM AIX, HP-UX, Red Hat Linux, performance tuning, Sun Solaris, Windows XP, SQL*Plus, SQL*Loader, SQL Developer, TOAD, Oracle Data Guard.

Confidential

Oracle DBA

Responsibilities:

• Installation, Implementation and maintenance the Oracle database
• Created and managing the database objects such as tables, indexes and views
• Create the users and roles
• Management of Tablespaces such as creation and dropping and modification of Storage parameters for disk optimization, coalescing tablespaces regularly in case of fragmentation and Analyze the statistics periodically and taking necessary action
• Created and managing the database storage structures which includes data table spaces index table spaces, rollback table spaces and rollback segments
• Loading the database with SQL*Loader.
• Performing the logical and physical structure of tables, indexes, modeling normalization and foreign key constraints
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant.
• Upgrade, patching Oracle databases.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting. Implemented Basic Replication using materialized views
• Setup backup and recovery procedures using RMAN.
• To improve the performance by Using the Hints, Indexes, Sql Trace, TKPROF, STATSPACK.
• Monitoring system performance, SGA tuning, rollback segments, space usage.
• Creating and rebuilding indexes and optimizing the code to improve the performance after analyzing the trace files.
• Monitoring the database daily activities

Environment: Oracle 10g,9i RMAN, SQL*Loader, Sun Solaris, RHEL, Oracle Linux

Confidential

Oracle DBA

Responsibilities:

• Created partitioning of its types like Range, List & Hash by the specific use
• Install, upgrade and configure Oracle RDBMS Software (10g& 11g) and applying CPU patches from Oracle.
• Involved in Installation of 11g RAC on Oracle Clusterware.
• Migrated data from non RAC to RAC Production.
• Taking care of frequent users request of refreshing there non production Databases.
• Cloning of production databases for test and development purpose.
• Building and implementing backup and recovery using Recovery Manager (RMAN) and export/import.
• Creating Users, Roles and object privileges to respective users.
• Performing daily and weekly monitoring of database
• Providing assistance to the other members of development team with application tuning

Environment: Oracle 9i, 10g,11g, PL/SQL, Windows 2000,Linux, Solaris Toad.