Vilayath Ali - DBA - Riyadh, Riyadh Province, Saudi Arabia

Mohammed Vilayath Ali

Riyadh, Riyadh Province, Saudi Arabia

Services

DBA

  • Full time
  • Part time
  • One time
  • Contract
  • Temp

Summary:

Total Experience : 20+ years
13+ years as Sr. Oracle DBA/ Apps DBAt
MBA ( Information Technology)
pursuing PMP

Work History

Oracle DBA

AFAM (Aqaf)

Installed RAC 10g R2 on MS-Windows 2003

Oracle DBA

ANB

From October 2010

Riyadh, K.S.A.
Company Profile: Leading Bank in Saudi Arabia (Tawafuq Technology Co.)
Role: Oracle DBA.
Duration: Oct, 2010 - onwards.
Environment: Oracle Database 8.x/9iR2/10gR2/11gR2 on HP-UX/Windows
Responsibility:
- DBA Support (24x7)/Maintenance/Installations, all database related issues.
- Managing databases using Enterprise Grid Control 10g/11g/12c.
- Database Upgrade (manual/DBUA) 9iR12 to 10gR2, 10R2 to 11gR2 on HP-UX Itanium.
- Apply CPU/PSU security patches every quarterly.
- Performance Tuning/AWR/ADDM/ASH.
- Rebuild indexes/Shrink (Segment Advisor)
- Table Redefinition to migrate to SDD storage/ Non Partition to Partition.
- Tablespace Data Encryption.
- Convert Single DB to RAC.
- Upgrade RAC 10g to 11gR2.
- Migrated windows 32-bit database to windows 64-bit.
- Used Memory Advisor/Segment Advisor/SQL Tuning Advisor.
- Cloned ORACLE Homes 10g/11g
- Working for PCI-DSS (Payment Card Industry - Data Security Standards) compliance program for certification.
- Installed EBS R12 (12.1.1) and upgraded database from 11.1 to 11.2.0.1 on Oracle Linux 6.


2. Name of the Company: Advanced Operations Technology (AOT), K.S.A, Riyadh.
Company Profile: AOT is specialized in Oracle eBusiness/Database Solution, having
projects across all over Saudi Arabia.

Apps DBA

Oracle Support

April 2010 - September 2010

Environment: 11i Applications (11.5.10.2) on AIX 5.3/6.1.
Responsibility:
- Upgraded 11i (11.5.10.2) to R12 (12.1.1)

PROJECT: Oracle Support (Apps DBA).
Customer: Banque Saudi Fransi, Riyadh, K.S.A.

Oracle DBA

Index Securities

Installed Oracle Fail Safe 10g on MS-2003 Server (Microsoft Cluster)

Apps DBA

Saudi German Hospital (Jeddah)

September 2010 - October 2010

Installed R12/11i Support on Sun Solaris 9 sparc 64-bit

Oracle DBA

Bupa, Jeddah

September 2010 - September 2010

Support/Maintained RAC 10g on Solaris 9 spac 64-bit

Oracle DBA

Dr. Soliman Fakeeh Hospital

September 2010 - October 2010

Support/Maintained RAC 10g on Windows

Apps DBA

Oracle Support

July 2009 - February 2010

Duration: July 2009 onwards - Feb 2010.
Environment: 8 11i Applications (11.5.10.2) (7 in AIX 5.3/6, 1 in Microsoft
Windows).
Responsibility:
- Cloning (11.5.10.2) / Refreshing the clone databases.
- Applied Patches, Implemented Password Policy.
- Maintaining 11i Systems, Database Health Check, Physical Standby Database.
- Followed all the DBA issues, creating/following SR's.

PROJECT: Oracle Support (Apps DBA).
Customer: KKESH, King Khalid Eye Specialized Hospital, Riyadh, K.S.A.

Apps DBA

Applied Patches

March 2009 - October 2009

- Followed issues with Oracle Support.
- Maintained R12 System, Database Health Check.

PROJECT: Oracle Support (Apps DBA).
Customer: Falcom, Riyadh, K.S.A.

Apps DBA

Applied Patches

February 2009 - July 2009

Followed issues with Oracle Support.

PROJECT: Oracle Support (Apps DBA).
Customer: National Air Services (NAS), Riyadh, K.S.A.

Apps DBA

Applied patches

January 2009 - September 2010

Environment: 11i (11.5.10.2) on SN.
Job:
- Maintaining 11i (11.5.10.2) on Red Hat 4 update 5.
- Installed R12 multi-node (12.0.4/12.1.1) on Red Hat 5.2.
- Applied patches.

