OBJECTIVE

• To make my IT experience and database administration skills effectively utilized and contribute them to the growth of the organization.

SUMMARY

• 8+ plus years of experience in Oracle 11g,10g,9i,8i Database Administration in Production, Test and Cluster Server environment.
• Experienced in Installation, configuration and performing upgrades of Oracle RDBMS environments on various platforms (LINUX, AIX, SUN SOLARIS etc).
• Experienced in configuration and troubleshooting of Oracle Golden Gate for initial load and Transactional change data capturing.
• Experienced in configuration of Datapump with extract process and configuring bi - directional extract and replicat processes in Golden Gate.
• Experienced in capacity planning and creating Database Storage Structures.
• Maintained Databases by evaluating high availability options and disaster recovery plans implementing Oracle RAC and Data Guard according to business requirements.
• Experienced in Installation and Configuration of Oracle ASM for RAC and NON-RAC Environments.
• Configured the physical & logical standby databases with different protection modes using sqlplus & RMAN.
• Implemented Security at database level, user level and the data level using Auditing and Protegrity.
• Established Backup policy using RMAN and Network backups. Also managed Backup, Restore using Data Pump, Traditional Export and Import and Recoveries using RMAN and conventional UNIX shell scripts.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Used Automatic workload repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Statspack Reports for trouble shooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Collections of performance data for specific time range using STATSPACK.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Configured Monitoring of Oracle Databases through OEM.
• Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Experienced in database reorganization regularly for removing row migrations and fragmentation using export and import utilities. Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.
• Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility
• Skilled in monitoring Oracle Database using DB Artisan, Toad and OEM, to minimize the performance problems.
• Expert in providing the full database dumps and schema level dumps to DEV database environments.
• Prepared documents detailing various database design and maintenance procedures.

TECHNICAL SKILLS

Databases Skills: Oracle 8i/9i/10g/11gR2, SQL, PL/SQL, Backup planning and Implementation, Performance Monitoring, Analysis and Tuning, Install, Patch and Upgrade, Disaster Recovery planning and implementation, Partitioning, Replication.

Database Advance Feature: RAC, Data Guard, ASM, Standby Database, Oracle GoldenGate, Advanced Replication/ Materialized View, Grid Control.

Oracle Utility: RMAN, OEM, Export/Import, Data Pump, SQL*Loader, DBVerify, DGMGRL, ASMCMD and DB Artisan, Golden Gate Director.

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Responsibilities:

• Managing the physical standby database 9i/10g.
• Rebuilding the Standby database and reconfigure standby database.
• Troubleshooting switchover hang/fails & failover scenarios - including single instance.
• Performed Switchover and Failover.
• Analyzing diag collection scripts to see archive gap, log transport services, current online redo log thread and sequence number.
• Manually determining & resolving archive gap.
• Managing the VERITAS Flash Snap of the Database. If it Fails Performing the Manual Recover of the Database if require.
• Performing regular health check of the database.
• Managing the RMAN Backup & Cold Backup.
• Interacting with Veritas Net Backup Team & TSM TEAM, When there is Backup issue on the database server.
• Analyze the Database Growth Report and Checking File system usage for feature growth(Asking for Additional Disk space ).
• Installation and Applying Patch if requires.
• Analyze the Tablespace Growth Report. As per the Report adding datafile to the tablespace(creating the tablespace and adding the new datafile to tablespace).
• Creating Application ID's and Schema Id's for the new deployed applications
• Managing the Profiles and Roles.
• Interacting with other teams (Application ) frequently in order to resolve different issues .
• Generating the Awr Report (Working on the issue).

Confidential - NY

Responsibilities:

• Installation and configuration of Oracle Server software 10.2.0.3.0 on Sun Fire 240/440/480 servers for Global Astra, Horizon and H fund Systems.
• Involved in development of Global Astra, Horizon and H fund application.
• Deployed Global Astra, Horizon and H fund applications to the QA, UAT and Production.
• Migrated Oracle Databases from 9.2.0.6 to 10.2.0.3.0.
• Managed DR database sites using SRDF synchronization.
• Performed Database Refresh from Production to QA, UAT, INT and Development databases.
• Implemented CSSCAN for Database Character Health check.
• Migrated database character set from US7ASCII to UTF8.
• Designed and implemented Audit rules for Database to meet the Security specifications of GIA.
• Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts.
• Worked with External Tables and Partitioned some of the large database tables.
• Tuned OLTP and DSS type queries, explain plans for developers, and reorganized tables and indexes.
• Performance tuning involving Memory, and SQL tuning.
• Migrated Disk backups to Net Backups.
• Implemented Autosys for all new servers, deployed jil scripts for day to day activity and End of the day jobs.
• Active member of the 24/7 on-call team.
• Implemented the database tuning to improve the performance of the database using the Perfstat package.

Environment: Oracle 10g/9i/8i/8.x.x, Oracle 10gR2 Real Application Clusters, 10g Application Server, Oracle Fail Safe Manager, 3.3.2, Oracle Designer2000, People soft, 8.20.03, OEM, OAM, Oracle Data guard, CSSCAN utility, Oracle Universal Installer, Oracle Configuration Assistant, BMC patrol, Power Builder, Forms 6i, PL/SQL, Unix Shell scripting, RMAN, SQL*Loader, Quest tools, Rapid SQL, Perl, Sun Solaris 9, HP-UX 11.11, Windows NT, Windows 2000 server and AIX 4.3/5.0l. Hardware: Sun Fire 240/440/480.

Confidential, CA

Responsibilities:

• Directed the DST Change project for the DBA team. Defined the strategy to role out the patch. Build the project team, coordinated the efforts with peer management such as application team management, SA management and the business management.
• The challenge is to role out the Oracle Patches on over 1700 database / SQL NET client servers completed 100% of the work in matter of weeks
• Directed the design and managed the project to build robust infrastructure architecture for RMAN catalog databases, which is used by 150 Oracle production databases.
• Documented the catalog database usage strategy
• Prepared and presented the DBMS roadmap, Standard Stack to 15 internal Business partners via a Brown Bag Event
• Oversaw and directed the Oracle 10g database migration project and migrated 40% of the total ~ 500 databases to the new stack.
• Directed the 10g Grid Control implementation project to manage, administer, monitor and tune Oracle databases.
• Turned the reactive management infrastructure into a proactive infrastructure. Overall result more stable systems and customer satisfaction
• Attended the technical presentations/demonstrations from the vendors, evaluated the vendor products against the business needs and recommended the most efficient & cost effective solution. E.g. Oracle Streams Implementation for the replication needs, Quest Share Plex for the critical Migration project & Oracle Enterprise Manager for Infrastructure etc.
• Installed and certified Oracle 10g R2 RAC on Linux/Solaris operating system using VERITAS (/Symantec’s) SFRAC 4/x or 5.x
• Prepared a step by step installation document for the 10g RAC on Linux operating system using SFRAC
• Designed, Engineered and Implemented the Oracle HIGH AVAILABILITY databases using Data guard and Oracle 10g / 9i RAC databases for various applications such as DW / OLTP on RHEL 4.0, 64-bit and Solaris 2.9 OS
• Performed the capacity planning for the databases and added nodes to the RAC databases to make the a 2 node RAC database a 4 node RAC database to accommodate the growing needs
• Defined and maintained the standards for databases, encouraged team to maintain them.
• Maintained the databases ranging from few GB up to 7 TB in size
• Evaluated various tools for monitoring and administration tools and deployed Oracle 10g Grid Control
• Evaluated Oracle database new features, industrializing them as per the business needs.
• Proactively monitored the databases using tools and scripts.
• Resolved any issues related to oracle by seeking Oracle support by creating SR as and when required.
• 7x24 nature Support for 150+ Oracle Production Databases
• Documenting the database usage, features and other tasks to simplify the process ease of maintenance.
• Supporting over 500 Oracle Database sizing from few GBs to 7 Terra Bytes in various environments
• Configured Oracle Streams between an Oracle 9i RAC and Oracle 10g RAC database to share the data
• Maintained the internal website for the documentation and guidelines for the DBA Team

