SUMMARY:

• 11 years of Experience as an Oracle 8i/9i/10g/11g DBA in 24x7 Production high availability, Test and Development Instance environment.
• Oracle 10g DBA Certified Professional.
• Hands on experience in RAC (Real Application Clusters), Dataguard/StandBy, ASM, Streams, Data Guard Broker and Grid Control on various Platforms including RedHat Linux, AIX, HP - UXi, Solaris and Windows Servers.
• Hands on Experience in Administration of RAC services for workloads management, and applications high availability.
• Experience in Developing Backup and recovery strategy for RAC and non RAC databases for large Databases.
• Configure and monitor Oracle Clusterware resources.
• Experience managing Oracle HA services for RAC Databases.
• Monitor High Availability RAC, ASM and Data guard instances using Quest-foglight.
• Administration of 10g/11g Data Guard for high availability.
• Experience in applying Patches both on Application and database.
• Experience working with Oracle Streams and Replication.
• Experience in doing backups and recovery using RMAN, Cold/Hot Backups, export/import/Data pump.
• Have done upgrades from 8i/9i/10g to 11g.
• System administration experience of Oracle E-business suite (Oracle 12i).
• Experience in installation, configuration and maintenance of Oracle Applications 11.5.x, single node and in multi node RAC environments.
• Oracle E-Business Suite (Apps) 11i Integration with 10g Application Server OID/SSO/Portal .
• Experience Managing Oracle Argus pharmacovigilance systems for comprehensive drug safety.
• Strong Technical expertise as Oracle DBA and Oracle Applications DBA with strong ability in the client and end user support.
• Experience on Migration of large Databases to Oracle, MS SQL and Sybase.
• Experience working with IBM Optim for Integrated Data Management.
• Experience working on Oracle Transportation management (OTM).
• Oracle replication solution from Shareplex and Replicate critical data and applications for high availability.
• Experience in installation, configuration and maintenance Quest-Foglight.
• Evaluate the database replication strategy using Streams.
• Experience working in Single sign-on (SSO).
• Creating SQL Server 2005 and 2008 instances and administration.
• Golden Gate configuration and installation experience.
• Install Audit Vault Server and Audit Vault Agent.
• Experience with Data Warehouses and Oracle Warehouse Builder.
• Experience in managing of Shareplex, working with Flex clones for netapp filer.
• Experience in Database Conversions from Various platforms.
• Skilled in logical and physical database design.
• Administration of Database Structure, Storage Allocation, and Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Adding, Managing Oracle partitions.
• Experience in Replication using Golden Gate.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, ADDM, AWR reports etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases.
• Administered databases of various sizes from 5GB to 4TB.
• Experience in Oracle Enterprise Manager (OEM) & Oracle Management Server (OMS).
• Experience administrating ONAMES and OID (Oracle Internet Directory)
• Configure VERITAS netbackup for Oracle and MS - SQL Database.
• Experience in UNIX shell and Perl scripting.
• Served as an Oracle Lead Database Administrator managing other DBA's and Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.

SKILL:

Hardware Platforms: HP9000, E250, Sun Ultra Sparc Server, IBM (INTEL Based & Compatible), Pentium PCs, Dell PowerEdge (R910, R810 and M910).

Operating Systems: Sun Solaris 8.0/9.0/10, Unix, AIX 5L, RED HAT LINUX 7.3/8/9/Enterprise Edition, Windows 9x/2000/NT

Languages: C, SQL, PL/SQL and UNIX Shell and Perl Script (Bourne, Korn)

Database Systems: Oracle 8.0/8i/9i/10g/11g, XML-DB, AbInitio, MS-SQL Server 2005/2008, OTM (Oracle Transport Management), Oracle Argus.

Front-end Tools and Utilities: Visual Basic, IIA, Weblogic Developer 2000, Oracle Warehouse Builder, SQL*LOADER, Import/Export, OEM, RMAN, SQL*PLUS, Autosys, 10g Grid Control.

