SUMMARY

• Oracle DBA offering more than 13+ years of Oracle Database maintenance and support experience in Oracle softwareinstallations, backup and recovery, software patch installations, up gradation, Security Additional experience in application systems monitoring and support, Oracle systems performance tuning, Database tuning, query tuningand troubleshooting, with an emphasis on support. Developed a highly acclaimed reputation for resolving user service requests and incidents
• Over four years of experience in Unix shell scripting
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Oracle 10g certified Database Administrator with Wide exposure to Oracle 10g and Solid understanding of its Architecture
• Having hands on experience in management and database administration of Oracle applications on ExadataQuarter RACK and Half RACK platforms
• AWS Cloud expertise in administration, migration and enterprise configuration
• Architect AWS instances to migrate on premise application to cloud.
• Experience in Oracle 11g/12c new features andOracle 10g Real Application Clusters(RAC)
• Expertise in configuring Data Guard for data availability, data protection, and disaster recovery solution for enterprise databases
• Configured and Maintained Oracle RMAN Backups,
• Worked as a SQL developer, Skilled in optimizing SQL, PL/SQL queries
• Experience in Logical and Physical Databases design including both OLTP and OLAP .
• Implemented 9i features like UNDO table spaces, Resumable space management, Segment space management, Redefining Tables
• Worked on 10g features like Data pump, Flash - Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Reorganized databases to avoid disk rotation for maximum performance
• Creation of new database links and materialized views and setting up of database jobs for their refreshment
• Installing and upgrading oracle database on UNIX, windows platforms, experience in managing physical structure storage and security
• Used different v$ views to study the database activities taking care of SQL*Net related problems like listeners and connect strings
• Database tuning: Optimize database performance by analyzing objects, generating statistics, creating indexes and views
• Database Performance Tuning using SQL TRACE, TKPROF, Explain plan, STATSPACK, AWR, and ADDM and Proactive Monitoring, identifying areas that need to be improved in the application and database using Stats pack, AWR, ADDM and 10g OEM Grid Monitoring .
• Configured Oracle Shared Server Configuration(MTS) architecture for optimum usage of system resources
• Configured Multithreaded Server and balanced the shared server processes and dispatchers
• Experience in OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Expertise performing archiving andpurging of partitions
• Backup and Disaster Recovery: Implemented robust backup strategy with hot, cold & Oracle exp/imp utility using UNIXshellscripts, RMAN backups. Evaluated disaster recovery options and implemented business continuity plans.
• As a senior dba worked on multipule database like MySql,Sybase and sql server
• Worked with tools like DTS, SQL * Loader, export/import,, Log Miner
• Working Experience on ORACLE EXADATA for the extreme performance of the database
• Ability to function successfully in a highly stressful, 24x7 mission critical environment
• Team player, excellent performer in a fast-paced environment. Self-motivated, quick learner and proactive.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g, 11g,12c, MS-SQLServer 2000/2005, MySQL & IBM Informix

Data Modeling Tools: ERWin 7.3 & Sybase Power Designer

Operating Systems: Solaris, AIX, HPUX, WIN 2000/2003, Red Hat Linux AS4

Database tools: TKPROF, EXPLAIN PLAN, STATSPACK,Exadata,AWR and ADDM. RMAN, ASM, OEM, TOAD,SQL*Loader, EXP, IMP, EXPDP, IMPDP &USEH

Scripting: UNIX shell scripting

Programming Languages: SQL, PL/SQL, T-SQL, C &Java

PROFESSIONAL EXPERIENCE

Confidential

Database Engineeer

Responsibilities:

• Involved in Installation and configuration of Oracle 11gR2& 12c RAC (4node) using oracle Clusterware and ASM
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAW Devices.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.Piloted the Planning and Migration of Oracle databases from In-premises Datacenters to AWS Cloud including homogeneous and heterogeneous migrations
• Worked on Database Migrations from On Premises to AWS RDS Database and Exadata
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 12c.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate
• DML and DDL Replication: Difference and configuration.
• Worked on Database Migrations from one datacenter to another datacenter on Quarter Rack on Exadata
• Golden gate Heterogeneous replication using Log miner utility
• Configured and Administered STREAMS and GOLDEN GATE.
• Standby Database (Data Guard) setup and configuration.
• Logical backup using Data pump and Import/export.
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Statistics and Reporting: various Golden Gate commands like STATS/LAG,RANGE to check the performance of various processes
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

Confidential, Framingham, MA

Sr Database Administrator

Responsibilities:

• Involved in Installation and configuration of Oracle 11gR2 RAC (4node) using oracle Clusterware and ASM
• Worked on import/export, export data pump/import data pump and SQL- loader.
• HP-UX Platform migration to Oracle Linux 6.3 Using RMAN Transportable table space
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAW Devices.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate
• DML and DDL Replication: Difference and configuration
• Golden gate Heterogeneous replication using Log miner utility
• Configured and Administered STREAMS and GOLDEN GATE.
• Standby Database (Data Guard) setup and configuration.
• Logical backup using Data pump and Import/export.
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Statistics and Reporting: various Golden Gate commands like STATS/LAG,RANGE to check the performance of various processes
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

Confidential, Hightstown NJ

Database Administrator, Environment Support

Responsibilities:

• Installation of Oracle 11.1.0.7. on Oracle Linux .
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Oracle Linux Intel
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Use of Data Guard Manager, 9i and 10g Data Encryption.
• Carry general administration tasks using tools like OEM and Toad.
• Implemented and maintained streams for synchronization of data at various sites.
• Used RMAN for backup and recovery jobs.
• Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applying Patches to 10g/11g on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Migrating data using RMAN transportable tablespace
• Daily monitoring of database instances. The daily monitoring included checking for fragmentation, tablespace spacing, log files, and the space availability for archiving Files, checking the backups etc.
• Rebuilding the indexes
• Analyzing the Database and Schema Tables.
• Monitoring the Database health Checks.
• Monitoring the tablespace and table growth
• Preparing implementation plans for production releases and Database reorganization
• Performing the Database reorganization
• Creating the Table partitions.
• Install in the application specific data build release patches.
• Install the all Revitas software patches.
• Creating the new environments for new releases.
• SQL tuning
• Performed scheduling UC4 for scheduling jobs.
• Configuring oracle enterprise manager 10g GRID, for monitoring and maintenance of 10g, 9i databases