CAREER SUMMARY

• Experienced IT Professional with over 8 years of Oracle Database Administration experience comprising of Oracle 11g, 10g Installation and configuration on Linux Solaris Platform using Veritas Cluster, OCFS ASM. Exa-Data Migration, RMAN Backup Setup Logical backup export setup using shell scripts and cron jobs. High Availability with Oracle DR setup using Data Guard, Performance Tuning, Advanced replication Setup Oracle Streams, Golden Gate, Oracle Upgrade Migration, Patch Installations, Database Design Development Implementation in Financial, Health Telecommunication Industries, 24 x 7 Production support on-site remotely.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g RAC database with ASM and single instance database and Migration to EXA-DATA Machines.
• Experience with Advanced queuing and Change Data Capture.
• Experience in maintenance of Production, Testing, Development env.
• Data Loading using SQL Loader.
• Fixing plans with SPB and sql profiles.
• Tuning with STATSPACK, ADDM, V views, ASH, TOP, netstat, vmstat, iostat and prstat.
• Installed 10g Grid agent on servers and configure OEM Grid control.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Configuration, Installation and Maintenance of Clusterware and Oracle RAC on Solaris.
• GG setup integrated capture to replace CDC.
• Replication using shareplex and Golden Gate Technology.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Experience in installing, maintaining, upgrading and patching Shareplex and Golden Gate.
• Experience in installing, maintaining, upgrading and patching Oracle versions 11g/10g.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning RAC .
• Oracle Database Administration in a variety of environments like UNIX-Sun Solaris, IBM AIX, HP-UX and LINUX- RHEL.
• Oracle Cluster ware installed to provide infrastructure for RAC in production, DR databases and configured 2 node Oracle 11g RAC and Migrated Database from NON-ASM to ASM and NON-RAC to RAC.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage, resolving ORA-errors and network management.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator, TOAD and Opatch Utility.
• Converted range to interval partitioning.
• Experienced in Oracle Support processes for technical requests through Metalink.
• Documented all Oracle database installations and database operations
• 24 7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SUMMARY

Databases: Oracle Versions -11g/10g.

Oracle Products: Oracle RAC, RMAN, OEM, Grid Control, Replication, Oracle Streams, Data Guard, Exa-Data, SQL Loader, Export/Import, data pump, CDC, AQ, 10046 Trace Event, oradebug, RDA, AWR and ADDM.

Languages: SQL, PL/SQL. Shell Scripting.

Replication: Shareplex, streams, Golden Gate.

Operating System: SUSE Linux, Redhat Linux, Sun Solaris, AIX.

Tools: TOAD, OEM

SKILL SUMMARY

• Implemented and managed hands-on Oracle based technical solutions in the following areas :
• RDBMS Installation Configuration: Oracle 11g/10g Installation for RAC and single node Installation. Patches installation DB upgrade.

• CRS Installation Configuration 11g CRS and Upgrade 10 to 11g.
• Backup Restore: Implemented robust hot backup strategies using Oracle's RMAN technology, Planned and coordinated DR drills. Recovered databases using RMAN'S restore options in real-time scenario. Logical backup using 'export' and recovered using 'import' features for object level recovery. Flashback of databases using guaranteed restore point. Backup restore using datapump.
• Disaster Recovery High Availability: Implemented DR Solution using Oracle 'Data Guard' did planned switch-over while setting up DR solution for Production boxes and Maintenance.
• Performance Tuning: Detecting and diagnosing production system performance problem by Analyzing Oracle trace file, analyzing SQL statements, querying Oracle dynamic data dictionary views pin plans, SQL statement tuning for OLTP data warehouse using TKPROF, SQL Trace and EXPLAIN PLAN tools. Generating Analyzing AWR ADDM reports. Enhance performance by Table partitioning for large tables.
• Replication: Shareplex, Golden Gate, CDC.
• Production Support: Providing 24x7 on-site and remote DBA support.

Professional Experience

Confidential

Sr. Oracle Database Administration

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, DR databases and configured 2 node Oracle 11g RAC.
• Worked on implementation of Oracle 11g Active Data Guard on physical standby databases with different modes.
• Involved in Installing, Configuring, Administration and troubleshooting Oracle 10g RAC/11g RAC.
• Migrated Single instance database to 4 node RAC Database.
• Installed and configured Golden Gate, upgrade from 11.2.0.1.11 to 11.2.0.1.21 and replaced CDC with GoldenGate.
• Troubleshooting GoldenGate Replication Issues.
• Worked on Migrating database to EXA-DATA Machines and from Non-ASM to ASM, non-RAC to RAC etc.
• Database refresh/Clone using RMAN for prod parallel env with minimal downtime using DR Solutions and with GoldenGate.
• Worked on Implementing RAC systems from scratch.
• Convert database from Non RAC database to RAC database and NON-ASM to ASM.
• HeartBeat setup for latency check for GoldenGate Replication.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer CBO , SQL analyzer, sql profiles, sql plan baselines, SQL Advisors, Performance Manager, and Stats pack.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and Active Session History ASH .
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.
• Involved in PL/SQL and UNIX shell scripting and automating them using Cron Utility.
• Cloning databases using scripts as well as RMAN for test and development.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Involved in Capacity Planning for databases based on the future business growth requirements.
• Partitioned large tables to get the better performance and manageability.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Unix Shell scripting in ksh for automating backup and recovery, Import and export procedure of databases, getting system alerts.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.

