SUMMARY:

An astute Oracle DBA with 7 plus years of IT experience in Oracle products both production and development environments. I have participated in a wide array of activities in support of multi-tier production and development environments which include the installation and configuration of Oracle RDBMS versions 9i, 10g, 11g, 12c on UNIX/Linux/Windows platforms, database administration, production support, installation, configuration, upgrades, patches, database security, troubleshooting database design, UNIX shell scripting, Backups and Recoveries, Data pump, Data Replication, Performance Tuning and OEM.

PROFESSIONAL SUMMARY:

• Hands on experience on Oracle 9i/10g/11gR1/11gR2, 12C , installed and configured on different platforms like Windows, Linux , RHEL, Oracle Solaris , HP-UX., IBM-AIX
• Worked on databases sizes ranging from 500GB to 8TB.
• Worked on Different operating systems for OLTP OLAP environment on Very Large Databases VLDB .
• Experience in configuring high availability systems like Real Application Clusters RAC .
• Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
• Involved in migrating production databases single instance to RAC environment.
• Planned and Implemented Disaster Recovery DR and HA using RAC, Data Guard.
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Data guard.
• Having good experience in migrating databases with zero downtime across the cross platforms.
• Hands on experience on Oracle Exadata Database Machine Implementation and Maintenance.
• Having good experience in Installation of 12C Grid Control on OEL 6.3 and experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control OEM grid 10g /11g.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM .
• Experience in installation and configuration of Oracle Golden gate GG both unidirectional and bidirectional .
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Generate and interpret Automatic Workload Repository AWR , Active Session History ASH , and Automatic Database Diagnostic Monitor ADDM reports using OEM.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager RMAN . Performed block recovery, data files and databases using RMAN.
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
• Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
• Implemented data transfer using Transportable Table Spaces TTS , Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Utilized SQL Loader to migrate or load data to Oracle.
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Worked on different types of storage structures SAN/NAS .
• Expertise in SAN/NAS migration and Re-IP.
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.
• 24 7 on-call production database support and maintained remotely.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiastic in learning new technologies.

TECHNICAL SKILLS:

• Operating systems : LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.
• Databases : Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005.
• Oracle Database Tools : SQL Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control, MySQL Enterprise Monitor
• Data Warehouse Tools : SQL and ETL tools for above database environment
• Tools Utilities : Export/Import, RMAN, Data Pump, Winscp3, ERWIN.
• Languages : C, C , UNIX shell scripts, PL/SQL
• Web Tools : HTML and XML.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle Database Administrator

Responsibilities:

• 24x7 production database support.
• I solved the errors ORA-600, ORA-1555, ORA-7445.
• Experience in Enterprise user security.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• Performance tuning and monitoring of Databases through v views, AWR, ADDM, statspack, etc.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
• Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Utilized SQL loader and data pump import to load data into tables
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Implemented 12c/11g Data guard with one physical database.
• Installed Golden Gate 12c on IBM-AIX Platform.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Created and Configured Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Created duplicate databases using RMAN duplicate.
• Implement Hot, Cold and Logical backup plans.
• Installed and Implemented Backup Recovery procedures.
• Set up backup and recovery procedure using RMAN and setup Autosys jobs.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication materialized views.
• Disaster recovery of Exadata Data guard Physical Standby. Failover/Switchover/Loss of Service/Rebuild/Corruption/Loss of data file testing.
• Involved in Data Center Migrations, SAN Migrations and NAS Migrations.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager OEM .
• Migrated Oracle database from Non Exadata machine to Exadata using data pump and golden gate.
• Implemented cross platform migration from HP-UX to AIX, Solaris to Linux, Windows to Linux.
• Upgraded Oracle Database from 10.2.0.4 to 11.2.0.3.
• I worked in managing multi-terabyte databases like more than 10 terabytes in this project.
• Set up, configured and maintained oracle data guard primary and standby databases to ensure disaster recovery, high availability and data protection.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.
• Installation, Cloning, Configuration and Administration of Oracle 11gR2 RAC.
• Performed Re-IP by moving the servers from one location to other without loss of data.
• Performed SAN/NAS migrations.
• Administering 24x7 Real Application Cluster RAC databases running on Cluster File system. Worked with senior DBA's for preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Exadata, Toad, AWR, ADDM, ASH, SQL, PL/SQL, Data-Pump, OEM, RMAN, SQL Loader, NETBACKUP, Solaris, RHEL, UNIX, AIX, HP-UX, Korn Shell Scripting, SQL Server, OLTP, Datacenter.

Confidential

Role: Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.
• Involved with installation and maintenance of ORACLE RAC 3 nodes and adding a node to this cluster database for high availability on Linux.
• Installation, Configuration and Maintenance of RAC, Standby database.
• Installed 12C GRID CONTROL and registered databases in GRID control.
• Knowledge in handling and Oracle Enterprise Manager OEM on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Involved in migrating non-RAC databases to RAC environment on ASM.
• Converted single instance database to RAC Database using R-CONFIG.
• Configured and installed 15 standalone DR servers on ASM.
• Implementation and configuration of Oracle golden gate.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Capture, Propagation, Apply using Golden Gate.
• Worked on databases sizes 8TB and involved in scheduling backups.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating HP-Unix databases from 9i, 10g, and 11gR1 to 11gR2 Linux.
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate
• Implemented Disaster recovery for production databases using Data guard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby.
• Implemented 11g new features for building Active Data-guard.
• Configured Data guard-broker and involved in registering of databases in Data guard broker using utility DGMGRL.
• Extensively used data-pump at schema level and Database level for moving data from Solaris to Linux during migration
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Installed and Implemented Backup Recovery procedures using RMAN.
• Performed Block Recovery, data file recovery using RMAN.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Maintained catalog server and registered databases in catalog server.
• Performed Database refresh using RMAN active cloning and data-pump.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, RAID, RAW Devices.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption .
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Netback up Team.
• 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: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, SQL Loader, Oracle Data guard, Sun Solaris, Linux, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM Grid Control , Export Import, RMAN, XML, Shell Scripting.

