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.
• 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 (11g to 12c to 18c)
• Worked with offshore team.
• Worked on Data Center Migration.
• Managed databases using 13c cloud control (OEM)
• Good understanding of Oracle GoldenGate replication.
• 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
• Migrated databases on X5 & X7 Exadata.
• Patching grid and database homes
• Good understand of Smart Flash Cache, Storage indexes, Smart Scans, Cell offloading etc.

SHORT TECHNICAL SKILLS:

• Scripting
• TOAD
• Performance Tuning
• ASH / AWR
• Data pump
• RMAN
• OEM
• ADDM
• Data Guard
• DB Cloning
• Active Data Guard
• OEL / RHEL
• SQL Developer
• Upgrade
• Upgrade
• SQL Profile
• GoldenGate
• SQL Server
• ASM Diskgroups
• Exadata X7
• Security, TDE
• RAC
• AWS
• Partitioning

PROFESSIONAL EXPERIENCE:

Confidential, Mettawa, IL

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 12c RAC.
• Build 12c RAC Cluster from scratch.
• Migrated databases to EC2 instances on AWS
• Migrated databases on Exadata.
• Migrated standalone databases to 2-node RAC Cluster.
• Migration single Instance Databases to 2 Node RAC environments.
• Managed databases via TOAD, SQL Developer and 13c Cloud 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.
• 24*7 Production database administration support on Exadata.
• Worked on Data center migration.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Analyze and tuned long running jobs by working closely with the application teams to analyze objects, rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF and Explain Plan.
• Clone databases using RMAN Duplicated.
• Troubleshoot performance related issues.
• Restore and recovered databases.
• Resolved gaps in Oracle Data Guard
• Worked with storage admins to get disk space for Oracle ASM Diskgroups.
• Worked with Oracle support in resolving issues.
• Working on upgrading database from 12c to 18c.
• Migrated databases from standalone to Exadata
• Used Data Pump to refreshed database objects
• Written scripts to automate repeating tasks.
• Worked on snapshot standby databases.
• Setup threshold in 13c cloud control for alerts.
• Generated ASH, AWR, ADDP reports and worked with app teams on performance.
• Partition tables.
• Good understanding of Oracle Dictionaries.

Confidential, Cincinnati, Ohio

Oracle Database Admin

Responsibilities:

• 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.
• Worked on Data Center migration project.
• Refresh database and schemas using export/imports and data pump.
• Worked on 12c multitenant databases.
• 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, Cincinnati, Ohio

Oracle Database Admin

Responsibilities:

• 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,
• Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Extensively worked under UNIX environment to provide DBA support.
• 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 to 11g
• 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.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Performed RMAN Restore and Recover the Database.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Worked on basic Linux OS system administration.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources daily
• Able to work effectively with multiple teams at once.
• Performed Database Refreshes and Database
• Implemented basic replication through Materialized Views.
• Provided 24/7 on-call rotation.