Curriculum Vitae

Muhammad Asif Qureshi

Residence: Dammam – Saudi Arabia

Mobile: 009**-*********. Email: ac318d@r.postjobfree.com SENIOR ORACLE DATABASE ADMINISTRATOR

&

System Administrator

Over 7 plus years experience in Database Administration on Solaris, Windows platforms. Extensive Knowledge and experience of Oracle database 10g/11g/12c & third party Tools

& Utilities.

Performed Logical and Physical database design. Monitored databases using performance and Edge diagnostic utilities.

Designed strategies for performing database backups and recovery.

Migrated data between different Oracle software versions, platforms and other database products.

Experience in administering,monitoring,configuring Vertias Netbackup & Backup Exec on Windows,Solaris Sparc.

Experience in administering Windows 2012 servers on virtual machine using windows hyper-v.

HARDWARE & SOFTWARE SKILLS

Databases: Oracle 10g/11g/12c, MySQL, SQL Server 2012/2008, Mysql, MS Access. Hardware: Sun M5000 Cluster Server, Sun Fire V1280, Sun Fire V240, HP Blade c7000 enclosure Server,HP Proliant DL380G7 server,HP Proliant DL380G7 Server Dell Desktop, Apple, HP LTO-4, Sun StorageTek SL24.

Storage : Sun Stor Edge 3500, Sun StorageTek 6100, HP P2000 G3 San, Lacie, iomega. Networking: Cisco 2800, Astaro Security Gateway.

Operating Systems: Windows 2012,2008,2003 Solaris Sparc 10/11, Mac OSX, Linux Suse Enterprise 10/11.

Applications:Baan ERP, Lotus Notes, MS office 2010. Backup: Netbackup 7.5,BackupExec 2010, Windows Backup Tool. EDUCATION

MBA Master in

Business

Administration with

Specialized in

Information

Technology.

University of East Hyderabad Sindh – Pakistan 2006 Bachelor in

Commerce

University of Sindh – Pakistan 1999

PROFESSIONAL EXPERIENCE

Al-Rashoodi & Partners Holding Company (AFI Groups) AFI is one of the largest and most diverse industrial companies in the Arabian Gulf which has various subsidiary companies with diverse business interests. SR.ORACLE DBA & SYSTEM ADMINISTRATOR 2004 – Present Dammam- Saudi Arabia,

www.afi.com.sa

Responsibilities:

• Architecting, designing, developing and supporting RAC environment.

• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware).

• Troubleshoot performance issues for the RAC instances (GC events).

• Upgrade of 10g R2 RAC to 11g R2 RAC.

• Add or Remove Node from RAC.

• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.

• Experience with ‘graceful’ switchover and switchback between primary and standby databases.

• Replicated to a disaster recovery site for increased server manageability and availability.

• Installed & configured Oracle 10g,11g,12c database on Oracle Virtual Box in Production & development environment.

• Created primary objects such as tables,views,indexes and modified control space allocation for tables.

• Analyzed tables to generate statistics and query the data dictionary for relevant table information.

• Participated to develop a plan for high availability, data protection and disaster recovery for enterprise data.

• Installed Oracle database instance, expended initialization parameter file and created and managed the operating system file that comprise database storage for data guard configuration in development environment.

• Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.

• Developed scripts for database startup and shutdown, tune the rollback segment and multiplex control communicated and interfaced with Oracle support visa meta link troubleshoot day-to-day database issues.

• Designed and developed and Oracle database constraints, and triggers to support and Internet client.

• Loaded the client's data into database and executed performance tests using SQL & data loader tool.

• Enrolling users and maintaining system security, develop database monitoring and performance tuning strategies. Write script to automate routine administrative tasks.

• Monitoring and optimizing the performance of the database.

• Monitoring Oracle database through third party tool Spotlight software.

• Performed user recommended enhancements for quicker queries and performed daily,weekly and monthly checks of Oracle database.

• Upgraded Oracle 10g database version to 11g database on solaris sparc environment.

• Migrated Sql Server 2008 database to Oracle 11g database using sql developer tool.