Confidential

Role: Oracle DBA

Responsibilities:

• Installed and maintained 3 Node 11g RAC and created database for production, development and test environment on Hp-Unix platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using Net-backup.
• Involved in migrating single instance databases to RAC databases.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• upgraded Databases from 10.2.0.4 and to 11.2.0.1
• Worked on ASM environment performed various tasks like creating disk group using ASMCA, adding a disk to disk group, making disk online/offline in disk group.
• Implemented data-guard for databases and maintained Data guard DR server and have good experienced in Trouble shooting issues in Data-guard Environment.
• Configured physical standby databases and converted snapshot standby database.
• Converting data files across different platform using RMAN convert, Transportable Tablespaces TTS , Export/Import and Data-pump expdp/impdp .
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.1 on Linux.
• Manage and maintain database and user security using OEM Grid Control.
• Documented backup and recovery plans and tuning procedures.
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Golden Gate installation, configuration for replication.
• Helped in Performing Golden Gate replication monitoring, tuning, and capacity planning.
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager OEM .
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers. Writing backend procedures, functions, packages and triggers using PL/SQL.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing which are kept in CRONJOB

Environment: Oracle 10g/11g, Oracle 10g RAC, ASM, HP-UX 11, RHEL 5.8, Data Warehouse, OEM, SQL Loader, Grid Control, RMAN, Golden Gate, ASM, Data guard, TOAD, Data pump.

Confidential

Role: Oracle DBA

Responsibilities:

• Involved in Real Application Cluster RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager RMAN , also setup Recovery Manager Catalog for the same and hot and cold backups.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing the SGA, sizing the database buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL Loader and data pump utilities.
• Installing configuring Oracle 10g, 10g RAC, 9i on Linux RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs change requests for future reference.
• Expertise in PL/SQL, SQL and UNIX Scripting Used to write UNIX Scripts implemented by Using CRONJOB for Day to Day activities.
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and SQL server integration services SSIS in the SQL server 2000 and 2005.

Environment: ORACLE 11g, SQL, PL/SQL, Data Pump, Import/Export, RHEL, Windows NT.

Confidential

Role: Oracle DBA

Responsibilities:

• Managing daily operations for over 20 servers, including the Oracle System, using physical data guard and Delivered technical presentations on Oracle database operation.
• Designing and Implementing Database security using Oracle roles and privileges.
• Creating and managing stored procedures and triggers, distributing data, database replication, server tuning, and automation of administrative tasks
• Preparing a plan, policy and testing for the Upgrade of Oracle from 9i to 10g.
• Used RMAN for Backup, recovery and security.
• Supporting all aspects of production, QA, and development Databases versions 9i and 10g on Solaris and Linux
• Working in/with Development and Production in resolving SQL issues.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate and Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries and Involved in PL/SQL Coding, Scripting Training Developers
• Installing, creating, configuring, tuning, and supporting Oracle Databases for several Enterprise java based E-commerce and portal applications
• Written PL/SQL programs functions, procedures, packages and triggers.
• Implementing Database object changes that were tested in testing environments
• Performing capacity planning and sizing of Databases based on inputs from business.

Environment: Oracle 9i/10g, SQL Plus, PL/SQL, Solaris, Red Hat Linux AS 2.1/3.0, and Windows 2000.

Confidential

Role: Oracle DBA

Responsibilities:

• Installed and configured Red Hat Linux, Oracle 9i on AIX 6.x and performed migration from existing oracle 8i system to 9i.
• Provided System support for both development and 24 7 production environments.
• Involved in applying patches for up-to-date database software, creating new control file, log files, tablespace, rollback segments, data files and alter data files for resolving disk contention issues.
• RMAN and conventional hot backups on daily basis and cold backup on weekly basis are taken in archived and no-archived mode, exceeding business requirements and are used at the time of recovery.
• Produced DB Links in Oracle for communicating with external databases.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Used tools such as SQL Loader to develop procedures for migration of data from systems.
• Tuning of database performance by query optimization and trace facility using Utlbstat/Utlestat utilities, Explain plan, analyze and Tkprof.
• Suggest appropriate measures depending on bottlenecks type - IO, CPU or memory bottleneck.
• Created users and granted/revoked their respective privileges and roles.
• Designed schema objects and extensively used PL/SQL procedures, sub queries, triggers, packages, shell scripts to automate data loading.
• Experienced in documenting the architecture and data flow of the entire system.

Environment: IBM AIX 6.x, Sun Solaris, RHEL, Oracle 9i/8i, PL/SQL, RMAN, Export/Import Data Pump, UNIX shell scripting, SQL Loader.