SUMMARY:

• Over 8 years of experience as an Oracle DBAproviding 24/7 support to Oracle RAC and non RACDatabases(OLTP and Data Warehouse)with ASM and non ASM storage in development, production and testing environmentson various platforms like HP - UX, Sun Solaris, RHEL.
• Over 5 years of experience working with Oracle RAC (Real Application Cluster) & have successfully done 3 projects on Oracle RAC - Configure, implement, and support
• Over 5 years of experience working with Oracle Data Guard (Physical & Logical)& have successfully completed 3 projects using Oracle Data Guard - Implement & support
• Over 3 years of experience working with Oracle Golden Gate and 5 years of experience with Oracle streams with complete end-to-end support for Basic & Advanced Replication - Configure, Setup, Install, & support
• Over 8 years of experience in performance tuning of production and development databases
• Over 8 years of experience in developing efficient database backup & recovery strategies
• Over 2 years of experience installing, configuring and administering 12c Cloud Control
• Over 5 years of experience in writing PL/SQL procedures, packages, SQL triggers for code deployment on non-production and production environments.
• Excelling experience in Installation, Setup and configuration of Oracle 12c, 11g, 10g in HP-UX, SUN SOLARIS and UNIX/LINUX environment
• Proficient in Database Administration activities such as Upgrades, Patches, CPUs, PSUs, TAR support, Cloning, duplicating, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Experience in using Oracle 12c,11g and 10g RAC features like - Flex ASM, Table recovery from RMAN backup, RAT, Database Replay, SPA, SPM, Real-Time SQL Monitoring, Data Pump, Flashback technology, Cloud Control, Recycle Bin and Transportable Tablespaces
• Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging.
• Experience using 12c pluggable and container databases (PDBs and CDBs).
• Experience in configuring and managing Golden Gate on multi-node RAC environment.
• Experience in performing History pull to synch-up data between Oracle to Non-Oracle databases using Golden Gate.
• Experience in setting up DDL/Bi-directional replication between source and target databases using Golden Gate.
• Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1
• Built Oracle MAA PhysicalStandby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Provide DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ASH ADDM,SQL TRACE, TKPROF and OEM Grid Monitoring.
• Experience in using SQLPerformance Analyzer to tune the database.
• Knowledge in using Database Repair Advisor - a wizard/expert system that guides DBAs through the fault diagnosis and resolution process.
• Excellent experience in using OEM, TOAD, Data Migrations using Export/Import,Data Pump benchmarking using load testing tools.
• Highly proficient in SQL, PL/SQLCoding and tuning
• DevelopedShell Scripts for backup and recovery, Imported and exported procedure, implementing transportable table paces and for Automating database periodic maintenance and activities
• Management of schemas, objects & Partitioning the tables & indexes.
• Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups to Disks and Tapes.
• Effective troubleshooting of database and performance problems.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures

KNOWN TECHNOLOGIES:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, RHEL 4.x, 5.x, 6.x

RDBMS: Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, Oracle 12c RAC

Languages: SQL, PL/SQL, C, Java, UNIX Shell Scripting PERL Scripting

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Tools: RMAN, OAM, OEM, EXP, IMP, Data Pump, TOAD, SRDF, SQL*Loader, Oracle Golden Gate, Oracle Streams, Shareplex, Data Guard Broker, RMAN

WORK EXPERIENCE:

Sr. Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)

Confidential, NYC

Responsibilities:

• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 11g and 12c RAC Production databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Develop upgrade roadmap and perform upgrade DBs from 11.2.0.4 to 12.1.
• Installing and configuring12c Cloud Control and Enterprise Backup Utility.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Thorough understanding of architecture and operational mechanism of CRS, GNS, GPNP.
• Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism
• Upgraded Golden Gate from 11.2 to 12.1.2.1.0
• Used Oracle Golden Gate for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• PerformedHistory pull to synch-up data between Oracle to Non-Oracle(Tandem, SQL Server) databases using Golden Gate
• Responsible in setting up DDL/Bi-directional replication
• Storage Migration: Migrated OCR, VD and ASM data from one SAN storage array to another
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose.
• High Level Evaluation and Performance Tuning, Load Balance and TAF Failover.
• DR Exercise: Perform planned switchover and failover to physical standby database with and without Data Guard Broker and SRDF Failovers to ensure high availability.
• Extensively usedOracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL tuning Automation, Flashback Database, compression techniques and several others
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Rebuilding of Indexes for better performance, maintenance of Oracle Database, Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Write and automate UNIX shell, SQL scripts, and Grid Control for ease in administrative tasks and monitor databases to optimize performance, resource use, and physical implementations of databases
• WrotePL/SQL procedures, packages, SQL triggers for code deployment on non-production and production environments
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle 11g Enterprise Manager (OEM).
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Automation of Startup Shutdown on all Production and Development Database
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Tuning.
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan.
• Resolve lock/latch and resource contention issues during production hours
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team

Environment: Oracle11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11.

Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)

Confidential, Herndon, VA

Responsibilities:

• Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC with ASM, Physical and Logical Standby database for Test, Development and Production
• Involved in 24x7 on-call support for production 10g and 11g RAC database using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
• Install, configure and support Oracle Databases for SAP Applications like MDM, BW, EP
• Upgrade Oracle Databases and Client software for SAP Applications from 10gR2, 11gR2, applying SBPs and using BR*Tools for administration
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team
• Upgrading of Database from 10.2.0.5 to 11.2.0.1
• Apply Patch set update to 11.2.0.2
• Upgraded Golden Gate from v10.4 to v11.1
• Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux (SLES) 10
• Supported 15 Terabyte Oracle Data Warehouse (Oracle 10g). Used Sybase Power Designer for development and support of Data Warehouse
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status
• Extensively used Oracle 11gR2 features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Wrote UNIX shell scripting to automate tasks and crontab and dbms scheduler for scheduling job
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update (CPUs) every quarter in rolling mode with no downtime
• Data refresh from production to test and development
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects

Environment: Oracle 10g /11gR1/11gR2 with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11, Sun Solaris 10, RHEL 5.x, TOAD, SUSE 9,10

Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)

Confidential

Responsibilities:

• Involved in 24x7 support for production RAC and Non RAC database with on-call pager
• Worked with Application Development team on Test and Production tickets
• Setting up 9i Oracle Parallel server and 10g RAC for Development and Production Environment
• Installation and creation of 9i and 10g databases on Testing Environment.
• Installed, Setup, Configured Oracle 10.2.0.4 64 Bit on RHEL 4.8
• Upgrading of Database from 9i to10g
• Installed, Configured, Setup, Maintenance and Supported Oracle 10g RAC, Physical Standby database
• Installed, Configured and setup Oracle Streams between Oracle Servers
• Used Oracle Streams for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Used Oracle 10gR2 features viz Oracle 10g Real Application Clusters (RAC), Data Guard, Oracle Streams / Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, big file table spaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/ Access Advisors, Flash Back Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, administer database objects
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK
• Applying patches whenever required
• Data refresh from production to test and development
• Was involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise
• Installing and configuring Recovery Manager (RMAN)
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Providing Solutions to the Problem Faced by end Users Or Programmers

Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)

Confidential

Responsibilities:

• Installation of oracle 9i & 10g databases in production, development and test environments depending on project requirements.
• Refreshing development/test database from production using Export/Import &RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• All Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents