SUMMARY:

• 10+ Years experience in IT including Production Database Administration and Oracle Database Administration in several environments like Windows, HP - UX, and IBM Advanced Interactive executive (AIX), SUN SOLARIS and RedHat Linux.
• Experience in data replication in the oracle database environment using Golden Gate software.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues
• Measured and implemented availability solutions using Oracle 10g Real Application Clusters (RAC), Standby Database using Oracle Data Guard
• Enough knowledge in monitoring and troubleshooting RAC cluster using Transparent Application failure (TAF), Server control utility (svrctl), and oradebug.
• Skilled in concepts like Performance tuning, backuping database and recovery of database, installing and configuration of database, cloning the database.
• Expertise in Database administration and production support, upgrading the database, Patching, Space management, Database security, Auditing, Troubleshooting any issues, Database design, UNIX shell scripting and documentation.
• Experience in using 11g new features Real Application Testing (RAT) and Database Replay (DB Replay) to validate database performance.
• Experience on Oracle monitoring tool including Oracle Application Server monitoring and Oracle Linux monitoring using SAR and TOP.
• Hadns on experience in installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS .
• Knowing about Migration and Upgrading the Databases in different environments and versions.
• Proficient knowledge in configuring ASM for RAC databases.
• Good experience in implemention and monitoring of Physical Standby Database for Data Guard disaster recovery technique.
• Indepth knowledge in Data Guard Command-line Interface (DGMGRL).
• Heavily worked on Utilities like RMAN, Data Guard, Data Pump, Flash Back and SQL Loader.
• Done backups and tested crash recoveries using hot & cold backups and RMAN.
• Done operations with EXP/IMP, EXPDP/IMPDP to restore the Dev, Test databases.
• Experience in High Availability Concepts like RAC, Oracle streams, Database Cloning.
• Knowledge in SQL, PL/SQL, Data Modeling and desiging of database physically and logically.
• Worked on Proof of Concept (POC) on OEM 12c Cloud, have good knowledge on 12c.
• Expertised in maintaining Oracle large databases (VLDB), ETL, DSS, Data Warehousing and OLTP.
• Exceptional knowledge in DSS/OLPT database systems, implementing and managing large Oracle databases (VLDB) of size 4 TB.
• Did Oracle 11g Active Data guard for Disaster Recovery Solution.
• Well expertise in applying Critical Patch Update (CPU Patches) on Databases.
• Experience in Data transfer between SQL Server and Oracle.
• Skilled in Quest Software to resolve issues with Shareplex.
• Knowing how to maintain of schemas, objects & partitioning the tables & indexes.
• Performance Tuned for Optimized results using SQL-Trace, AWR, TKPROF, and ADDMreports Explain-Plan.
• Experienced the nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.
• Experience in Working DB2, and SyBase on AIX Platforms.
• Expertise in working with Oracle Architecture, Networking, I/O tuning, Memory tuning, Capacity planning, space management, Performance tuning and optimization.
• Experience in Change Data Capture (CDC) in Oracle 9i.
• Schema design experience using ERwin, expert scripting experience in Perl and all UNIX shell scripting variations.
• Performed numerous tasks tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Replication of Oracle Databases using Logical Standby and Shareplex and Streams.
• Well experienced in PL/SQL, Shell Scripting, SQL, Data Modeling, Partitioning, OLAP, and Creation of database logically and physically.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, Perl, HTML, XML, UNIX Shell, Scripting, C, C++.

ETL Tools:: Apache Tomcat, Data modeling, Informatica, Erwin.

Databases: Oracle 12c/11g/10g/9i, MS Access, MS-SQL Server 2000/2005/2008 , OEM 12c Grid Control.

DBA Tools: SQL plus, SQL Loader, RMAN, DBUS, Toad, EXP/IMP, OEM, TKPROF

Platforms: Linux, HP-UX, Windows NT, XP, Sun Solaris, AIX, OS X0/OS2.

NETWORKING: ISO 8583, TCP/IP, LAN, SPI, NFS, DHCP.

