PROFESSIONAL SUMMARY:

• Overall 15+ years of total experience in IT Industry
• Extensive 12+ experience supporting database solutions in Oracle enterprise and SQL Server environments.
• Oracle 10g/11g/12c
• Worked on RMAN backups, restore, recovery
• Worked on Database Optimization, Performance Tuning
• Worked on very large scale database size up to 45 TB
• Strong skills in managing RDBMS on RHEL, Solaris, HPUX and Windows.
• Build 11g R2 RAC on RHEL
• Configure / Reconfigure RAC
• Cloned Databases
• Used RMAN to duplicated database.
• Performed point in time recovery using RMAN.
• Managed database using 11g Grid Control, 12c Cloud Control.
• Worked on ASM file system.
• Applied CPU and PSU patches.
• Refresh databases and schemas using Export Import and Data Pump.
• Worked on Grants, Privileges and Roles.
• Worked on Database security profiles.
• Worked on Upgrade projects.
• Resolved Gaps in Data Guard Environment.
• Supported SQL Server environment.
• Analyzed database and queries using ASH, AWR and ADDM.
• Managed databases which are configured with Oracle Golden Gate Replication.
• Created 12c Databases.
• Hand on experience with Oracle to SQL migration.
• Supported on - call 24/7 environment.

TECHNICAL SKILLS:

Databases: Oracle RDBMS 10g, 11g, 12c RAC, Cloud Control, Data Guard, SQL Server, OEM

DBA Tools/Utilities: SQL Developer, 12c Cloud Control

Operating Systems: RHEL, Windows, HPUX, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Midland MI

Oracle DBA

Responsibilities:

• 24x7x365 production support.
• Responsible for database creation with Oracle RAC one node configuration.
• Used RMAN convert database function from cross platform migration.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Managed Data Guard to provide high availability by implementing Physical stand by database.
• Recovered Physical standby database using SCN
• Rebuilt Physical standby databases.
• Responsible for Data guard switchover activity.
• Scheduled scripts to monitor Physical standby update status.
• Experience in data masking using OEM 12c.
• Managed large scale database size 45 TB and its Physical standby
• Proactively identified datafile limit for the large database and provide solution.
• Managed and administer databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Upgraded Databases from 11.2.0.1 to 11.2.0.4
• Database recovery and cloning using RMAN.
• Database migration from 11g to 12c.
• Experience in Oracle to SQL migration using SSMA.
• Compared and contrasted multiple snapshots using AWR.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Extensively worked on configuring OEM grid control agent on new servers, registering new databases in 11g OEM Grid Control and automated RMAN and data pump backups in 10g/11g OEM Grid Control
• Proactive performance monitoring, and capacity planning for future database and server growth.
• 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.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.

Environment: Oracle 10g/11g/12c, Data Guard, 10g/11g RAC, Data pump, Export/Import, 12c cloud control

Confidential, Long Beach, CA

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, 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 for Oracle using 11g R2
• Database migration from 9i to 10g to 11g.
• 24x7x365 production support.
• 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.
• 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 Import and Export using Oracle Data pump utilities
• 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.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.

Environment: Oracle 10g/11g/12c, Data Guard, 10g/11g RAC, Data pump, Export/Import, 12c cloud control

Confidential, Fountain Valley, CA

Oracle & SQL server 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.
• Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
• Developed PL/SQL based program for loading Data Mart.
• Oracle Applications server including OID. Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
• 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.
• 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.
• Applied various database and Application patches

Environment: UNIX, Oracle 8i/9i/10g, Oracle 9i AS, Sun Solaris, Apache, VERITAS Net Backup

Confidential - New York, NY

Oracle DBA

Responsibilities:

• Pre-Upgrade Planning, study and analysis of Applications and database
• Analysis of requirements upgrades from Oracle 9i to 10g.
• Database sizing, Capacity Planning
• Estimate System/Database performance
• Created/Configured test and development environments using Oracle export/import.
• Database refreshes from production to test and development environments.
• Install and configure Oracle 9i databases
• Performed various Unix Administration tasks and automated with cronjobs.
• Developed SQL scripts and shell scripts
• Configured and implemented Backup and Recovery using RMAN
• Performed Export/Import of Oracle 8i Database
• Installed and configured Oracle 9i in test environment for Oracle Applications
• Successful installation and configuration of Oracle 9i in test and production environment
• Applied Oracle Database patches
• Database space management and Reorganization

Environment: Oracle 9i, 10g on Sun Solaris, RHEL, Window, TOAD

Confidential, IL

Jr. Windows Admin and Jr. SQL Server Jr. DBA

Environment: Windows 2000, SQL Server 2005

Responsibilities:

• Support various prod and non-prod SQL server 2000 databases
• Configure Log shipping
• Worked on Windows Server Installation.
• Worked on SQL Server Installation.
• Configured SQL Server Backup
• Restore databases
• Migrate Databases
• Restore Windows Servers.
• Writing batch scripts.

Environment: Windows 2000, SQL Server 2000, LAN / WAN