SOHAIL AHMED

Document Sample
SOHAIL AHMED Powered By Docstoc
					Profile – Sohail Ahmed                                                    0548460473



SOHAIL AHMED
Mobile: 0548460473                       Email: sohailahmed.app@gmail.com

Experience Summary

    Around 5 Years of Experience as an Oracle Database Administrator.
    Presently working in Specialists for Computer Systems (Riyadh, Saudi Arabia) from
     Last two year as an Oracle Database Administrator on both Windows and Linux
     platform. Administered and maintained database on the Production server.
     Performed the cloning of Production instance using RMAN for Test, Dev
     environment.
    Oracle Apps DBA experience includes planning, Installations, configuration and
     Maintenance of Oracle E-business suite 11i and R12.

Hands on Experience

    Installation and maintenance of Oracle database on UNIX, Solaris and Windows
     Environment.
    24 * 7 Production DBA including maintenance and troubleshooting.
    Performing periodical Backup,Restoration and recovery using RMAN full &
     incremental backups.
    Experience in Hot and cold cloning using Rman.
    Writing RMAN Backup Scripts, monitoring weekly/daily backups.
    Create, configure and utilize Recovery manager catalog (RC).
    Implemented standby database (Data Guard) for production database. Setup and
     successfully performed active failover in the event of production failure.
    Performance Tuning of SQL statements and database using tools like Explain plan,
     Tkprof, Statspack and AWR.
    Tuning SGA, Initialization Parameters and Database size tuning.
    Installation of cluster software.
    Implemented RAC in 2 node environment.
    Migration of Database from Non-Cluster to Cluster environment using Rman.
    Good knowledge in taking backup of OCR and VD (voting disk) files.
    Added node for RAC Database.
    Experience in ASM on RAC.
    Applied RDBMS patches using Opatch Utility.
    Upgrade Oracle Database from 10g to 11g using DBUA and Manually.
    Monitoring database alert logs with the help of OEM and TOAD Utilities.
    Maintaining data integrity, managing profiles,Roles,resources and password security.
    Administering Oracle 10g networking such as listener.Ora and tnsnames.Ora.
    Taking Logical Full & Incremental Backups using Export/Import and Data Pump.

Education

    Bachelor of Engineer in computer Science (B.Tech) from JNTU, Hyd, A.P, INDIA.
Certifications
        Oracle Certified Associate (OCA 10g)

Technical Skills
    Operating Systems      : UNIX, Solaris, Windows 2000/2003 Server, NT, 2000, XP.
    Languages              : C, SQL, PL/SQL Basics.
    Databases              : Oracle 8i, 9i &10g, MS Access
    Tools                  : SQLPLUS, OEM, RMAN, Putty, Toad
    Oracle Applications    : Oracle E-Business Suit 11.5.8, 11.5.9, 11.5.10.2, R12
    Networking              : Windows 2000/2003 and Networking Essentials.

Experience Profile

Project # 2: Support and Maintenance of Oracle 10g on Windows & Linux Platform.

Job Title                    :   Support and Maintenance of Oracle Database Administrator
Organization                 :   Specialists for Computer Systems (Riyadh, Saudi Arabia)
Role                         :   Oracle Database Administrator
Environment                  :   Oracle 10g, 9i, Unix, Linux, Windows 2000/2003/2008 Servers
Duration                     :   July 2009 to Current Date

Responsibilities:


           Oracle Database Administration 9i, 10g on Multiple OS Platforms.
           Creating Database required for Production, Development and Test usage.
           Tablespace Maintenance like adding & increasing the size of the data files.
           Managing Password Security and Resources, Users, Privileges and Roles.
           Managing user sessions and object locks.
           Checking ALERT logs for unknown errors and troubleshooting.
           Database Logical Backups (Export/Import/Data Pump).
           Regular Refresh of Stage and Dev instances from Production using Cold Backup.
           Attending user calls and resolving them.
           Database links were created to access the data from remote databases.
           Monitoring the databases by using the Oracle Enterprise Manager (OEM).
           Generating reports using AWR/STATSPACK utility to compare the Database
            performance.
           Managing Oracle Networking using NETMGR /NETCA.
           Reorganizing the database using export and import utilities.
           Interact with Oracle Forums logged for various unknown errors especially ORA-
            600 and ORA- 7445.
           Taking Applications Backup on Tapes/Disks.
           Daily Data Base Health Check.
           Migration of data from Sql Server Database to Oracle using DB Migration Tools.
           Follow Technical Notes and Making Documentation to avoid future mistakes.
         Performing periodical Backup and Restoration and recovery using RMAN
          (full & incremental) and RMAN incrementally updated backups.
        Implemented standby database (Data Guard) for production database. Setup and
         successfully performed active failover in the event of production failure.
        Writing RMAN Backup Scripts, monitoring weekly/daily backups.

Project # 1: Support and Maintenance of Oracle E-Business suite & Oracle 10g RAC

Job Title                   : Support and Maintenance of Oracle DBA & Oracle APPS DBA
Organization                : Meotex Solutions (INDIA)
Designation                 : Oracle DBA & Application DBA
Environment                 : Oracle 10g, 9i, Linux, Solaris, Windows Servers
Duration                     : April 2006 to May 2009

Responsibilities:

      Installation of cluster software.
      Implemented RAC in 2 node environment.
      Migration of Database from Non-Cluster to Cluster environment using Rman.
      Good knowledge in taking backup of OCR and VD (voting disk) files.
      Added node for RAC Database.
      Start/ stop cluster services (automatically / manually on reboot).
      Check registered cluster resource status, cluster health status and cluster log analyzing.
      Administering and Managing production databases in 24/7 environment.
      Installation and maintenance of Oracle database 9i/10g on Unix & Linux Servers.
      Tablespace Maintenance like adding & increasing the size of the data files.
      Managing Password Security and Resources, Users, Privileges and Roles.
      Administered and maintained database on the Production server. Performed the cloning of
       Production instance using Rman for Test, Dev and Stage environment.
      Database Logical Backups (Export/Import/Data Pump).
      Implemented various Database Backup Strategies like export & import, hot, cold and
       RMAN backups.
      Oracle Apps DBA experience includes planning, Installations, configuration and
       Maintenance of Oracle E-business suite 11i
      Patching the 11i instance for product enhancements, resolving bugs etc.
      Cloning using Rapid clone utility.
      Used FNDCPASS to change passwords.
      Maintaining Oracle Application File System and Database using AD Utilities Like
       adadmin, adctrl, adpatch, adrelink and autoconfig
      Restarting Processes, Managing workers Processes, Server processes, Compiling invalid
       objects, Re-linking AD Executables.
      Sysadmin activities like Creating Users and Assigning Responsibilities.

Personal Profile
Name                             : Sohail Ahmed
Nationality                      : Indian
Religion                         : Islam
Date of Birth                     : 14-05-1984
Marital Status                    : Single
Passport Status                   : Valid
IQAMA                             : Transferable

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:11/1/2011
language:Spanish
pages:3