Learning Center
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Adnan Khan


									                                                                                           Adnan Inayatullah Khan
                                                                                             Mobile # : 0092 322 8283247
                                                                                            eMail :

    1997-2000   S.M. Arts and Commerce College                             Bachelors in Commerce            (B.Com)
    1995-97     S.M.Science College Karachi                                Higher Secondary Certificate     (HSC)
    1993-95     Karachi High School                                        Secondary School Certificate     (SSC)

 Technical Qualification
    Oracle Associate Master Diploma, from Oracle Education Center (Under auspices of Ora-Tech System Pvt.
    Ltd., Karachi, Pakistan. Authorized distributors of Oracle Corporation, USA)

   Oracle Certified Professional (OCP) 10g DBA
   Oracle Certified Professional (OCP) 9i DBA
   Oracle Certified Professional (OCP) 8i DBA
   Oracle Certified Professional (OCP) 8.0 DBA
   Certified Oracle DBA (8i) by Brainbench Online Certification (
   One year diploma in computer science from PETROMAN TRAINING INSTITUE main campus Karachi.

 Experience Summary

 Over seven years work experience in Information Technology discipline, including Database Administration Application
 Development and Business Process Re-engineering and Programming.

 Oct 2006 – Aug 2007         Rakeen Development R.A.K, UAE (


 Database Administration
     Installation, maintenance and upgrades of Oracle 10g
     Gathering Statistics about database performance and make corrective actions.
     Creating Users according to their profiles and assigning roles
     Design & develop database structures using (Tables, Indexes, Views, Triggers to implement Business
         Rules, Procedures etc).
     Performed backups using RMAN for easier and Well-Managed Recovery Procedures.
     Performed Hot and Cold Backups using RMAN (Incremental and full backup)
     Licensing Oracle Softwares and suggesting tools to be purchased supporting large databases.

      Key Coordinator in Oracle Financials Implementation
      Support on Oracle Customized ERP
      Further Functionality Testing and Quality Assurance
      Input Designing the architecture and flow of data.

 Network Administration

        Ensuring the provision of an efficient service for network, desktop hardware and software installation,
         maintenance and support
        Providing end user support, service request, change requirements and optimizing the resource pool to support
         business operations
        LAN Management : configuring HP Procurve switches, setting up policies in ISA server integrated with Cisco
        PIX firewall
       Storage Management
       Active Directory Administration
       Exchange Server 2003 Installation, user management and backups
       Design overall LAN & Wan Solution for the Organization.
       ADSL line administration defining appropriate access for the users

June 2001 – Sep 2006         Al Meraikhi Group of Companies Abu Dhabi (U.A.E) (


       Installation, maintenance and upgrades of Oracle RDBMS.
       Design, implementation and support of backup and recovery procedures.
       Support of multiple production, development and test environments.
       Security, audits and change-control practice, procedures and implementation.
       Performance tuning and maintenance of Oracle database.
       Creating and maintaining concurrent managers
       Defining, scheduling and maintaining concurrent processing.
       Database administration, backup and recovery and performance tuning.
       Designing and planning of database, which involves deciding about logical storage structures and
        forecasting future expansions.
       Creating and managing Schema Objects/Security of Database.
       Managing physical and logical storage structure
       Security Administration by creating Users with appropriate ROLES and PRIVILEGES.
       Creating Stored Procedures, Functions and Database Triggers.
       De-fragmentation of database.
       Optimizing the SGA and Shared Pool Size.
       Optimized INIT.ORA parameters to best utilize the new system's resources.
       Support and development of customized HR,Gl and Inventory application.
       Implement policies & procedures to meet the business rules.
       Installation, Maintenance and troubleshooting of Network (LAN, WAN)
       Support and Implementation of Oracle Customized ERP (Modules : GL,Payroll,Inventory)

June 2k – May 2001          Intralink Systems, Karachi (Pakistan)
 Role                      Assistant DBA cum Software Developer
 Front End                 Developer 2000 4.5 / 5
 Back End                  Oracle 8.0
 Platform                  WinNT (Server), Client (Windows 98)

          I was involved in Full Software Development Life Cycle for two projects.
          Worked as an Assistant DBA in the project, leading a team of 4 developers.


  Name of the Project                 Payroll
  Duration                            3 months
  Client                              Intralink Systems Karachi Pakistan.
  Programming Environment             Developer 2000 Oracle Forms 5,Oracle Reports 3
  Platform                            Windows NT 4.0
  Back End                            Oracle 8.0
  Team Size                           4
  Role                                Assistant DBA.

The payroll accounting software was developed with the requirements of the contracting industry kept in mind. The
module takes care of the different projects an employee can be working during the month their passport/Labour
Card/ Visa/ Contract expiry details, calculation of Leave Salary, Gratuity and Final Settlement including details of
Increments/ Termination/ Absconding etc. Right from Card entry to payroll processing to printing the different reports,
the program does it all, thus enabling the management to keep track of the employees more effectively
 Assist DBA in Administration tasks, designing of database physical and logical, Creating and managing Schema
Objects, assist developers in tuning their code and take backup of the database on regular basis (export).

 Name of the Project            Production Planning & Inventory Control
 Duration                       7 months
 Client                         Abdullah Garments, Karachi, Pakistan.
 Programming Environment        PL/SQL,Developer 2000(4.5).
 Back-end                       Oracle 8.
 OS Platform                    Win NT4.0
 Team Size                      6
 Role                           Software Developer

This project was developed to maintain a database for Abdullah Garments, Karachi. This project was mainly for
Production Planning, Cost Estimation and also included inventory control. The client was a garment production
company engaged in production of the garments based on the old as well as new designs. The project included
breaking down every design to lowest possible level and preparing planning sheets for production, which are
distributed to looms and weavers for the production. The project included tracking of the seasonal designs, based on
the sales of designs in different seasons and also in different locations.
      Participated in project team meetings for designing database tables.
      Developed procedures for different modules and written database triggers in PL/SQL.
      Development of Order Forms, and Forms for Stock maintenance and inventory in Developer


       Worked freelance on Census 2006 UAE project as an Oracle DBA particularly to monitor the standby
        database and make corrective actions to avoid logwait incase of bulk entries.
       Due to my excellent performance appreciated by the management of Al Meraikhi Group of Companies I was
        promoted to an IT Administrator position.

Skill Set
Database(s)                Oracle 7/8/8i/9i/10g (Enterprise Editions)
Platforms                  Windows 2003 Server/Windows 2000 Adv. Server/ WinNT/win
                           9x/ Linux
Languages                  Oracle 7/8/8i/9i/10g (SQL/Pl Sql)
Tools                      Oracle D2k, Crystal Report (With Oracle/SQL Server)
Backup Tools               Brightstor ArcServe Ver. 11.1

Available upon request.


To top