SUMMARY

• Over 10+ years of experience in Information Technology. 8+ years of extensive experience in Oracle Application DBA (11.5.10,R12,R12.2) / Oracle Database(10g,11g,12c) /Golden Gate,OEM 12c / Exadata (X2,X3)/ Fusion Middleware (SSO,OID,OAM) /ASM,RAC on supporting mission critical OLTP/OLAP, E - Business DWH 24x7 databases..
• Installation, Configuration,Upgradation, Patching, Migration, Trouble shooting, proactive monitoring and Performance tuning of oracle 8i/9i/10g/11g stand alone and RAC databases with ASM,VCS, CRS/Clients on UNIX, LINUX and Windows environments.
• Design, implement and support Oracle Enterprise Manager (OEM) 12C to Monitor/Maintain entire IT infrastructure.
• Expertise in upgrading oracle applications from older versions (11.5.10, R12.0 to Oracle Applications R12.1.3 and R12.2 )
• Installed and upgraded 11g to 12C database including Pluggable databases
• Upgrade experience in 10g to 12c
• Experience on maintaining Greenplum databases
• Performed all aspects of database architect role including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, migrations and new business rollouts.
• Expertise in Maintaining teh Oracle Applications using Auto Patch, Ad Admin, Ad controller, Autoconfig, Rapid Clone, Ad Relink, License Manager and Ad Splicer etc Applications utilities.
• Worked on enterprise data center migration/Disaster recovery of 24x7 systems with tight SLA’s using Oracle Golden Gate, Oracle streams and Data guard technologies.
• Expertise in Integrating SSO,OAM,OID with E-business suite R12.1.3
• Worked on OBIEE and ODI integration with R12.1.3
• Experience in administration of databases DB2,SQL SERVER
• Good experience in Exadata implementation for mission critical financial systems in coordination with Oracle support and various vendor teams.
• Excellent command in creating Backups & Recovery and Disaster recovery procedures and Implementing backup and recovery strategies for off-line and on-line Backups, with excellent command on RMAN, Recovery Catalog, NetApp Snap backups.
• Expert in performance tuning on PL/SQL, database server configuration, memory, Instance and database level.
• Experience in SQL SERVER 2008,2010 and SAP Oracle Databases.
• Design, implement and supported Oracle Goldengate provide a replicated database environment to support internal business sites
• Worked on year to year capacity planning for oracle servers and involved and coordinated with vendors in procurement process for new hardware.
• Worked as teh subject matter expert in teh matters of High available solutions, Replication methods such as Oracle streams, Goldengate, Data guard and security and audit for various internal/business users and end clients. producing compliance reports For Auditing purposes ( PCI DSS, FISMA, GLBA, SOX, HIPAA, ISO 27001)
• Experience in Migration of Non-oracle databases (SQLserver, sysbase to Oracle) using SQL developer
• Plan and acquire teh new technologies for and implementation, suitable for teh applications in regard to teh specific future requirements of teh company's business projections and growth.
• Worked on Hyperion and PeopleSoft upgrade projects.
• Experience in maintaining SQL server 2008,2012 databases.
• Provided training for new onboard consultants and trainees on regular basis about teh Database standards, security compliance and first look of environments.
• Configured RMAN and Non-Oracle backup methodologies for multi-tera byte databases with full documentation of crash recovery testing’s.
• Maintained Offshore Teams 24* 7(India )
• Excellent command on Pl/SQL and Unix Shell scripting.
• 24 X 7 Production on-call support and administration with ITIL and Agile Process .

TECHNICAL SKILLS

Operating Systems: Solaris 8/9/10, HP-UX, SUSE Linux, Redhat Enterprise Linux 4/5, Windows 9X/XP/2000, IBM AIX 5.1/5.2/5.3Applications R12.2,R12.1.3,11.5.10.2

Database: Oracle 8i/9i/10g/11g Enterprise/Standard Edition (With RAC), SQL Server 2008/12, SAP

Languages: SQL, PL/SQL, UNIX Shell Scripting

Database Tools: SQL*PLUS, RMAN, OEM, SQL*Loader, Exp, Imp, expdp, impdp and TOAD, SQL Developer, dbverify, DUM .oracle Apex

Tuning Tools: SQL Auto Tracing, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, Tuning advisors, ADDM, oradebug, OS Watcher and SQL Plan stability management etc.

