SUMMARY:

• 10+ years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions
• Proficient in maintaining 10g, 11g, 12c, 18c databases.
• Proficient in oracle dictionary and oracle dynamic views.
• Tuned SQL Queries SQL Access Advisor
• Worked on tuning using SQL Performance Analyzer
• Tuned SQL using SQL Plan Manager
• Worked on Table compression enhancement
• Managed Active Data Guard
• Managed and administered databases from command line and 12c/13c OEM
• Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance
• Tuning of oracle databases on UNIX, LINUX and Windows environments
• Upgrade databases to 11g, 12c to 18c
• Managed databases on Exadata x7
• Build configured and managed multi node RAC Cluster on RHEL.
• Experience with setting up and managing standby database using Data Guard
• Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
• Tune queries using SQL Plan, SQL profiler, Baseline etc.
• Build RAC Clusters from scratch including deployment of Linux operating system.
• Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL* Loader, Data Pump
• Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Experience in datacenter migration.
• Supporting development 24/7 production systems.
• Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Maintained databases on Exadata X7
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Vast Experience with RMAN to implement Backup/Recovery strategies
• Clone databases using RMAN Duplicate.
• Implemented data replication through materialized views.
• Refresh database objects using Data Pump
• Good experience in SQL, PL/SQL, Shell Scripting
• Experience in Data Modeling using Data modeling tools such as Erwin and Toad.
• Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices
• Worked on SQL Server 2008 and 2012
• Experience with installing and maintaining Oracle 13c Cloud Control
• Build and managed ASM Disks and Disk groups
• Migrated non - ASM database to ASM.
• Experienced in RAID, storage technologies and backup solutions
• AWR Baseline Enhancements
• Automatic Memory Management.
• Automatic SQL Tuning.
• Data Recovery Advisor.
• Read-Only Tables
• Flashback Enhancements
• RMAN Enhancements
• Table Compression Enhancements.
• Worked on Tablespace/Extent/Segment Management
• Worked on Backup and recoveries using user managed and RMAN.
• Setup Oracle Enterprise Manager (OEM)
• Maintain Oracle failover databases (Physical and Logical standby databases- Data Guard)
• Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, and 11g.
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Automated Storage Management (ASM) for 10g/11g databases.
• Installed and Administered Grid Control.
• Worked with Oracle on open issues.
• Discoverer Administration including the design and administration of Business areas.
• I have worked on virtual machines and created few in Aws

TECHNICAL SKILLS:

• Oracle 11g, 12c, 18c,
• 13c Cloud Control
• Oracle Automatic storage Management
• Real Application Clusters (RAC)
• Performance Tuning
• Security Administration
• Replication
• Partitioning
• Disaster Recovery Solutions
• Database Design
• SQL Server
• AWS
• Amazon Web Services (AWS)
• Recovery Manager (RMAN)
• Standby Database Solutions
• Oracle 9i, 10g, 11g Data warehousing
• Oracle Enterprise Manager (OEM)
• Data pump, RMAN, Shell Scripting
• SQL, PL/SQL
• UNIX, Solaris, HPUX, Tru64, AIX
• Windows Server 2003, 2008, 2012
• Golden Gate
• Exadata
• Data Guard

PROFESSIONAL EXPERIENCE:

Confidential, Lombard, IL

Senior Oracle DBA

Responsibilities:

• 24x7x365 administrative support staff.
• Manage offshore team on day to day to tasks.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata
• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Configuration, troubleshooting GoldenGate issues
• Setup Uni-directional GoldenGate setup.
• Setup and managed replication using Oracle Golden Gate
• Worked on Data Migration project.
• Migrated databases from Windows platform to Linux.
• Upgraded from 11g to 12c.
• Migrating database from NON-ASM to ASM.
• I have worked on virtual machines and created few in Aws
• Migrated databases to AWS
• Build new servers on AWS
• Worked on project to migrate databases to AWS instance
• Set up oracle instances on AWS cloud
• Maintained databases and alerts from 13c cloud control (OEM)
• Migrated standalone databases to RAC on Exadata
• Oracle DBA in 12c, 11g, with 9+ year's professional IT work experience
• Worked on 12c Multitenant databases
• Setup unidirectional GoldenGate replication
• Rolling install oracle patch in Oracle RAC 11g and 12c
• Upgraded database from 11g to 12c R2
• Cloned databases using RMAN Duplicate
• Installation of 11g, 12c clients/databases on Solaris and Linux.
• Complete Build of 4-node 12c RAC Cluster on RHEL
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Performed database Cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery
• Responsible for administration and supporting oracle 11g, 12c databases
• Performed large batch jobs and tuning of SQL queries and database systems.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources daily.
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

• 24x7x365 administrative support staff.
• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Performed RMAN restores and recovered database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Applied CPU/PSU Patches
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• 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.
• 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.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis.
• Able to work effectively with multiple teams at once.
• Good understanding of ticketing system and change control process.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.

Confidential, Naperville, IL

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.
• Used RMAN to backup database.
• Review alert logs and dump files to check for any problems related to the database.
• Used Export Import and Data Pump
• Used Database Partitioning
• Provided 24/7 Online support
• Create and maintain users, roles and privileges.
• Written Shell scripts
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Setting up privileges to create local and remote objects
• Worked on Materialized Views
• Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
• Applied CPU patches