PROFESSIONAL SUMMARY

• 8+ Years experience in Oracle Database Administration which includes Installation, Configuration, Performance Tuning, Backup/Recovery, Disaster Recovery, Cloning, 24X7 On-Call production supports on LinuxVarious Platforms.
• Installation, configuration and maintenance ofOracle 9i/10g/11g/11R2RAC on a two node and four node configurations, Standby Database (Data Guard), Replication.
• Experience in installation and configuration ofOracleclusterwareandAutomatic Storage Management (ASM)inRACenvironment.
• Performed Upgrade/Migration of the oracle databases from Oracle 8i/9i to Oracle 10g, Oracle 10g to Oracle 11g & Oracle 10g to Oracle 11R2g.
• Implemented Golden Gate replication solution.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate.
• Strong Knowledge of data migration from non-ASM Data files to ASM.
• Experienced in installing Oracle patches,Migrating databaseacross releases.
• Upgraded OWB repository from 10g to 11.2.0.3.
• Extensive experience in the Installed and configuredOracle Enterprise Manager10g Grid Controlfor enterprise monitoring.
• Proficient in writing SQL, PL/SQL stored procedures, packages and triggers.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Experience in using Oracle 10g/11g features like Data pump (export and import), Flash-Back Recovery and ASM.
• Implemented FLASHBACK technology. Experienced on various flashback technology features introduced in Oracle 10g/11g.
• Expert in Cloning, manual creationof Oracle Databases.
• Extensive amount of experience with Oracle 9i/10g/11g DATA GUARD.
• Extensive knowledge in working with the tools likeOEM, TOAD, ADDM, Export/ Import, Stats pack, SQL * Loader, SQL Analyze, TKProf, AWR, Explain Plan andmanaged system Events and Jobs usingOEM.
• Extensive experience on Automatic Workload Repository and Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g (10.1.0.2).
• Created Partition Table (List, Range, and Hash) to improve query performance.
• GeneratedMaterialized viewsto cache data that was frequently needed, to improve performance.
• Creating Logical Data Model and Physical Data Model in order to knock out the design phase.
• Experience in Data Migrations, Benchmarking.
• Used ERWIN for Logical and Physical database Modeling.
• Extensive knowledge in UNIX platforms and also includes HP-UX, SOLARIS, AIX, and LINUX.
• Database and application integration. UNIX shell scripting, CRON jobs.
• Proven experience with database performance and tuning techniques to enhance database optimization plans.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• Excellentanalytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.

TECHINICAL SKILLS:-

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3
RHEL 2.1, 3.x, 4.x, 5 .x, SuSELinux Enterprise Server 9, 10and Windows 95/98/ME/NT/2000/XP, VMware.

RDBMS

Oracle8i/9i/10g/11g/11R2gRAC,SQL Server 2000/2005/2008

Application

Oracle Applications 11i and R12

Languages

SQL, PL/SQL, Java, C, C++, .Net, UNIX Shell Scripting, PERL.

Tools & Utilities

RMAN, OEM, SQL*Loader,EXP, IMP, data pump,Erwin, Power designer, TOAD, Oracle SQL Developer, Golden Gate.Forms,Reports.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Others

Informatica Power Center 7/8.1/8.6 , ODI, BI,BO, ERwin® DataModeler r7.3, PLSQL DEVELOPER, Quest Software Toad V8/9/10, DBArtisan 8.1/8.7

EDUCATION:-
Bachelorof Technology.

PROFESSIONAL CERTIFIED: -

• Oracle Database 11gAdministrator Certified Professional (OCP)
• Oracle Database 10gR2: Administering RAC
• Oracle Database 10gAdministrator Certified Professional (OCP)
• Oracle Database 10gAdministrator Certified Associate (OCA)
• Oracle Database 11g: SQL Fundamentals I

WORK EXPERIENCE:-

Company: Confidential, New YorkNY
Role:Database Administrator
Duration:May 2012- Present
Environment:HP-UX, Sun Solaris, Linux, Windows,AIX,Oracle11R2/11g/10g RAC

Summary of responsibilities:

• 24 X 7 Production Oracle database support, administration and on call rotation.
• Installation and configuration of oracle 10g and 11gR2RACdatabases.
• Upgrading databases from 10g to 11.2.0.3.
• Implemented Golden Gate replication solution.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.
• Worked on data ware house environment, supported ETL process.
• Installed and configured Golden Gate director server/client for monitoring golden gate processes.
• Upgraded OWB repository from 10g to 11.2.0.3.
• Maintained and upgraded databases andsoftware.
• Worked onrolling patch apply throughout the environment with no downtime.
• Monitored system resources and takes action to keep the system at optimal performance usingGrid Control.
• Planned and implemented a backup and recovery strategy using RMAN and Data Guard.
• Worked on database refresh usinghot backup and rman backups.
• Worked on SQL explain plans and query performance, session tracing.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.
• Worked onschemascreationandmaintaining largepartitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring space requirement for production and dataware house databases.

