SUMMARY:

• I have over five years of hands - on experience in Oracle Database Administration Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.
• Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
• Design and Architect End-to-End Oracle Database and Cloud Solutions based on commodity server, storage and network components.
• Testing and Validation of Oracle 12c/11g RAC databases on Dell Hardware Stack which include PowerEdge RAC and Blade Servers with networking Force 10 switches and storages like EMC, Compellent and Equallogic.
• Performing Fault Injection Test Cases for verifying High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
• Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implementation of Oracle Flash cache and different host based caching technologies like Dell Fluid Cache/Fusion IO to improve Oracle database performance.
• Design and Implementation of Oracle Disaster Recovery Solutions using Oracle Data Guard and Storage based replication technologies.
• Proficient in Performance tuning using AWR Reports, Reviewing Explain Plans for SQLs, Creating Baselines, Enable Tracing, Suggesting necessary indexes for boosting SQL performance.
• Experience in Database Security by implementing Data Encryption(TDE) and SSL Setup over insecure networks.
• Proficient in logical backups Export/Import and Datapump. Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL PROFICIENCIES:

Tunning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

RDBMS : Oracle 10g, 11g, 12c

Operating Systems : HP-UX 10.x, 11.x. Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

PROFESSIONAL EXPERIENCE

Confidential, Eatontown, NJ

Oracle Database Administrator

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Installation of 11.2.0.3 RAC(3 node) from the Scratch and the maintenance of the high available Databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM's native rebalancing feature.
• Installation of ASMLIB rpm packages. Initialize the asmlib using oracleasm init command. Portioning the disks using fdisk/dd command.
• Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware)
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Generating AWR/statspack reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports
• Implemented scripts to monitor and get information on free space, alert log errors Provided maintenance of user accounts, privileges, profiles and roles.
• 1 Year experience using 11g and 12c GoldenGate, Director, including upgrading, setup and support in QA and production ODS.
• Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and Goldengate director notifications.
• Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Partitioned Large tables to execute queries in finite window and fine tune the response time of database. Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 10g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Framingham, MA

Oracle Production Support Databse Administrator

Responsibilities:

• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Helped Implementing High availability using Golden Gate replication.
• Knowledge on Golden Gates for Active-Active Replication between the Datacenter for High Availability
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL, HORIZONTAL SCALING.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Logminer, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance Implemented Transparent Data Encryption (TDE) for database security.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.
• Implemented Recovery Manager (RMAN) . Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 5.x boxes.
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Used TOAD for database management.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential, Costa Mesa, CA

Junior Oracle Database Administrator

Responsibilities:

• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, troubleshooting.
• Managed and resolved design issues during development. Migrated and upgraded databases from version 9i to 10g.
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement
• Coordinated database backup and recovery strategies and performance and storage monitoring
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Provided on-call production database support.Created materialized views for faster retrieval of data and implemented bulk inserts to reduce insertion speed.
• Partitioned tables with range partition and hash partition to improve performance.
• Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks

Environment: HP-UX, Windows, Oracle 8i, 10g, SQL, PL/SQL, SQL plus, TOAD