Oracle Apps DBA / Oracle DBA / Oracle eBusiness DBA

Aashish Kapoor

Email: *****.******@*****.***

Ph: 1-612-***-****

_____________________________________________________

Role Desired

Application DBA / Technical Lead as Oracle apps - Oracle DBA / DB Architect

Skills Summary

10+ years of extensive IT Experience, 7+ Oracle DBA (7.x / 8.x / 8i.x / 9i.x / 10g.x) experience in Implementation, administrating, architecting and troubleshooting single instance databases and clustered databases in Production, Support and Development environments.

Installation, migration, SQL tuning, DB tuning, backup and recovery, RMAN, data load / unload, SQL*Loader, Exp, Imp database security, replication, standby DB, OEM/OMS, DB designing, VPD, Net8, listener, SQL-PL/SQL, Partitioning, RAC, Standby / Data Guard.

7+ years of Oracle APPS DBA (APPS R12/R11i -11.5.x) experience in administrating and troubleshooting Oracle Apps Instances in single and multi node environments and with RAC/OPS environment.

Installation / Implementation, patching, cloning single node to multinode/multinode to single node / RAC cloning with application, concurrent manager, Maintenance Pack application, JDK, JInitiator, Dev6i upgrade and handling day-to-day APPS DBA tasks, Discoverer, Workflow admin.

7+ years of strong exposure to UNIX and Windows platforms (Sun / Linux / HP /IBM AIX Win-2k / Win-XP) to handle regular Sys Admin activities to support Oracle Databases and Oracle Apps Instances installed on Unix/Win boxes.

OS installation, File system maintenance, License management, Patch application, Installing 3rd party SW, User maintenance, Performance Monitoring of CPU, Disk and Memory usage, Shell scripting.

Have good analytical and troubleshooting skills with PROVEN track record in highly demanding and challenging endeavors with support of thought and results leadership in technical areas with strong people and relationship leadership skills.

IT Skills

Databases: Oracle 7x, Oracle 8x, Oracle 8ix, Oracle 9ix, Oracle 10gx, Oracle 11g

Operating Systems: Sun OS 5.8 Linux RHAS 2.1/8.0/9.0, OEL 4/5, Win NT/2000/XP, HP-UX

Hardware: Dell Edge 2980, Sun E–4500/10000/450, HP-9000, HP Netserver LT 6000r, Dell Power Edge, Compaq

Programming Languages: C, C++, JAVA, PL/SQL, PERL

ERP/CRM: Oracle APPS R11i (11.5.x), Release 12, Baan 4c4

Other Tools: D2K , OAS, 9iAS/10G AS, Apache, Crystal Report

Qualification

MCA (Master in computer Application)

PGDIT (Post Graduate Diploma in Information and Technology)

B.Com (Bachaelor in commerce)

Certifications

Oracle Certified Database Administrator Professional(OCP) in version 10g/9i/8i

Sun Solaris Certified 8

IBM DB2 Certified Database Administrator

Microsoft SQL server certified.

Professional Experience

Employer: L1ID Biometrics, MN

Role: Principal Oracle Application DBA

Duration: Feb 2009 to Till Date

Responsibilities during this Projects:

ط Migration of 11.5.10 application single node database to RAC 10G application with shared application on Linux GFS file system.

ط Implementation of Agile 9.2.2.6/9.3.0.1 application and integration with 11i application.

ط 10G Grid control setup.

ط 10G Discoverer setups with 11i application.

ط Regular activities: cloning, patching, backups using RMAN, day to day trouble shooting.

ط Implementation and integration of SSO/Portal with 11i Application.

ط Implementation of High Availability solutions: 10G/11G RAC, Disaster Recovery.

Employer: ARROW Electronics

Role: Oracle Application DBA

Duration: Nov 2008 to Feb 2009

ط Support and implementation of Oracle Application 11i/R12 with shared application.

ط 10G Grid control setup.

ط 10G Discoverer/OBIEE setup and support.

ط Regular activities: cloning, patching, backups using RMAN, day to day trouble shooting.

ط Implementation and integration of SSO/Portal with 11i Application.

ط Implementation of High Availability solutions: 10G/11G RAC, Disaster Recovery.

ط Regular task includes patching on multi node / single node / RAC, Cloning on multi node to single node / single node to multi node / RAC to RAC clone / RAC to single node clone, Installation of Oracle eBusiness suite R12, 11i/Installation of 10G application server/ Oracle Database, Workflow configuration, Discoverer configuration, Backups using RMAN, Solution of Performance issues, Troubleshooting various issues like Concurrent manager / Discoverer / workflow, Configuration of shared application.

ط Involved in various stages of the Oracle Database Administration Life cycles (Installation, migration and Upgrade, Applying Patches) and provided 24*7 Support when on call.