Other Tools: Golden Gate EMC, NetApp, Streams.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Oracle DBA Architect

• Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, 9i databases and E-business Suites (11i/R12)
• Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS
• Install and configured MYSQL databases and worked with end user to improve performance.
• Setup and configuration of MYSQL database and migrated MYSQL database to Oracle.
• Migrated SQLServer database to Oracle.
• Upgrade Oracle SAP application database from 10G - 11G and 11.2.0.2 - 11.2.0.3 - 11.2.0.4 and Install and applied SAP Bundle Patch for GI and RDBMS home.
• Build Oracle database environment for SAP application and refresh Oracle database for SAP application and configured backup and monitoring and Moving Weekly/Monthly transports.
• Worked with developers to develop reports.
• Installing Oracle Golden Gate in SQL Server and in Linux.
• Creates Extract/Replicates and moving the trail files from one position to another position.
• Setting up monitoring for oracle Golden Gate.
• Pulling History Loads for extract and pump in oracle Golden Gate.
• Checking for bad data by using Log Dump and alter ER to skip Header and start from exact location
• Setting up the transactional Extraction and transactional Replication
• Troubleshooting the issues related to Extract/Replicates and altering them for exact Relative Byte Address and SEQNO.
• Monitoring and solving Performance Issues like sudden errors of ER by using report file.
• Checking log files and manage the issues
• Classification of data by using timestamp and replicating that data from source to destination.
• Updating the Version of Oracle Golden Gate.
• Knowing the capture of database and unregister and registering that particular ER to that database as a user.
• Solving Golden Gate Errors caused by database like database vaults.
• Migrated databases to Oracle Exadata database Machine for different applications.
• Migrated to Oracle exadata Machine with Dataguard RAC.
• Migrated two node RAC ASM database to Exadata.
• In-depth and working knowledge of Exadata, Smart Scan, Flashcache, Flashlog
• Installed and configured Redhat Linux OS, Oracle Linux OS and Oracle VM and Installed and configured 5 Node 11gR2 on 6 different environments.
• Used OCFS/ASM and RAW devices for RAC.
• Review and provide effort estimate to upgrade Oracle 9i DB to Oracle 11g including 3 D/W databases refresh from PROD DB Server through Perl/Unix shell scripts.
• Designed and executed a plan to upgrade databases to Oracle 11G including standby and Data Warehouse environment for online banking application.
• Upgraded 6TB database from 10G RAC to 11G RAC.
• Partitioned and Reorg objects online using DBMS REDEFINITION
• Migrated Oracle9i RAC Database to Oracle10g, and Migrated Oracle10g to Oracle11G ASM and NON-ASM Single Instance.
• Migrated PeopleSoft CRM from 9i/10G single node to 10G/11G 6 node cluster and migrated the same application 6 nodes to 4 nodes.
• Reorganized 3 TB table from BIG file table to normal tablespace using range partition.
• Tested standby databases using flashback and switchover.
• Supported over 40 production RAC/ASM databases on HP/Solaris/Linux and plus development and testing databases. Participated in planning and implementation of off-site Disaster Recovery planning and testing. Monitor databases for performance and tune accordingly.
• Installation of ORACLE 10G and ORACLE 11G RAC databases, Managed ORACLE 11G databases. Also performed rolling and non-rolling Cluster upgrades
• Performed ORACLE10G CLUSTER upgrade to ORACLE11G CLUSTER.
• Managed over 5 SQL servers 2005.
• Migrated 10G non ASM to ASM database and used Flashback on the standby for testing before the cutover period.
• Restored/Recovered databases using RMAN hot and cold backup.
• Tuned Databases using (v$ tables, STATSPACK,AWR Report, ASH and ADDM Reports)
• Tuned SGA by Tuning Library Cache, Dictionary Cache, and Buffer Cache. Tuned Applications using EXPLAIN PLAN, SQL TRACE and HINTS.
• Tuned numerous long running SQL statements to avoid full table scans and to use indexes & statistics. Improved the performance of many statements from over 1 hour to 3 seconds. Modified statements to use hints and indexes
• Managing tablespaces and performing general system diagnostics, system troubleshooting and resolving problems in oracle database.
• Documented the database system for future references, upgrades of the system. And Making necessary software

