Moeen Ahmed Syed

as contractor

•Manage and support the 100+ Oracle databases.
•Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
•Managing space in disk groups adding disks in DG.
•Managing table spaces, data files, redo logs, tables and its segments, Creating and Rebuilding Indexes
•Performed online activity resize of redo log files in ASM level.
•Created database manually
•Maintaining data integrity also managing profiles, resources and password security.
•Good working knowledge in performance tuning:-
• Joining performance call, monitoring the sessions and generating the AWR reports
• Pinning the better plan
•Install Oracle software and applying patches (Opatch and PSU patches).
•Managing RMAN backup jobs in crontab.
•Managing archives in RMAN restoring archives as per requirement.
•Upgrading the Database from lower version to higher version.
•Working knowledge of RAC.
•Handling Import/Export (data pump) like schema, table, full database etc.
•Attend daily change requests for Non prod and production databases.
•Working on Incidents/Changes/Tasks in Service now tool.
•Working in SR raising SR as per requirements.
•Working knowledge in OEM, and also managing space for file system in various OS.
•Attending daily flash calls and weekly cab calls for the changes.
•Managing jobs in crontab placing scripts in server.

Professional Experience Summary
Worked as Oracle Apps dba for Carillion project: (http://www.carillionplc.com)
ORACLE APPS DBA: R12
•Providing 24 X 7 Support for client
•Experienced in Applying application patches using adpatch
•Performing daily checks
•Deploying RFC in production and test databases
•Bouncing the concurrent manager.
•Applying the patches, performing cloning activity
•Increase and decreasing the size of the concurrent managers depending up on the usage.
•Knowledge on discover plus and discover viewer
•Follow-up with Oracle Product Support through Metalink for any issues that Functional Consultants raise which requires file system level log files etc.


DAY TO DAY AND MISCLLENIOUS ACTIVITIYS

CHANGE REQUEST
•Emergency, Routine Pre-Approved, CAB Changes.
INCIDENTS, TASKS
•USERS-CONNECTIVITY, TABLE-SPACE ALERTS, TROUBLE SHOOTING ISSUES.
PERFORMANCE ISSUES:
•Generating SQL-PLAN, AWR- REPORTS, ASH REPORTS, stats gathering, index rebuild.
•Checking blocking sessions, PIN HASH VALUE IN PROD prior test in stage.
SCHEDULED ACTIVITY’S:
•Up gradation, Patching (rolling fashion for cluster database), Migrating of lun’s,
Database creation (Done for single instance database (has))

Database Versions: Oracle 11g, 10g and 9i
Oracle 11G RAC, 12C OEM grid Control, 11g-Rman, Data-Guard, HEXA-DATA.
Environment: Linux, Aix, window and Sun- Solaris