SUMMARY:

• Results - driven Oracle Certified Database Administrator with over 6 years of hands-on experience in the daily administration of production Oracle 10g, 11g, 12c databases as well as installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN) and Recovery Catalog, database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard for Disaster recovery and GoldenGate for real time data replication and Oracle 12c Cloud Control configuration and monitor.
• Also, responsible for patching, upgrade, database troubleshooting and supporting development effort with regards to production deployment releases, database schema, role, user, and objects, database hardening and baseline per security policy to improve database security.

WORK EXPERIENCE:

Confidential, IRVING, TEXAS

Responsibilities:

• Responsible for Installing, Configuring Oracle 12c Golden Gate for data replication across heterogeneous platforms.
• Responsible for Data Center Migration from old Data center to new data center
• Migrated and upgraded single instance database to multiple instance databases using export/import, data pump, Transportable Tablespace and RMAN
• Configure Data Guard on both standby and primary for 45 production databases.
• Fail over and switch over between standby and primary databases.
• Refresh schema using export/import, Creating the database, tablespaces, tables, indexes, setting privileges and user logins.
• Experience in multi-node and RAC environments
• Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode
• Import/Export and Expdp/Impdp utilities. Excellent experience in Installation, configuration, Maintenance of Oracle 12C, 11g, 10g on Operating Systems Solaris, Linux, AIX and Windows platforms.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage
• Utilizing SHELL SCRIPTS to Automate my nightly jobs on CRONTAB
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Handled RAC Node hangs and node eviction issues.

Confidential, Chicago, IL

Responsibilities:

• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Performed database recovery using User-Managed, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery.
• Experience in automating backup strategy using the UNIX shell script Cron Utility
• Experience in schema and table designing, stored procedures, Triggers, Views, and Indexes.
• Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, DBMS STATS, Automatic workload Repository (AWR), ASH and Automatic database diagnostic monitor (ADDM)
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".
• 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.
• Implemented various backup strategies for Large / Medium sized databases using RMAN
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE. Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Install, configure Oracle 12c Golden Gate for Real-Time Data Integration and Heterogeneous Database Replication for zero down time and continuous availability
• Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 2 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade Databases from 11.2.0.4 to 12.1.
• Troubleshoot and resolve performance issues with extensive investigation and follow-up with respective application teams with proposed solutions.
• Resolve lock/latch and resource contention issues during production hours
• Configure Dataguard and Broker for administration of seamless switchovers.
• Upgrade GI and DBs from 11g to 12c with physical standby DBs in place
• Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
• Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
• Analyze AWR, ASH and Confidential and draw conclusions that aid in troubleshooting performance issues. Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g/12c environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Confidential, Houston, TEXAS

Responsibilities:

• Refreshing Dev and Test instances with data from Production on a regular basis.
• Monitoring and Troubleshooting GoldenGate Replication issues
• Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others
• Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp undo enabled.
• Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Active member in making enterprise hardware infrastructure related decisions with IT management
• Involve in meetings with top IT management to discuss platform migrations
• Installed, Setup, Configured Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11
• Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux (SLES) 10
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status
• Transferring data from one server to another server by Export/Import Data Pump and Normal Export /Import utilities
• Refresh Test/Dev/Quality//Sandbox environment from Production for Apps Team
• Regularly applying all CPU & PSU Patches to All Oracle Databases using Opatch
• Creating and monitoring SR with Oracle Support
• Extensively used Oracle 10gR2 new features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Implemented DATA GUARD (Physical Standby) for disaster recovery purpose
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF,
• STATSPACK
• Tuned parameters for a large monthly SQL* Loader job resulting in 90% reduction of operation time
• Working with Blobs and Clobs, Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning).
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Refreshed/cloned databases using Datapump and RMAN utility.
• Performed Database upgrade from Oracle 10g to Oracle 11g database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Involved in Real Application Cluster (RAC) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Creating tablespaces, sizing the system tablespace, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing the SGA, sizing the database buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g, 10g RAC on Linux & RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future .
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)