Iftikhar khan, Database Administrator

Iftikhar khan

Database Administrator

EHA HOFFMANN GmbH, Excise & Taxation Dept.

Location
Pakistan - Islamabad
Education
Bachelor's degree, Computer Science
Experience
15 years, 2 Months

Share My Profile

Block User


Work Experience

Total years of experience :15 years, 2 Months

Database Administrator at EHA HOFFMANN GmbH, Excise & Taxation Dept.
  • Pakistan - Peshawar
  • My current job since October 2012

 Working on Oracle Database 10g and 11g
 Configuring simple Database as well as ASM Grid infrastructure in Linux OS.
 Perform initial software installation, setup and testing
 Working on Application Server MVRS (Motor Vehicle Registration)
 Establish and maintain sound backup and recovery policies and procedures
 Maintain software, including testing, evaluation and installation of new versions.
 Troubleshoot hardware/software problems and system failures.
 Determine and initiate appropriate and immediate actions needed to restore normal services with minimal down time.
 Extensive experience in planning, installing, Patching, configuring, and administering multiple Large Oracle databases in a Windows Server 2003.
 Develop and implement security controls and access protocols
 Implement and maintain database security (create and maintain users and roles, assign privileges)
 Installation, configuration and upgrading of Oracle server software and related products
 Data Migration using data pump, export and import utility
 Monitor DBMS backup procedures and execute recovery operations when necessary.
 Monitoring and optimizing database performance
 Monitor database log for errors and/or problem analysis for proactive action
 Maintain statistics, optimize indexes
 Hardware up gradation and configuration
 Devise and deploy disaster recovery and archiving procedures.
 Take regular backups of all local data.
 Implementing backup and recovery strategies using Hot/Cold backup.
 RMAN Backups with restoring and recovery.
 Performance tuning.
 Monitor, manage and configure all districts databases that are connected to the servers.
 Prepare documentation of systems and software for permanent records
 Perform additional duties as assigned.
 Linux configuration and new deployment of Oracle database 11g R2 for testing Enhancement
 Recently implementing the Oracle Data Guard for replication with maximum availability.
 Working on Ms Sql Server 2005, 2008.
 Working on Ms Access and Ms Excel for reporting purpose.

Oracle Database Support at Quaid-I-Azam University Islamabad
  • Pakistan - Islamabad
  • April 2012 to September 2012

 Perform initial software installation, setup and testing.
 Develop and implement security controls and access protocols
 Working on Oracle Database 10g
 Working on ERP with HEC project Campus Management Solution (CMS)
 Maintain software, including testing, evaluation and installation of new versions.
 Troubleshoot hardware/software problems and system failures.
 Determine and initiate appropriate and immediate actions needed to restore normal services with minimal down time.
 RMAN Backups with restoring and recovery.
 Implementing backup and recovery strategies using Hot/Cold backup.
 Working in application server Oracle people soft with Campus Management Solution
 Monitor DBMS backup procedures and execute recovery operations when necessary.
 Devise and deploy disaster recovery and archiving procedures.
 Extensive experience in planning, installing, Patching, configuring, and administering Oracle databases in a Linux and Windows server 2003.
 Using Ms Excel for reporting.
 Prepare documentation of systems and software for permanent records
 Take regular backups of all local data.
 Perform additional duties as assigned.

Database Administrator/ I.T Officer at Pakistan Red Crescent Society
  • Pakistan
  • January 2009 to December 2011

 Working on Oracle Database 10g, Linux base as well as windows based
 Take regular backups of all local data.
 Determine and initiate appropriate and immediate actions needed to restore normal services with minimal down time.
 Upgrade systems software as required
 Provide first level hardware maintenance & upgrades.
 Keep an up to date inventory of all IT hardware & software.
 Maintain the Local Area Network.
 Extensive experience in planning, installing, Patching, configuring, and administering multiple Large Oracle databases in a Windows2003 as well as in Linux environment.
 Manage contracts with external suppliers and service providers in IT purchasing.
 To provide hands-on support / training whenever required.
 Perform additional duties as assigned.
 Implementing backup and recovery strategies using Hot/Cold backup.
 RMAN Backups with restoring and recovery.
 Hardware up gradation and configuration.
 Working in php with mysql database.
 Ensure the reliability of the local communications system: e-mail & Internet.
 Ensure that the virus protection software is installed on all machines & updated regularly.

Education

Bachelor's degree, Computer Science
  • at University of Peshawar
  • December 2008

Bachelor of Computer Science (BCS) Computer software related University of Peshawar

High school or equivalent, Computer Science
  • at Board of Intermediate Secondary Education Swat
  • December 2004

F.Sc Pre-Engineering Board of Intermediate Secondary Education Swat

High school or equivalent, Mathematics, Physics, Chemistry, Biology
  • at Board of Intermediate Secondary Education Swat
  • December 2002

SSC Mathematics, Physics, Chemistry, Biology Board of Intermediate Secondary Education Swat

Specialties & Skills

Database Administration
Database Management
MySQL database design
Database Design
Database
BUSINESS INTELLIGENCE
DATA ENTRY
DATABASE ADMINISTRATION

Languages

Pushto
Expert
Urdu
Expert
English
Intermediate

Training and Certifications

Oracle DataGuard (Training)
Training Institute:
Oranet Training and Solution
Date Attended:
January 2012
Duration:
9 hours
PHP, Web Design, Web Development (Training)
Training Institute:
Bench Mark Institute
Date Attended:
September 2008
Duration:
225 hours
Oracle Database Administrator(DBA) (Training)
Training Institute:
Oranet Training and Solution
Date Attended:
October 2011
Duration:
225 hours
Oracle BI (Training)
Training Institute:
Oranet Training and Solution
Date Attended:
February 2012
Duration:
9 hours