SUMMARY

• Senior Oracle DBA wif more than 8 years IT experience in Oracle products on multiple platforms and environments spanning Finance, IT, Insurance, Communication and Tech sectors.
• Experience as On - Call24x7productionDBA support, application/development DBA.
• Extensive noledge on database administration for Oracle 8i, 9i, 10g, 11g and 12C wif experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing.
• Extensive noledge on EXADATA and implemented specific features like Smart scan, HCC, Smart flash log.
• Extensive hands on experience on building 11gr2 RAC databases on EXADATA X5, X2-2 FULL, HALF and QUARTER RACK servers.
• Involved in moving databases in Exadata RAC environment and also Implemented DBFS on Exadata.
• Involved in configuring Exadata X5, X2-2, X2-8 and has a good noledge on smart flash cache, storage index, storage management and migration.
• Installed Oracle 12c database and OEM 12c Cloud control on Linux server.
• Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.
• Setup and configured Oracle enterprise Manager Cloud control 12cand use it as a tool of administration, monitoring and performance tuning.
• Implemented OEM 12c Repository database, Backup strategies using OEM12C, OEM 12c Agent and golden gate plugin Installations.
• Experienced in Installation of High availability RAC environment (2, 3 and 4 node clusters), upgraded standalone databases to 10g/11g/12c RAC environment and adding a node to the cluster database for high availability.
• Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Proficiency wif Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and amend.
• Experience in using Golden Gate in moving large volumes of transactional data, wif minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Extensive experience in Data guard configuration, implementing and monitoring standby databases.
• Implemented FSFO (Fast start failover) on databases and configuring disaster recovery. Also proficient wif new 11g features such as Active Data guard and Snapshot standby database.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Experience in database cloning wif RMAN, Capacity Planning, Database Refresh and patch management.
• Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on Databases, Application Servers and Middle Tiers.
• Extensive experience in configuring and implementing ASM(Automatic Storage Management) and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Extensive noledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulativebackups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Responsible for Loading Data on different databases using SQL*Loader .
• Experience in LOGICAL BACKUPS and Database migration tools wif DATA PUMP, Export/Import and Transportable table spaces.
• Extensive noledge and experience on Data Warehouse using ETL.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively usedTOADfor querying databases etc.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network
• Proficient wif UNIX Shell Scripting, Partitioning, Rebuilding Indexes,Gathering Statistics, ERWIN Data modeling, Logical and Physical database design.
• 24*7 production database support wif Support to developers & end-users.

TECHNICAL SKILLS

Databases: Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i,8i, MYSQL, SQL Server 2008

OracleProducts: Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Golden Gate, Data guard, Import & Export, Data pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, Oracle Fail Safe,RMAN, Transparent Data Encryption.

OperatingSystems: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.x

Languages: SQL, PL/SQL, Unix shells scripting, PostgreSQL 8.0+

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool, DBUA, DBCA, OPATCH, Statspack, DB Verify, SRVCTL, CRSCTL, ASMCMD, ADRCI, SQL Loader.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintainedOracle 11GR24 node RAC on Exadata X5-2 full rack.
• Assisted in management and database administration of Oracle database applications on Exadata X5 and X2platforms.
• Installed, configured and maintained Oracle Database 12c
• Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.
• Plug-in installations on the target servers to extend the functionality of OEM
• Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well).
• Research, Implement, Test and configured various performance tuning methodologies including OLTP compression HCC (Hybrid columnar compression for EXADATA) Exadata Scan query specific - Compress for query high/low Storage Savings specific - Compress for Archive high/low
• Implemented DBFS on EXADATA and Troubleshooting Exadata smart scan/offloading issues.
• Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Migrating databases to Exadata Setting and Monitoring Exadata using OEM12c
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• Implemented Goldengate Unidirectional/Bidirectional replication on RAC using ACFS file system..
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev Databases fromNetApp to HNAS and also to block level storage. (Migrating the databases from Non-ASM to ASM)
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using Datapumps.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPATCHand OPATCH Auto.
• Capacity planning for the projects owned in the environment.
• TEMPEffective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 12c/11g/10gon Unix/Windows, Oracle EXADATA X5, X2, Goldengate, Oracle 11g, Sun SPARC T4-1/T3-1, Red Hat Linux 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, ASM, Performance tuning, OPATCH Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Confidential, Colorado Springs, CO

Sr. Oracle DBA

Responsibilities:

• Extensively worked on GoldenGate implementation like installation, configuration GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11g LINUX.
• Migrated oracle databases using oracle 11g GOLDENGATE.
• Involved in configuring Exadata X2-2, X2-8 and has a good noledge on smart flash cache, storage index, storage management and migration.
• Migrating databases to Oracle Exadata Database Machine for differentclients
• Worked on upgrading of oracle databases from 11g to 12c.
• Installed ORACLE 12c database and Cloud control (12.1.0.3) on Linux 64 bit server.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM.
• Monitoring all the databases using OEM 12c cloud control.
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
• Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Dataguard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configure OEM 12c monitoring wif customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked wif ASMCMD for managing ASM.
• Performed DR drill activity.
• Applying patch set and interim patches using OPATCH for upgrading the binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.
• Installed SQLTXPLAIN (SQLT) Tool dat halps to diagnose SQL statements performing poorly.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle 11g database versions.
• Extensive Experience wif Change Control Management for all database changes.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Data Refresh from Production to Development and Test environments using Data Pump export/import
• Involvement in space management, rectification of lock problems, user management.
• Supporting Application developers wif various performance, connectivity and security related issues on various projects.
• Scheduled Jobs and Backups using 12c OEM and CRONTAB.
• Experience in backups and recovery using RMAN shell Scripts.
• Involved in 24×7 Production Support wif on-call pager.

Environment: Oracle 12C, 11gr2, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Golden Gate, Oracle Exadata, Oracle Fail Safe 3.x, RMAN, EXPDP/IMPDP, Partitioning, ASM, DBFS, Data guard including DGMGRL, Performance tuning, OPATCH Utility, TOAD, DB Artisan, SQL Developer, Shell Scripting.

Confidential, San Diego, California

Sr. Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX, AIX and WINDOWS environments.
• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 nodeRAC and Failover environments.
• Installed 10g & 11g 2 Node RAC &Cluster ware installation on RHEL 5.x server.
• Upgraded oracle database from 11.2.0.2 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1.
• Installed, Configured and Monitored STREAMS and GOLDEN GATE unidirectional replication.
• Extensively worked in setting up physical standby database using Data guard.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using11g ACTIVE DUPLICATION.
• Setup the standby via OEM cloud control 12c for several databases.
• Installation and configuration of GoldenGate on 11g database for the replication.
• Resolving the issues in conflicts between the target and source database in goldengate.
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.
• Daily Health Check Up of the Database and SQL Queries using OEM, Statspack, AWR, ADDM andTKPROF.
• Established standard operating procedures for administering PostgreSQL databases.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.
• Cloned 10g and 11g databases using RMAN duplication (wif and wifout backup).
• UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Handy in utilizing datapump tool for exporting and importing the data between databases.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• ASM Disk storage and user Management.
• Having good exposure in user management, table space management, session management, undo management issues.
• Experience wif remedy ticketing tools for resolving the tickets.
• UNIX shell scripting as and when required based on the requirement
• Provided 24x7 support and On-Call rotation when needed for very large databases.

Environment: Linux, Solaris 10, Hp-Unix,OEM 12c, Oracle 9i,10g,11g,12C, Shell Scripting, OEM, SQL*Plus, PostgreSQL 8.0+,XMing, Putty, Data Pump, RMAN, OPATCH, ASM, Data Guard, Oracle streams, AVAMAR, Golden Gate.

Confidential, Wilmington, DE

Oracle DBA

Responsibilities:

• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging And Training.
• Installed and configured 2 NodeRAC on 10gR2.
• Installed 13 standalone servers on ASM and migrated databases to ASM environment.
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converting Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Implemented Oracle database backup & recovery solutions using RMAN and export/import.
• Restored and Recovery of databases at the times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Created and modified PL/SQL objects like Packages, Stored Procedures and Triggers.
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those.
• Rebuilt indexes for better performance of Oracle database.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Responsible to provide 24 x 7 database administrative activities.

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RHEL, RMAN, DBCA, Data guard, Oracle Enterprise Manager, EXPLAIN PLAN, Export/Import, Cloning, OEM, STATSPACK, TKPROF, Putty, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential

Junior Oracle DBA

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Design Evaluation and Analysis of physical and logicalmodel.
• Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.
• Involved in Schemamanagement, TablespaceManagement, UserCreation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 8i, 9i, 10g.
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and also having experience wif EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience wif recovery managed backups i.e. RMAN.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, Involved in writing UNIXshellscripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using CRONTABfor processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience wif SGA tuning and Histograms understanding and sound noledge in SQL execution plan.
• Tuning Oracle 10g database servers using tools dynamic, dictionaryviews, Statspack, ADDM, AWRDiagnostic and tuningpackages.

Environment: Oracle8i,9i, 10g, Linux, AIX5.1, Hp- UX, Sun Solaris, RMAN, EXPORT/IMPORT, CRONTAB, PL/SQL, Shell Scripting.