PROJECT: Oracle Support (Apps DBA).

Apps DBA

Saudi Arab Investment Bank (SAIB)

From April 2009

onwards.
Environment: 11i (11.5.10.2) on 1 Node Microsoft Windows 2003.
Job:
- Maintaining 11i.
- 11i Cloned SN - SN.
- Following issues with Oracle Support.

PROJECT: Oracle Support (DBA).

DBA

SAICO

From March 2009

onwards
Environment: 11g Database, Oracle Fail Safe, HA, Microsoft Windows 2003.
Responsibility:
- Installed Oracle Fail Safe/11g Database on Microsoft Windows 2003.
- Migrated and restructured database from 9i R2 to 11g.

PROJECT: Oracle Support (Apps DBA).
Customer: Saudi German Hospital, Riyadh, K.S.A.
Role: Apps DBA.
Duration: April 2009 onwards.
Environment: 11i (11.5.9) on Sun Solaris 8 sparc.
Job:
- Cloned 11i from Solaris 8 to Solaris 10.
- Followed issues with Oracle Support.

3. Name of the Company: Emirates Computers Dubai, U.A.E. (Oracle Partner).
Company Profile: Emirates Computer is a software consultancy, one of the leading company in U.A.E, takes all kinds of commercial
projects and support.
Duration: May 2000 - Aug 2008.

URL: http://www.emiratescomputers.ae

PROJECT: Oracle Support (DBA).
Customer: Dubai Police (Department of E-Services (CID)).

Oracle DBA

Oracle Support

October 2008 - February 2013

Duration: Oct, 2010 onwards.

PROJECT: Oracle Support (Apps DBA).
Customer: Bank AlBilad, Riyadh, K.S.A.

Apps DBA

Oracle Support

October 2008 - June 2009

Duration: Oct 2008 - June 2009.
Environment: 11i (11.5.10.2) 2 Nodes on Microsoft Windows 2003.
Responsibility:
- Cloning (11.5.10.2) MN - SN on Microsoft Windows 2003.
- Applied Patches, Created/Maintained Physical Standby Database.
- Maintaining 11i System, Database Health Check.
- Maintaining Standby database 9i (EBS) and 10gR2.
- Following all the Apps DBA/DBA issues.

PROJECT: Oracle Support (Apps DBA).
Customer: Watan Investment, Riyadh, K.S.A.

Oracle DBA

May 2006 - July 2008

Responsibility:

- maintained and monitored databases as:
- more than 16 database servers in Oracle 7/8i/9i/10g.
- 1 RAC 10g 10.2.0.3.0 (2 Nodes) on HP-UX B11.23 (using asm).
- 3 RAC Oracle Database (9i) 9.2.0.6 on HP-UX B11.11(using raw devices)
- 2 Oracle Database (9i) 9.2.0.6 on HP-UX B11.11 Active/Passive Mode (for OAS 10g Infra Structure Database)
- Daily databases health check.
- Tablespace growth size/file system size, cpu utilization.
- Rebuild indexes, move indexes, generate statspack, check invalid objects on a daily basis.
- Helped in deployment any new applications with developers.
- Check problematic queries and reporting to developers.
- Help in tuning their applications SQL's etc.
- Maintaining Oracle Database 10g (10.2) on MS Windows 2003.
- Check daily RMAN backups/ logs.
- Database recovery.

PROJECT: Oracle Support (DBA).

Oracle DBA

National Security, Dubai Police

From July 2006

Installed 2 database Sun Solaris 9 sparc 64-bit

Oracle DBA

Sharjah Airport

From September 2006

Installed 10g R2 DB Active/Passive on Sun Solaris 10 64-bit and migrated from 8.1.7 database

Oracle DBA

Emirates Transport

September 2005 - August 2008

Duration: Sept 2005 - Aug 2008.
Responsibility: Installed/Maintained Oracle Database 8i (8.1.7) on MS
Windows 2000 Server.
- Database Tuning.

PROJECT: Oracle Support (DBA/Apps DBA).
Customer: Emirates Transport, Dubai.

Oracle DBA

Tech Data

From December 2005

Installed Oracle Fail Safe 9i R2 on MS-2000 Server (Microsoft Cluster)

Oracle DBA

October 2004 - September 2005

Responsibility:
- Installed and maintained Oracle Database 9i Rel 2 on development servers on MS Windows 2000 Servers for (BPCS Project).
- Installed and maintained Oracle Application Server 10g (9.0.4) on MS Windows 2000 Server on development servers for (BPCS Project).
- Applied patches on OAS 10g/Database.
- Database and Application Level Tuning.
- Data Migration (Export/Import/SQL*Loader).

