SUMMARY:

• 12+ years of experience in Information Technology industry with10+ years of experience as Oracle Apps DBA in oracle E - Business Suite (),Oracle DBA, Oracle Form /Report, Software Development Life Cycle and extensive experience
• 11.5.4, 11.5.9, 11.5.10.2, 12.1.3 & 12.2.5 oracle eBusiness suite applications with 8i/9i/10g/11g/12c/Enterprise Manager Cloud Control 12c on erp databases and non-erp databases
• Oracle EBS 12.2.5.0 online patching.
• Oracle EBS suite upgrade from 11i to R12 (11.5.9 to 11.5.10.2 and 11.5.10.2 to 12.1.3 and R12.1.3 to R12.2.4/5) and database upgrades from 8i,9i to 10g, 9i to 11g, 10g to 11gR1, 10g to 11gR2 and to 12C
• Oracle Linux/ Solaris/Windows OS Oracle RDBMS & and SQL Server databases
• Installation and configuration of Hyperion EPM 11.1.2.3, 9.3.3 for project management team .
• Oracle Web Services for Fusion Middleware (Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11gR1
• Installation, configuration, cloning, maintaining concurrent managers, user management issues and space management, Patching (database and application patches), backups (logical and physical)
• Installation and configuration of Oracle Configurator.
• Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration
• Oracle Application Object Library ( AOL ), Oracle EBS R12 data structures , workflows , oracle application utilities, HRMS Patching Strategies such as Datainstaller, HrGlobal, schema updates, data migrations, tech upgrades, user maintenance, troubleshooting, backup management, performance tuning, data recovery, and disaster recovery planning
• Oracle ebusiness suite extensions for Endeca and oracle Endeca information discovery with FMW HOME and weblogic server 10.3
• Change Management in Production and non-Production instances through ITG Confidential applications
• Web ADI and Custom Application Deployment with Oracle 11i Apps and Applications sysadmin tasks.
• Documentation, software development methodology, version control, testing, and migration standards
• Performance Tuning of SQL statements and Database using tools like AWR, Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Oracle Active Dataguard for high availability/disaster recovery setup (implement and test DR plan)
• Replication, Performance Tuning, RMAN, ASM, RAC, OEM
• Handled more than 400 databases with max size of 15TB.
• Data Pump and Exp/Imp utilities, replication of tables to cross platform and Creating Materialized Views, PL/SQL and stored procedures and SQL scripting,
• PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages, creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Diagnosis and troubleshooting typical SQL, PL/SQL Tuning issues
• Data modeling, Table restructuring, data loading with external tables in oracle database
• Disaster Recovery Strategies, testing & implementation
• Support and manage Onsite-Offshore model for Production in 24/7 systems, Development and Test instances and Oracle Applications environments of varied complexity.
• Installation and Administration of Oracle products such as Oracle Application server and non-Oracle products such as Confidential (ITG), Noetix
• Create Endeca Discoverer applications to do analysis of Data.
• Installation and configuration of Sun Solaris 10
• Installation and configuration of Sun Storage T3 and T4
• Development of application using Oracle Form 6i, 11g Developer.
• Financial Application development using Microsoft Visual Basic, MSSQL Server
• Installation and administration of Microsoft SQL Server 2000
• Installation and configuration of Hadoop MapR Big Cluster

TECHNICAL SKILLS:

Platforms: Linux, HP-UX, Oracle Solaris SPARC 8/9/10, Windows (NT2008R2), RHEL 5/6

Database: Oracle 12C, 11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4 ), Oracle 10g, Oracle 9i/8i, MS-SQL Server (7,2000) 11gR2 active dataguard

ERP Applications: Oracle eBusiness Applications 11i (11.5.4, 11.5.9/ 11.5.10.2 ), R12 (12.1.3/ R12.2.5)

Languages: PLSQL, UNIX Shell Scripts,Java, Visual Basic,C,C++,Oracle Forms 6i/11g

Third Party applications: HP Confidential Applications (ITG for deploying scripts, forms, reports, objects), OBIEE, ebusiness Endeca applications, Share point, NOETIX,Excel4apps

