Sr Oracle DBA

Amreen Sarwar Sayyed, Oracle Applications DBA

******.*******@*****.***

Mobile: +91-888*******

Possess around 9+ years of IT Exposure, Primarily as an Oracle DBA and Apps DBA on UNIX, Linux, and AIX in Production and development environments. Holds Hands on experience in setting up High availability architectures using various products and methodologies from Oracle including RAC, Data guard, ASM, RMAN. Expertise in optimizing and tuning Oracle databases. Experience in the Implementation and support of Oracle ERP 11i/R12, Oracle Access Manager 11g, Oracle Identity Manager 11g, Oracle Internet Directory 11g and Oracle SOA 11g. PROFESSIONAL PROFILE

Oracle E-Business Suite R12/R12.2:

Expertise in Implementation/up-gradation/troubleshooting/support/patching of oracle high volume production databases and Applications (E-Business Suite).

Expertise in Implementation/Configuration/Integration of SSO using Load Balancer for Oracle E-Business Suite R12/R12.2 using Oracle Access Manager 11g,Oracle Internet Directory 11g.

12C OEM installations and agent deployments

Configured DMZ for ISupplier in Oracle E-Business Suite R12.1

Extensive cloning exercises of Oracle Databases and Applications including multinode to multinode.

Oracle DBA/RAC:

Upgraded database from 11.2.0.3 to 11.2.0.4

Configured Oracle secure backups in Oracle Cloud.

Upgraded database from 11gR2 to 12.1.0.2 (Cluster Environment).

Migrated database from non-cluster file system to ASM.

12C OEM installations and agent deployments

Raising and Handling Service Request with Oracle Support

Restored database using Import/Export Utility

Amreen Sarwar Sayyed, Oracle Applications DBA

******.*******@*****.***

Mobile: +91-888*******

2

Database restoration to another server

RMAN Backup and Recovery Catalog Management

SKILLS/STRENGTHS:

● Application : Oracle eBusiness Applications11i/12, Discoverer.

● RDBMS (Database) : ORACLE Database 9i/10g/11g/12c

● Languages : SQL, PL/SQL,

● OS : Linux/SUN Solaris/AIX/Windows/Unix

● Tools : SQL*PLUS, OEM, 10g Grid, Toad

● Specialization : Oracle Database 9i/10g/11g/12c and Oracle Applications 11i/12/12.2

Work experience:

Project Client Role Duration

Maintenance and

support of

Oracle Applications

11i/R12, Databases 10g/11g/12c Knape V, US

Oracle Apps

DBA Dec 2010 to present

Maintenance and

support of

Oracle Applications

11i/R12, Databases 10g/11gr2

Forsythe, Nidec,Tuff medical,

US Oracle RAC DBA

June 2014 to

present

Maintenance and

support of

Oracle Applications

11i/R12, Databases 10g/11gr2

Dollar tree, Kidspeace, Twitter,

US

Oracle Apps

DBA

June 2014 to

present

Education, Certification & Training:

Bachelors in Computer Applications from Pune University.

Master of Computer Application from Pune University, Pune in the Year 2014.

Oracle DBA Certified Associate (OCA) 10g

Amreen Sarwar Sayyed, Oracle Applications DBA

******.*******@*****.***

Mobile: +91-888*******

3

Oracle certified professional (OCP) with 10g

RAC Certified

Oracle Apps DBA & RAC DBA Responsibilities:

Handling On-call production support

Sysadmin activities, Cloning, Patching on Oracle Apps 11i and R12 environment.

Used Oracle application tools for maintaining application like adpatch, adadmin, adctrl etc.

Good Knowledge over Linux, Solaris,AIX

Configured Workflow Notification mailer.

Configured Oracle Alerts.

Database Cloning and Application Cloning.

Database upgradation (manually as well as using DBUA).

Expertise in patching, cloning and AD utilities.

Managing concurrent managers.

Creating users, Responsibilities, Menus and Managing profile option.

Installing and configuring printers from O.S and Oracle application.

Network Administration (configuring listener.ora and tnsnames.ora).

Have work experience on Stand Alone and RAC environments.

Have a good Working knowledge with database architecture and RAC Architecture.

Responsible for Installation, Up gradation, Applying Patches, Cloning(Both at Application & Database level),Trouble Shooting,SQL Tuning, Configuring Data Guard in High Performance, Availability and Protection Modes.

Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups, Logical Backups..

Have Good Knowledge/experience on Explain Plan, Tkprof and performance tuning.

Considering future growth, reorganization of database and space management of database as per need.

Managing Users, Password Security, Roles, Privileges and Resources. Amreen Sarwar Sayyed, Oracle Applications DBA

******.*******@*****.***

Mobile: +91-888*******

4

Creation of DB link for access the remote database objects. Oracle RAC DBA Responsibilities:

Handling On-call production support Architecture, Installation, Cloning and Patching in Oracle e-Business Suite.

Upgradation of 10g to 11g Databases.

Upgradation of 11i to r12.Upgradation of 12.1.1 to 12.1.3.4

AD Utilities AD Admin, AD Patch, AD Controller etc.

Applying RDBMS (O-Patch) and Application patches.

Configured Customization Environment.

Managing Table spaces and Data files.

Performing daily health checks.

Configured Oracle NET on server and client machines.

Checking database locks and clearing the blocking sessions.

Worked on user managed backup strategies like online and offline backups.

Used logical backups (export/import) for backing certain tables and schemas.

Implemented Backup and Recovery strategies using RMAN(migrated from user managed backup to RMAN)

Changed from full database backup to incremental backup.

Worked on RMAN scripts.

Performing Cloning of databases at regular intervals.

Applying interim patches and patch set patch.

Configured standby Database and performed the necessary troubleshooting.

Tuning Memory structure like Shared Pool, Buffer Cache and Redo Log Buffers.

Purging the obsolete data to enhance performance.

Troubleshooting general issues like DB connectivity issues and user login issues.

Troubleshooting data corruption issues.

Amreen Sarwar Sayyed, Oracle Applications DBA

******.*******@*****.***

Mobile: +91-888*******

5

Gathering statistics.

Generating and analyzing automatic workload repository and stats pack report.

Checking for invalid objects and compiling them.

Applied HRMS patches.

Troubleshooting Application Errors related to Forms and Reports.

Hot backup/Cold backup cloning using Rapid Clone.

Good Hands on OEM

Having good knowledge on Backup & Recovery.

Set Cold and Hot backup of Database instances on HP Data protector (scheduler).

Good command over shell-Script writing.

Monthly and quarterly maintenance tasks.

Administer and troubleshooting Concurrent Managers.

Proactive server monitoring and Alert management

Document and prepare the end to end scenarios for impact of enhancement and test the same in dev and testing environments along with QA and implement in production.

Production Support, Install and Up-grade of various releases of Oracle database and applications.

Oracle Application Cloning multimode to multimode via rapid clone

Cloning using rapid clone or database refresh.

Proactive monitoring of all environments and deployed alert mechanism for incidents.

Cloning oracle database and application for various environments (Test/Dev/Uat)

Configured Workflow notification mailer on the Production and Test Instances

Worked closely with developers to extend support on all development activities. Personal Information:

Marital status : Married

Date of Birth : 29-June-1988

Citizen : Indian

Driving License (UAE) : No

Spoken and written languages : English, Hindi

Contact this candidate