• Performed database cloning for development and server migrations.

• Upgraded Oracle database patches.

• Backup and Recovery using Oracle’s RMAN tool used offline/online for recovery in a production environment via Korn shell scripting.

• Utilized logical backup (Export/import) utilities for Oracle database data movement.

• Analyzed the performance for the database and performance tuned the database.

• Communication with vendors regarding system planning and solutions, maintenance contracts, support related issues, bug reports and patches, problem reports etc. UNIX / Linux Administrator Experience :

• Installation, Disk partition, Unix File System, Auto mounting, patch/package installation, file system backups and administration.

• Installed Solaris 10 sparc 64-bit operating system using jump start server.

• Sun Cluster 3.2 Installation, Configuration and daily Administration. Monitoring Cluster status, logical host, cluster switchover, resource groups and data services. Veritas Netbackup Administrator Experience:

• Responsible for all Veritas Netbackup procedures and backup polices, setting up Master, Media and Client Servers.

• Configured multiples data backup copies on different LTOs.

• Installed patches & upgraded Veritas Netbackup versions 6.5 to 7.5.

• Configured backup & restored windows 2008 Active directory GRT (Granular Restore Technology) backup using veritas netbackup.

• Implemented a Netbackup environment using disk based backup with de-duplication.

• Restored Lotus Domino e-mail Server on Production environment using Veritas Netbackup.

• Monitoring daily,weekly backups schedule using netbackup activity monitor. Windows 2012 Server Administrator:

• Installed & configured windows 2012 servers on virtual machine.

• Installation, configuration & maintenance of workstations, servers, desktops, notebooks & network.

• Responsible for configuring and managing Windows 2012 virtual Servers backup & restore using export/import.

EARLY CAREER SUMMARY

Webiff Software development limited Company

Oracle DBA - Developer & System Admin

2003-2004

Hyderabad- Pakistan

Responsibilities:

Project School Information School:

Environment: Oracle Forms 6i,Oracle Report 6i,PL/Sql, Sql, Sql*Plus, Sql Loader Oracle8i Windows2000.

Analyzed data flow and business requirements to automation several documents management processes in the school. Wrote functional specification for the business process,designed and implemented database solution to mange students,grades,certifications,employees and payment information. The application produced variety of report and statistic information.

• Designed created and maintained Oracle Forms & Reports.

• Generated Sql and Pl/Sql scripts to install, create and drop trading exchange connection database objects including: Tables,views,Indexes,Sequences & synonyms.

• Created documentation for all aspects of the project including training the end users. Project Diagnostic Lab System:

Environment: Oracle Forms 6i,Oracle Report 6i,PL/Sql,Sql,Sql*Plus, Sql Loader Oracle8i Windows NT.

• Developed & designed Oracle forms & reports for the user interface a data load using SQL loader.

• Provided technical and user documentation.

Project General Inventory Control System:

Environment: Oracle forms 5,Oracle Report 3,Pl/Sql,Sql,Sql&Plus Oracle 8 Windows 2000. Analyzed developed and maintained Oracle forms & report for newly designed inventory system.

Designed coding specification and documentation.

• Created database multiple objects,triggers and Pl/Sql packages. PROFESSIONAL COURSES

Computer Science

Diploma

Faith College of Information Technology –

Pakistan

1999

Oracle Specialized

Course

Orasoft Education Center – Pakistan 2000

Crystal Report

Training

Conducted by AFI 2005

Veritas Netbackup

Specialized Course

Symantec --UAE 2007

Windows 2012

Server

Administration

Al Khaleej Training & Education --KSA 2013

Certified Professional (OCP)

Candidate -Id SP3230212 Oracle 8

• Sql,Sql*Plus,Pl/Sql.

• Database Administration.

• Backup & Recovery workshop.

• Network Administration.

• Performance Tuning Workshop.

PERSONAL DETAILS

Languages: Urdu (Mother tongue)

English, Arabic

Date of Birth 24/03/1978

Nationality: Pakistani

Address: Dammam KSA.

Religion Islam

Passport DL4910411 f

Status Married

Contact this candidate