SUMMARY:

• Senior Oracle Database Administrator with 8+ years of experience in Oracle Administration in planning, installation, configuration and upgrades of Oracle 11gR2, 10G, 9i databases including applying patches under Linux, HP - Unix, Sun Solaris and Windows platforms.
• Experience includes managing Oracle 9i, 10g and 11gR1, 11gR2 RAC environments using the OEM Grid Control tools.
• Experience includes using Golden Gate to support data replication in the Oracle database environment.
• Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN. SQL.

TECHNICAL SKILLS:

Operating System: UNIX, LINUX, Solaris, AIX, HP-UX and WINDOWS NT/2000, XP.

RDBMS ORACLE: 11g/10.x/9.x/8.x and SQL Server 2008/2005

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACKAWR, ADDM, OEM, Sql Server.

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Confidential, FL

Sr. Oracle DBA

• Worked on refreshing production databases on sandbox for application testing using export/imports and RMAN active duplicate.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Provided on call support for every 3 weeks and provided support on weekends.
• Worked on Real application testing to have access the work load before migrating and upgrading production databases.
• Supported mission critical databases and extensively involved in resolving the performance issues.
• Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
• Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
• Management of schemas, objects partitioning the tables & indexes.
• Worked on refreshing the QA databases with PRODUCTION backups.
• Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
• Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
• Experienced in developing shell scripts for deleting old file.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Actively worked on Disaster Recovery.
• Worked on database upgrade from 11.2.0.3 to 11.2.0.4.
• Experienced in backups, restores, indexes, key structures and data loading.
• Worked on data blocks corruption issue, index & table rebuild.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Strong knowledge of Oracle internals, tools including DBMS jobs,RMAN,SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM).
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Environment: Oracle 11.2.0.3/11.2.0.4, Exadata X4/X5 Quarter/Half/Full RACK, OEM 12c, LINUX, Confidential AIX, TOAD,SQL Developer.
• knowledge of Oracle Workspace concept and table versioning process.

Confidential / Confidential, CT

Sr. Oracle DBA

• Planning, implementing and validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Installation of 11.2.0.3 RAC(3 node) from the Scratch and the maintenance of the high available Databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
• Involved in Oracle Spatial database configuration and schema creation.
• Created A schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types.
• knowledge of Oracle Workspace concept and table versioning process.
• Experienced in developing and implementing backup and recovery strategies and working on Oracle 11g R2 Spatial for GIS development.
• Involved in Operators, functions, and procedures for performing area-of-interest queries, spatial join queries, and other spatial analysis operations.
• Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware).
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby Setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Experienced in design and implementation of an efficient, scalable database schema, and/or maintaining and supporting existing databases.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Implemented Oracle Patches CPU & PSU on the Compliance Databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
• Closely Worked with Oracle support in identifying some long-standing issues. Also, extensively used oracle Metalink.
• Experienced in schema creating and maintenance.
• Experienced backups, restores, indexes, key structures and data loading.
• Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
• Installed and supported databases installed using the templates on Oracle VM.
• Environment: Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Exadata X3/X2 Quarter/Half/Full RACK, OEM 12c, LINUX, Confidential AIX, TOAD,SQL Developer.
• Managing the cluster resources and performing health check of all instances within the cluster.
• Experience in setting up Golden Gate for CDC extraction of files for ETL.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Experience in Implement and maintain monitoring tools for Golden Gate components.

Confidential, NJ

Sr. Oracle DBA

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
• Installed & Configured ORACLE 10g RAC, 11g on Red Hat ES Linux Servers.
• Upgrade oracle 10g databases to 11.2.0 version
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and performing production databases Maintenance.
• Very good experience with Oracle 10g RAC administration and HA environment.
• Experience in using DB links & materialized views.
• Wrote PL/SQLstored procedures, functions and packagesfor moving data
• Good Experience with Oracle PL/SQL scripting
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
• Experience in setting up Golden Gate for CDC extraction of files for ETL.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Experience in Implement and maintain monitoring tools for Golden Gate components.
• Experience with BMC Remedy tool for all change management process.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Creating Materialized views and Materialized View Logs for Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-NetBackup.
• Used Flashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performing Database Refreshes using Exp/Imp, Data pump, Sql*Loader and RMAN.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

Confidential

Oracle DBA

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.
• Involved in Schema management, Tablespace Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 8i, 9i, 10g.
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups i.e. RMAN.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre-installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Confidential

Oracle DBA

• Involved in 24x7 Oracle Production Database Administration.
• Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Monitored Production Databases, performed performance tuning, added data files, resized segments, and tablespaces.
• Installed and configured Oracle 10g.
• Migrated Oracle 9i database to Oracle 10g.
• Storage and space management including table spaces and data files.
• Monitoring Database for fragmentation and correcting them.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
• Monitoring and Management of table space growth, extent growth.
• Planning and implementation of Backup and recovery procedures and Maintenance of Database.
• Performed Backup/Recovery using RMAN.
• Wrote scripts for Startup, Shutdown and automation of backups.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Involved in the process of tuning and refining queries of various applications.
• Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Interfacing with Oracle Corporation for technical support.
• Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.