PROFESSIONAL SUMMARY:

• Senior Oracle DBA with 7 years IT experience in Oracle products on multiple platforms and environments spanning Finance, IT, Insurance, Communication and Tech sectors.
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge 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 hands on experience on building 11gr2, 12C RAC databases.
• 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 plug-in 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 with Oracle 12c CDB/PDB architecture and setup experience in High Availability environments using RAC with ASM.
• Oracle 12c Data guard experience with Oracle 12c CDB with multiple instances and using ASM
• 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 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 Linux, Solaris, IBM AIX and debugging Golden Gate issues.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.
• Migrated databases from Non Exadata to Exadata Machines using GoldenGate with minimal downtime.
• 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 the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.
• 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 knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable table spaces.
• Extensive knowledge and experience on Data Warehouse using ETL.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD for 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

Oracle Products: 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.

Operating Systems: 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 - Dublin, OH

Oracle DBA

Responsibilities:

• Planning and configuring near Zero downtime database migration and Upgrade of Oracle databases leveraging Golden Gate 11g and 12C.
• Design and implement Active to Active and Active to Passive Golden Gate replication.
• Upgraded GoldenGate to 12.1.0.2 from lower versions.
• Built more than 70 Oracle 11g/12c Databases on Linux (Standalone, RAC, CDB’s and PDB’s)
• Implemented advanced security using TDE (Transparent Data Encryption).
• Involved in cross platform migration of 15TB heavy transactional Oracle database from Solaris (11.1.0.7) to Linux (12c) using Oracle GoldenGate.
• Install, configure and administer OEM 13c.
• Migrated more than 70 Oracle databases between different Datacenters using GoldenGate, Active Data Guard, Transportable tablespaces and RMAN.
• Upgraded 11.2.0.4 databases to 12c using manual upgrade and DBUA.
• Configuration and Implementation of Data Guard Physical / Logical Standby Databases and Automating the Monitoring / Resolving on and off Gap or lagging issues.
• Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic shared memory management (ASMM), ASH and Buffer Cache Advisors.
• Fabricated multiple CLONING databases using manual method and RMAN utility
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data guard, Oracle Advanced Replication, Real Application Clusters.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 11g/12c, CDB&PDB, Oracle Enterprise Manager 12C, GoldenGate 11g/12C, GoldenGate Veridata, TDE, Active Data Guard, RMAN, Expdp/Impdp, DBUA, Transportable tablespaces.

Confidential - Berkeley Heights, NJ

Oracle DBA

Responsibilities:

• 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).
• Implemented Golden gate 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 Data Guard status
• 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 Data Pumps.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPATCH and OPATCH Auto.
• Capacity planning for the projects owned in the environment.

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

Confidential - St Louis, MO

Oracle DBA

Responsibilities:

• 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 Data Guard 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.
• 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 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 the performance of the database.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Supporting Application developers with various performance, connectivity and security related issues on various projects.
• Scheduled Jobs and Backups using 12c OEM and CRONTAB.
• 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, 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, CA

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 nodes and 3 node RAC 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.
• Installation and configuration of GoldenGate on 11g database for the replication.
• Worked in setting up physical standby database and 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.
• 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 and TKPROF.
• 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).
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
• 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, tablespace management, session management and user management issues.
• 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.