Posted by on January 07, 19102 at 15:14:01:
Khalil-ur-Rehman
F.C Plaza, 5th Floor, SNGPL, Sunehri Masjid Road Peshawar Cantt.
Peshawar, Pakistan
Phone: 092-091-9211554
Email: rehman2000@hotmail.com
OBJECTIVE: Looking forward to a challenging position as Oracle D.B.A.
Computer Skills:
Certification: OCP (DBA TRACK) Oracle 8.0
Candidate ID : SP3163782
Databases: Oracle 8.0.
D.B.A Tools : Security Manager, Storage Manager, Data Manager, Backup Manager,Schema Manager ,Instance Manager. NT Back up and Recovery Manager, Oracle Database Assistant, Oracle Net 8.0 Assistant.
Development Tools: DEVELOPER 2000 (Forms 5.0, Reports 3.0,
Graphics 3.0). SQL *PLUS, SQL *FORMS, SQL *REPORTS, SQL*MENU, SQL *GRAPHICS.
Languages: SQL, PL/SQL, C++, Pascal and COBOL
Web Development: HTML, JavaScript.
Operating Systems: Windows NT, Windows 95, UNIX, and DOS.
Office Auto. Tools: MS Office 2000.
Technical Qualification: Master’s Degree in Computer Science from Gomal
University D.I.Khan, Pakistan (1996).
Total IT Experience: 5 + Years of experience in Database Administration (D.B.A) and also have experience of Database systems development as additional.
(1)Organization: Sui Northern Gas
PipeLines Ltd.(S.N.G.P.L) (Sep 2000 to Date).
Present Position: Senior Database Administrator (DBA).
Responsibilities:
Responsible for monitoring to convert a monthly Billing system in Cobol under Unix to Oracle 8.0 under AIX
Responsible for scheduling backup & recovery procedures.
Responsible for performance monitoring & tuning.
Responsible for maintenance of Oracle 8.0 distributed server.
Responsible for OS tuning.
Leading a team of 7-10 junior DBAs.
(2) Organization: Hyper Link Pakistan (Pvt.)
Ltd. Rawalpindi, Pakistan August 1997 to Date
Position: Database Administrator (D.B.A)
Responsibilities:
Installing, configuration and maintenance of Oracle database, Oracle applications and different systems developed.
Implementing different features as required by management as according to their policy matters.
Introducing Security features related to data by using backup, recovery options
Implementing User level security by using Rolls, Privileges on different databases and application level objects.
System Maintenance according to current requirements by Creating database objects like Tables and Constraints, Views, Packages, Procedures and Functions, Triggers, Synonyms. Writing PL/SQL Codes, Scripts etc.
Application maintenance Designing, Building and implementation of Forms, Reports, Menus in Developer 2000 (R.2).
So this is an additional ability of a D.B.A to be good Developer and knowing each and every phase of system development in order to meet all future challenges of a system after implementation.
Performance tuning and optimal utilization of resources of the systems by different techniques and method on each level form backend to end user application.
Updating documents of all system implemented and currently running.
To prepare future proposal for existing and new system in order to increase performance on long term basis.
End User’s on line training.
Database Systems Administrating
System: Accounting System for Fazal Steel Industries (A subsidiary of Punjab
Groups of industries)
Description: Consists of following modules to fully automate the whole industry:
Accounts &Finance: Handling of accounts related activities auto generation of voucher and their management, Journal updating, Linking with ledger, Cash book linkage, Payments and receipts management and aupto transaction processing. Generation of large numbers of financial statements for higher level management for making decision.
Production: Automation of different activities and events related to Production Department the cost and quantity of number of units produced, Units to be produced in future for specific period, expected units to be produced in future. Clients Interaction. Online linking with other sections as described in modules. Cost Involvement and management. And Generation of Different Reports for making Decision.
Sales and distribution: Total Number of Orders Placed. Processing of orders, Distribution channels and their confirmations. Past and Present status, functioning, performance of different distributors and suppliers. And Generation of Different Reports for making Decision.
Assets Management: Relates to management of total assets of the enterprise. Liquid and Fixed assets and their manipulation. And Generation of Different Reports for making Decision.
Material Management: Management of raw material used in different productions. Online material to be used, wastage and consumption. Quantity factors etc. And Generation of Different Reports for making Decision.
Quality Assurance: Controls the quality factors of different production and their levels and maintenance. And Generation of Different Reports for making Decision.
Human Resource Management: Includes all functions related to human resources department having activities like hiring, selection criteria, employees personals records, individuals status, performance, promotions, payroll, leave sanction and record. And Generation of Different Reports for making Decision.
Plant Maintenance: To manage and keep track of different activities relates to plant maintenance.
Environment: Oracle 8.0, PL /SQL, SQL *PLUS 8.0 Developer 2000 (R.2) under Platform : Windows-NT.
System: Budget Estimation of provincial Assembly Secretariat Peshawar (NWFP)
Description: Keeping the whole record of Budget of the coming financial year for different heads used in the secretariat in different programs having following major modules.
on line interface with finance division
assignment of Revenue
Grant of guarantee
Non provision Expenditure
floating of loan,
Re- appropriation, foreign exchanges
Enforcement of Govt. Rules.
Foreign Trips of elected and non elected member of the secretariat
Environment: Oracle 8.0, PL /SQL, SQL *PLUS 8.0 Developer 2000 (R.2) under
Platform: Windows NT.
System: Sales and Distribution System for Friends Pharmaceuticals
Description:
Inquiry
Quotation,
Sales Order
Delivery and Billing Documents
Initialization.
Environment: Oracle 8.0, PL /SQL, SQL *PLUS 8.0 Developer 2000 (R.2)
Platform: Windows NT.
(3). Organization: Oil & Gas Development
Corporation Jan 1997 to July 1997
Position: Database Administrator (D.B.A)
System: Departure Control System for OGDC’s Aviation Services
Description: The main features of this system are processing of PNL(Passenger Name List), Check-in Passenger. Generation of post flight messages and reports. Checking the weight and balance of the aircraft and baggage reconciliation.
Environment: Oracle 7.3, SQL / PLUS, SQL *Plus 3.0, SQL *Forms, SQL
*Reports, SQL *Menu, SQL net, SQL Loader.
Platform:. Windows NT.
System: Personnel Management Information System for OGDC’s Gen. Admin Department:
Description: This system assists the managers in career planing, training, keeping track of vacations, vacancies and annual credit reports of company’s employee.
Environment: Oracle 7.3, SQL / PLUS, SQL *Plus 3.0, SQL *Forms, SQL
*Reports, SQL *Menu, SQL net, SQL Loader.
Platform: Windows NT.
System: Payroll, Sale and Purchase System for the Account Department of the OGDC
Description: This system helps the Account department of the company to keep the
Records of employee’s basic pays, allowances, hiring, promotion and fixation. It also keep the records of selling and purchasing of different machinery used at different oil exploration sites.
Environment: Oracle 7.3, SQL / PLUS, SQL *Plus 3.0, SQL *Forms, SQL
*Reports, SQL *Menu, SQL net, SQL Loader.
Platform: . Windows NT.
System: Patients Information System for OGDC’s Medicare Center
Description: Includes Processing and record storing of different indoor and outdoor
Patients, their treatment, diagnose, servicing, nursing and dues.
Environment: Oracle 7.3, SQL / PLUS, SQL *Plus 3.0, SQL *Forms, SQL
*Reports, SQL *Menu, SQL net, SQL Loader.
Platform: . Windows NT.
System: Automation of Library System for OGTI Islamabad
Description: This system Maintains selection of material, Checking of duplication, book
Order stage, preparation of order, payment of bills,borrowing and returning,
Fines adjustment and Classification Catalog.
Environment: Oracle 7.3, SQL / PLUS, SQL *Plus 3.0, SQL *Forms, SQL
*Reports, SQL *Menu, SQL net, SQL Loader.
Platform: . Windows NT.