Highlights:

Skills:OCP, Oracle DBA, RAC, Data Guard

Technical Consultant (EBS-R12) 04/2010 - 06/2010
Xavor, LAHORE, PUNJAB Pakistan
Industry: IT
Xavor is an Irvine, California-based Management & Technology Solutions firm with Global 1000 clients, complete with an outsourcing set-up. They use a proprietary workshop-driven consultative approach to help their clients. This company is operating their business successfully in Pakistan from previous 10-years.
? Report development for all modules of application through oracle report builder or discoverer. ? Support for SQL, PL/SQ, Form, Report, Discoverer & XML publisher. ? Forms customization and personalization for application. ? Query tuning and optimization. ? Good understanding of APPS application schema--
Specialist (Database) 07/2009 - current
ORASCOM TELECOM (Mobilink-Pakistan):, LAHORE, PUNJAB Pakistan
Industry: IT
Here, I am appointed as a specialist (database) and monitoring large databases on 24x7 support commitment. Here, I am totally responsible for smooth operations of database, TL & application (Oracle EBS-R12) on 0 tolerance level.
? Establishing the needs of users and monitoring user access and security. ? Monitoring performance and managing parameters to provide fast query responses to 'front end' users; ? Mapping out the ‘conceptual design’ for a planned database in outline; ? Working as a Technical Consultant for their applications (Oracle EBS-R12). ? Considering both 'back end' organization of data and 'front end' accessibility for end users; ? Refining the ‘logical design’ so that it can be translated into a specific data model; ? Further refining the ‘physical design’ to meet system storage requirements; ? Installing and testing new versions of the database management system (DBMS); ? Writing database documentation, including data standards, procedures and definitions for the data dictionary (‘metadata’); ? Controlling access permissions and privileges; ? Developing, managing and testing backup and recovery plans. ? Ensuring that storage, archiving, backup and recovery procedures are functioning correctly; ? Capacity planning. ? Working closely with IT project managers, database programmers and web developers; ? Communicating regularly with technical, applications and operational staff to ensure database integrity and security; ? Commissioning and installing new applications. ? VERITAS Netback Administration-SUN-Storagetek L-700. Netbackup environment configuration, client, upgradation, OpsCenter, storage units, volume pools, duplication and Media Management.--
Oracle DBA / EBS-R12 Technical 07/2008 - 07/2009
SERVIS INDUSTRIES LIMITED (SIL), LAHORE, PUNJAB Pakistan
Industry: IT
. I am appointed as Oracle DBA in Head Office, Lahore and my core responsibilities are for database & application administration and also fully support to implement EBS.R12 modules in whole industry. Currently, we have implemented successfully financial and Supply Chain Management (SCM) modules
? Database & application administration. ? Database and application configuration on separate nodes. ? Hardware recommendation for EBS-R12. ? Responsible for database & application backup and availability. ? Managing database and application security. ? Database capacity planning and tuning. ? Maintaining data-guard services for standby database. ? Managing application and database patching, cloning and upgradation. ? Seed data cleansing and interfacing for application R12. ? Database restore and recovery testing. ? Report development for all modules of application through oracle report builder or discoverer. ? Forms customization and personalization for application. ? Functional understanding for financial modules. ? Verify user requirements and deploy by the consultant. ? Good understanding of APPS application schema. ? SQL, PL/SQL, Form, Report, Discoverer & XML publisher training to junior developers. ? Managing in-house develop HR-Payroll System--
Oracle DBA / Developer 07/2003 - 07/2008
PHARMAX PAKISTAN (PV) LTD., LAHORE, PUNJAB Pakistan
Industry: IT
. I was appointing as DBA / Developer in a U.S based Pharmaceutical retailer chain company. This company is operating 57-outlets all over the Pakistan including three warehouses. Here I am responsible for all departments computerize automation including their modules inventory, accounts, HRM and centralize. Inventory, centralize and account modules have completed and running successfully at their territories. Now, I am working on HR modules which will be finalized in April, 2008. All these modules are integrated (ERP) with each other and performing their functions efficiently.
? Responsible to design database architecture for all kind of software modules. ? Database Troubleshooting and monitoring. ? Database backups and recovery operations through RMAN. ? Diagnose problem and apply patches if needed. ? Software support for all modules all over the Pakistan. ? Generate new ideas which can improve company efficiency level. ? Monitor company I.T resources and recommendations for up gradations. ? Monitor the all operations of software for whole company. ? Also behaving as a System Analyst. ? Responsibility for staff training and software implementation. ? Responsible to communicate with all staff and provide problem solutions as per company policies. ? Responsible for software quality and performance. (Note: All software modules developed by using Oracle.9i.r2 (DB) and Developer / Reports 6i/9i)--

UNIVERSITY SOUTH ASIA 01/2000 - 12/2003
, , Pakistan
Degree: Bachelor's Degree
Major:DATABASES
.

Irfan_USA_NEW Oracle DBA Apps DBA