Confidential, San Francisco, CA

Oracle DBA

• Experienced in installing and setting up Oracle 10g, 9i, 8i databases.
• Responsible for configuration of 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Controlled migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Responsible for installation and maintenance of Oracle 9I/10g Data Guard.
• Created Standby database setup via Data guard for Database Disaster Recovery.
• Enforced and maintained database constraints to ensure integrity of the database.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Created Physical Standby Database for Active Production Database.
• Validating Databases Backup and Restore periodically and Data refreshes from Production to Non-Production environment.
• Creation of Duplicate Databases using RMAN.
• Done Golden Gate Databases and worked with application team/Development Team in Trobleshooting Issues
• Checking and Reading GSS Error Logs, Alert Logs and User trace Files for any issues to solve.
• Experience with Replication concepts and used Golden Gate Software to do the replication.
• Implemented Oracle Patches (Critical patch updates, Patch set updates) on the adherence databases Device.
• Was involved in developing Disaster Recovery (DR) plan.
• Good knowledge in Perl and all UNIX shell scripting variation.
• Performance tuning for advanced results using Explain-Plan, SQL-Trace and AWR Reports.
• Build and supported 45 RAC Databases with cluster.
• Experience in Oracle OEM Grid Control 10g and OEM.
• Installed and configures DATAGUARD for 23 databases on file-system and ASM in production Environment.
• Created Data Guard using physical standby database, Implemented log miner, Data guard / Standby both physical and logical standby, performed switch/failover and monitored using Data Guard manager command line and GUI.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Writing documentation for RAC Database creation, RAC RDMS installation, Cluster ware installation.
• Experience all kind of DB MONITORING including status and performance.
• Installing ASM environment and transferring database to Non-ASM to ASM.
• Know how to used Logical volume manager (LVM) for configuring local volume.
• Knowledge on Distributed Database Configuration, Creation of Database links and Snapshots using Streams for replication of data.
• Worked with SRVCTL for observing and configuring RAC Environment.

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 8i/9i/10g, RAC, ASM, Dataguard, Streams, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Toad.

Confidential, Woodland Hills, CA

Oracle DBA

• Expertise in high availability solutions using Data Guard and replication using Oracle Streams.
• Participated in installation of 9i/10g RAC on Linux environment with two nodes and ASM storage.
• Interested in implementing and building multi-terabyte databases on RAC.
• Database migrations from 9i -10g and apply patching if necessary.
• Writing Stored Procedures, functions, packages, triggers.
• Communicating with the application team to know the information regarding data migrations.
• Construct Standby Database in manually managed mode, Shell scripts and Cronjobs.
• Experienced with DATA GUARD implementation and point in time recovery.
• Imported data from flat files into databases using SQL loader and External Tables.
• Expertise to check health of database using AWR and STATSPACK.
• Involved in helping customers and developers to troubleshoot server based and database errors.
• Restored and recovered databases using RMAN within SLA.
• Upgrading WebLogic Servers in developing and testing environment.
• Involved in managing Oracle RAC database using Golden Gate and dataguard to ensure max data protection.
• Created and maintained failover logical standby database.
• Created bit-maped indexes for data warehousing databases.
• Worked with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM manager, Diagnose Extents, Segment Advisor and Query Builder.
• Involved in migration of databases from standalone(ASM) to cluster environment.
• Managed and monitored the Oracle Real Application Cluster RAC running on VERITAS storage.
• Writing Audit Scripts to enable the Auditing in all Non-Prod and Prod Databases.

Environment : Oracle 10g RAC, UNIX, Solaris, TOAD, VERITAS, OEM, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, DataGuard, Tivoli Storage Manager, Quest.