Summary:

• Skilled and Resourceful Oracle professional with 5 years IT experience which includes leading team of DBA's, people management, database administration, database design, development and support of oracle 9i/10g/11g RAC in production, test and development environment.
• Installations and configurations of Oracle database Servers 8i, 9i, 10g 11g oracle 9iAS, Oracle 10g AS on Linux, Windows servers in production and development. Experienced in performing Database related activities using GRID, Data Pump, SRVCTL, RMAN, SQL Loader, Export, Import, PL/SQL, SQL Plus, SQL Net, SVRMGR, Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Strong Experience with Application database Administration Utilities AD Utilities .
• Strong experience in Creating Users, Responsibilities, Menus and Form Functions Sys Admin and Knowledge of Application Object Library AOL .
• Registering Concurrent Programs with Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance.
• Experience in changing Application user passwords using FNDCPASS utility.
• Oracle Dataguard and standby database Setup.
• Created ASM disk group to store database files.
• Experience in the creation of Database Links.
• Experience in database security patch management, upgrading oracle RDBMS to higher versions which includes RAC and non RAC environments.
• Troubleshooting expertise for all tiers client, middle-tier, database
• Create and Maintaining the Technical Notes and Documentation.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities with excellent communication skills.
• Knowledge on MS SQL databases.
• Database and application object migration.
• Knowledge in Tidal, Ignite, OEM and Stat.
• Good Technical and Communication Skills.
• DW database, OWB and materialized view creations
• Experience in imp/exp at table, schema and database level.
• Knowledge in implementation Oracle Glassfish, Primaware, Apex.
• Installation and maintenance of OBIEE instances.

Confidenti al

Oracle DBA Consultant

Responsibilities:

• As Production DBA, managed all database issues including database capacity, re-orgs, backup recovery, scripting and Performance tuning.
• Supported various Financials, Supply Chain, Order Management, Manufacturing, HR and Payroll Modules in 24x7 Production Environment.
• Supported Development/Functional Team resolving issues.
• Supporting web logic server's deployments.
• On call DBA support
• Installed and configured 12c / 10g Grid Control and Confio to monitor various Production and Development databases.
• Installed and configured 10g/11g Oracle Transparent Gateways to connect to heterogeneous Databases.
• Assisted the developers with data conversion and performance tuning tasks.
• Installed and configured OBIEE, Discoverer 11g/10g with Load Balancing.

Environment: Oracle Applications 11i and R12 ERP and HRMS with cluster configuration.

Confidential

Oracle DBA Consultant

Responsibilities:

• Installation and configuration of Oracle 11g databases.
• Built new Databases on new servers from the scratch.
• Performed database refreshes from production to UAT environments.
• Taken care of backups and recoveries using RMAN.
• Applied necessary CPU and PSU patches to Oracle Databases.
• Performed exports / imports based on users requirements.
• Performed performance tuning and SQL tuning using AWR, TKprof utilities.
• Taken care of Tablespace re-organization.
• Created Table partitions and purging non- required partitions based on application demands.
• Performed daily database monitoring and general space check.
• Given Support for application users in solving their database issues.
• Deployed and trouble shoot database change requests.

Environment: UNIX platforms: Sun Solaris 5.10, Database Versions: Oracle 11g.

Confidential

Oracle DBA Consultant

Responsibilities:

• Installed and configured R12 application in a multi node RAC environment with PCP and application Load Balancing.
• Installed and configured 10g/11g Physical standby with Data Guard for DR.
• Migrated Oracle Applications from NetApp File system To EMC on ASM
• As Production DBA, managed all database issues including database capacity, re-orgs, backup recovery, scripting and Performance tuning.
• Supported various Financials, Supply Chain, Order Management, Manufacturing, HR and Payroll Modules in 24x7 Production Environment.
• Provided Production / Development support to Oracle Data warehouse environment
• Installed and configured 12c / 10g Grid Control and Confio to monitor various Production and Development databases.
• Installed and configured 10g/11g Oracle Transparent Gateways to connect to heterogeneous Databases.
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates
• Monitoring Applications and Database Backups.
• Monitoring Concurrent manager and concurrent requests.
• Issue management - Files, Schemas, and Tablespaces etc.
• Export and Import schemas using data pump.
• Database Refresh.
• Support Administration of Oracle 11i, R12 Applications
• Cloning of Oracle 11.5.10 and R12 instance.
• Monitoring Concurrent manager and concurrent requests.
• Object migration - compile forms, reports and packages etc.
• User creation setups, Creation of Responsibilities.
• Menu and functions creations, Profile Option Settings, Printer Setups.
• Creation of Concurrent Mangers, Programs, and Request sets
• User Management and gathering statistics GSS on Database Objects
• AD utilities usage for various tasks
• Support on daily basis
• Printer configuration and setup at application level
• Handling Netapp storage system for backup
• Working on NGDC storage move
• Database and Application Patching.

Environment: Oracle Applications 11i and R12 ERP and HR with cluster configure on 10g and 11g on OLE 5 64 bit Linux, Data warehouse 10g an 11g , 9i, 10g and 11g data bases.OEM 10g, OEM 10g, Apex. APT applications, Tidal Applications, Net APP Application for filer, restore and backups, Tidal applications, oracle databases running on other applications

Confidential

Oracle DBA Consultant

Responsibilities:

• Worked closely with development team to assist with application design and development as they interface with the databases both on Oracle and SQL Server.
• Participated in gathering business requirements, system analysis and designing Database enhancements for the application.
• Developed complex SQL queries and have done extensive coding of Procedures, Functions and Packages in PL/SQL.
• Extensive knowledge of working with Cursors.
• Worked extensively with database utilities like IMP, EXP and SQL Loader utilities to load the developer's databases.
• Experienced in developing reports.
• Provided database support, Problem identification, and resolution for issues.
• Good Understanding of the ETL architecture and concepts.
• Strong Knowledge of Star Schema, Snow Flake Schema, Dimension and Fact Tables.
• Installation, configuration and upgrading of Microsoft SQL Server.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security create and maintain users and roles, assign privileges .
• Understanding basic Query flow Conditions and ordering the result set .
• Good understanding of SSIS, SSRS and SSAS.

Environment: Unix, Oracle, SQL Server2008/2005, Windows 7, Synergy, C , Java.

Confidential

Oracle DBA Consultant

Responsibilities

• Installing, Configuring and Integrating with Oracle Fusion 11g 11.1.1.7 IDM Middleware Components Weblogic, OAM, ODSM, OIM, with Oracle Application Express 3.1.1.00.09 .
• Configured the schemas for OID, OAM and OIM using Oracle Repository creation utility RCU .
• Installed, configured and integrated System components OHS, OID, OVD, ODS with Fusion middleware Java components Weblogic, OAM, OIM, SOA .
• Installing Oracle HTTP Server 11.1.1.7.
• Installing Directory Services Components OID / OVD 11.1.1.7.
• Validated the installation of the OID, OVD instance using ldapbind command.
• Creating a policy store property file and using the idmConfigTool, to configure the Policy store for different components.
• Creating Adapters in Oracle Virtual Directory and validating both Changelog Adapter and User Adapter using ldapsearch command.
• Configure OID/OVD parameters for better performance through Oracle Fusion Middleware control Enterprise Manager .
• Troubleshooting the issues with OID and OVD during the Configuring phase.
• Taking the snapshot backup of Fusion Middleware components Weblogic, OAM, OIM, OID, OVD .
• Managing the Fusion Middleware components through Weblogic Admin Console and Oracle Fusion Middleware control Enterprise Manager .
• Troubleshooting the issues with Fusion IDM Components.
• Raising SR's to Oracle and responding to SR's on the issues.

Environment: Oracle Applications Express 3.1.1.00.09 , Oracle Apps R12 12.1.3 , Oracle Fusion IDM Middleware 11g Components Weblogic, OAM, ODSM, OIM, SOA , Solaris Sparc 10, Oracle 11g, OEM, SQL plus, Toad.