Zeeshan Ashraf Email & Phone Number

Karachi

Managing Exadata X7-2 and X8M, running with Core banking Oracle RAC databases.Design, Install, configure, and maintaining 5 different role of SQLSERVER ALWAYS ON 3tier architecture (Primary-Standby-DR), including configure 2-nodes, shared storage failover Cluster on primary.Compliance databases patches and security with audit and quarterly year standard.Enable TDE (Transparent data Encryption) on Oracle and SQL Databases as PWC and SBP observation.Managing Oracle Application R12.2.6.Mange backups.

Karachi, Pakistan

Upgrade 9+TB oracle database 9i to 12C on Sun Solaris Sparc 10 of our client GrameenPhone Telenor Group BD. Upgrade Oracle EBS Application from 11.5.0 to 11.5.10.2 then 12.2.0 to 12.2.5. Rman online Database hot backup/Restore with 9+TB volume on Tape drives. Provided support to UBL, HBL and other inbox clients.

Pakistan

Installing oracle EBS 12.1.1 on Linux, Upgrading oracle EBS 12.1.3, Maintaining Oracle EBS node on Linux system, Cloning and patching EBS, Backup the EBS system, maintaining e-ticket reservation oracle system.Maintaining three Dataguard with production Server on oracle 11gR2. at Karachi, Lahore, and Dubai position.Install oracle Real Application Cluster on11gR2 with Linux environment for demo presentation. Install Weblogic on Linux and migrate the legacy 6i application to Weblogic Environment. Maintaining GDS database on 11gR2. RMAN configuration for backup and restore operations.

Karachi

Faysal Bank Limited:Upgrade Oracle EBS 11.5.10.2 (with Oracle Databas 9.2.0.6 to 10.2.0.4 and then 11.1.0.7) to 12.1.1 with backend Database (11.1.0.7)Successfully Implemented on IBM AIX power 64bit OS Dual Node Application System.Shaheen Air International Limited :Successfully upgrade Oracle EBS 12.1.1 to 12.1.3 on Dell RS900 system

C3, S.I.T.E. Manghopir Road, Karachi

Env:Oracle EBS 12.1.2 with Oracle Data Guard , SQL, PL/SQL, SQL*Plus, TOAD, RMAN, SQL Server 2008 Enterprise Editions, Win 2003/ 2008/ XP, Dell RS 710 and 610 with Dell AX-5i SAN configuration and Oracle Enterprise Linux 5.4, Oracle VMServer 2..2.1, Dell PowerEdge R710, Dell PowerEdge R610, EMC SAN AX-5 with OEL5.4, Physical Standby Dataguard 11g, Backup Using Symantec Backup Exec 2010Resp. as an ORACLE Apps DBA:•Configure EMC SAN AX-5 with OEL5.4•Install Oracle VMServer 2.2.1 on Dell PowerEdge R710, Dell PowerEdge R610•Installed & Configured, cloning, patching Oracle EBS 12.1.1 to 12.1.2 OEL5.4 for UAT, CRP and PROD instances•Maintain Multi Node with Load balancing need Oracle EBS 12.1.2 on OVM Container•Configure Dataguard 11g, perform switchover and failover operation with EBS 12.1.2 Application•Configure Shared Application home at dual node configuration with EMC SAN AX5i.•Upgrade from EBS 12.1.1 to 12.1.2•Applied Oracle security patches, Current EBS patches on Oracle Production databases.•DMZ setup with Oracle CRP, UAT and then Production instances.•Maintain Concurrent Managers/Programs, EBS Forms and Custom Applications integrated with EBS•Creating Responsibilities, Menus, Functions and EBS Securities objects.•Communicate with Oracle Support (Metalink) to solve the SR.•shell scripting for Hot backups,archive logs & trace files purged, RMAN Backup scripting•CRONTAB job schedulingResponsibility as a SQL Server DBA:•Installed & configured and maintain SQL Server 2008 Producction Instances, on Windows 2003/2008 Server with applied service packs..•Created maintain databases & transaction logs.•Handling dynamic database growth for space management strategies.•Run DBCC Consistency checks and fixed data corruption in user database.•Involved in Security Administration created users and assigned roles & privileges.•Configured Transactional Replication.•Maintenance plan (Rebuilding index, Backups, Purging files)

220 5Th Ave Rm 1501 New York, Ny 10001