Environment: Exa-Data , GodenGate, Oracle 10g/11g, RAC, ASM, Shareplex, OEM Grid Control , RMAN, Data Guard, Data Pump, Putty, Sun Solaris 5.10,

Confidential

Sr. Oracle Database Administration

Responsibilities:

• Upgraded Database with DR from 11.2.0.1 to 11.2.0.3.
• Installed and configured SHAREPLEX for multi master replication and Shareplex upgrade from 7.2.0 to 7.6.3
• Implemented backup strategies using hot/cold, exp/imp used on the business requirement.
• Datagaurd Rebuild.
• Worked on Building 4 Node RAC database with 4 Node DR database.
• CDC Setup between DB2 and ORACLE and ORACLE-ORACLE.
• Experienced working on Advanced queuing , change data capture and Advanced Compression.
• OU-Exa-Data and GoldenGate and Tested zero downtime migration with GG.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer CBO , SQL analyzer, sql profiles, sql plan baselines, SQL Advisors, Performance Manager, and Stats pack.
• Administration of Oracle 11g RAC.
• Implemented interval partition.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Used Oracle CDC Replication feature to set up replication from database to grid.
• Unix Shell scripting in ksh for automating backup and recovery, Import and export procedure of databases, getting system alerts.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Working experience in OLTP/OLAP and DATA WAREHOUSE environments.
• Evaluating PL/SQL procedures, sqls before golive.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain table spaces, creation and maintenance of tables, partition tables and indexes Stats Collection.
• Scheduled Jobs for auto drop partitions.
• Creation and maintenance of standby database by using oracle high availability method and Oracle Data Guard.
• Providing on-fly solutions to make database healthy and keep running During Change Control and Enterprise release.
• Responsible for backups and recoveries of the oracle database.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
• Monitoring over 6 Prod databases with max size of 30 Tb.
• Hands on experience working with Oracle Grid Control Environment.

Environment: Oracle 10g/11g, Red Hat Enterprise Linux 4, ASM, HP-UX11,Shareplex, OEM Grid Control , RMAN, RAC and Data Guard, Explain Plan, PL/SQL, Data Pump, Putty, SQLT, Sun Solaris 5.10.

Confidential

Oracle Database Administration

Responsibilities:

• Upgrade RAC from 10.2.0.4 to 11.2.0.1.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the database using AWR, ADDM, Grid Monitoring and Administering RAC databases running on Cluster File system.
• Performed performance tuning using Explain Plan, SQL Trace, TKPROF, Stats pack, ASH.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning.
• 24x7 on-call production database support.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Responsible for scheduling and holding design reviews as needed to support the development processes and performing data loading using SQL Loader.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup's logs and alert logs.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning.
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Knowledge on VMware Virtual Machine
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Performed daily database administration tasks: User management, Space, Performance, Alert Log and Backup Monitoring and solving errors like ORA-600, ORA-7445.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, Toad, SQL, PL/SQL, ERWIN, Data guard, Data Pump, OEM, RMAN, SQL Loader, Streams, Shell Scripting, AWK, SQL Server, Data Warehouse, OLTP.

Confidential

Oracle Database Administration

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.1.0.6.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the database using AWR, ADDM, Grid Monitoring and Administering RAC databases running on Cluster File system.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Performed performance tuning using Explain Plan, SQL Trace, TKPROF, Statspack, ASH.
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication.
• Experience with data modeling using Erwin, converting the logical model to physical model.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager OEM .
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Maintained Very Large Multi Terabyte VLDB in Data Warehouse Environment for DSS.
• Performed daily database administration tasks: User management, Space, Performance, Alert Log and Backup Monitoring and solving errors like ORA-600, ORA-7445.
• Documentation of Oracle database operations and training of backup personnel.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, OEM, RMAN, SQL Loader, Streams, Shell Scripting, AWK, SQL Server, Data Warehouse, OLTP.

Confidential

Oracle Database Administration

Responsibilities:

• Responsible for installation and creation of databases 10g RAC for Development and user acceptance test.
• Responsible for Installation of 10g 10.2.0.1 cluster ready services and 10.2.0.1 database in OCFS and ASM file systems.
• Responsible for Upgrading 10g 10.2.0.1 CRS to 10.2.0.4.
• Responsible for Upgrading the Database from 10.2.0.1 to 10.2.0.4.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Upgradated from 10.2.0.4 TO 11.2.0.2 on both standalone and RAC databases on DEV env.
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery usingRMAN and Data Guard.
• Tested many backup and crash recovery scenarios on test environment, using RMAN tool.
• Responsible for automation of startup and shutdown on all production and development databases.
• Involved in export and import of database objects in order to copy them from one database to another copying the export dump file to tape.
• Resolution of problems and issues coming up in the database according to predefined mutual service statutes.
• Wrote scripts Linux Shell for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Responsible for all database activities such as space management, database security management, rollback segments creation of DB links between two oracle servers.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Experience with OLAP.
• 24x7 production environment and provided on-call and day-to-day support.

Environment: Oracle 9.2.0.8, 10.2.0.4 11.1.0.6, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL Plus, SQL Loader, OEM, PL/SQL Developer, Import/Export, TOAD.