SUMMARY:

• Experienced in Performance Tuning using EXPLAIN PLAN, AWR, ADDM and the Oracle Advisory Framework.
• Good in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Golden Gate.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Expart in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF and AWR.
• 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)
• Expertise in Performing Tuning of Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Created indexes to facilitate easy user interface implementation and tuning.
• Involved in construction of DR sites for all the Production and IST environments.
• Performed Database Refresh from Production to TST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.
• Proficient in backup and migration using data pump and transportable tablespaces.
• Worked on Setup, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
• Expert in RMAN backups including full, incremental differential and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Knowledge of advanced security configuration such as data masking, data redaction, column and tablespace TDE as well as Network Encryption.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x, WindowsXP, and Oracle Enterprice Linux 5,

RDBMS: Oracle 10g/11g/12c

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Erwing, Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, SqlDeveloper, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, dbms, Veritas, HP Manager, My Services.

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, SQL TUNNING SET, AWR, and ADDM etc

PROFESSIONAL EXPERIENCE:

Confidential,Miami, FL 

Oracle Database Administrator

Responsibilities:

• 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.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases. 
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import. 
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch. 
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. 
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog. 
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), Rman Catalog, Database Flashback and Export and Import (Datapump) for restoring the specific objects at the database level. 
• Building Oracle Standby databases, both Active Dataguard for real-time replication and physical standby Dataguard for disaster recovery automated with Broker fast to failover and Observer process. 
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database. 
• Worked and implemented security with Datamasking, Data Redaction and Database Wallet for Oracle 11g and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using tablespace encryption, also used TDE for Goldengate replication. Used VPD for RMAN Catalog and Also took part in configuring Network Encryption.
• Also tested DR sites with database failover and switchover also tested Goldengate replication after that using DBFS filesystem and ACFS. 
• Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• 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 11g to Oracle 12c using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups of Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database for twenty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Developed RMAN Backup Scripts to take cold backups automatically every week, do daily incremental differential or incremental cumulative backups for about 200 databases varying in size from 200GB to 2TB, using parallelism as needed and available and automated the process through crontab.
• Implemented Oracle Patches PSU on the Compliance databases, Devised and set plan to patch them.
• Upgraded / patched dataguard configuration, patching standby databases with PSU opatch and OJVM and doing a PSU opatch, OJVM and Catbundle on the Primary and started the dataguard process.
• 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.
• Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.
• Migrating and consolidation of 11g databases into 12c in both QA and Production environments.
• Installation and consolidation of 12c multitenant databases in QA and Test environments. Container and Pluggable database administration and cloning.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports, as well as OERR errors resolutions.
• Monitoring space, wait events, locks and long operations running on the database using top, sar and iosat commands and OEM Grid control.
• Monitoring the session waits for the database performance and resolving the performance issues.
• Monitoring the database for growth and added space to the table spaces as per demand and using capacity growth technics such as Soft Links and backupsets to limit space consumption.
• Upgrades, patching, and off-hours maintenance and change control execution in production 24/7 environments and hosting facilities using Remote desktop connection or Putty in conjunction with RSA -VPN.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Applying upgrade patch, maintenance and interim ( opatch ) patches on all the databases.
• 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.
• Applied Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Used Data Pump for export and import. Used SQL Loader to migrate files across heterogeneous platforms into databases, 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 and datapump.
• Created logical and physical design installed and upgraded databases. Did ETL with the use of SQL Loader and Erwing
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and Optimal Flexible Architecture (OFA ).
• Documented procedures for peers to follow.

Environment: Oracle 10g/11g RAC/11gR2 Oracle 12c, Arch linux, Ubuntu 16.04 TSS xenial xerus, Red hat enterprise linux (RHEL)5.5, RHEL 6.6, AIX 5.3 AIX 7.2 HP UX packed and windows 2012 and 2008, TOAD, RMAN, SQL server, OEM GRID.

Confidential,Cockeysville, MD 

Oracle Production Support Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Detect corrupted blocks by using DBVERIFY utility.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Implemented table partitioning to improve performance and data management.
• Implemented Security through Virtual Private Database and Fine grained Auditing.
• Developed RMAN scripts for database backup and recovery.
• Designed and implemented the database servers for two new data centers.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA etc.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration. Install and managed Physical Standby databases Data Guard for disaster recovery.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL
• With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation .
• Extensively developed UNIX Shell scripts to automate database operation and database monitoring.
• Experience in working high transacted OLTP systems.
• Creation of monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.
• Partitioning for improving big tables to improve the Performance of the database.
• Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
• Performance tuning at database level for the parameters like SGA, PGA and PGA AGGREGATE TARGET .
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.
• Maintaining data integrity and tune database for optimum performance and availability.