PROJECT: Oracle Support (DBA).
Customer: Sharjah Municipality.
Role: Oracle DBA.
Duration: May 2000 - Aug 2008.
Responsibility: Installed and maintained Oracle Application Server 10g
(9.0.4) on MS Windows 2000 Server
- Installed Oracle Database 10g (10.2) on MS Windows 2003 Server.
- Applied patches on OAS 10g.
- Database Tuning.
- Data Migration (Export/Import) from their legacy system (8i) to Oracle 10g Database on Development Server (MS Windows 2003 Server).
- Installed Oracle Database Enterprise Edition 10g R2 on Production Server on HP (11i v2 ) 64 bit and migrated database from legacy System.
- Moved all indexes which was lying in data tablespaces to index tablespaces.
- Tuned the database.
- Created RMAN catalog on Windows Oracle 10g R2 Database for galaxy software using rman.

PROJECT: Oracle Support (DBA).
Customer: DTPS (Development Town Planning Sharjah).

Oracle DBA

Oracle Database

February 2004 - February 2004

Installed Oracle Fail Safe (3.2.1) / Oracle Database 9.2.0.4 on Mircrosoft Server 2000 Adv Server/Microsoft Cluster,
- Database Corruption issue after 1 year, applied media recovery.

4.
Djibouti Port , Africa / Dubai Authority Port.
(on behalf of Oracle Corporation, Dubai)

Oracle DBA

Oracle Database

April 2004 - May 2004

-Installed Oracle Database 9i R 2 (Oracle Fail Safe (Active/Passive) ) on Sun Solaris Sparc 9 (v440) machine with sun cluster manager
3.1. (2 nodes).
-Created Tablespaces/Performance Tuning.
-Configured Archive log mode.
-Created RMAN catalog for NetBackup (Veritas) to implement Backup & Recovery.

5.
Dubai Economic Development

Oracle DBA

June 2004 - June 2004

Installed Oracle Real Application Cluster (RAC) 9i (9.2.0.1.0) 64bit on Sun Sparc Solaris 9 machine with sun cluster manager 3.2. (2 nodes)

6.
Ministry of Health, Dubai
01/02/2005 Oracle DBA
- Installed Oracle Database 9 R2 with Oracle Fail Safe on Microsoft cluster on Microsoft Windows Server 2003
- Migrated database to RAC using export/import.

Oracle DBA

May 2003 - November 2006

Responsibility: Maintaining the database (clustered database) on Sun Solaris 8.
- Regular visit to check the database health.
- Tuning the database.
- Scheduled daily backup (export dump file).
- Scheduled cold backup once in a week.
- Solved Performance issues, tuned application level SQL's.
- Maintained EBS 11i (11.5.10.2) on HP-UX.

Short Term Tasks:
S.No Customer Name Date Role/Task Job Description
1.
Safestway, Dubai

Oracle DBA

June 2002 - August 2008

Responsibility: All issues of Database, Performance and application level
tuning. Oracle Database installations Sun Solaris Sparc 8 / Oracle 7.x/8i
- Migrated from Oracle 7.x to 8i (8.1.7)
- Database Tuning.
- Created RMAN catalog for NetBackup to implement Backup and Recovery (hotbackups)
- Regular visits to check the health of the database.
- Migrated from Oracle 8.1.7 to 9i R2 on Active/Passive environment on Solaris 9 sparc 64 bit.
- Created/Maintainded Physical Standby Database
- Maintained 11i (11.5.9) on windows 2003 (1 Node).

PROJECT: Oracle Support (DBA).
Customer: Sharjah Customs and Sea Ports, Sharjah.

Oracle DBA

Oracle Fail Safe

June 2002 - March 2004

Responsibility: All issues of Database, Performance and application level tuning. Oracle Database installations Sun Solaris Sparc / Oracle 7.x, Installed and Support for Oracle Database 8.1.7 (Oracle Fail Safe) on Microsoft Windows 2000 Adv Server with Microsoft Cluster 2 nodes.
- Migration from Oracle 7.x (Solaris) to 8.1.7 (Windows 2000) Server.
- Regular visits to check database health.

PROJECT: Banknet Project (e-Commerce)/ (DBA/Apps DBA).
Customer: Emirates Bank International Dubai, U.A.E.
Size of the Team: (1+4) one project leader, Four Programmers/Analyst.

Oracle DBA

Ministry of Labour

May 2002 - August 2008

Duration: May 2002 - Aug 2008.
Responsibility: Installed Oracle Database 9.x R1 and maintained.
- Database Tuning/Daily backup.
- Scheduled daily backup (export dump file).