Employer: Genome International Corporation

Role: Oracle Application DBA

Duration: Aug 2008 to Nov 2008

ط Migration of 11.5.10 application single node database to RAC 10G application with shared application on Linux GFS file system.

ط Release 12 implementation and integration with Demantra.

ط 10G Grid control setup.

ط 10G Discoverer setups with 11i application.

ط Regular activities: cloning, patching, backups using RMAN, day to day trouble shooting.

ط Implementation and integration of SSO/Portal with 11i Application.

ط Implementation of High Availability solutions: 10G/11G RAC, Disaster Recovery.

Employer: Oracle corporation, USA/India

Duration: Apr 2005 to July 2008

Role: Senior Consultant

Responsibilities during this Project:

ط R12/11i installation/upgrade/administration/Support of single node/RAC with 10G RDBMS version with and without shared application.

ط OBIEE setup as a standalone and integrated with Release 12.

ط SOA Enterprise setup with multi Oracle Home.

ط Oracle Data Integrator(ODI) setup.

ط Demantra 7.1/7.2 setup/integration with APS/ERP environment.

ط Installation of 10G application server and deploying ADF libraries.

ط 10G grid control setup/administration with Apps 11i/R12 application/10G databases.

ط SSO/Portal setup/integration with R12/Apps11i/10G Application server for development in ADF.

ط Primary responsibility is to administer production databases, offshore to continue supporting ongoing production cycles with the aim of Smooth and Successful in-time campaign executions.

ط DMZ setup with 11.5.10/Release 12 environment.

ط Design/Development of deployment software for Oracle 9i/10g RAC cluster solutions.

ط As DBA the main tasks are to have the DB available 24/7, to troubleshoot performance issues, coordinate with development team to rollout new code releases, define, document and implement DBA procedures as per Oracle standards

ط Regular task includes patching on multi node / single node / RAC, Cloning on multi node to single node / single node to multi node / RAC to RAC clone / RAC to single node clone, Installation of Oracle eBusiness suite R12, 11i/Installation of 10G application server/ Oracle Database, Workflow configuration, Discoverer configuration, Backups using RMAN, Solution of Performance issues, Troubleshooting various issues like Concurrent manager / Discoverer / workflow, Configuration of shared appltop.

ط Extensive usage of AD utilities.

ط Installation of Oracle Application 11i, R12 and Database server 8i/9i/10g.

ط Develop sql scripts / shell scripts to Automate functions and process

ط Assist in determining strategy and approach, design and conduct performance experiments in conjunction with DBA’s and R&D engineers, monitor system and database during sessions that represent typical load, review current Unix server configurations and determine changes to be made for optimum performance within product pricing constraints.

ط Involved in various stages of the Oracle Database Administration Life cycles (Installation, Migration and Upgrade, Applying Patches) and provided 24*7 Support when on call.

ط Strive to identify the areas of improvements in production operation processes to continuously improve identified areas from all dimensions.

ط Managing and Troubleshooting Data Guard, Physical & Logical Standby Databases.

ط Complete Oracle lifecycle from concept to design, architecture, hardware selection, installation and patches, database creation, backup/recovery scripting and database performance monitoring, waits, locks, enqueues tuning, automated scripted creation and refresh of reporting databases from production and mentoring developers. Utilize a large personal collection of tuning, performance monitoring and bottleneck identification scripts. Performed database modeling, design, sizing, tuning, loading with SQL Loader. Wrote triggers, created and restored backups. Wrote SQL Plus queries to monitor the database. Performed Oracle DBA work to create the total solution, process control, data acquisition, client server. database backup using RMAN.

Employer: EDS (Electronic Data system)

Duration: November 2004 to April 2005

Role: Senior Oracle Apps DBA

Responsibilities during this Project:

In this project I was involved with General Motors Co. Pvt Ltd for the support of Oracle Application and OLTP Databases / Data warehouse.

Environment: H/W: Sun/Dell, O/S: Sun OS 5.8, IBM AIX, and Linux OS: Oracle 8ix/9ix/10g, Tools: OEM, First Logic, BMC and VERITAS.

ط Main responsibility was to provide consulting services to Oracle clients worldwide to help enterprises keep Oracle Databases / Oracle Applications running in situations of any Critical DB issues to scheduled upgrades to unscheduled outages.

ط Provided DB consultation in areas of RAC/OPS, DB corruption, Application/SQL tuning, DB tuning, Oracle internal errors, Migration, Installation, Patch application, Backup and Recovery and day-to-day DB issues.

ط Worked as liaison between Oracle Development Team, DDR team and Customers to collect technical details, provide them to DDR and Dev Team, and finally implement bug fixes in Customers production/development environments.