Company:Confidential, ManhattanNY
Role:Database Administrator
Duration:Oct 2011- May 2012
Environment:HP-UX, Sun Solaris, Linux, Windows,AIX,Oracle11R2/11g/10g RAC

Summary of responsibilities:

• 24 X 7 Production Oracle database support, administration and on call rotation.
• Installation and configuration of oracle 10g and 11gR2RACdatabases.
• Primarily responsible for instance tuning, interfacing with clients.
• Maintained and upgraded databases andsoftware.
• Worked onrolling patch apply through out the environment with no downtime.
• Monitored system resources and takes action to keep the system at optimal performance usingGrid Control.
• Planned and implemented a backup and recovery strategy using RMAN and Data Guard.
• Worked on database refresh usinghot backup and rman backups.
• Worked on SQL explain plans and query performance, session tracing.
• Used anadministration toolDBArtisan for space and performance monitoring, Moving data within and across the environments.
• worked on database upgradefrom 10g to 11gand 11R2.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.
• Worked onschemascreationandmaintaining largepartitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring space requirement for production and dataware house databases.

Company:Confidential, Secaucus,NJ
Role:Database Administrator
Duration:Oct 2010-Oct 2011
Environment:HP-UX, Sun Solaris, Linux, Windows,AIX,Oracle 11.2/11/10g RAC

Summary of responsibilities:

• 24 X 7 Production Oracle database support, administration and on call rotation.
• Installation and configuration of oracle 10g and 11gR2 RAC databases.
• Monitoring various targets through Oracle Enterprise Manager Grid Control.
• Configuring and Monitoring RMAN and Hot backups and performing recoveries.
• Implementing and maintaining of Database Security using auditing for SAS70.
• Applying Critical Patch Update (CPUs) every quarter in rolling mode with no downtime.
• SQL, PL/SQL, Shell and Perl Scripting.
• Upgraded databases from 10g to 11g.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Worked on configuration and monitoring standby databases.
• Configured fast refresh for Materialized Views.
• Maintaining schemas and partitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Data refresh from production to stage, test and development.
• Participated in developing backend Oracle batch processes, developed PL/SQL functions, procedures, packages and triggers.

Company:Confidential, Glendale,AZ
Role:Database Administrator
Duration:March 2009-Oct 2010
Environment:AIX,HP-UX, Sun Solaris, Linux,Windows, Oracle 11/10g RAC

Summary of responsibilities:

• 24 X 7 Production Oracle database support, administration and on call rotation.
• Implemented 4-node 10g/11g RAC in stage and Prod environments.
• Installed, configured oracle 10g and 11g databases.
• Developed stored procedures and complex packages using PL/SQL.
• Developed shell scripts to pull & process data.
• Prepared test environment for QA team to test the developed application from end-end.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Worked on Informatica Power Center 8.1/8.6 for monitoring and tuning sql Queries to improve performance of oracle databases in Data Warehouse Environment.
• Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, AWR, ADDM and ASH report.
• Monitored various targets through Oracle Enterprise Manager Grid Control.
• Configuring and Monitoring RMAN and Hot backups and performing recoveries.
• Setup and configure SQL Server for other business functions. Index & Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Creating tablespaces, tables, and users for custom applications.
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Converting Single instance to RAC.
• Added new node to the existing RAC.
• Designing the security and database access strategies.
• Implemented Transparent Data Encryption (TDE) for data protection at operating system level.
• Configured Streams bidirectional setup between source and target database.
• SQL, PL/SQL, Shell and Perl Scripting.
• Configured fast refresh for Materialized Views.
• Maintaining schemas and partitioning tables.
• Experienced with Space Management and Security.
• Created and Implemented Backup & Recovery procedures.
• Importing data from flat files into database using SQL loader and External Tables.
• Data refreshfrom production to stage, test and development.
• Participated in developing backend Oracle batch processes, developed PL/SQL functions, procedures, packages and triggers.

Company:Confidential, Austin,TX
Role:Database Administrator
Duration:February 2008 - March 2009
Environment:IBM AIX, Sun Solaris, RedHat Linux,Windows, Oracle 10/11g RAC