Other: Veritas Net Backup, Netapp snap manager, Tivoli, EMC, Citrix Server & VMware,more4apps,Excel4apps

Applications Patching Tool: Ring Master,HP kintanna,More4apps

Ticketing tools: Servicenow, remedy

PROFESSIONAL EXPERIENCE

Confidential, Deerfield IL

Application Database Administrator /Onsite Team Lead

Environment: Oracle E-business suite R12,Oracle 11g, Oracle Exadata,ODI,OBIEE,EM Cloud Control 12c, Goldengate, RMAN, Linux 4/5,ODA

Responsibilities:

• Working as Application DBA
• Involved in Installing, Implementing Oracle Application R12.1.3 project and performance tuning on Exadata Machine
• Worked on building/maintenance/administrator/refreshes R12.1.3 implementation
• Worked on configuring ODI 12c for R12.1.3 Reporting
• Golden gate configuration for teh databases for zero down time upgrade
• Coordinated teh development and successful implementation ofDisasterRecoverystrategies for Confidential . Instrumental in setting up ODA servers forOracleFinancials and E-Business Suite based onOracleBest Practices.
• Worked with Network,unix,storage, Identity teams to setup DR site for Confidential financial system
• Worked on migration of object code (manual migrations and HP - kintana )
• Installed Excel4apps and More4apps products on R12.1.3 for GL reporting purpose
• Worked on converting Non - Rac to RAC using rconfig
• Updated teh Oracle Applications to Latest CPU 2014 patch level
• Configured EM controls for 11g databases and Application cloning through OEM 12c
• .Configured SSO and SSL and Load balancer for their Production server
• Project coordinator for r12.2 upgrade test cycles
• Configuring ODI scheduled jobs as part EBS-ODI-OBIEE integration project.
• Leading Offshore team and training teh new joiners and KT .

Confidential, Rockford IL

Application Database Administrator

Environment: Oracle E-business suite 11i/R12,Oracle 10g/11g, Oracle APEX,EM Cloud Control 12c,, RMAN, Linux 4/5, Symantec backup

Responsibilities:

• Worked as Oracle DB architect for 11g upgrade project /and consolidation Project to save teh CPU licenses.
• Involved in Installing, Upgrading Oracle Application R12 upgrade project and performance tuning.
• Worked on building/maintenance/administrator/refreshes for Confidential HRMS implementation
• Configured EM controls for 11g databases
• Perform capacity planning required creating and maintaining database environments.
• Involved in database /oracle application migration using DMU tool.
• Configured and implemented Datagurd setup for operation databases
• Maintaining their SAP Oracle databases as part SAP Basis administration
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Automating Development, QA and UAT database cloning process using Active duplicate mechanism.
• Involved in APEX installation of Confidential Reporting
• Administered DB2 subsystems in Prod, Qual, Test and Development regions
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Performed data maintenance using LOAD,UNLOAD,REORG,RUNSTATS

Confidential, New jersey

Sr Oracle APPS DBA/Migration Expert

Environment: Oracle 9i/10g/11g RAC with Solaris/Redhat, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Solaris 9/10,Oracle streams, Golden Gate, Dataguard, Net Backup, l, Oracle app server, web logic, Oracle E-Business Suite, SOA, Exadata Machines X2/X3,OID,OAM, EM Cloud Control 12c,, MS SQL Server 2005/2008

Responsibilities:

• Key member and offshore project coordinator for Sqlserver 2008 to Exadata migrations
• Converting single node application to Multi node RAC.
• Performed RAC health checks and RAT reports.
• Worked on sqlserver 2005/2008 Administration
• SQL server backups and jobs on Windows 2008
• Preparing POC and Business best practices for Customers
• Integration of E-business suite with OAM/OID
• Installation of Fusion middleware apps
• Designed and installed OEM cloud management, DBaaS implementation of 12c in an enterprise scaleFor backups and monitoring
• Pushing OEM agents for Oracle e-Business, and plugins for data masking, identity management .
• Installed and administration of OBIEE as Part of EBS-OBIEE Integration

Confidential

Sr Oracle APPS DBA/Migration Expert

