افتخار خان, Database Administrator

افتخار خان

Database Administrator

EHA HOFFMANN GmbH, Excise & Taxation Dept.

البلد
باكستان - إسلام أباد
التعليم
بكالوريوس, Computer Science
الخبرات
15 years, 2 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :15 years, 2 أشهر

Database Administrator في EHA HOFFMANN GmbH, Excise & Taxation Dept.
  • باكستان - بيشاور
  • أشغل هذه الوظيفة منذ أكتوبر 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 في Quaid-I-Azam University Islamabad
  • باكستان - إسلام أباد
  • أبريل 2012 إلى سبتمبر 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 في Pakistan Red Crescent Society
  • باكستان
  • يناير 2009 إلى ديسمبر 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.

الخلفية التعليمية

بكالوريوس, Computer Science
  • في University of Peshawar
  • ديسمبر 2008

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

الثانوية العامة أو ما يعادلها, Computer Science
  • في Board of Intermediate Secondary Education Swat
  • ديسمبر 2004

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

الثانوية العامة أو ما يعادلها, Mathematics, Physics, Chemistry, Biology
  • في Board of Intermediate Secondary Education Swat
  • ديسمبر 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

اللغات

الباشتو
متمرّس
الأوردو
متمرّس
الانجليزية
متوسط

التدريب و الشهادات

Oracle DataGuard (تدريب)
معهد التدريب:
Oranet Training and Solution
تاريخ الدورة:
January 2012
المدة:
9 ساعات
PHP, Web Design, Web Development (تدريب)
معهد التدريب:
Bench Mark Institute
تاريخ الدورة:
September 2008
المدة:
225 ساعة
Oracle Database Administrator(DBA) (تدريب)
معهد التدريب:
Oranet Training and Solution
تاريخ الدورة:
October 2011
المدة:
225 ساعة
Oracle BI (تدريب)
معهد التدريب:
Oranet Training and Solution
تاريخ الدورة:
February 2012
المدة:
9 ساعات