Ayaz Ali

  • Karachi, Pakistan

Oracle Certified Professional / Senior Database Administrator

Summary

A professional  certified Database Administrator having vast experience in a wide range of environments and have used Oracle versions 8.0 through to 11g and Oracle EBS 12i on a number of different operating systems. A highly professional who has worked on Database projects using Oracle8, Oracle8i, Oracle9i and Oracle10g, 11g, R12. Have solid knowledge of database concepts, designing, backup and recovery, performance tuning Oracle Application Installation (multi-node, single-node), Oracle Server Administration like Patching, Cloning (multi-node, single node), Backups and restoration, Relational Database Systems, using Oracle 7.3.4, 8.0, 8i, 9i, 10g, 11g Database, SQL Server & MS Access. A Solution-oriented IT Professional with notable success directing a broad range of corporate IT initiatives while participating in planning, implementation and analysis of solutions in direct support of business objectives.Working in SQL, PL/SQL, Dynamic PL/SQL, writing Packages, Materialized Views, Stored Procedures, Functions, Database Triggers, Oracle Packages.

Professional Summary

Work History
Oct 2007 - Present

Manager I.T Group Database 

Yousuf Group of Companies

Role Tools & Technologies Database Installation, Creation, Manage security, profile and user accounts, RMAN, Data Guard, Export, Import, Migration, Upgrade, Replication, Performance and Tuning, Troubleshooting, Oracle Database 10g, 11g,(ASM), TOAD, SQLPLUS, ENTERPRISE MANAGER, CuteFTP. Maintenance Oracle servers(9i, 10g, 11g) with high availability production multi-tier environment with RAC & Cluster Oracle8i(8.1. 7.4), Oracle9i(9.2. 0.8), Oracle10g, 11g Operating Systems Sun Solaris, Linux, Unix, Windows 2000/2003 server, Windows XP Installation, Troubleshooting, Monitoring, Backup and Recovery, Performance Tuning and Coordinate with the Application developer's team with 10+ different physical locations. Oracle Developer 6i/9i Forms & Reports installation and connectivity issues to the Database. I am Monitoring Real Time Replication with 6 different Physical locations all around Pakistan. Take decisions with coordination of higher management in critical situation. Coordination and correspondence with Oracle Corporation(USA, INDIA) during any critical situation to resolve errors & bugs. Created Package to find out the replication data errors between locations and then synchronize the all location to master location. Managed database issues like Managing and configuring files of a database(Table spaces and Data files), managing schema objects(tables, indexes), managing rollback segments, managing users by assigning them privileges through roles, and quotas, performing daily Hot backups and export backups through batch system, Securing database access through Privilege, Role and Resource Management, Monitoring the performance of the database, tuning the database when required(like EXPLAIN PLAN, Tuning Memory, Monitoring locks and latches on system resources.) Convert a legacy software data into the Oracle 8i database.

Jan 2007 - Oct 2007

Consultant

Gangjees Registrar Services Pvt

Supervising Oracle Implementation and troubleshooting. Implementation of Active Directory, Group Policy, DHCP Server, Installation and Monitoring of RAID controller, SCSCI, ISCSCI Disks Installation, Patching, Upgrade of different software packages.

Jan 2006 - Dec 2006

Junior Database Administrator

Micron Solution Pvt Limited.

Troubleshoot and resolve Oracle issues by telephone or e-mail.

Installation, Troubleshooting, Monitoring, Backup and Recovery, Performance Tuning and Coordinate with the Application developers’ team.

Oracle Developer 6i/9i Forms & Reports installation and connectivity issues to the Database.

Visit client premises to resolve critical problems and run RDA.

Install Red hat Enterprise Linux 4 & 5 on enterprise servers

Education

Education
2007

B.Com

University of Karachi

Bachelors in Commerce

Certifications

Certifications

Info Base

College of Business & IT and Solution Providers

HTML

Java Scripting

CIT- (Certified Information Technology)

Certificate In Information Technology

OCP-10g (Oracle Certified Professional) 

Oracle Certified Professional

Oracle Database 10g: New Features for Administrators

Linux Administration:

LINUX System Administrator-I.

LINUX System Administrator-2.

Linux Administration:

Red Hat Linux 9.0 Certified Engineer from Techno-ED (Pvt.) Ltd Karachi.

Certificates Include

Managing and Maintaining a Microsoft Windows XP and Windows 2003 Environment.

Planning, Implementing and Managing Microsoft Windows Server 2003 Network Infrastructure.

Planning, Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure.

Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure.

Windows Administration:

Microsoft Certified System Engineer-2003 (MCSE) from CTTC (Pvt.) Ltd Karachi.

Oracle Professional Program (OCP) Wired Networks: 

CISCO Certified Network Administrator (CCNA) from CTTC (Pvt.) Ltd. Karachi.

Oracle Professional Program (OCP) Oracle 9i Certified Database Administrator Track.

ntroduction to SQL.

Introduction to PL/SQL

Database Administration Fundamental-I.

Database Administration Fundamental-II.

Database Performance Training.

Oracle Technology 

Techno-ED (Pvt.) Ltd

(From Techno-ED (Pvt.) Ltd. affiliated with Oracle University Singapore)

Jan 2007 - May 2007

OCP- 9i (Oracle Certified Professional)

Oracle

Oracle 9i Certified Database Administrator Track

Technical Skills

Skills

Programming Language

SQL, PL/SQL, TOAD, SQLPLUS, ENTERPRISE MANAGER, CuteFTP, Winscp

Databases

Oracle EBS, Oracle 7.3, 8.0, 8I, 9i, 10g, 11g, SQL server (2000)

Modeling tools

Erwin 2.5, Designer 2000 2.1/6i, Visio 2000

Personal Contact Info

Contact : 92-302-8292203

Email : ayazali1@hotmail.com