Environment: Oracle 9i/10g/11g RAC with Solaris/Redhat, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Solaris 9/10,Oracle streams, Golden Gate, Dataguard, Net Backup, l, Oracle app server, web logic, Oracle E-Business Suite, SOA, Exadata Machines X2/X3,OID,OAM, EM Cloud Control 12c,, MS SQL Server 2005/2008

Responsibilities:

• Key member and offshore project coordinator for Confidential 9i,10g, 11g databases and EBS to Exadata
• As a part of Oracle SSI Migration factory Responsibilities includes Migration and upgrading of databases to EXADATA
• Converting single node application to Multi node RAC.
• Preparing POC and Business best practices for Customers
• Implementing E-Business MAA best practices when migrating to EXADATA
• Worked on X3 full rack Exadata machines

Confidential, Houston, TX

Sr. Database Administrator

Environment: OracleApplicationsR12,11i,Oracle8i/9i/10g,TOAD,OEM,OracleRAC,RMAN,SQLBACKTRACK, Redhat Linux, Precise, RingMaster, Netapp snapdrive

Responsibilities:

• Evaluating, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying database patches.
• Backup plan designing and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.
• Design, implement and support Oracle advanced replication and Oracle streams to provide a replicated database environment to support internal business sites
• Re-organizing teh database architecture to work efficiently and for better response time.
• Working with Cemli Team and migrate teh customizations into upgrade instances.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for teh health check of teh databases, and used teh notification tool to send teh alerts in OEM Grid Control.
• Intensively used tools like Sqlbacktrack,Precise,Ringmaster for monitoring database
• Proficient in Snapdrive, Flexclone technologies
• Supporting Peoplesoft Appliacation Databases for peoplesoft users for running Queries and migrating code.
• Well verse in CRQ, INC and other ITIL, change management procedures
• As part of a pilot project to transfer teh database administrative activity to overseas, me have documented and coordinated with teh people overseas.
• Successfully providing 24/7 support for production, development, and test database.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Plan and acquire teh new technologies for evaluation and implementation, suitable for teh applications in regard to teh specific future requirements of teh company's business projections and growth.

Confidential

Oracle DBA

Environment: Oracle Applications 11i, R12, Oracle 8i/9i/10g, SQLPlus, Oracle OEM, RMAN, Toad, Red hat Linux, IBM AIX, Solaris, HP-UX, and Windows.

Responsibilities:

• Upgrades from 10.7 to 11i, 11.0.3 to 11i, 11.5.x to 11.5.10.2 and 11i to R12
• Upgrade of oracle databases from 8i to 9i & 9i to 10203.and 11g.
• Character set conversions using CCSCAN, Platform migrations & OATM Conversion.
• Cloning teh Oracle Applications using Rapid clone utility (11i and R12).
• Apply and document Oracle applications patches using Adpatch and troubleshooting.
• Experience in Autoconfig to change configuration in Applications.
• Add additional nodes using Rapid Clone Utility and Configure teh Shared Apps/Appl Tier.
• Load Balancing & PCP configurations.
• Maintaining teh Oracle Applications using Auto Patch, Ad Admin, Ad controller, Autoconfig, Rapid Clone, Relink, License Manager and Ad Splicer etc Applications utilities.
• Monitoring Concurrent requests and troubleshooting
• Working with Cemli Team and migrate teh customizations into upgrade instances.
• Licensing new products and new languages using License manager and adding Off Cycle products using adsplice.
• 10g Discoverer Installation and Upgrade
• Database backup, restore and recovery.
• Tuning teh database using database utilities like ADDMRPT, SQLTRPT.
• Working with Support to resolve teh issues like Upgrade issues and Post Upgrade issues.
• SR creation and Monitoring.
• Find teh bottlenecks using oracle scripts to see load and CPU usage.
• SOA suite, SSO, OID integration.

Confidential

Database Administrator

Environment: Oracle 10g,9i/8i, SQL Plus, Oracle OEM, RMAN, Red hat Linux & Windows, Shell scripting,.

Responsibilities:

• Helping to teh developing team and data warehousing team.
• Writing complex queries and procedures using sql *plus and toad.
• Developed shell scripts and automated nightly jobs using crone to schedule teh backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk me/O.
• Managing archive logs, DB-links, partitions.
• Oracle Database tuning using SQL Auto trace, TKPROF, EXPLAIN PLAN for teh Better performance.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.