ط Later grew as a strong team contributor in Performance Tuning as primary competency and High Availability as Secondary to support only Severity One (Most Critical) issues in production environments.

ط Upgraded skills in APPS 11i to support Oracle APPS 11i issues with Apps Support Team in areas of Installation, patching, cloning, concurrent manager, Maintenance Pack application, JDK, Jinitiator, Dev6i upgrade and day-to-day APPS issues.

ط This includes guiding oracle clients for best practices to follow, after understanding the depth and criticality of issue, then defining the best, less complicated, less time consuming solution and finally implementing it on customers production/development environments.

ط Contributed to update Oracle’s technical knowledgebase (WebIV) with any undocumented problem-resolution scenario to document any new topic in Oracle as a Metalink Note.

Employer: Polaris Software Lab. Pvt Ltd

Duration: Apr 2004 to Nov 2004

Role: Senior Oracle Apps DBA

Role/Responsibilities during this Project:

In this project I was working with General Electrical (GE) to support there Oracle Applications / Oracle Databases. This account was targeted towards building and maintaining an offshore support.

Environment: H/W: Sun/Dell/Compaq, O/S: Sun OS 5.8, IBM AIX, Linux, HP UNIX S/W: Oracle 8ix/9ix/10g, Tools: Toad, OEM, BMC, VERITAS

ط Principal responsibility was the administration of four development and testing databases distributed between Oracle 7.3.4 and Oracle 8i.

ط Administration activities involve creating new Oracle instances, administering users, downsizing and applying data cuts, migrating databases between Oracle versions, reviewing and applying structural database changes.

ط Was also performing general Unix administration (user creation, backups, patch application, health monitoring, disk configuration/reconfiguration etc.) of the development/testing machines.

ط Was primary point of contact to fine tune and sign-off the tune code to role out the changes into production

ط Providing Oracle expertise to team as needed to handle any complex Oracle development task.

ط Installation of Oracle Apps 11.5.8 Single Nodal configurations

ط Installation and configuration different versions of Oracle Apps like Vision, Test and PROD, copying the entire Production Database on to a new server remotely.

ط Installation of Oracle 11.5.8 Binaries on to a new location on same server using upgrade feature of Rapid Install.

ط Installation of new Database on the same server.

ط Applying Patches and Patch sets both in Preinstall mode and normal mode, applying Database patch sets.

Employer: Wipro Technologies

Duration: Apr2003 to Apr2004.

Role: Oracle Apps DBA / Oracle DBA

Responsibilities during this project:

In this project I was supporting the client databases and Oracle Application.

Environment: H/W: IBM, O/S: IBM AIX, Windows S/W: Oracle 7.3.4/8ix,

Tools: Toad, OEM, and Spotlight.

ط Import tables to different databases and perform auditing and tuning routines.

Routine admin scripts, stored procedure and triggers, periodically rebuilding indexes and space management.

ط Managed space, monitoring free space, chained rows, migrated rows.

Creation of users, roles, managing security, implement effective database security practice and procedure.

ط Applying database and application patches.

ط Upgradation database releases.

ط Migration of Oracle Application and database.

ط Installation of Oracle Application, Patching Oracle Application and cloning.

ط Patching/Cloning/Installation of Oracle Applications/Workflow Configuration/troubleshooting.

ط Performance and tuning analyzing using statspack and Bstat-Estat scripts.

ط Monitoring and tuning different instance areas.

ط SQL tuning to reduce the physical IO, response time and distributation of load to different mount points moving the datafiles.

ط Providing the solution for the wait events like latches, eneques, buffer busy wait, free buffer wait.

ط Ensuring high availability and low down time.

Employer: Unisols Infosystem

Duration: Jan 2000 to March 2003

Role: Oracle DBA

Responsibilities during this project.

In this project I was involved with in house development team to provide database support and Oracle Application support.

Environment: H/W: IBM, O/S: Windows S/W: Oracle 7.3.4/8x.

Tools: Toad, Spotlight.

ط Export & import of database tables into the different versions.

ط Installation, Patching, cloning of Oracle application to DEV/Test and Patch environment.

ط Data deploy from text file to Oracle database using SQL Loader.

ط Proactively taking part with development team for SQL tuning.

ط Creating rebuilding indexes as requirement.

ط Managing hot backups, cold backups, backups through export.

ط Tuning the parameters for better performance.

ط Database Space management.

ط Scheduling the backup jobs using crontab.

ط Recommendation for Performance Enhancement and improved response time for several databases.

ط Responsible for Installing and Configuration of Oracle new Oracle Environments.

ط Testing and Installing Oracle Patches on Production Databases

ط Designing & Modifications in Reports as per requirements

Contact this candidate