Oracle Manager
Resume:
Apps DBA
Resume
Siddiqui Dilshad Azharuddin
Apps DBA
Experience: 3+ Years
Contact: +966-*********/+966-*********
***********@*****.***
Career Objective:
With the knowledge in Databases & Oracle ERP technologies, coupled with strong exposure on
Oracle as Database Administrator and seeking a long term career in the organization where I can
utilize as well sharpens my knowledge in Oracle Database management systems.
Summary:
Good at daily Database / ERP Administration activities.
•
A competent professional with an overall experience of 3+ years in Oracle Applications
DBA (1 Year as Oracle DBA & 2+ Year as Applications DBA)
Installation of ERP 11i & R12, several 9i,10g & 11g databases in different environments
•
Managing physical and logical backups
•
Backup using RMAN
•
Trouble shooting of Oracle database
•
Defragmentation of the Oracle Database
•
Cloning, Patching on Prod to Dev & Test
•
Good knowledge in AD utilities and Patching
Frequent monitoring of the database to look for any resource drain as well as any runaway
•
processes effecting the system response time
Very proficient in Oracle on line/off line backup and recovery principles
•
Tuning the databases using AWR, ADDM reports
•
Excellent communication and a very good team player
•
Knowledge of RAC
•
Work Experience:
Page 1
Apps DBA
Currently working in a leading Carpet Manufacturing Organization, Jeddah, KSA as
“Oracle Apps DBA”:
Designation : Oracle Apps DBA
Duration : Nov 2008 to Till Date
Creating database and table spaces
Adding and resizing datafiles
User administration
Enabled the database in archive log mode
Supported in Configuring RMAN (Recovery Manager)
Planning and Performing Daily, Weekly and Monthly RMAN Backups
Archival management issues
Cloning of PROD to DEV & TEST using Rapid Clone.
Generating the AWR, ADDM reports for tuning the database
Taking oracle traces & providing the output of Tkprof & Explain plan utilities to the
development team and to Oracle Support.
Export & Import utility for backup purpose and distributing the tables in multiple
environments.
Moving Data between Database using utilities like Export/Import, Sql * Loader and
Transport Tablespace.
Database Patchset Application (RDBMS Upgrade)
Working on OEM for regular database maintenance.
Oracle E Business Suite System Administration
Performing Oracle E Business Suite Patch administration, review, testing, and deployment.
Monitoring Concurrent Manager processing.
Day to Day database activities like Space management and resolving DB errors.
Application Developers requests as database tasks in Production Environment.
Maintaining and Monitoring Backup activities.
Installation of Oracle E Business Suite (Single & Multi node)
Maintenance of Oracle Applications using AD Admin.
Oracle E Business Suite System Administration.
Bouncing application services like CCM, Apache Forms Server Listener DB etc.
Changing APPS user and SYSADMIN password using FNDCPASS periodically to ensure
security.
Parallel Concurrent Processing (PCP)
Managing Concurrent Processing, monitoring concurrent batch jobs, defining work shifts
incompatibilities and additional managers.
Page 2
Apps DBA
Troubleshooting CCM and Apache issues.
Plan growth and changes (Capacity Planning)
Changing database id (DBID) using nid utility for UAT and TEST database.
Performance tuning/monitoring. (Locking issues, Request running longer, taking hang
analysis etc.)
Rendering support for the PROD, TEST, DEV Instances.
Configured OSW (Operating System Watcher) tool to monitor OS resources.
A team player with strong communication, team leadership, organizational and relationship
management skills, with expertise in interfacing with international project teams for successful
execution of projects.
OEM 10g Grid Control installation and configuration.
Worked on backup tools such as HP Data Protector
Collecting RDA and uploading to Oracle.
Weekly maintenance window.
Perform general technical trouble shooting and give consultation to development teams
Well versed in ALL Oracle backup and recovery scenarios.
Providing Offshore Support Round the clock.
Configured 85 Branch Servers for the Point of Sales Application with Oracle 10g Database
which is integrated with Oracle EBS R12.
Point of Sales Server performance monitoring, synchronization issues and other
administrative task.
Backup & Cloning of Point of Sales Servers.
Worked in Integrated Auto Plastics Systems, India Pvt. Ltd as “Oracle DBA”
Designation : Jr. Oracle DBA
Duration : Jan 2007 to June 2008
Role:
Creating database and table spaces
Creating tables, views and indexes whenever needed
Adding and resizing datafiles
User administration
Ensuring Database security by managing uses & profile
Enabled the database in archive log mode
Online Database Backup, Archived redo log files and Offline backup
Planning and Performing Daily, Weekly and Monthly RMAN Backups
Page 3
Apps DBA
Archival management issues
Refreshing development/test database from production using Export/Import
Moving Data between Database using utilities like Export/Import, SQL * Loader and
Transport Tablespace
Creation of database links & materialized views
Auditing (privilege, object, statement levels)
Cloning of database for testing purposes
Dealing with the Row migrations, Row chaining
Generating the AWR, ADDM reports for tuning the database
Taking oracle traces & providing the output of Tkprof & Explain plan utilities to the
development team
Assisted in Configuring Dataguard
Export & Import utility for backup purpose and distributing the tables in multiple
environments.
Maintaining Archive logs and their spaces for routine administration alert and trace
monitoring
Managing the space, monitoring the Free Space
Oracle E Business Suite:
Performing Oracle E Business Suite Patch administration, review, testing and
deployment.
Creation of Users and assigning the responsibilities.
Oracle E Business Suite System Administration.
AD Utilities
Skill Set:
ERP : ORACLE APPLICATIONS 11I, R12
RDBMS : ORACLE 8i,9i, 10g & 11g
Tools : Toad, Putty, SQL*PLUS, OEM, RMAN
Operating System : Linux AS 3 4 5, Solaris 9 10, Windows XP,2000, 2003.
Languages : C, C++, VB 6.0, HTML, SQL.
Applications : Word, Excel, PowerPoint, Outlook, Internet Browsing
Page 4
Apps DBA
Academics:
:
Master of Computer Applications (M.C.A) passed in First Division from Dr.
B.A.M. University, Aurangabad, India.
Diploma in Unix Administration
Diploma in Oracle Database Administration
Personal:
:
Name : Siddiqui Dilshad Azharuddin
Fathers Name : Nooruddin Javeed
Marital Status : Unmarried
Nationality : Indian
Date of Birth : 21 February 1985
Residential Permit : Valid and transferable
Page 5
Contact this candidate