SUMMARY:

• Over 7 years of experience in managing Oracle and SQL Server Databases.
• Managed Databases on RHEL, OEL, CentOS, AIX, HPUX, Solaris and Windows.
• Proficient in Administering 11g, 12c and 18c Oracle Instances.
• Extensive work in database installation, configuration and upgrades.
• Proficient in applying Oracle Patches.
• Worked on SQL Tuning for faster response time.
• Setup Disaster Recovery sites using Data Guard
• Written shell scripting to automate procedures and jobs.
• Provided on - call support.
• Proficient in Administering Microsoft SQL Server Instances.
• Setup log shipping for Standby databases on SQL Server
• Restore and migrated SQL Server databases.
• Poses midlevel expertise in managing SQL Server 2005, 2008 and 2012 instances.
• Expertise in Developing Recovery Manager (RMAN) scripts for database backup
• Build 2-node and 4-node RAC clusters
• Extensive expertise in export import and data pump.
• Database Migration to Amazon Web Services (AWS).
• Build and managed ASM instances, ASM disks and ASM diskgroups.
• Perform various database upgrades from lower to higher version. (11g to 12c to 18c)
• Worked with offshore team. Managed Jr. DBAs and offshore DBA Team
• Build configured and managed 2-node and 4-node RAC Clusters.
• Worked on Data Center Migration.
• Managed databases using 13c cloud control (OEM)
• Build and managed Materialize views and Golden Gate Replication.
• Provided support to manage Golden Gate Extract and Replicate processes
• Troubleshoot Golden Gate abend processes.
• Clone databases using RMAN duplicate.
• Performed various backup, restore and recoveries using RMAN
• Hands on Experience in Performance tuning and optimization
• Analyze database performance using ASH, AWR and ADDM reports
• Worked on Advance Security like Transparent Data Encryption (TRE) and wallet management.
• Worked on Oracle Licensing
• Migrated databases on X5 & X7 Exadata.
• Used Hybrid Columnar Compression to Archived databases on Exadata.
• Understand Smart Flash Cache, Storage indexes, Smart Scans, Cell offloading etc
• Worked with Oracle platinum engineers on scheduling patching on Exadata.

TECHNICAL SKILLS:

Worked on Golden Gate: Configure ASM

Worked on: Performance tuning

Build Active Data: Guard

Refreshes using Data pump: Build Data

Guard: Performed DB

Cloning: Backup and restore using RMAN

Managed OEM: Used SQL Developer

Building RAC: Managed SQL SERVER

Worked on Oracle Security, TDE: Exadata X5 Exadata X7

Upgrade Grid Infrastructure: Worked on DB Upgrades

Configure Statspack: Strong Linux Admin skills

ASH,AWR, ADDM: Shell scripting

Managed DB using TOAD: Worked on

Performance tuning: AIX, HPUX, SOLARIS

SQL Profiling: Amazon Web Service

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA

• 24*7 Production database administration support on Exadata.
• Installation, Configuration and Administration of Oracle 12c RAC.
• Build RAC Cluster from scratch.
• Migrated databases on Exadata.
• Migrated standalone databases to 2-node RAC Cluster.
• Migration single Instance Databases to 2 Node RAC environments.
• Installed and configured 12C Grid Control.
• Implementation of High Availability solutions with Oracle 12c RAC and Data Guard
• Implemented ASM on RAC and stand-alone databases.
• Managing disks and disk groups with ASM.
• Applied PSU and one-off patches.
• Refresh databases using RMAN, Export Import and Data Pump utilities.
• Involved in installation and configuration of Golden Gate extract and replicate issues.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Migrated Oracle Database environment from On-Premise to Amazon AWS Cloud.
• Expertise knowledge on Transportable Tablespaces and also Exadata compression and performance tuning.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Analyze and tuned long running jobs by working closely with the application. Development teams and analyzing objects, rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF and Explain Plan.
• Daily incremental backups and weekly full backup of databases using RMAN.
• Troubleshoot performance related issues.
• Implement Advance Security TDE.
• Restore and recovered databases.

Confidential, Ohio

Oracle Database Admin

• Provided Operations support of 11g and 12c Databases.
• Installed Standalone and RAC Database Servers
• Coordinated the migration of oracle instances to AWS.
• Managed databases on Exadata.
• Setup instances on Amazon Web Services.
• Setup alerts, threshold and jobs using 13c Cloud Control.
• Upgraded 11g to 12c with Physical Stand by Data Guard upgrade.
• Migrated 11g databases from Windows to Linux and upgrade to 12c.
• Managing users, profiles, roles and table space according to the requirement.
• Analyzed ASH/AWR and ADDM reports and guided application team.
• Setup Golden Gate replication.
• Worked on Data Center migration project.
• Refresh database and schemas using export/imports and data pump.
• Worked on 12c multitenant databases. understanding of Microsoft integrated tools (SSIS, SSRS, and SSMA)
• Worked with Oracle Engineer in troubleshooting RDBMS and patching issues.
• Coordinated tasks with various teams including offshore team members.
• Performing tuning of application with RBO, CBO, using Trace, TKPROF, Explain plan, statspack, AWR, ASH and ADDM.
• Worked on slow running queries to optimize databases performance.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Monitored data files, logical data storage and data growth activities
• Perform capacity planning required to create and maintain database environments.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Cloned databases using RMAN Active Duplicate.
• Performed point in time and transportable tablespaces recoveries.

Confidential, NY

Oracle DBA

• This project pertains to installation of oracle 10g RAC and later converted to 11g Upgrade
• Responsible for administration and supporting Oracle 10g/11g.
• Implemented Data Guard for maximum availability.
• Responsible for restoring and recovering database as required for Oracle.
• Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied Oracle patches on need basis.
• Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installed, Configured, Upgraded and Performed Trouble Shooting for oracle Golden Gate 10g/11g Version.
• Extensively worked under UNIX environment to provide DBA support.
• Ran the Oracle STATSPACK on the Oracle Instances to find out the System
• Performance Statistics during the peak load times.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes.
• Used Oracle 10g AWR & amp; ADDM to monitor database activities and performance tuning.
• Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery.
• Upgrade/Migrated the production and development databases from 11.2.0.3 to 11.2.0.4
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Performed RMAN Restore and Recover the Database.