PROFESSIONAL SUMMARY:

• 8 years of Oracle DBA IT experience managing products Oracle 8i/9i/10g/11g/12c in Production, Test & Development environments.
• Installed and maintenance of ORACLE 11g RAC 2 node cluster database for high availability
• Experience in very large scale database environment and mission critical OLTP and OLAP systems
• Experience in configuring, managing and monitoring ASM for standalone database and RAC database.
• Experience in Korn Shell scripting. Expertise in Alert Monitoring and Ticketing.
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red hat Linux and Windows servers.
• Extensive experience In SiebelAdministration, Root Cause Analysis and trouble shooting.
• Monitoring and scheduling jobs for all teh databases using latest OEM 12c cloud control
• Expertise in SQL and PL/SQL programming.
• Experience working with Exadata/Non Exadata servers.
• Expertise in Administration and scheduling jobs in Control-M Enterprise Manager versions 6.3, 6.4, 7.0 and 8.0.
• Experience in Social Enterprise Management such as Curam Framework.
• Exadata Administration, which includes Implementation, migration of DBs, Monitoring and Troubleshooting, Storage Management, Infiniband Switch, CellCLIand DCLI commands
• Experience in upgrading Database using DBUA, Manual Upgrade and export/Import
• Good understanding in Data Marts and data warehousing concepts (OLTP &OLAP).
• Experience working with Oracle Streams and Change Data Capture (CDC).
• Installed oracle 12c databases and 12c cloud control on Linux Server.
• Managing CONTROL-M Servers/agents using CONTROL-M/Configuration Manager
• Experience in installation and configuration of oracle Log miner.
• Working experience in implementing Oracle RAC and Data Guard on Windows 2012
• Worked on teh physical and logicaldesigning of teh database
• Administrated database of various sizes ranging from 40GB to 3TB.
• Experience in Design, Creating and Maintaining teh Oracle Database.
• Experience in Performance SQL Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL developer, PL/SQL developer, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, AWR, ASH, ADDM Reports
• Experience in Online and Offline backups and recovery.
• Coded SQL/PL-SQL, SQL* Loader and Korn Shell scripts for high volume data warehouse instances.
• Experience in JBoss and SVN
• Experience in constructing teh triggers, tables, collections, functions, user defined data type, procedures etc.
• Working Experience with Perl environment
• Installed ODI. Set up teh ODI connection with Oracle, flat files.
• Experience in backups and recovery using RMAN and Scripts.
• Experience in using RMAN with and without Catalog database.
• Configuring a flash cache in an Oracle Real Application Clusters environment.
• Experience working with data pump to move data from prod to Dev & test environments
• Taking Physical & Logical backups using RMAN and Data pump utilities
• Proficient in Oracle utilities and tools (Export, Import, SQL*loader, PL/SQL, OEM, TOAD, SQL Developer).
• Expertise in Database control as well as Grid control.
• Provided Oracle DBA support, backup and restore, performance monitoring and SQL tuning; Experience of using Oracle Enterprise Manager (OEM), Grid Control, and Data Guard.
• Worked as a part of team in 24x7 production environment and provided on-call day-to-day support.

TECHNICAL SKILLS

Operating Systems: Windows2003/2007/2008/XP/VISTA, Linux, UNIX, Solaris, IBM-AIX,HP, RHEL ES/AS/4/5

Database: Oracle 9i/10g/11g/12c, MS Server 2008/2012/2014 and Enterprise DB

Programming languages: SQL and Oracle PL/SQL.

Database Tools: PL/SQL Developer,DB2, PgAdmin, SQL*Plus, TOAD, OEM, Microsoft Visual Source Safe, SVN, Putty, WinScp, SQL Loader, Oracle Gloden Gate Repository database

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump, RMAN, TKPROF, pg dump

Web Technologies: PSP (PL/SQL Server Pages), HTML

Script Languages: UNIX, Korn Shell Scripting, Perl Scripting

Others: Oracle Data Integrator (ETL Tool), MS Visio, Alfresco, Life ray, Object Oriented Designing Methodology, RDBMS Concepts.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Burbank, CA

Responsibilities:

• Installed Configured and maintained 2 node 11.2.0.3/12c RAC databases in Linux/Solaris Server.
• Configured oracle Active-Active (Bi-directional) gloden gate replication and setup CDR.
• Upgraded oracle gloden gate from 11.2.1.0.3 to 11.2.1.0.25 version.
• Sending oracle Gloden gate Trail files from Linux to AIX server for reporting purpose
• Involved in teh Migration projects by using Data pump and RMAN utilities.
• Configured CDC Process to has minimal performance impact on source database.
• Performing Transition activities for Non-Mainframe DB2Database Servers and basic administration activities of Oracle database.
• Server system Admin - release deployments, Patch apply (Siebel8.1.1.10) for IE8 compatibility
• Implemented CDC Process to capture all TEMPeffects of insert, update, and delete operations including data values before and after update operations.
• Installation, Configuration & Deployment ofOracle E- Business Suite 11i/R12.
• Applying CPU and PSU patches for all teh development and UAT servers when required
• Configured 11g Physical standby RAC databases.
• Worked efficiently on OLAPData Warehouse, Design, Model and Implementation.
• Excellent experience in using Data pump utility for refreshing databases
• Involved in setting up and supporting Gloden gate replication on databases with RAC and data guard on oracle EXADATA Database machines.
• Involved in setting up and supporting Gloden gate replication on databases with RAC and data guard on oracle EXADATA Database machines.
• Assessment and calculate Resource consumption of Non-Exadatato Migrate on ExadataPlatform.
• Configure Exadataspecific Dataguard parameters to Avoid Block corruptions.
• Export / Import Baseline and statistics from Non-Exadatato Exadata.
• Exadata Administration, which includes Implementation, migration of DBs, Monitoring and Troubleshooting, Storage Management, Infiniband Switch, CellCLIand DCLI commands
• Understanding teh OLAPprocessing for changing and maintaining teh Warehousing, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Implemented Oracle RAC and Data Guard on Windows 2012.
• Monitoring and managing more TEMPthan 12,000 jobs running in six different Control-M Servers
• Involved in teh migration of huge databases of sizes ranging from 100GB to 7TB
• Experience in Migration from NON-ASM databases to ASM database.
• Coordinating with Unix/Wintel team while performing activities related to Control-M
• Installed of log miner procedures to capture teh database transactions.
• Performed Troubleshooting of database using AWR and ADDM reports for 11g databases.
• Configured RMAN backup jobs for newly built databases.
• Upgraded oracle Grid Control 11g to Oracle Enterprise Manager 12c.
• Installed Gloden Gate server 11.2.1.0.6 and in implementation of GG initial-loads, Uni-directional replication.
• Building new databases and schemas from teh scratch for new projects/application on Linux and UNIX boxes.
• Expert in transforming complex business logic into Database Design
• Worked on teh physical and logical designing of teh database, which includes teh distribution of data- files on different disks
• Cloned databases and schemas using data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN Duplication.
• Worked on Gloden gate to setup unidirectional replication on 4 node RAC database.
• Worked with Oracle Support and performed root cause analysis for critical issues.
• Worked on multiple projects and delivering projects within timeline.
• Supported Perl Oracle Web UI for customer account representatives.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle11.2.0.3/12c,RHEL 4.x, Solaris 10,Window 2008, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Db2,Korn Shell Scripting, Stored Procedures, OLAP, ASM, Data guard.

Oracle DBA

Confidential

Responsibilities:

• Experience in Design, Creating and maintaining Oracle Databases 10g and 11g from teh scratch on UNIX, LINUX, AIX and WINDOWS environments.
• Handled critical tickets and escalations (Incident & Change Requests) as per teh service level agreement using BMC remedy and JIRA Tool.
• Migrated 11g databases to different server using gloden gate with minimal down time.
• Installed 10g & 11g 2 Node RAC & cluster ware installation on RHEL 5/6.x server.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Install and configure SiebelEnterprise Servers and Web-Plugin (SWSE) for multi-lingual Arabic on multi-clustered heterogeneous VM platform.
• Developed and customized scripts to monitor teh health, functioning and performance of standby databases.
• Efficiently carried out DBAresponsibilities in planning DB2version migration activities, in migration phases and in performing post migration tasks
• Worked with ETL Tool.
• Working experience in implementing Oracle RAC and Data Guard on Windows 2012
• Experienced in database security management
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers
• Involved in teh migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of teh Database and SQL Queries using 12c OEM, AWR, ADDM,ASH and TKProf
• 12c OEM agent upgrade on RAC databases
• Working experience with JBoss and SVN
• Creating Calendars and uploading same in Control-M Server Database.
• Building new databases and schemas from teh scratch for new projects/application on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Regular schema, table and database refreshing from production to development, UAT and SIT environments using RMAN and data pump utility.
• Assisted in teh development of Logical database design
• Designed teh Physical data model
• We used LogMiner to calculate table Access Statistics.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION
• ASM Disk storage and user Management
• Worked on teh Oracle RAT for managing teh performance solutions.
• Performance SQL Tuning for teh SQL queries by scrutinizing long running sql queries
• Worked on Gloden gate to setup unidirectional replication on 4 node RAC database.
• Generated Email notification for users using Perl.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL

