SUMMARY:

I have over 8 years of experience in managing Oracle Databases.

FOLLOWING ARE THE AREAS THAT I HAVE WORKED ON:

Installation

AWS

RAC

Cloning

Data Guard

Ec2 instances

ASM

Refreshing

10g, 11g, 12c

Oracle Cloud

ASH

New Builds

Tablespaces Management

Export Import

AWR

DR Setup

User Management

Silent installation

ADDM

RAC Build

Cross platform migration

Troubleshooting

RMAN

Patching

Exadata

Performance Tuning

Data Pump

OEM

GoldenGate

Windows / Linux / AIX

Shell Scripting

24/7 on - call

Dictionary Views

Dictionary Tables

Partitioning

Auditing

Intermediate knowledge on SQL Server Database Administration.

Beginner knowledge on MySQL.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington Heights, IL

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 11g and 12c databases
• Build new 2-node and 4-node RAC clusters.
• Migrate standalone to RAC
• Build and standby databases using Oracle Data Guard.
• Build and managed Active Data Guard
• Configure Data Broker.
• Handling and performing day to day database operations on oracle databases from 10g to 12c on Single node, RAC and Exadata.
• Responsible from upgrading the database from 10.2.0.4 to 12.2.0.1 o AIX 64 power system.
• Maintaining X3-2 exadata databases server with 2 node RAC.
• Upgraded the exadata compute node and storage from 11.2.3.3.0 to 12.1.2.3.2
• Migrated databases to Exadata x5
• Resolve gaps between primary and standby.
• Applied PSU and Bundle patches.
• Worked on 12c multitenant databases.
• Upgrade grid/RDBMS from 11g to 12c.
• Applied CRS bundle patches.
• Configure and managedASM Disks and ASM Diskgroups
• Handled 4 Node DWH Exadata RAC Database sizing more than 100+ TB with 4 Node Exadata DR (Physical Standby) as a Primary DBA with Goldengate Bi-Directional replication.
• Creating and managing application schemas with appropriate table spaces and Indexes.
• Creating listeners, services, public and private database links.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Manage users, privileges and profiles, schemas using 13c cloud control
• Refreshing application schemas using Data Pump and export import utility.
• Worked on cross platform Data Migration project
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Utilizing OEM to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Clone database using RMAN Duplicate
• Restore/recover databases using RMAN
• Provided day to day operations support.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Used Fine Grain Auditing on users and tables.
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Configure flash cache for better I/O.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Poses basic OS system administration.
• Strict adherence to policies and procedures - specifically in regard to change management.
• Perform database administration tasks as part of a scheduled change management task.
• Installed agents for 13c cloud control.

Confidential

Oracle DBA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Installation, configuration and maintenance of Oracle 11g databases.
• Responsible for migrating from oracle Exadata, with 11.2.0.4 database to 12.1.2 Converged system (Cloud).
• Installing & configuring 11.2.0.2 RAC database on RHEL
• Setup uni-directional and bi-directional Oracle Goldengate
• Setting up Golden Gate extracts, pumps and replicates for replication
• Upgrading both standalone and RAC databases from 10.2.0.4 to 11.2.0.2.
• Implemented database auditing, data security and Remediate high-risk violation
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning
• Review alert logs and dump files to check for any problems related to the database.
• Used Data Pump to refresh schemas.
• Used RMAN to Clone database
• Discoverer Administration including the design and administration of Business areas.
• Developed PL/SQL based program for loading Data Mart.
• Applying one off patches using OPATCH utility to resolve bug fixes.
• Creating and managing application schemas with appropriate table spaces and Indexes,
• Create public and private database links.
• Rebuilding Indexes and gather statistics on users/tables/Indexes
• Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
• Refreshing application schemas using data pump export/import
• Provided support for Advanced Replication using Golden Gate Technology.
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Provide tuning recommendations based on various OS utilities to monitor memory, disk usage, swapping, paging, provide instance tuning by configuration settings, SQL tuning by using DBMS SQLTUNE package
• Monitoring & giving recommendations tuning SQL queries, tracing sessions using DBMS MONITOR package, analyzing explain plans.
• Administer databases using OEM grid control, installing OMA to configure new targets.
• Configured shell scripts for job/process automation.
• Provide on call support on rotation basis.
• Experience in refreshing databases to different environments, Schema refreshes from prod-dev/staging.
• Moving databases from regular file system to ASM.
• Testing Backup, restore and recovery using RMAN.

Confidential

Oracle DBA

Responsibilities:

• Installing, creating 10g, 11g databases.
• Upgrade from Oracle 10g to 11g
• Create, maintain and support Oracle 11g databases
• Administer database with Oracle Enterprise Manager 10g Database Control
• Performed database stats pack reports automation, stress test on production copy for scalability, resolving production performance issues
• Experience on RAC Installation and Administration on Oracle 10g environment
• Administer ASM storage for multiple databases.
• Logical Backup/Restoration strategy of Export and Import.
• Monitoring SQL sessions, using dbms monitor package, dbms system packages
• Security Administration and Creation of Users, Managing their roles and privileges.
• Control user access and ensure database security through privileges and roles in Oracle 11g
• Installed Golden Gate as a high availability solution.
• Creation and maintenance of high availability databases using Data Guard.
• Implementing physical standby databases in maximum performance mode.
• Customizing & implementing scripts to automate monitoring & scheduled jobs.
• Configured oracle net using netca, lsnrctl to set up access to the database over network.
• Space management involving issues with redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Implementation of backups.