SUMMARY:

• I have over Ten years’ of in depth experience in Oracle SOA development with duties including Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams. UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases. Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features like 10g RMAN, Data pump Flash - Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active Data Guard.
• Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.
• Expertise in maintaining Database Security using auditing. Experience in Data Migrations.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, and AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
• Performance Tuning of the database (Memory Tuning, I/O Tuning) Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF. Expert in Performance
• Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof,
• Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, and Memory.
• Created indexes to facilitate easy user interface implementation and tuning. Involved in construction of DR sites for all the Production and IST environments.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, data pump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Stats pack and tuning of initialization parameters.
• Experience as 24x7 productions DBA as well the application (development) database administrator. Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.
• Experience in database patching, cloning, upgrade, migration & maintaining standby db. Server (DR).
• Experience with database backup, recovery, and setting up disaster recovery Database servers.
• Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems.
• (Normalization, De-normalization, Entity Relationship diagram, DFD etc.)
• Expertise in all the phases of Software Development Life Cycle (SDLC).
• Experienced in working with DBVERIFY utility and other method to find Data Corruption.
• Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files.
• Allocating logical storage structures like table space, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle data bases.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts.
• Heavy UNIX shell scripting, CRON jobs.
• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 12c, 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11g, Oracle 10g

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, Toad, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL, Developer, Grid Control

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2000/2003 server

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Oracle SOA Developer

RESPONSIBILITIES:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10, Oracle 11i/r12 & 12c to support internal production and test environments.
• Implementation of OPM and sub ledger accounting/MAC
• I successful design and implementation of the integration solution using Oracle SOA Suite to support development team.
• Diagnose root cause or issues on SOA web services configuration and SOA fusion middleware components.
• Identify and eliminate recurring issues on SOA web services configuration and SOA fusion middleware components
• Performed conversion of SingleNodeInstance to MultiNodeRAC with ASM, and adding instance to existing RAC.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Installation, maintenance and tuning of11g RAC databases including ASM and CRS.
• Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection .
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Setting up Golden Gate replication to heterogeneous environments for OS and Databases.
• Capture, analyze and replay database transactions by using RAT.
• Installed Oracle 11i Fixed Assets including AP, AR, GL
• Experience in upgrading 11g OEM to OEM 12c Cloud Control with a Two system approach method having zero downtime
• Installed, Configured Oracle 12c Golden gate on Oracle 12c Database.
• Extensively worked on Golden gate.
• Configured cascading and bi-directional setups to accommodate the business requirements.
• Performed conversion of SingleNodeInstance to MultiNodeRAC with ASM, and adding instance to existing RAC.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Installation, maintenance and tuning of11g RAC databases including ASM and CRS.
• Experienced in Enterprise Application Integration tools using TIBCO products.
• Extensive experience in design, development, testing, deployment and high level design documentation of Enterprise Application Integration (EAI) projects using TIBCO components.
• Development experience of business logic and automated business processes using TIBCO Business Works, Active Matrix Service Grid and Active Matrix Service Bus.
• Experience in using messaging standards such as EMS, JMS and TIBCO
• Rendezvous for developing distributed applications.
• Experience in using TIBCO middleware products like TIBCO Active Database and MQ Adapters.
• Experience in system monitoring, domain monitoring and management using TIBCO Administrator and TIBCO Hawk.
• Excellent conceptual skills in writing SQL Statements using Oracle, MS- Access and SQL Server 2005.
• Excellent skills in implementing services by using XML, XSD, SOAP and WSDL.
• Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Atlanta, GA

Oracle SOA Developer/ Database Administrator

RESPONSIBILITIES:

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• All the applications, end systems are connected using TIBCO as integration platform. ING has taken initiative called European Roadmap to have separate data centers for ING bank, ING Insurance and ING Investment Management
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Plan and schedule RMAN backups (hot, cold and incremental backups)
• Setup 12c Oracle Enterprise Manager (OEM)
• Implemented Transparent Data Encryption (TDE) for database security.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.