EXPERIENCE SUMMARY:

• Oracle DBA in 12c, 11g, 10g with 9+ year's professional IT work experience
• Very strong in RMAN and all backup, restore and clone task
• Migrated databases to Oracle ASM (Automatic Storage Management)
• Build and maintained 4 - node RAC Cluster from scratch
• Worked on performance tuning tasks to better response time
• Maintained databases and alerts from 13c cloud control (OEM)
• Migrated standalone databases to RAC on Exadata
• Performed RDBMS and Grid upgrades
• Applied CPU, SPU, PSU, CRS Bundle patches
• Proficient with Amazon Cloud (AWS)
• Written Shell scripts to automate day to day maintenance tasks
• Provided 24/7 on-call support
• Created Disaster Recovery site using Oracle Data Guard
• Expert at cloning databases using RMAN Active Database Duplicate feature
• Worked on 12c Multitenant databases
• Excellent at setup and managing GoldenGate Replication
• Strong troubleshooting experience
• Very good understanding of Change control process
• Extensive user and tablespace management experience
• Excellent in Oracle Security, Roles, FGA, TDE etc.
• Effective at resolving clone and resolution errors during activity
• Well managed 12c container and pluggable databases
• Performed many refreshes using export import and Data Pump directory
• Extensive experience in Export-import, database character set change
• Skillful in Performance Tuning including SQL Query analysis and TKPROF analysis
• Widespread understanding of Oracle Dictionary tables and dynamic views
• Moderate experience in managing SQL Server
• Intermediate experience in managing MySQL instances

TECHNICAL SUMMARY:

Operating Systems: RHEL, OEL, Windows, AIX, Solaris

Database: Oracle 10g, 11g, 12c, MySQL, SQL Server 2008, 2012.

High Availability: ASM, Data Guard, RAC, RAID, Exadata, GoldenGate

EDUCATION:

ORACLE DBA

Confidential, Phoenix, AZ

Responsibilities:

• Provided day to day support of 11g, 12c and multitenant databases
• Migrated standalone to RAC on Exadata
• Performance tuning at database, statement level and finding bottleneck SQL statements to enhance speed and performance by using AWR, ADDM, SQL tuning advisor TKPROF, EXPLAIN PLAN and TOAD
• Migrated databases to AWS
• Managed and patched database on Amazon cloud
• Patched grid home and RDBMS home on Exadata
• Worked with network engineers to configure InfiniBand Network switch on Exadata
• Worked with Oracle Engineers to apply patch on compute nodes, Exadata home, Exadata Storage Servers, Exadata Storage Cell Commands and firmware patching
• Implemented Flash Cache for FTS tables
• Refreshed databases using RMAN Duplicate
• Restored and recovered datafile/tablespaces using RMAN backups
• Refreshed database objects using Data Pump
• Cloned database to lower environments
• Created materialized view
• Installed 13c cloud control agents
• Setup alerts from OEM
• Setup unidirectional GoldenGate replication
• Rolling install oracle patch in Oracle RAC 11g and 12c
• Upgraded database from 11g to 12c R2
• Written Shell scripts to automate tasks and monitor databases
• Provided all kinds of DBA support to development teams as well as production support to various applications
• Created and maintained different database entities including tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers
• Collecting table, schema, and database system statistics periodically and scheduling of collection jobs in OLTP database during off peak hours to limit system resources
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement
• Support MySQL databases including create and configure MySQL databases
• Worked closely with client’s team and offshore DBA team
• Provide on-call support
• Applied CPU/PSU patches

Environment: RHEL, AIX, Exadata, RAC, Data Guard, GoldenGate

ORACLE DBA

Confidential, Chicago, IL

Responsibilities:

• Installed and created databases for Testing, Development and Production
• Oracle 12c, Windows OS, Physical/Standby setup
• Setup uni-directional GoldenGate replication
• Performed cross platform migration from Windows to Linux
• Configured folders, created users and granted privilege for user access
• Generated SQL script to create or drop database objects including: tables, indexes, sequences, and synonyms
• SQL programming
• Rolling install oracle patch in Oracle RAC 11g
• Upgraded database from 10g to 11g
• Resolved connectivity issues and any issues related to database for developers
• Performed backup and recovery using RMAN
• Managed Import/Export Depending upon Requirement
• Data migration loading with SQL Loader
• Resolving SQL tuning issues and Tuning Considerations for Different Applications
• Expert in writing shell scripts for automating backups and restoration
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, and SQL TRACE
• Monitored database activity and attended to developer/user queries and requirements
• Provided Oracle space, change and object comparison management
• Overall performance enhancements
• Performed Oracle database administration tasks including user administration, schema creation and maintenance, data validation, backup and recovery procedure using RMAN
• Created database objects like tables, indexes, and views etc.
• Developed and deployed scripts to provide updates from development to production

Environment: RAC, Data Guard, AIX, RHEL

ORACLE DBA

Confidential, Chicago, IL

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g on Linux
• Upgraded from Oracle 10g to 11g
• Performed the migration from Tandem to Oracle 11g
• Performed Database Refresh from Production to Development databases
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Worked closely with developers during release and used oracle advanced features to achieve minimum downtime
• Well experienced in Performance tuning of large databases
• Outstanding Data Guard administration and maintenance
• Monitored Day-to-Day Backups, Log's & recovering them as per the requirement
• Utilized Log Miner Technology & applied Application Database Transactions on other Databases
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups
• Maintained RMAN incremental and cumulative backups
• Scheduled the databases backup using Cron tab and VERITAS net backup
• Performed Logical backup using full/partial export/import and data pump
• Created Logical and Physical database structure, Creating and altering Tablespaces
• Managed Users and Resources, Granting and revoking privileges through Roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Performed Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts
• Created Users and granted them the required Roles and Privileges accordingly
• Involved in space management, managed quotas
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance
• Configured Listener and Net Service names using NETCA and NETMGR
• Cloned schemas, objects and data on new server using Data pump
• Managed databases on multiple servers
• Monitored 10g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control

Environment: Windows, CentOS, Linux,