Environment: Solaris 2.x, AIX 4.0, Oracle 10g, 9i, 8i OEM, SQL BackTrack, Data Guard, RMAN

Confidential, San Diego CA

Responsibilities:

• Defining the system and Network architecture for implementing the ERP Systems.
• Installing and upgrading of the Oracle 9i/8i/7.x release on the Solaris 2.x HP-UX 11.0 / HP-UX 10.20 operating systems.
• Physical and Logical designing of the databases.
• Creating the databases for various applications such as ERP, OLTP and DSS applications.
• Installing of Oracle Applications 11.5.x (Release 11i.) in the Single node and multi node architecture using Rapidwiz on Sun Platform.
• Defined and implemented the backup strategies for the databases.
• Tested, configured and demonstrated the Oracle hot stand by database and Oracle Data Guard.
• Checking for required patches on Metalink and applying required patch sets using adpatch.
• Using Adpatch, adadmin, adctrl, adrelink etc. utilities to maintain & administer Oracle Applications.
• Managing concurrent processing.
• Managing and administering the Forms, Reports, HTTP (Apache) Servers and Concurrent Managers.
• Configuring OEM2.x to monitor Oracle Applications 11i,Oracle 9i9iAS and other Oracle Databases
• Creating / configuring the Hot Stand By Database in Oracle 8.1.7 And used Oracle Data Guard.
• Migrating of the databases from 7.3.4 to 8.1.6 or 8.x to 9.0.1
• Replicating data using Quest’s Share Plex 2.1
• Defining the backup strategy and implementing scripts to hot / cold backup and export of the databases through a cron job on the disk.
• Using the system performance management tools such as GPM (Glance Plus) for checking the bottlenecks at the system level during the performance tuning.
• Communicating with Oracle Tech Support.

Environment: Solaris 2.5/ 2.6, HP 9000 HP-UX 10.20/11.0 Oracle Applications Release 11i, Oracle 9i,8i, 8.x, 7.x, OEM 2.x, SQL*PLUS, SQL*Net, Oracle 9iAS, Quest Share Plex2.1

Confidential

Responsibilities:

• Installation issues eg. Root.sh has not executed successfully on 2 node and patching issues, vipca fails.
• Recreating the OCR and Vote Disk If in the case OCR and Vote Disk lost and no backup of OCR and Vote disk is available.
• Recreating the new OCR location with the help of OCR Auto Backup if Required.
• Doing the RCA(Root Cause Analysis) for Node Eviction(ORA-29740) also for CRS reboots & other issues.
• Troubleshooting RAC startups, crashes, evictions, reboots, corruptions, failover & failback of VIP.
• Handling OUI reports errors VIPCA is not a public interface.
• Locating & Using the log files for CRS,RAC & Data Guard.
• Executing cluvfy pre-checks & post-checks after performing CRS & Database Software Installation.
• Installation propagation problems. Enable tracing for OUI & checking which IP is used for copying the binaries from one to another node.
• Adding/Deleting Nodes using dbca or manually.
• Troulbeshooting on why the CRS has not started resources as on when reboots.
• Enabling tracing for srvctl PRK* using SRVM TRACE(10g) if the srvctl commands did not work & analyzing the traces.
• Stopping CRS reboot loops when CRS problem occurs.
• Used different crs*, ocrconfig,crsctl comamnds as on when needed.
• Generating ocrdump & check the ocrlog file to see ocr keys corrupted or not.

Environment: Oracle 7.1,7.3 Hardware: Sun servers/ Solaris 2.5/2.6