PROJECT: Oracle Support (DBA).
Customer: Ministry of Labour, Dubai, U.A.E.
Role: Oracle DBA.
Duration: May 2000 - Aug 2008.
Responsibility: Installed Oracle Database 8.1.7 on Windows and maintained.
- Implemented Oracle Advanced Queues (messaging
system) linked (e-Govt link) between Ministry of Labour
(MOL) & Ministry of Immigration (DNRD) in the year 2001.
- Regular visits to check Database health.
- Migrated to different server 8.1.7 on windows/ Applied patch 8.1.7.4
- rebuild the indexes & restructured the database to enhance performance.

PROJECT: Oracle Support (DBA/Apps DBA).
Customer: Chamber of Commerce, Dubai.

Oracle DBA

Oracle Database

January 2002 - January 2002

7.2 on SCO Unix/ user datafiles hard disks failed / recovered database and re-created all tablespaces and applied import from the backup

2.
Grand Store, Dubai
08/06/2003 Oracle DBA
Database Crashed 7.2 AIX (sga) / user datafile and rollback disks failed - able to startup the database - recreated the tablespaces and imported the database.

3.
Platinum Project (Jabel Ali, Dubai) on behalf of Oracle Corporation, Dubai

Oracle DBA

Department of Security Special Branch

May 2000 - August 2008

Responsibility:
- Installed Oracle Real Application Cluster Database 10g (10.2) on Sun Solaris sparc 9.
- Installed Oracle Database 10g (10.2) on Windows 2003 Advance Server.
- Configured Archive Log Mode.
- Created RMAN catalog for NetBackup (Veritas) to implement Backup & Recovery.
- Database Tuning.

PROJECT: Oracle Support (DBA).
Customer: Dubai Police (Department of Security Special Branch).

Oracle DBA

May 2000 - August 2008

Responsibility:
- Installed and maintained Oracle Database 8.1.7/9.2/10.2 on
SGI (AIX)/ Linux (Red Hat) / Sun Solaris 9 Sparc 64 bit.
- Installed Oracle Real Application (RAC) 10g (10.1.0.4/ 10.2) on
Sun Solaris 9 sparc 64 bit.
- Applied Patches for bug fixing, upgrade products.
- Installed Oracle Application Server 10g (9.0.4/10.1.2.0.2) on Sun Solaris Sparc 64bit, deployed Oracle Forms/reports.
- Installed Oracle Application Server 9 Rel 1/ Rel 2 on MS Windows 2000 Server, deployed Oracle forms/reports.
- Created stored procedures and packages.
- Database Tuning.
- Handle all sort of issues related to Oracle Databases.

PROJECT: Oracle Support (DBA).
Customer: Dubai Municipality.

Programmer/Analyst cum Oracle DBA/Apps DBA

BROKAT

September 2000 - May 2001

Responsibility: Developed Oracle Stored Procedures to build business Logic for Application Server called Twister (BROKAT) which is accessing backend as400 and Oracle to supply business logic to Web Server (JSP) and responsible for tuning the database.
https://banknetpower.net
- DBA support/Maintained banking databases.
- Maintained 11i(11.5.9) on Linux RedHat AS 2.1 Enterprise Edition (2006-2008).

PROJECT: Oracle Support (DBA).
Customer: Ajman Municipality, Ajman, U.A.E.
Role: Oracle DBA.
Duration: May 2000 - Aug 2008.
Responsibility:
- Installed Oracle Database 8.x and 9.x.
- Tuning database level and Application level.
- Advise of any database related issues.
- Installed Oracle Application Server 10g (9.0.4).
- Regular visits to check database health.

PROJECT: Oracle Support (DBA).
Customer: Ummul Quwain Municipality, U.A.E.

Developer

SQL*Report Writer 1.2/2.5/3.0.
SQL*Loader, SQL*DBA, Procedure Builder.


1. PROJECT: Rainbow Financials.
Customer: Grand Stores Dubai, U.A.E.

Programmer/Analyst

Oracle V6 & V7

SQL * Forms 3.0 & 4.5 (Developer 2000)
SQL * Report Writer 1.1 & 2.5, SQL * Loader, SQL * DBA,
Procedure Builder, Clipper 5.0 for POS Machines.

