SUMMARY

• Senior Oracle DBA with 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 with 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 have 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 gloden 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 teh 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 with Installation and maintenance of replication tool GlodenGate by creating extract process, extract pump, and replicate.
• Implemented Gloden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Gloden Gate issues such as extract, replicate rebuild and amend.
• Experience in using Gloden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Gloden 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 with new 11g features such as Active Data guard and Snapshot standby database.
• Configured Data guard broker between teh primary and standby databases, perform Switchover/Failover and monitor teh 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 with 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 with 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 with UNIX Shell Scripting, Partitioning, Rebuilding Indexes,Gathering Statistics, ERWIN Data modeling, Logical and Physical database design.
• 24*7 production database support with 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, Gloden 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 teh 12c agents on teh target servers and add teh target Configuration Items to monitor.
• Plug-in installations on teh target servers to extend teh 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 teh 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 Glodengate Unidirectional/Bidirectional replication on RAC using ACFS file system..
• Configure Data guard broker between teh primary and standby databases, perform Switchover/Failover and monitor teh Dataguard status
• Storage Migrations: Solely responsible for migrating teh Prod/Test/Dev Databases fromNetApp to HNAS and also to block level storage. (Migrating teh databases from Non-ASM to ASM)
• Backup/Restore & Recover of teh 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 teh binaries by applying patch set and interim patches using OPATCHand OPATCH Auto.
• Capacity planning for teh projects owned in teh 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, Glodengate, 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 GlodenGate 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 have 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 teh 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 with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked with ASMCMD for managing ASM.
• Performed DR drill activity.
• Applying patch set and interim patches using OPATCH for upgrading teh binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical me/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.
• Installed SQLTXPLAIN (SQLT) Tool that helps 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 teh performance of teh 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 with 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 with 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 with on-call pager.

Environment: Oracle 12C, 11gr2, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Gloden 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 teh 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 teh standby via OEM cloud control 12c for several databases.
• Installation and configuration of GlodenGate on 11g database for teh replication.
• Resolving teh issues in conflicts between teh target and source database in glodengate.
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to teh Query.
• Daily Health Check Up of teh 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 (with and without backup).
• UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Handy in utilizing datapump tool for exporting and importing teh 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 with remedy ticketing tools for resolving teh tickets.
• UNIX shell scripting as and when required based on teh 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, Gloden 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 teh 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 teh 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 teh 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 teh 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 teh 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 me.e. Export & import and also having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups me.e. RMAN.
• Migrated teh database from non-Oracle to Oracle me.e. SQL Server to Oracle.
• Documented teh complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, Involved in writing UNIXshellscripting for automating teh 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 with 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.