Oracle DBA

Confidential, St. Louis, MO

Responsibilities:

• Installation, configuration, and maintenance of Oracle 11gr2 on AIX 5.3 and AIX6.1.
• Responsible for setup and implementation of 2 node RAC on Oracle 11g.
• Configured ASM with high redundancy for high availability in RAC databases
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Implemented and managed Oracle Data Guard on Oracle 10g and 11g for Disaster Recovery.
• Upgrading Oracle 10gr2 to teh latest Oracle 11gr2 using Manual and DBUA methods
• Implemented oracle GOLDENGATE one-way replication on Oracle database 11.2.0.2
• Monitoring gloden gate LAG from source to target using 12c OEM
• Installed 12c database in Development environment as part of POC work
• Working continuously captures and deliver changed data in real time between source databases and teh Teradata warehouse.
• Creating Calendars and uploading same in Control-M Server Database.
• Troubleshooted teh ODI connection with oracle by fixing teh tnsnames.ora file, TNS listener and DNS entries
• Experience in implementing Oracle RAC and Data Guard on Windows 2012
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Applying CPU and PSU patches for all teh development and UAT servers when required
• Developed DDL & DML SCRIPTS and applied in teh production database during production releases
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Daily Health Check Up of teh Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Configure and manage RMAN backup and recovery Created User accounts, Roles and granting required access permissions and privileges to teh database based on teh applications they are accessing.
• Worked on teh physical and logical designing of teh database, which includes teh distribution of data- files on different disks
• Implemented and Monitored Data Guard on Oracle 10g.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Export and import of database objects using traditional export/import and Data pump utility.
• Cloning of schemas, objects and data on new server using RMAN and Data pump utilities
• Table partitioning to improve performance and I/O access.
• Involvement in space management, rectification of lock problems, user management.
• Data Refreshes from Production to test and Development environments using RMAN or Data Pump
• Alert log monitoring every day in all non-production environments.
• Performance SQL Tuning for teh SQL queries which are running slow and taking more CPU cost.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs and Backups using CRONTAB and OEM.
• Experience in moving teh data from one server to another server using SFTP,FTP and SCP
• Restoration and Recovery of databases at teh times of occurrence of critical failures
• Experience in Online and Offline backups and recovery.
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Experience in backups and recovery using RMAN and Scripts.
• good noledge on STREAMS Replication

Environment: Oracle 10.1.0.4/10.2.0.4/11g R1 and R2, RHEL 4.X,5.X, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Korn Shell Scripting, Stored Procedures, TOAD, ODI, Oracle Streams and all Oracle Tools.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installation, Configuration of oracle 10g on RHEL 4.x
• Configuration and maintenance of a Two node RAC on Oracle 10g
• Configuration of ASM with normal and external redundancy.
• Restoration of databases from Critical failures.
• Responsible for scheduling backups.
• Taking Incremental backup using RMAN.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts
• Creating and maintenance of databases using DBCA and manual scripts.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema and Table level Replication using Oracle Streams.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Alert monitoring and Ticketing.
• Implementing backup procedures and jobs using Crone Tab.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Creating roles and granting privileges to teh users.
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Scheduling Oracle Jobs in teh database.
• Managing table spaces, user profiles, indexes, storage parameters.
• Involved in developing and implementing PL/SQL stored procedures and triggers.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle 10.2.0.3/11.1.0.6/.7, RHEL 4.x, Solaris 10,Window, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Korn Shell Scripting, Stored Procedures, ASM, Data guard.

Oracle DBA

Confidential

Responsibilities:

• Oracle Database software installation, Instance creations, schema creations.
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEMDatabase Control to monitor database.
• I was involved in Maintaining critical interfaces with MMIS NCTRACKS using Curambatch framework-CuramV6
• Thorough understanding of how teh Curambatch works for Recipient File and also Provider Mass Change Process.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Created database links that are required for databases.
• Experience in Data conversion using RMAN in teh migration process of Oracle databases in Cross platforms.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Well conversed using teh CRSCTL and SRVCTL tools for maintaining database, ASM and node applications
• Created physical standby database and worked with data guard to provide Disaster Recovery.
• Performed troubleshooting of database using AWR and ADDM reports.
• Extensively used SQL LOADER as a tool for loading data.
• Performed replications using Oracle Streams.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Stats pack, ASM, TOAD 7.4, Korn Shell scripting, Data warehouse, AIX 4.3 etc.