1. PROJECT: I-FAST*Financial.
Customer: Sport Ghornatah Riyadh, K.S.A.
Role: Programmer/Analyst.
Size of the Team: (1+2) one project leader, Two Programmers/Analyst.
Environment: NCR 3330 with AT & T Unix SVR4, ORACLE v7.1, in H.O.
Compaq Server with SCO Unix V 4.2, at district H.Q. P.C's with POS in clipper at every showroom. SYMBOL data collectors for physical inventory, price, validation, etc.
Responsibility: Design/Develop/Implement an integrated inventory control and purchase order system, migration to the existing system.
Interface of POS system and handheld data capturing
machines with the backoffice, Integration with I-FAST*Financial
Modules.

2. PROJECT: I-FAST*Financial.
Customer: Sport Ghornath Riyadh, K.S.A.
Role: Programmer/Analyst.
Responsibility: Implementation and maintenance of I-FAST*Financials in Arabic.

3. PROJECT: I-FAST*Financial.
Customer: AH Group of companies, Al-Hasa, Dammam.
Role: Programmer/Analyst.
Size of the team: (1+2) , One project leader, Two Analyst Programmer.
Environment: AT & T Pentium 60 Server, Oracle V 7.1, SQL forms. Report writer 1.1. Mainly for the purpose of job costing and to control the production and stock which is linked to their main inventory system. Developed under I-FAST*Financial system Modules.

4. PROJECT: I-FAST*Financial.
Customer: Al Raya Super Market Jeddah (K.S.A).
Role: Programmer/Analyst.
Responsibility: Implementation and maintenance of I-FAST*Financials.

Giffin Bytes

August 1998 - April 2000

Company Profile: Giffin Bytes is a software consultancy, is a division of Giffin Traffiks
Abu Dhabi, (U.A.E) having an Integrated software application called
Rainbow Financials and having their own POS software.
Giffin Bytes is the sub-consultant of Emirates Computers, Dubai, U.A.E. Rainbow Financials (ERP) is developed by Park Lane
Software, Australia in Oracle Forms 6 covering all commercial
modules like:

• Inventory.
• Debtors.
• Purchase Order Processing.
• Creditors.
• Sales Order Processing.
• General Ledger.
• Fixed Assets.
• Payroll & Personnel.

Environment: Irix Unix , Silicon Graphics Server, Oracle V 7.2 / 8.x.

Programmer/Analyst

September 1998 - April 2000

Responsibility: Designed/Development/Implementation of Rainbow
Financials, migration of data from their old legacy system into
Rainbow Financials, giving technical advices, responsible for
Y2K complaint to Rainbow Financials.

2. PROJECT: Rainbow Financials.
Customer: Safestway Sharjah, U.A.E.
Role: Programmer/Analyst.
Duration: Sept 1998 - April 2000.
Responsibility: Development and Implementation of Rainbow Financials,
responsible for Y2K complaint to Rainbow Financials.


3. PROJECT: Rainbow Financials.

Programmer Analyst / Oracle DBA

Lamcy Plaza Dubai, U.A.E

September 1998 - October 2004

Development and Implementation/Support of Rainbow

September 1998 - October 2004

Financials, responsible for Y2K complaint to Rainbow
Financials.


5. Name of the Company: Sport Ghornatah / Unix Consulting Group (UCG),
Riyadh, K.S.A.
Duration: March 1996 - Feb 1998.
Company Profile: UCG was a software consultancy, having an Integrated
software Commercial application called I-FAST*Financial,
which is built in house in Oracle Forms 6i, it was an integrated
system, English/Arabic Bilingual Financial Accounting
System, supporting multi-company, multi-location and multi currency covering.
• General Ledger.
• Accounts Receivable.
• Accounts Payable.
• Cash Book.
• Inventory Control & Purchase Order.
• Fixed Assets.
• Customer Order Processing.
• Sales Analysis.
• Payroll & Personnel.
UCG also having POS programs which was in clipper 5.0.

Environment: NCR 3330 with AT & T UNIX SVR4, Novell Network 3.12.

Programmer/Analyst

Al Bayrooni Computer Est

July 1995 - October 1995

(on a contract basis).
Responsibility: Developed an Estimation System (job costing) for civil
construction in System Builder + (SB+).

7. Name of the Company: Riyadh Development Authority
(Semi Govt. Organization, Riyadh, K.S.A).

Programmer/Analyst

January 1993 - January 1994

(on a contract basis).
Responsibility: Developed an Application Software to Control
Purchase/Quotations and Stock modules using FoxPro (Arabic).

Programmer/Analyst

Al-Emar Group

April 1992 - December 1992

(on a contract basis).
Responsibility: Designed & Developed & maintained inventory control
application using Dbase/FoxBase, Clipper 5.0.

Qualifications & Certifications

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more


Are you sure that you want to leave?

   
Supported Countries
Choose your country

×