Development Tools and Utilities: TOAD, DBArtisan, SQL Navigator, Erwin, Foglight, IBM Optim Quest-fog light, Veritas Netbackup, Control M, Shareplex.

Web Technologies: HTML, DHTML, IIS, VBScript, Java Script, Web Methods Experience, Active Directory

EXPERIENCE:

Confidential, Green Bay, Wisconsin

Lead Oracle DBA

Platform: Oracle 11g on Sun Solaris/HP-UXi/Linux/AIX/windows.

Responsibilities:

• Managed and provided production support for Oracle Database instances.
• On call production support for High availability Real Application clusters Databases.
• Infrastructure Installation and maintenance of ORACLE 11g RAC, ASM Database for high availability.
• 10g/11g RAC Design/Installation/Configuration/Support: Design/Install 4 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Installation and good working experience on Oracle Enterprise Manager (OEM).
• Working on Oracle Transportation Management (OTM).
• Managing HA RAC services for HA Databases.
• 11g RAC Databases creation on multi-node and Adding/Deleting RAC instances on clusters.
• Pro-active monitoring using the custom made scripts and also using Enterprise manager.
• Creation and managing ASM Disk groups.
• Frequently Applying patches for both Applications and Database using ADPATCH and Opatch Like adadmin, adctrl AND ADSPLICE.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non RAC Databases.
• Installing and upgrading OCFS Cluster, RAC clusterware, ASM software and oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• SQL and batch performance tuning on regular basis.
• Configured Oracle 10g/11g oracle database for GRID performance monitoring and availability.
• Coordination with Oracle Support for service requests on SR basis.
• Experience in 10g/11g Grid Control for managing the high availability databases.
• Regularly monitoring the RMAN Backup batch and resolving the issues.
• Regular Database refreshes/Database cloning using RMAN/ Datapump/ export import and cold clone.
• Good working experience working with Product development team for day to day support for development work.
• Supporting Production releases and follows up the production change management.
• Supporting Data ware housing Databases upto 200 TB.
• Performed Database tuning which included use of OEM, ADDM, AWR reports, statspack package and have done tuning of: Buffer cache, shared pool, Rollback segment, redo space wait, Free list wait (use of dynamic data dictionary views such as v$system event, v$session event, v$session wait), disks sort, file I/O, row fragmentation, index fragmentation, extent size, DB block size, PCTFREE, PCTUSED.

Confidential, Rahway, New Jersey

Lead Oracle DBA

Platform: Oracle 10g/11g on Sun Solaris/HP-UXi/Linux/windows.

Responsibilities:

• Managed and provided production Oracle Database instances.
• Managing Oracle Argus pharmacovigilance systems for comprehensive drug safety.
• Involved with installation and maintenance of ORACLE 10g/11g RAC, ASM Database for high availability.
• 10g/11g RAC Design/Installation/Configuration/Support: Design/Install 3 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Performed Backup and Recovery using manual and RMAN and written shell scripts for scheduled online backups.
• Managing HA RAC services.
• Adding Deleting RAC instances on clusters
• Administration of RAC clusters and ASM Disk groups.
• Applied patches for both Applications and Database using ADPATCH and Opatch and extensive experience in using AD Tools like adadmin, adctrl AND ADSPLICE.
• Have done Creation and deletion of RAC Database up to 4 node RAC Databases.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non RAC Databases.
• Installing and upgrading OCFS Cluster, RAC clusterware, ASM software and oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Managing ASM for RAC Databases.
• Configured Oracle 10g/11g oracle database for GRID performance monitoring and availability
• Installation and configuration of VERITAS netbackup for Oracle and MS-SQL Databases.
• Administration of ONAMES and OID Databases.
• Experience in 10g Grid Control for managing the high availability databases.
• Extensive production experience supporting a clustering environment (LifeKeeper or Veritas) and replication (GGS or SharePlax).
• Determine your most critical instance alarms from Quest-foglight and immediately take action to resolve performance issues.
• Performed Database tuning which included use of OEM, ADDM, AWR reports, statspack package and have done tuning of: Buffer cache, shared pool, Rollback segment, redo space wait, Free list wait (use of dynamic data dictionary views such as v$system event, v$session event, v$session wait), disks sort, file I/O, row fragmentation, index fragmentation, extent size, DB block size, PCTFREE, PCTUSED
• Cloning/ Data Refresh from production to setup test and development environments.