Tools: & Utilities: Oracle Enterprise Manager (OEM), SQL Developer, Endeca,Oracle Hyperion, Toad, VNC, Hadoop MapR Cluster, Secret Server (Enterprise Password Management), NetApp Backup, Cassandra NoSQL database.

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

Senior Oracle Apps DBA/Oracle DBA

Responsibilities:

• End to end Support and implementation for Oracle 11g/ Dev/Test/Production instances for multiple applications.
• Daily backups and db refresh from production database to Dev/Test
• Migration of the databases and applications between different file systems on different filers.
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
• 11gR2 active dataguard and DR drill (once in 6 months)
• Plans and implements backup and recovery of the Oracle database.
• Installation and configuration of Oracle Developer Suite 11g (Forms, Reports)
• Installation and configuration of Oracle Weblogic Server 10.1.3
• Create users and provide access to developer team with required privileges
• Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
• Installation and configuration of Oracle Form 11g,Reports,Toad,Weblogic 10.3
• Help BA and Development team to Tune the Business Rules, Tune the Data Design, Tune the Application Design
• Frequently checking if require changes to the data design and additional creation of indexes to increase performance of application
• Help to Development team to understand Oracle's query processing mechanism to write effective SQL statements.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

Environment: Oracle RDBMS 12C/11gR1/11gR2/ RMAN, Oracle Linux 6, OEM11g/12c,Oracle Form 11g,Report, Web logic Server 10.1.3, Share point

Confidential, O’Fallon, IL

Senior Oracle Apps DBA

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle EBS 11i Development and Test Instance.
• End to end Support and implementation for EBS 11i and R12 all Pre- Production instances.
• Co-ordination between Development and DBA team
• Discussion with Customer for future project implementations.
• Installation, Monitoring and Administration of SUN SOLARIS Server.
• Installation and configuration of different third party tools.
• Closely works with Network teams
• Performs tuning of the databases and Performs the capacity planning to create & maintain the databases
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
• Installation, configuration and maintenance of Hyperion EPM Release 9.3.3
• Actively involved in throughout Upgrade life cycle from first iteration till UAT deployment of Oracle E-Business application Upgrade from 11.5.10.2 to 12.1.3
• Part of successful migration of data from legacy system to Oracle EBS 11i.

Environment: Oracle EBS 11i, 12.1.3, Oracle RDBMS 11gR1/11gR2/10g, RMAN, Oracle Solaris, Share point, Hyperion EPM Release 9.3.3

Confidential

Oracle Apps DBA, St. Louis, MO

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle EBS 11i Development, Test, UAT and PROD Instance
• End to end Support and implementation for EBS 11i Production instances.
• 11gR2 active dataguard and DR drill (once in 3 months)
• Cloning of Dev,Test and UAT instances from Production
• Patch analysis, Patch application on DEV UAT PROD using Confidential Package
• Discussion with Customer for future project implementations.
• Installation and configuration of different third party tools.
• Closely work with Onsite-Offshore DBA and Development Team.
• Plans and implements backup and recovery of the Oracle database using NetApp Backup.
• Installation and configuration of Neotix, Confidential tools
• Actively involved in throughout Upgrade life cycle from first iteration till UAT deployment of Oracle E-Business application Upgrade from 11.5.9 to 11.5.10.2 for EPM one the Emerson’s most critical division.
• Part of successful deployment of Shared APPL Top on Oracle EBS 11i.

Environment: Oracle EBS 11i, Oracle RDBMS 11gR1/10g, RMAN, Oracle Solaris, Share point, Neotix

Confidential

Oracle Apps DBA and MSSQL Server DBA

Responsibilities:

• Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle EBS 11i Development, Test, UAT and PROD Instance
• Patch analysis, Patch application, Cloning.
• Regularly Checking Alert log, Implementing Backup strategy. Monitoring Users, Concurrent Managers using Sysadmin, Pro-Active Checks up on the Database
• Installation, configuration and Implementing Backup strategy of MS SQL Server 2000.

Environment: Oracle EBS 11i (11.5.4, 11.5.8), Oracle RDBMS 10g/9i, RMAN, HP -UX, MSSQL 2000