PROFESSIONAL SUMMARY:

• Over 7 years of IT experience, years of extensive experience as an Oracle DBA on 11g, 12c.
• Worked on Oracle 11g and 12c Standalone and Cluster Environment.
• Experience in Data Center Migration.
• Experience in setting up Oracle Data Guard.
• Upgraded from 11g to 12c.
• Worked on Tablespace/Extent/Segment Management worked on Backup and recoveries using user managed and RMAN.
• Setup Oracle Enterprise Manager (OEM) 11g worked on 11g Grid Control for database monitoring / performance / diagnostics. planning and scheduling Backups, Database Recovery, taking Logical Backups
• Maintain Oracle fail over databases (Physical and Logical standby databases - Data Guard)
• Proficient in Oracle RDBMS including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, datapump, tablespace, and Extents fragmentation.
• Automated Storage Management (ASM) for 11g databases.
• Installed and Administered Grid Control.
• Worked with Oracle on open issues.
• Discoverer Administration including the design and administration of Business areas.

TECHNICAL SKILLS:

Databases: Oracle RDBMS 11g, 12c, RAC, Grid Control, Data Guard

DBA Tools/Utilities: RMAN, Oracle Enterprise Manager, AWR, Oracle Diagnostics Pack, DBCA, DBUA, SQL*Plus, SQL*Loader, Oracle Export/Import utilities TOAD, data pump. 

Operating Systems: UNIX (HP-UX, LINUX)

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Oracle DBA

Responsibilities:

• Migrating/Upgrading Oracle RAC/Standalone and RDS database from 11g to 12.2.
• Setting up datapump/RMAN backups on regular basis.
• Working with application side directly as their need.
• Refresh schemas as per customer s request.
• On call 24X7 for Production database if needed.
• Backup/restore & recovery, database monitoring & operating system configurations
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Create and maintain users, roles and privileges.
• Review alert logs and trace files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Perform Space Management & Troubleshooting the database issues.
• Installing of quarterly security patches on all non-production and production servers.
• Upgrading/patching GI on Rac environments.
• Patched Oracle homes and database via OEM automation
• Setting up OEM monitoring, installed OEM agents

Confidential, Wichita, KS

Oracle DBA

Responsibilities:

• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux.
• 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 11g RAC with 3 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.10g and 11g.
• Database migration from 10g to 11g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Tuning Wizard, and Windows Performance Monitor.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production 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.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• 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.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting
• Performance and networking issues. 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.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once.
• Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for
• Change Management practices processes
• Solid discipline in providing end-users timely updates on their problems. Installing server software.

Environment: Oracle 10g/11g databases, 10g/11g (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, Grid Control

Confidential, Chicago, 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.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Discoverer Administration including the design and administration of Business areas.
• Oracle Applications server including OID. Implementation of Oracle Applications Server for use with
• Portal, Custom Forms and Reports.
• Create and maintain users, roles and privileges.
• 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.
• Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line. setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN Scripts.

Environment: UNIX, Oracle 10g/1gg