Senior Remote Oracle & SQL Server DBA Oracle ,11g,10g, 9i, 8i,,8,11i,12i Oracle Data Guard and Oracle RAC, SQL, PL/SQL, SQL*Plus, TOAD, RMAN, SQL Server 2000, 2005 Enterprise Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP, UNIX, AIX, LINUX.• Installed & Configured, cloning, patching Oracle database 12i,11i,11g,10g, 9i & 8i on Windows, UNIX, AIX, SUN, LINUX.• Applied Oracle security patches, Current patches and CPU patches on Oracle databases.• Configure CRS and OCR on RAC nodes• Install,Configure and maintain RAC instances and added if required by clients.• Wrote Oracle shell script (.ksh & .sh) for archive logs & trace files purged, check database status, check listener status, check oracle agent status, check max extent fails, check next extent fails, analyze tables & schemas, rebuild indexes online and others.• Configured oracle database status alert, table spaces trash holds, listeners’ status alert and others through Oracle management server (OMS).• Wrote shell script (.ksh & .sh) for database full export, database full import, exports schemas, import schemas, export tables, import tables and others. • Configured shell script running through CRONTAB job.Responsibility as a SQL Server DBA• Installed & configured SQL Server 2005, 2000 & 7 on windows 2000, 2003 & XP and applied service packs.• Upgraded from previous version SQL Server 2000 to SQL Server 2005.• Created databases & transaction logs.• Handling dynamic database growth for space management strategies,attached & detached databases and moved databases. • Implemented SQL Server disaster recovery, backup/restore, migration, and upgrade. • Configured the agent & setting up database mail.• Created alerts & operators & associated alerts with jobs.• Run DBCC Consistency checks and fixed data corruption in user database.• Involved in Security Administration created users and assigned roles & privileges. Managed Bluewolf Oracle and SQL Server Clients

G-23/B-5, Parklane, Block-5, Clifton, Karachi

Responsible for Analysis, Design, Development and Implementation of Customer Relationship Model in MB on Oracle 9i, Sql Server.• As a System Analyst & Database Administrator for analysis of the entire system Customer Relationship Model up to deployment and database maintenance with planning. • Designing and developing CRM modules with visual basic and .net on Sqlserver 2000 and oracle 9i.

2Nd Floor, Nadir House, I.I. Chundrigarh Road, P.O. Box No. 4616 Karachi

• Coordinate Project Development and implementation.• Responsible for testing and implementation for enhance applications. • Installed, Designed and implemented ORACLE SERVER (RDBMS) for Windows 2000 as Back-end database, Application Server on Windows 2000 and Developer 6i as Front-end application tool on windows ’98 and Windows NT.• Analyze existing system and plan the new system designing.• Development time scheduling.• Analyze and Insurance Business information of Both Head office & Branches.• Analyze and develop Insurance Company’s BRD.• Data modeling for insurance system.• New integrated database design.• Development of new system.• Deployment of new forms on client.• Backup planning.• Incase of failure recovery strategies. • Auditing Insurance System.• Dealing all type of I.T contracts.• Implemented Stand by Database.• Responsible for database and network trouble shooting and maintenance for whole network.• Installation, Configuration of Network using Active Directory, dealing local network.Achievements:1. Under Writing Departmenti. Motor Insurance Systemii. Marine Insurance Systemiii. Fire Insurance Systemiv. Accident Insurance System2. General Ledger System (Partial)3. Claim System4. Branch Control System

1-K Commerical Area Naizamabad 2, Karachi

In IT department as Oracle Developer directly involved with MIS Development and Reporting. Using Oracle Database as a back-end and Developer 4.5 and 5.0 as a front-end in windows environment, my job responsibilities includes:• Manage Information about database.• Analyze new module for new system.• Data modeling.• Normalization of the new system.• Entity Relationship Diagram designing.• Two dimensional time slicing.• Gantt chart for new system. • Database Designing.• Creating new database users.• Granting privileges for users.• Administration of database. • Development of new system.• Deployment of forms and reports on Client.• Configuration of oracle client.• Network configuration.• Backup aspects coverage.• Recovery of system. • Auditing for new System.• Provide Assistance to purchase hardware and software.• Managing and trouble shooting Networking.• Managing and trouble shooting Hardware.• Dealing all type of I.T contracts.Achievements:1. Inventory System.2. General Ledger System.

Responsible for Building Desktop Application of export quality with any database dependent upon clients

Mcs, Computer Science

Bcs, Computer Science