Confidential, Chicago, Illinois

Sr. Oracle DBA

Platform: Oracle 9i/10g/11g on Sun Solaris/HP-UXi/Linux

Responsibilities:

• Managed and provided production support to more than 500 Database instances.
• Involved with installation and maintenance of ORACLE 10g/11g RAC, ASM Database for high availability.
• 10g/11g RAC Design/Installation/Configuration/Support: Design/Install 4 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Serve as Oracle E-business solution delivery expert in the areas of Supply Chain Planning and Execution for a large ERP program conforming to established system architecture standards and practices
• Configure physical standby database for RAC database from 3 nodes RAC to 2 nodes RAC. Configure flashback database for point in time recovery in case of disaster.
• Managing HA RAC services.
• Adding Deleting RAC instances on clusters
• Administration of RAC clusters and ASM Disk groups.
• Good Experience in Moving RAC instances from one node to another for rebalancing system resources.
• Have done Creation and deletion of RAC Database up to 4 node RAC Databases.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non RAC Databases.
• Installing and upgrading OCFS Cluster, RAC clusterware, ASM software and oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Managing ASM for RAC Databases.
• Configured Oracle 10g/11g oracle database for GRID performance monitoring and availability
• Installation and configuration of VERITAS netbackup for Oracle and MS-SQL Databases.
• Administration of ONAMES and OID Databases.
• Experience in 10g Grid Control for managing the high availability databases.
• Extensive production experience supporting a clustering environment (LifeKeeper or Veritas) and replication (GGS or SharePlax).
• Determine your most critical instance alarms from Quest-foglight and immediately take action to resolve performance issues.
• Monitoring Databases using Foglight.
• Installation and configuration SQL Server 2005 and 2008 servers.
• Configure SQL Server 2005 and 2008 to netback on polyserve clusters.
• Install Audit Vault Server and Audit Vault Agent.
• Configure and Manage Audit Vault Collectors.
• Create User-Defined Audit Reports.
• Data migration from Sybase to Oracle 10g/11g.
• Golden Gate configuration and installation experience.
• Oracle Data Integration using golden gate.
• Database Migration using Shareplax to Oracle 10g on HPUXi.
• Manual Data Migration from Sybase 11 to Oracle 10g.
• Moving Oracle partitions and Truncating Partitioned Tables, Splitting Oracle partitions.
• Performed Database tuning which included use of OEM, ADDM, AWR reports, statspack package and have done tuning of: Buffer cache, shared pool, Rollback segment, redo space wait, Free list wait (use of dynamic data dictionary views such as v$system event, v$session event, v$session wait), disks sort, file I/O, row fragmentation, index fragmentation, extent size, DB block size, PCTFREE, PCTUSED
• Performed /debugging SQL tuning which involved use of super indexes, hints, proper indexes, rewriting SQL to Minimize I/O, SQL star join, star transformation, changing order of joins, pinging procedure/package, caching tablePre-running a report, use of histogram for skewed data.
• Install, patch and maintain all Oracle software.
• Performed Unix server monitoring which included regular checking of: cpu load (use of uptime, sar - u, top), paging, Swapping, thrashing, processes inactive for long time, processes with high cpu time, network traffic (use of netstat for % of collision).
• Cloning/ Data Refresh from production to setup test and development environments.

Confidential, Chicago, Illinois

Sr. Oracle DBA / System Engineer

Platform: Oracle 9i/10G/11g on AIX/Sun Solaris/ Windows/HP-UX/Linux

Responsibilities:

• Managed and provided production support to more than 1000+ Database instances.
• Involved with installation and maintenance of ORACLE 10g/11g RAC, ASM Database for high availability.
• 10g RAC Design/Installation/Configuration/Support: Design/Install 4 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Configure physical standby database for RAC database from 3 nodes RAC to 2 nodes RAC. Configure flashback database for point in time recovery in case of disaster.
• Managing HA RAC services.
• Experience in multiple Supply chain Management modules preferred such as Planning, Warehouse management & Transportation for Oracle E-Business suite.
• Oracle E-Business Suite (Apps) 11i Integration with 10g Application Server OID/SSO/Portal .
• Adding Deleting RAC instances on clusters.
• Administration of RAC clusters and ASM Disk groups.
• Good Experience in Moving RAC instances from one node to another for rebalancing system resources.
• Have done Creation and deletion of RAC Database up to 4 node RAC Databases.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non RAC Databases.
• Installing and upgrading OCFS Cluster, RAC clusterware, ASM software and oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Managing ASM for RAC Databases.
• Configured Oracle 10g Grid for oracle database performance monitoring and availability
• Installation and configuration of VERITAS netbackup for Oracle and MS-SQL Databases.
• Administration of ONAMES and OID Databases.
• Experience in 10g Grid Control for managing the high availability databases.
• Extensive production experience supporting a clustering environment (LifeKeeper or Veritas) and replication (GGS or SharePlax).
• Performance monitoring using Foglight and take action to resolve production performance issues.
• Analysis the foglight performance diagnostics and alarm data to resolve recent performance issues.
• Installation and configuration SQL Server 2005 and 2008 servers.
• Configure SQL Server 2005 and 2008 to netback on polyserve clusters.
• Install Audit Vault Server and Audit Vault Agent.
• Configure and Manage Audit Vault Collectors.
• Create User-Defined Audit Reports.
• Data migration from Sybase to Oracle 10g.
• Golden Gate configuration and installation experience.
• Oracle Data Integration using golden gate.
• Database Migration using Shareplax to Oracle 10g on HPUXi.
• Manual Data Migration from Sybase 11 to Oracle 10g.
• Moving Oracle partitions and Truncating Partitioned Tables, Splitting Oracle partitions.
• Performed Database tuning which included use of OEM, ADDM, AWR reports, statspack package and have done tuning of: Buffer cache, shared pool, Rollback segment, redo space wait, Free list wait (use of dynamic data dictionary views such as v$system event, v$session event, v$session wait), disks sort, file I/O, row fragmentation, index fragmentation, extent size, DB block size, PCTFREE, PCTUSED
• Install, patch and maintain all Oracle software.
• Cloning/ Data Refresh from production to setup test and development environments.

Confidential, Long Island city, New York

Oracle DBA/Apps DBA

Platform: Oracle 9i/10G/11g/11i on AIX/Sun Solaris/Linux/Windows

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• 10g RAC Design/Installation/Configuration/Support.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Creation of Database, Tablespaces and Schemas.
• Managing data security and user access.
• Manage TAR's and Production Support.
• Manage large partitioned databases on Windows 2000 for MS SQL Server.
• Upgrading MS SQL Database .
• Database migration from MS SQL to Oracle and Oracle to MS SQL Server.
• Oracle replication solution from Shareplex and Replicate critical data and applications for high availability.
• Designing Logical and Physical Layout of the databases.
• Evaluate the database replication strategy using Streams.
• Implementation of replication strategy in PoC environment using Oracle Streams.
• Implementation of Oracle Advanced replication environment and mechanism.
• Patch application working with AD utilities- ad patch, adadmin, admerge, adctrl, adclone.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Rebuild index for better performance.
• Coordinated with Oracle Corp for technical issues.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Managing Flex clones with Netapp for test databases.
• Monitoring Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC database for high availability.
• Determining the Oracle10g RAC architecture.
• Responsible for Database Replication.
• Performance tuning for Oracle Real ApplicationClusters (RAC)

Confidential, Warren, New Jersey

Oracle DBA/Apps DBA

Platform: Oracle 9i/10G/11i on AIX/Sun Solaris/Linux

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Creation of Database, Tablespaces and Schemas.
• Managing data security and user access.
• Manage TAR's and Production Support.
• Designing Logical and Physical Layout of the databases.
• Implementation of Oracle Advanced replication environment and mechanism.
• Patch application working with AD utilities- ad patch, adadmin, admerge, adctrl, adclone.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Rebuild index for better performance.
• Cloning Oracle Applications production system, using RAPID clone.
• Coordinated with Oracle Corp for technical issues.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Managing Flex clones with Netapp for test databases.
• Monitoring Index Usage.
• Installation and configuration SQL Server 2005 and 2008 servers.
• Implementation of replication strategy in PoC environment using Oracle Streams.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC database for high availability.
• Determining the Oracle10g RAC architecture.
• Responsible for Database Replication.
• Performance tuning for Oracle Real ApplicationClusters (RAC)

Confidential - Confidential, Charlotte, NC

Oracle DBA

Platform: Oracle 9i/10G on AIX/Sun Solaris

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Creation of Database, Tablespaces and Schemas.
• Managing data security and user access.
• Designing Logical and Physical Layout of the databases.
• Database conversions from Sun Solaris/windows to different platforms.
• Used Quest Shareplex for replicating databases.
• Install the Quest-foglight Server and registering and monitoring Oracle Databases using foglight.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using Explain Plan, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Coordinated Oracle Corp for technical issues.
• Experience working with MS-SQL server 2005.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Experience in managing of Shareplex.
• Working and support to Data Warehouses databases.
• Monitoring Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Responsible for Database Replication.
• Performance tuning for Oracle Real ApplicationClusters (RAC)

Confidential

Oracle DBA

Platform: Oracle 9.2.0/10g and Oracle 11i on Sun Solaris 2.8 / AIX 5L / Windows 2000.

Responsibilities:

• Oracle Server software installation and configuration
• Creating and maintaining the data model and physical integrity of the databases.
• Planning, testing and setting up backup and recovery strategies.
• Disaster recovery using Standby database and Database cloning.
• Writing migration scripts for migrating data from Oracle 11i Apps to Oracle 9.2.0.4
• Monitoring database health by scheduling shell scripts thru cron jobs.
• Creation of Database, Tablespaces and Schemas, Data Loading.
• Managing data security and user access.
• Manage TAR's and Production Support.
• Installation, configure, and administration of E business suite.
• Designing Logical and Physical Layout of the databases.
• Writing stored procedures, functions, packages and triggers.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using Explain Plan, SQL Trace and Tkprof
• Creating snapshots, database links that are required for distributed databases.
• Creating generic database objects like sequences, synonyms, and views.
• Written shell scripts to automate certain jobs like exports and backups.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Technical assistance and guidance to development team.
• Involved in design and implementation of the data warehouse.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.

Confidential

Engineer - Oracle

Platform: Oracle 9i on Win NT/Linux/Sun Solaris

Responsibilities:

• Installation and Configuration of Oracle database, Application (both J2EE and Pro*C) on Sun Solaris.
• Configuring Oracle 9i RAC database and monitoring the same.
• Installation of patches and software upgrades.
• Creation of E-R diagram and Data Flow diagrams.
• Creation of Tablespaces, Schemas, Database triggers and Stored Procedures. Implementing the Primary & Foreign Key Constraints for the objects in the Schema.
• PL/SQL Programming.
• Implement and maintain database security.
• Establish and maintain sound backup and recovery policies and procedures.
• Use of Recovery Manager (RMAN)
• Monitoring the database.
• Use of Import-Export utilities and SQL * LOADER, Data Migration.
• Performance Tuning of database and tuning of SQL.
• Guide Application development team for writing effective queries in applications & Creation of Shell Scripts.
• Coordination with Oracle Support for critical problem resolution.
• Evaluate Oracle features and Oracle Related Products and prepare technical documentation.
• Active participation in setting up Network Architecture of the Project on-site.
• Designing the production database and involved in the sizing the database activities & 24x7 Production Support.