SUMMARY

• Over Nine Years and 2 Months of proficient experience in Oracle 10G/11GR1/11GR2/12c in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Implemented and maintained Physical standby databases using Data Guard for disaster recovery (DR) and Business Continuity.
• Creation and Configure of Snapshot Standby and Active Data Guard
• Involved in Installation and configuration of Oracle 11g R1/R2 RAC using oracle Clusterware and ASM.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption, recover a Production SYSAUX data - file from standby etc.).
• Upgraded database, Clusterware, RAC and ASM from oracle 10g to 11g and applied oracle patches for DST.
• Installed and used Oracle Enterprise Manager (OEM) for Proactive monitoring, identifying areas that need to be improved in database performance monitoring, job scheduling, Setting Optimizer Statistic etc
• Experience in Capacity Planning, Storage Allocation and Space Monitoring & Management
• Tuned the SGA components like buffer cache, shared pool to avoid paging & swapping
• Hands on experience of database backups and recovery methods like PITR, TSPITR Export/Import
• Used database tuning advisor, SQL Plan Management and SQL Profiler for performance optimization.
• Used DataPump (expdp,impdp) to take backup at database level or tablespace level and also to accomplish table leveland full database de-fragmentation.
• Experienced in Flash-Back Recovery (Flashback database, Flashback Drop & Flashback Query).
• Moving data from development to production through Transportable Tablespace exports
• Extensive Knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Designed and implemented database backup and recovery strategies using RMAN. Created scripts for Monitoring andMaintenance task, automated Database backup.
• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, DBlinks, Packages, Procedures,Functions, Cursors, and Triggers.
• Proactive in monitoring, identifying areas that need to be improved in the application and database using 11g OEM GridMonitoring. Supported Unit/System Testing and User Acceptance Testing.
• Proven capability to multi-task, work in a team environment, and recognize systematic approaches to resolve problems.
• Good knowledge of the IT Service Management and improves the quality of services provided to the customer by best ITIL practices.Golden Gate:
• Hands on experience with Installation and Configuration of Oracle Golden Gate software for performing database upgrades, cross platform migrations and replications on IBM GPFS (The General Parallel File System) & ACFS.
• Configured Replication between Active-Active Database’s with golden gate replication.
• Capture, Propagation, Apply using Golden Gate 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.
• Configured Replication between different structured Target and source with DEFGEN and COLMAP.
• Performed Data Transformations in PUMP and Replicate.
• Handled CDR's (conflict Data Resolution's), wrote exceptions to catch issues.
• Tuned golden gate replication using parameters like BATCH-SQL, PARALLEL and MAX PARALLESIM.
• Configured lag monitoring and heart beat table in Golden Gate.
• Investigate Replication failures using Log Dump utility.
• Configured Oracle GoldenGate XAG for Oracle Grid Infrastructure

TECHNICAL SKILLS

Operating Systems: SPARC Machines, Sun Solaris 9.0/10, IBM AIX, Red Hat Enterprise Linux 5/6

Databases: Oracle 11g/10g RAC, Oracle 11g/10g Stand alone with Sun Cluster/Veritas Cluster

Languages: Shell Scripting, Sql, Pl/Sql

DBA/Utility Tools: EXPDP/IMPDP, Sql* Loader, RMAN, DBCA, crsctl, srvctl, Data guard, OEM, ASM, opatch

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, Rhode Island

Senior Oracle Database Administrator

Responsibilities:

• Installed and Configured Oracle 11GR2 with Grid Infrastructure (GI) on AIX 6.1 and also migrated Oracle database from Solaris to AIX.
• Configured and Implemented Oracle 11GR2 Database on a Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Upgraded 11gR2 (11.2.0.3) to (11.2.0.4) in rolling fashion.
• Applied PSU & CPU patches for the oracle enterprise database servers.
• Experienced with SRVCTL/CRSCTL and worked on configurations of OCR, Voting Disk, ASM /OCFS of 11g RAC.
• Participated in Oracle Golden Gate 12 installation, configuration and management, and supporting bi-directional data replication.
• Capture, Propagation, Apply using Golden Gate 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.
• Configured High availability and set-up custom monitoring through Heart beat tables using Golden Gate.
• Worked with application team for setting up conflict handlers in Golden gate.
• Used BATCHSQL, RANGE functions to improve throughput in Golden gate REPLICATES.
• Troubleshoot slow running EXTRACTS, REPLICATES and tuning.
• Duplicated RAC Databases in non production environment through RMAN.
• Involved in Implementation of Oracle 11g Active Data guard.
• Actively participated in DR activity.
• Implemented OEM 12c Repository database, OEM 12c Agent for monitoring targets
• Monitoring production databases through Oracle Enterprise Manager (12c) to troubleshoot and diagnose database problems.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, and incremental backups and troubleshooting ORA errors for backup issues.
• Monitoring tablespace usage and adding space, adding disks to ASM disk groups and performing ASM disk group rebalance when required.
• Provided support on performance issues during project development resulting in improved response times and reduced contention.
• Maintenance and monitoring for Standby database. Archived log gap monitoring for standby database. In case of huge archived logs gap, taking hot/Incremental backup from PROD database from current SCN of standby. And then apply to standby database.
• Migrated database Schemas from Single instance to RAC.

Confidential, Minnesota

Senior Database Administrator

Responsibilities:

• Designed and Configured Oracle Database 11GR1/11GR2 Real Application Cluster (RAC) with 3-nodes clusters
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Setup Client side and Server Side Load balancing in RAC environment.
• Upgrading Oracle software to latest patch set using silent installation mode.
• Applying PSU and bug fix patch for 11GR2 GRID Infrastructure.
• Converted/migrated few databases from single instance to two node RAC database
• Performed backups and recoveries using RMAN/conventional hot & cold backups using TSM.
• Support/Fault finding & resolution to the database problems on RAC/Non RAC/Clustered (VCS).
• Implementing Data Guard with physical Standby server for high availability.
• Migrate, upgrade and support SAP 3 node 11R2 RAC databases
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Monitored databases with GRID Control, and extensively used AWR, ADDM reports to ensure overall health of the databases with focus on 100% uptime.
• Extensively used exp/imp & Data Pump utilities to refresh the databases from Production to Test environments.
• Used Stored Outlines, SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues.
• Performing Logical backup/recovery of schema with Data Pump.
• Maintaining active data guard on physical standby systems to ensure high availability.
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking space management & performance troubleshooting.
• Tuning the scripts & queries for better performance by picking the best available plan, SQL profiling and Hints.
• Carried out monthly /weekly maintenance of database such as Defragmentation of Table spaces, Rearrangement of segments in different Disks based on disk I/O.
• Includes maintaining healthy backups with RMAN and recovery as needed to support business/applications.
• Monitoring alert logs, trace files, disk space, etc periodically through scripts and automating reports through mails.

Confidential, New Jersey

Technology: Oracle 9i/10g on Sun Solaris 9 /10, IBM-AIX.

Database Administrator

Responsibilities:

• Implementing Data Guard with physical Standby server for high availability.
• Performing Logical backup/recovery of schema with Data Pump.
• Checking and validating the objects after import and migration process.
• Restoration of backup’s from TSM Server‘s. Backup failure management
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database
• Creating users, roles, synonyms and providing grants to users on application schema tables
• Monitoring the performance of database using OEM.
• Monitoring alert logs, trace files, disk space, etc periodically for correcting errors.
• Tablespace creation / design for database.
• Monitoring the growth of Tablespaces.
• Tuning production/development database from statistical analysis.
• Rebuilding the indexes, when necessary.
• Monitoring alert logs, trace files, disk space, etc periodically through scripts and automating reports through mails.
• RMAN backup configurations.
• Refreshing the database from Prod to UAT Servers as per the client request.

Confidential, NewJersey

Database Administrator

Responsibilities:

• Worked in 24 Hours Production Support.
• Monitoring alert logs, trace files, disk space, etc periodically through scripts and automating reports through mails.
• RMAN backup configurations.
• Refreshing the database from Prod to UAT Servers as per the client request.
• Daily / Weekly / Monthly Backup of Production & Non-Production databases.
• Backup, Exporting and Importing small to medium Database from Production to Test.
• Creation of table space, enabling Archive logs.
• Avoiding dynamic space allocation to database objects.
• Responsible for designing the security features of the database like creating Users & Profiles and Assigning roles and privileges to the Users.
• Moving Data between Database using utilities like Export/Import and Transport Table spaces.
• Performing Export and Import of database Objects, loading data via SQL Loader.