TECHNICAL SKILLS:

• 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

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.