SUMMARY:

• Over 12+ years of IT experience in handling Oracle Databases on 10g, 11g, 12c and various platforms like UNIX (HP, AIX, and SOLARIS) and Windows.
• Strong UNIX Shell scripting/programming experience. Used shell scripts/programs to cleanup log files, reporting purposes.
• Implemented Disaster Recovery solutions using data guard in Oracle 11g.
• Strong production Support experience doing hot and cold backups using RMAN as well as manually. I have been a production support DBA for most of the contracts in US. Maintained a replication environment for more than 4 years at different places.
• Experience in installing Oracle 11g Grid Infrastructure with ASM disk both for RAC and Standalone database.
• Experience in installing Oracle 11g Grid Infrastructure with ASM disk both for RAC and Standalone database.
• Good experience in upgrading 10g & 11g R2 database to 12c Pluggable database using Oracle DBUA and/or expdp/impdp method.
• Extensive experience in ASM Storage management such as create ASM disk groupsfrom SAN disks, add/remove ASM disks to existing ASM disk group, drop disk group.
• RAC experience includes working experience in - planning, designing, developing, deploying, maintenance and supporting RAC on RHEL and Oracle Linux.
• Experience with database backup, restore, and disaster recovery procedures such as creating catalog database, Virtual Private Catalog, Hot Backup, RMAN (9i/10g, 11g) full & incremental backup, 10g Data pump (expdp, impdp).
• Installed GoldenGate 11gR2/12c software in Test and production (RAC DB) environment.
• Extensive hands-on experience working in UNIX (Linux, CentOS, Red Hat, HP-Unix, IBM-AIX) environment and with UNIX Shell Scripting.
• Experience in Administration activities such Installation, Configuration, Client/server connectivity, Creating and Managing Repositories, Users, User Groups, Folders, User Roles, Profiles and Privileges.
• Worked on Database monitoring / performance / diagnostics via dictionary views and cloud control.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (withExport/Import).
• Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)
• Worked on Oracle Flashback / Flash Recovery Area (FRA)
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, Data Pump,tablespace, and extents fragmentation.
• Worked on Automated Storage Management (ASM) for 10g/11g databases.
• Worked on much performance tuning including SQL tuning and instance tuning.
• Experience in setting up Grid Control and 12c Cloud Control.
• Experience in Setting up Materialize View Server.
• Worked on Table space/Extent/Segment Management
• Setup Oracle Enterprise Manager (OEM) and worked on 12c cloud control.
• Provided On-call support on 24/7 basis.
• Have written shell scripts to automate database management tasks.
• Pose strong administrative skills in RHEL.
• Worked on Migration & Upgrade project
• Extensive knowledge of Oracle functionality & internals. Good consulting and communication skills, knowledge of client-relationship building techniques and project methodologies with good team building skills.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.

PROFESSIONAL EXPERIENCE:

Confidential, Phila, PA

Oracle Cloud DBA

Responsibilities:

• Implemented Data Guard - creating 2 Standby Databases on production environment.
• Installation of various plugins supporting Golden Gate, Exadata Machine and Agents
• Configure and support Exa-data and clustered Linux servers (RHEL and OEL) to host Oracle 11g and 12cRAC technology stack supporting both OLTP and DSS (data mart/data warehouse) databases.
• Responsible for 24x7 on-call support.
• Done Installation and configuration of Golden Gate on 12c database for the replication.
• Resolving the conflicts between the target and source database and Implemented Bi-Directional replication in golden gate.
• Upgrading GoldenGate from 11g to 12c and Expertise on Oracle Golden Gate and be able to configure Golden Gate.
• Migration of databases.
• Administration and support of Oracle RAC database, Data Guard.
• Work with Oracle Support for managing critical database issues.
• Acquired familiarity with Agile methodologies.
• Migration of 2-4 TB Databaselevel from non -Exadata to Exadata environment.
• Weekly data refreshes using data pump and RMAN from Production to UAT / BUAT.
• Write PL/SQL procedures that will handle the conversion task from legacy system to target system
• Fine tune PL/SQL procedures and SQL queries.
• Data loaded from legacy systems using PL/SQLand SQL*Loader.
• Used Toad for creatingPL/SQL (trigger, sequence, stored procedure)
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Created Packages, Procedures, Functions, Triggers, Cursors usingPL/SQL in UNIX and Windows environment.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance andWell Experienced in taking Cold Backup for a very Huge 64-Tb Database.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups usingRMAN.
• Experienced with troubleshooting the failed backups by working closely with TSM and NetBackup Support.
• Applied Patches to 11g and 12g and used datapatch to upgrade 12c databases
• Kept team members and management updated on major issues so they have a clear picture of situation.

Environment: Oracle 10g/11gR2/12C, Linux 6.3, Oracle Enterprise Manager, Grid Control, OEM Cloudcontrol, PL/SQL, Shell Scripting, TOAD, ASM, RAC, Golden Gate, Data Guard, RMAN, Data pump, Exadata

Confidential, Charlotte, NC

Oracle Cloud DBA

Responsibilities:

• Installed and configured 12c multitenant databases on Red Hat Enterprise Linux.
• Implemented and Worked on 13c oracle enterprise manager High Availability Architecture for monitoring Time critical oracle database (11g/12c).
• Configured Data Guard (physical standby) for Enterprise Manager Repository Database for High Availability Architecture.
• Designed and implemented Active/Passive model for Oracle Enterprise Manager High Availability Architecture with minimum down time.
• Upgraded Databases from 12.1.0.2 to 12.2.0.1 in production, test and development environments.
• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Involved in developing interactive forms and customization of screens using OracleForms.
• Diagnosed and reduced Enterprise manager startup time from 15mins to 5mins.
• Migrated 12.1 Enterprise Manager Repository database from a non-container database (non CDB) to a 12.2 pluggable database (PDB) and worked on TCP Invited node setting for restriction connections. monitoring oracle database from OEM and Deploying management Agents on to Target servers.
• Upgraded Enterprise manager 13.1 to 13.2 in production, Test and Development environments.
• Experience in applying patches for both oracle databases and critical Enterprise Manager components like OMS system, Plugins and Agent system patches and Agent plugin patches.
• Experience in refreshing of databases using Datapump utilities expdp/impdp.
• Created oracle wallets and imported Third party user and root certificates into the oracle wallet.
• Created and troubleshooted TCPS and TCP with ASO listeners with Third party certificates usingoracle wallets related to enterprise manager connectivity.
• Performed Management Agent upgrades from 13.1 to 13.2
• Relocation of Enterprise Manager Agents Targets in a clustered environment.
• Experience in offline patching of databases and the management agent using offline catalogwhen OEM is not connected to oracle support.
• Performed PSU verifications and created custom database related jobs from oracle enterprise manager.
• Experience in using OEM components like Performance home page, Top activity, ASH report, AWR reporting and SQL worksheet for proactive monitoring of oracle databases.
• Configured database using RMAN utility for level 0 and level 1 cumulative backups.
• Deployed and secured Oracle Management Agents on target servers for host level and database monitoring.
• Created custom script for retrieving all the list of incidents from Enterprise Manager Repository Database.
• Cloned databases using RMAN Utility.
• Performed remote clone of oracle multitenant databases using Database link.
• Implemented backup/recover strategies using RMAN and Export/Import utilities and wrote Shell Scripting, cronjob entries for managing day-to-day activities and automation of backup.
• Excellent Knowledge on Data Guard Broker configured TCPS listeners using oracle wallets forData Guard connectivity

Environment: Teradata V13.10/V12, SQL Programming, UNIX Shell scripts, BTEQ, Fastload, Multiload, Informatica 9.0.1 with Hotfix 1, Datastage 7.5, SQL assistant, Teradata Manager

Confidential, North Brunswick, NJ

Sr.Oracle DBA

Responsibilities:

• Migration of databases from 11g to 12c using data pump export/import utilities.
• Installed Oracle DB 12c RDBMS, RAC on ASM, Applying Oracle patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning.
• Involvedin Implementation of Oracle Grid Control12C - Installation and Configuration of 3 OMSs for Software Load balancer and 3 node RAC OEM Repository.
• Converted single Instance Databases to RAC databasesManually and expertise in troubleshooting RAC issues, very strong in using ocrconfig to backup OCR and Voting files.
• Performed health checks of Real Application Cluster instances using Crsctl and Srvctl utility and troubleshooting RAC using clusterware logs.
• Extensive use of Explain Plan, autotrace, Tkprof, Statspack, ASH, AWR, TOAD.
• Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions.
• Data extraction and load using materialized views.
• Creating PowerShell scripts for database monitoring like database and tables growth, index fragmentation, deadlock, CPU, I/O and memory.
• Creating database reports and generating adhoc data requests for management.
• Database Backup and Disaster Recovery for Azure databases.
• Troubleshooting all Oracle Apps Issues like Forms, Apache and CM.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Supporting the databases for different applications like noetix, fog light.
• Written Shell scripts to move the Tables from one instance to another instance using Import/Export.
• On-call support for Oracle ERP Applications and databases.
• Attended Oracle Conferences and had knowledge about Oracle Future technologies 18c databases.
• Database management by creating schemas, tablespaces, partitions, indexes and coding inPL/SQL and T-SQL packages, procedures, functions and triggers.
• Designed and implemented replication solution using GoldenGate.
• Responsible for user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Experience in troubleshooting expdp/impdp errors in a RAC environment.
• Refreshing of databases using Datapump utilities expdp/impdp.
• Experienced in Installing OEM agent and hooking up to the grid and Used OEM grid for monitoring the Listeners present in the oracle environment.
• Database support of Oracle and SQL Server databases.
• Manage SQL Server databases, Blobs on Azure platform using Azure portal and storage explorer.
• Identifying bottleneck SQL in production databases proactively based on Database reports (AWR,ADDM) considering various statistics for SQL and providing tuning suggestions proactively.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.
• Implemented backup/recover strategies using RMAN and Export/Import utilities and wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Experience ensuring the high availability, integrity of databases & database designing. performedcross platform migration using Export/Import from Sun Solaris to Linux server.
• Configured RMAN forincrementalbackups and weekly cumulativebackups.

Environment: Teradata V15, V14.10, SQL Programming, UNIX Shell scripts, BTEQ, Fastload, Multiload, SQL assistant, Teradata Manager.

Confidential, Austin, TX

Oracle Cloud DBA

Responsibilities:

• Involved in configuring Exadata X5-2, X5-8 and having hands on the smart flash cache, storage index, storage management and migration.
• Worked on ExadataDatabaseMachine X2-2 Half Rack, X3-2..
• Extensive experience in RMAN recovery in RAC and standalone database.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Delivered training to other DBAs in Oracle RAC, Backup/Recovery, Oracle GoldenGate, Performance Tuning and general database administration tasks.
• Performed Tuning, coding and Monitoring for OracleReal Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Performance tuning and optimized the knowledge modules to improve the functionality of the process and worked on Cluster ware troubleshooting, CRS-ERRORS, CRS-4639, CRS-4530 and CRS-4535 and wait events in RAC environment.
• Worked extensively on monitoring 10G/11g/12c grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Installing OracleGoldenGate on RHEL and setup table level replication as well as DDLreplication too.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.
• Troubleshooting GoldenGate issues with error reports and ggserror.log.
• Developed Shellscripts for monitoring Goldengate processes and their stats running on 60+ servers from one single database repository and thus maintain history of all Goldengate processes.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Zero Downtime DatabaseData Center Migration using Goldengate and Datagaurd.
• Monitored Dataguard status periodically and Maintained DRserver and troubleshooting issues in Data Guard environment.
• Killed Blocking sessions on oracle databases and monitoring Alert logs and Applying shipped archived logs to standby databases on using MRP process.
• We successfully switched over databases to secondary databases during DR testing using Dataguard broker and Configured Dataguard broker.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups and Scheduling the databases backup using Crontab and VERITAS net backup.
• Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching.
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.

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, Portland, OR

Oracle DBA

Responsibilities:

• Migrated oracle databases using oracle11g GOLDENGATE.
• Worked on upgrading of oracle databases from 11g to 12c.
• Installed ORACLE 12c database and Cloudcontrol (12.1.0.3) on Linux64-bit server.
• Implemented OEMCloudControl 12c Agent installations, plug-ins installations and adding targets to OEM.
• Installed and implemented 11gR2 3 node RAC with Data guard (DG) broker.
• Installed and configured of 11gR2 RAC with ASM and RawDevices.
• Configured 11gR2 RAC Data Guard for mission critical production systems andmanaged using Dataguard broker.
• Installed 12C cloud control and Used Oracle Enterprise Manager Grid control 11gfor monitoring databases.
• Expertise in Oracle Enterprise Manager Cloud Control 12c/13c.
• Expertise in managing oracle 12c Multitenant databases and good working experience with using advanced features of 12c.
• Experience in using the Oracle Cloud Control (OEM 13c) features like Snap Cloning (using Test Master Snapshot), Orachk Integration.
• Monitoring all the databases using OEM 12c cloud control.
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
• Extensively worked on GoldenGate implementation like installation, configuration GOLDENGATEunidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11gLINUX.
• 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 OEM12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASMMetadatacorruption.
• 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.

Environment: Oracle 11gR2/12CR1/12CR2, Red Hat Enterprise Linux 7, HP-UX, Solaris 10, Oracle Enterprise Manager 13.1/13.2, Grid Control, PL/SQL, Shell Scripting, Data Guard, RMAN, Data pump, TCPS listeners, oracle wallets, DBLINK, web logic server, oracle management agents

Confidential, Piscataway, NJ

Oracle Cloud DBA

Responsibilities:

• Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
• Installation of Application Instances and configuring them according to the client's requirements
• Configure the following modules: HRMS family, GL, AP, AR, FA, OM, INV, Supplychain & iprocurement.
• Upgrade of Oracle Application from 11.5.10.2 to 12.1.1.
• Troubleshoot various HRMS and Oracle Financial module issues and resolve the issues.
• Involved as a team lead with a team of 13 Oracle Apps dba's.
• Upgrade of Oracle database from 10.2.0.4 to 10.2.0.5 versions.
• Following up with Oracle support on software related issues, create TARs and TAR Tracking
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the Oracle PL/SQLscripts to Production.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTABand invoking the procedures through shell scripts.
• Involved in implementing bug fixes and enhancements within packages, forms, and reports.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Responsible for preparing user manuals and quick reference guides..

Environment : SAS programming, SAS MACROS , Oracle, SQL, SDTM, RTF, HTML, SAS.

Confidential, Saint Louis, MO

Oracle Cloud DBA

Responsibilities:

• Vertex installation, upgradation, hrglobal administration
• Cloned the Application Instances as per functional and technical requests using the Autoconfig and build the Context.xml file.
• Registering the Custom Applications, installing the Custom Docs into Oracle Application.
• Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.
• System Administration tasks also includes creating and defining the concurrent programs and executables.
• Applying Patches as per Oracle support to troubleshoot various errors.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Administering and maintaining Production Apps R12 instances.
• Advanced configurations - Load Balancer, PCP with RAC.
• Patching using adop and adpatch.
• Cloning of Oracle Apps Databases ( 11i, R12.1.x and R12.2.x ).
• Cloning of 12.2.4 Applications on multi node.
• SSO, OID and OAM configuration for EBS.
• Installation, configuration and managing Fusion Middleware components Oracle SOA, HTTP server and web logic.

Environment: Linux, Windows, Oracle 9i, Developer Forms 6i & Reports 6i