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.
• Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two-node on Linux with ASM).
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• Procedures using RMAN, VERITAS Net Backup. Worked with EXP/IMP,EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Migrated data from SQL Server 2000 to SQL Server 2005 with SP2.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions X3/X2 Quarter/Half & Full Machines. Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.
• Managing the cluster resources and performing health check of all instances within the cluster.

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

Responsibilities:

• 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, IBM AIX, TOAD,SQL Developer. knowledge of Oracle Workspace concept and table versioning process.

Confidential, CT

Sr. Oracle DBA

Responsibilities:

• 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 GB 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, IBM 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

Responsibilities:

• 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/SQL stored procedures, functions and packages for 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

Responsibilities:

• 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

Responsibilities:

• 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 Confidential for technical support.

Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.