SUMMARY

• Senior Oracle Database Administrator with over 11 years of experience in administration, planning, installation, configuration and upgrades of Oracle 11gR2, 10G, 9i, databases including applying patches under Linux, HP - Unix, Sun Solaris, IBM-AIX 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.
• 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.
• 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.

TECHNICAL SKILLS

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

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, Golden Gate, ERWIN

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE

Confidential, PA

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(2 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.
• Installation of ASMLIB rpm packages. Initialize the asmlib using oracleasm init command. Portioning the disks using fdisk/dd command.
• 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 & setup Active Data guard Configurations.
• Very Good Experience with Oracle Golden Gate Installation, Configuration and troubleshooting the Issues
• 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.
• 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.
• 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).
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.

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, Golden Gate, TOAD,SQL Developer.

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1,11.2) & 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.
• Implementing Physical Standby Active Data Guard in both 10g & 11g environments
• Involved in installation, configuration and support of Oracle 11g RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• 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.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) and Maestro 7.0 (Job Scheduling Tool).
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.

Environment: Oracle 9i,10.2.0.4,11.1.0.6,IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, IBM AIX, WebSphere,Solaris5.9,TOAD,SQL Developer.

Confidential, IL

Sr.Oracle DBA

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Creating Tables, indexes, & triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Was involved in developing a disaster recovery (DR) plan.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Taking periodic backup of the database and the software.
• Automation of Backups.
• Interfacing with Confidential for technical support.

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9,Informatica Power center 8.1x and 8.6.

Confidential, IL

Sr. Oracle DBA

Responsibilities:

• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.
• Functionality testing has been performed against the identified modules.
• Volume management using Verities Volume manager to configure Disk group.
• Configured Verities Net Backup R3.2 is to automate the physical Backup of the Database.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery.
• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• Also involved in SQL performance tuning.
• Creation of database links.
• Estimating the size of Databases.
• Creating Databases.
• Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4.
• Upgraded the databases from 9.2.0.7 to 10.2.0.2.
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Checking the Alert Logs of production Databases for any errors reported by Oracle.
• Adopting change control Mechanism (Lotus Notes Server) for replicating the changes made to the production Databases.
• Export and Import of databases from one database to another databases.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database).
• Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.

Environment: SQL Navigator, Oracle 8i, 9i, 10.0,WebSphere, data Stage, Remedy, clear quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, Maestro,ERWin4.0, Informatica Power Center, TOAD.

Confidential, MA

Oracle DBA

Responsibilities:

• Database Design, Backup & Recovery.
• Tuning the Database and Analyzing the Database.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
• Installation of the Databases, Environment Building to OFA compliancy.
• Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
• Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.
• Altering the Database objects and files during maintenance.
• Implementation of RAC Technology.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Software design of medium/large business applications, Design methodologies.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• Troubleshooting and maintaining, Database Recovery, Automation of the Database Start up and Shut down. Database Migrations.
• Writing Stored Procedures, functions, packages, triggers.
• Managing the network and service changes on the network of the databases.
• STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.

Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, shareplex, Perl, Windows NT shell scripting, TOAD.

Confidential, NJ

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.