TECHNICAL SKILLS:

Oracle: Oracle12c,11gR2,11gR1,10g,9i, OracleGolden Gate, OracleGrid Control, OracleCluster ware, OEM, ARDCI,RMAN, SQL*Loader, Import and Export, Data pumps, ASM, TKPROF, AWR, SRVCTL, OracleStreams.

Operating System: UNIX, Red Hat Enterprise Linux (RHEL) 4.x, 5.x,6.x,7, Windows

Languages: PL/SQL, UNIX Shell Scripting.

Tools: PeopleSoft, VERITAS TOAD, Putty, NX client, Virtualization Software

PROFESSIONAL EXPERIENCE:

Level 2OracleOperational DBA

Confidential, Tampa, FL

Responsibilities:

• OracleHA Stack: Install, Configure, Setup, Maintain and SupportOracle11gR1, 11gR2, 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
• Familiarizing myself with Oracle 12c on a Single Instance and Two node RAC Database by performing installation, configuration and monitoring DB activities.
• Develop upgrade roadmap and perform upgrade 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 storage Instance.
• 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
• UsedOracleGolden Gate for Basic and Advanced Data Replication betweenOracleDatabase Servers and Legacy Databases
• Performed History pull to synch-up data betweenOracleto Non-Oracle(Tandem, SQL Server) databases using Golden Gate
• Set up DDL/Bi-directional replication
• Storage Migration: Migrated OCR, VD and ASM data from one SAN storage array to another
• BuiltOracleMAA 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 usedOracle11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup,OracleData Pump, big file table spaces, 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 etc.
• Performance Tuning ofOracleDatabase Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF for optimized results
• Rebuilding of Indexes for better performance, maintenance ofOracleDatabase, Creating and Managing Table spaces 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
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• 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.
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team

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

ORACLEDBA

Confidential

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues..
• Involved in capacity planning and configured 11gr2 RAC for high Availability.
• Converted single instance database to RAC Databases
• Configured databases for BI and worked on databases sizes from 2TB to 30TB.
• Applied patches toOracleDatabases using Opatch utility and upgraded databases manually and implemented Up-gradation of databases from 10.2.0.x to 11.2.0.x.
• Migrated databases from Cooked File-system to Raw ASM environment.
• Involved in migrating HP-Unix databases from 10g/11g to 11gR2 Red hat-Linux.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Configured parameters for the Bi-directional replication using Golden-Gate.
• Implemented Disaster recovery for development databases using Data guard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby, read only stand by and also Active Data-guard.
• Involved in creating listeners and TNS manually in Data-guard Environment.
• Extensively used data-pump at schema level for migrating data from Solaris to Linux.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Troubleshooting RMAN whenever backup failed and Configured retention policy, archive log deletion policy for Production databases and registered databases in catalog server.
• Involved in Management of schemas, objects partitioning the tables & indexes.
• Performed Database refresh from production to test/dev environment.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Perform other regularDBAactivities including space management and performance Tuning.
• Granted and Revoked user privileges and roles as per requirement and killed blocking session and performed database refresh from Production to test environment using RMAN cloning and Exports and imports.
• Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases and Involved in gathering requirements from end users.
• Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• PerformedOracleDatabase monitoring, troubleshoot and resolved the issues.
• Extensive Performance Tuning, Memory (SGA) Tuning,
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Net-backup Team.
• Involved in Writing SQL scripts to monitor table space and extent growth.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Familiar with ORA-600 error. Involved with this ERROR.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: Oracle10g, 11gR1/R2, HP-Unix 7i, RHEL 5.x, OEL 6.3, OEM 10g/11g, RMAN, RAC, ASM, Data guard, Virtualization Tools, AWR, ADDM, ASH, Data pumps

Operational OracleDBA

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
• Set up 10g RAC for Development and Test Environments.
• Installation and creation of 9i and 10g databases on Testing Environment.
• Installed, Setup, ConfiguredOracle10.2.0.4 on RHEL 4.8
• Installed, Configured, Setup, Maintenance and SupportedOracle10g RAC, Physical Standby database
• Installed, Configured and setupOracleStreams betweenOracleServers
• UsedOracleStreams for Basic and Advanced Data Replication betweenOracleDatabase Servers and Legacy Databases
• UsedOracle10gR2 features vizOracle10g Real Application Clusters (RAC),OracleStreams / Replication, automatic SGA tuning, enhanced RMAN with flash recovery area,Oracledata pump, big file table spaces, Database Control, Studio Control, Statspack, ADDM, SQL Tuning/ Access Advisors, Flash Back Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning ofOracleDatabase Objects
• Performed database Cloning using RMAN 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
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK
• Data refresh from production to test and development
• Was involved in developing a Disaster Recovery (DR) plan
• Installing and configuring Recovery Manager (RMAN)
• Setting and InstallingOracleEnterprise Manager (OEM) and Enterprise Backup Utility
• Setting up new Development environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Test and Development Databases
• Providing Solutions to the Problem Faced by end Users Or Developers.

ORACLE TRAINEE/Jr. DBA

Confidential

Responsibilities:

• Installation of Oracle9i & 10g databases in development and test environments.
• 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 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
• Performed othercommon administration tasks like performance tuning, monitoring tablespaces and monitoring users.
• Installed and Configured 9i Single instance database for business transaction functionality.
• Provided production support for the deployed project to better stabilize it.
• Familiarized myself with 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

Environment: Oracle10g/9i, OEM 10g, Shell Scripting, Oracle10g RAC, TOAD, Virtualization Tools, STATSPACK, EXPLAIN PLAN.