Summary of responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10/11g RAC.
• Involved in RAC administration including Installation of Oracle 10/11g, Database cloning, tuning, patching and monitoring concurrent manager processing etc
• Applying Patches and Upgrade/Migration ofdatabases to Oracle 10g from Oracle 9i on Linux to Sun Solaris.
• Creation of the Oracle 10g physical standby database.
• Setup and configure Standby database (Physical & Logical) for high availability
• Designing the security and database access strategies.
• Configured Oracle OEM Grid Control to monitor database.
• Analyzing EXPLAN PLAN and tuning sql's accordingly.
• Performing Backups and Recoveries using RMAN/Conventional hot backups.
• UsedExport and Import ofdatabasesfor Logical backups and restores.
• Transferred data from different database to oracle database usingSQL*Loader.
• Creating and dropping of users, granting and revoking rights as and when required.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Applied patches to Oracle RDBMS and Oracle Applications.
• Experience using modeling tools, logical and physical database design using ErWin.
• Creating stored procedures, packages and database triggers.
• Customization and development of Korn shell scripts.

Company:Confidential, Phoenix,AZ
Role:Database Administrator
Duration:May 2006- February 2008
Environment:Sun Solaris, Linux,Windows, Oracle 10g RAC /9i

Summary of responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Managing, troubleshooting and resolving Oracle Databases, RAC and applications issues.
• Installation of Oracle 10g/9i/cluster ware, Configuring public and private network and VIP.
• Configured the Public Network/Private Interconnect for Oracle 10g RAC.
• Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
• Managed disks and disk groups using ASM.
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Import and Export of database objects to copy from one database to another database
• Creating Database links.
• Developed UNIX Shell Scripts (KORN Shell) for automating the loading procedures.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL programs, tune queries and database sizing.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing SQL Loader control files for data loading.
• Creating PL/SQL packages, procedures and database triggers.
• Database tuning, backup and recovery and general day to day running of the system.

Company:Confidential, Minneapolis,MN
Role:Database Administrator
Duration:January 2006- May 2006
Environment:Oracle 9i/10g, Sun Solaris, HP-UX

Summary of responsibilities:

• 24x7 Oracle Production DatabaseAdministrations.
• Installing and Configuring ofOracle 9i/10gRAC
• Managing, troubleshooting and resolving Oracle Databases, RAC and applications issues.
• Installation and Creation/Conning Oracle Databases.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Migrating Oracle 9i database to Oracle 10g. Installing Oracle Patch. Migrating production database to new server.
• Logical and Physical data modeling.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performing Backups and Recoveries using RMAN/ conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
• UsedExport and Import ofdatabasesfor Logical backups and restores.
• Responsible for managing development and test databases.
• Designed the logical and physical database.
• UsedExport and Import ofdatabasesfor Logical backups and restores.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases for development and testing.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Coordinated with the developers and customizing the modules.
• Created and maintaining materialized views.
• Tuned of the Database for improved performance in a scenario of Full table scans on large tables, Design discrepancies in physical database layout,
• Finding and resolving I/O bottlenecks, Heavy data loading jobs.

Company:Confidential, Hyderabad,India.
Role:Jr. Database Administrator
Duration:January2004- December 2005
Environment:Oracle 9i/8i, HP-UX, Win 2000

Summary of responsibilities:

• 24x7 Oracle Production Database Administrations.
• Interacting with users, business managers in gathering the requirements.
• Installation, configuration, and maintenance of Oracle databases.
• Responsible for designing, creating, operating, maintaining and troubleshooting of Oracle databases.
• Worked with SQL* Loader control files and PL/SQL Procedures.
• Implemented Database export/import, hot backup and cold backup setup for all the clients.
• Discoursed the tips on evaluating the backup and recovery procedure periodically.
• Back up and Archiving Strategy of Solution have been given to spell out to each client.
• Capacity planning and storage management.
• Defragmentation of tables and indexes for improve performance and efficiency..
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Oracle installation, creation of database, which includesphysical and logical design.
• Assisted developers in Creatingstored procedures, Triggers, Functions, Cursors and Packages.
• Responsible for monitoring and resizingOracle database objects(Table spaces, Tables, Indexes etc,).
• Responsible formemory and Application tuning of the database.
• Oracle utilities likeSQL Trace, TK Prof and Explain Plan,
• Partitioning Strategies for very large tables implementing range, list partitions, hash sub partitions.
• User access Auditing and security aspects of the database.
• PL/SQL programming and shell scripting.
• Installing software, version upgrades and applying patches.
• Created Procedures Triggers.