[pic] [pic]

[pic]

SHAKIL ZUBAIR

acc2mf@r.postjobfree.com Cell. 1-416-

***-****

*** ****** ***** ****** **, Canada Home 1-

905-***-****

OBJECTIVE

To obtain a position as Database/ Administrator in a dynamic organization

where I can contribute positively with my skills and get professional

accomplishment.

PROFILE

o Diverse experience of database administration for various environments

(DSS, OLTP, Production, Testing, Staging and Development environments)

o Self motivated, and can work with minimal supervision. Productive and

Result oriented,

SKILLS SET

Operating Systems UNIX (Solaris, Windows 2003,2008 AIX 5/6/7, Linux 5.0,

HP unix

Languages SQL, PL/SQL, Visual Basic 6, JCL, COBOL II, ABAP

Databases (RDBMS) Oracle 7.3.x, 8i/9i /10g/11g (ExaData), MS SQL

2000,2005,2008

Development Tools Informatics 9.x, SAP Crystal Report, Oracle Data ware

House Builder

CERTIFICATIONS

Oracle 8i DBA Microsoft Certified Professional

Sun Solaris 9 Certified Oracle Exadata 11g certified

EDUCATION

Bachelor Degree of Commerce 1987 The Punjab University Lahore, Pakistan

Courses 2005 Herzing /Oracle Corp. Toronto,

Canada

Oracle / MS SQL Server DBA functions:

. Install, configure, upgrade and expanding software server, tools, and

applications also applying patches for oracle

. Monitor, tune, size, backup, recover, analyze, defrag, and migrate

. Design and implement DB security, user management and VPD

. High availability, 24/7, basic replication, standby/Data Guard database,

RMAN

. Design/model DB structures to support a variety of software applications

. Monitor DB growth and provide DB capacity planning for apps expansion and

proper objects sizing

. Design and implement backup methods and disaster recovery strategies

. Migrate DB between software versions, platforms, DB products

. Installation of data ware house builder 9i/10g and workflow

MS SQL 2005/2008

Implementations, deploy, upgrades, security patches and the day-to-day

operations of MS SQL Server 2005/2008 including Development, QA, UAT and

Production systems.

database refreshes from Production to non-production environments

Participate in change control activities

Perform data capacity planning, performance tuning, monitoring,

troubleshooting and optimization of the databases.

Design backup and recovery strategies for both file stores and

databases.

EMPLOYMENT

SENECA College (Dec 2013 -

TODATE)

Position: Oracle DBA

Environment: Oracle 11g, PeopleSoft, Sun Solaris10 / Linux Red Hat 5,

Sql server 2008

ExaData X3-2, OEM cloud 12c

Projects: People soft Databases migration to ExaData

TASK:

. ExaData HCC for OLTP and DW compression tables.

. Planning for migration DW for ExaData. Data pump / Transportable

tablespace and CTAS

. Installation/Upgrade of Oracle Binaries 10gR2 and 11gR2 and New

Instances, ASM, OEM Agents ASR and IORM

. Testing / POC for Golden Gate 11 (downstream) for some SQL server to

Oracle

. Performance issues of queries and PS SQR on non-ExaData servers.

. Creating scripts / schedules for RMAN online Full / incremental backup

/restore on Exadata and non ExaData. Using BCT feature on some high IO

extensive environment

. Implementation of Oracle Grid control Cloud 12c with Exadata plugins

. Some task as PS admin like stopping starting and pointing application

to different new DB

. Backup and restore for SQL server 2008 and some migration to Oracle

11g for PS ERP

INTACT INSURANCE (April 2012 - Dec.

2013)

Position: Oracle DBA

Environment: Oracle 10g/11g, PeopleSoft, AIX 6.1, IBM TSM, Red Hat 5,

Sql server 2008

ExaData X2-2, OEM cloud 12c

Projects: claim projects like OPUS, Guide Wire, Snowflake (Detica)

TASK:

. ExaData POC (Smart scan /HCC /Storage Index etc.) and Cell Admin

. Planning for migration DW for ExaData. Data pump / Transportable

tablespaces

. Installation/Upgrade of Oracle Binaries 10gR2 and 11gR2 and New

Instances, ASM, OEM Agents

. Implementations, deploy, upgrades, security patches and the day-to-day

operations of MS SQL Server 2005/2008 including Development, QA, UAT and

Production systems.

. database refreshes from Production to non-production environments

. Participate in change control activities

. Oracle Data Guard using Data Guard Broker

. Creation of database monitoring alerts on Grid Control / CRON jobs

. Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning

. Creating or Refreshing QA and staging with preproduction by using RMAN

duplicate.

. Setting up Oracle streams to reporting database.

. Code deployment and working on new releases with developers.

. Supporting /patching / maintaining Data guard databases.

. Capacity planning and proper object sizing

. Working with Performance issues with RAC environment

. Supporting data warehouse.

. Table partitioning/ object resizing

. Resolving backup / restore issues with RMAN

. Working on releases for the rolled out projects.

RIM (Research in-motion) (July 2010 - April

2012)

Position: Oracle DBA

Environment: Oracle 8i//10g/11g, ExaData X2-2, Solaris 10, AIX 5.3, RED

HAT 5.4, Tomcat

Application: REMEDY/ CMDB / ITSM, SAP Netweaver 7.1, Golden Gate 10g,

HP-UX

TASK:

. Installation of Oracle Binaries 9i,10g/11gR1 and New Instances,

. Some tasks for SAP Basis in Development environment. Like UME, Spool,

dba cockpit, and migrations

. Supporting more than 5 Production and 24 non-production databases

. Migration of legacy application oracle 10g from AIX to Solaris

. Testing Oracle Query on ExaData X2-2 for Production deployment

. Apply security Patches and upgrades for Oracle and OS level

. Resolving backup / restore issues with RMAN

. Code deployment and working on new releases with developers.

. Working with ASM instances on Sun Solaris and Linux (red Hat 4.5)

. Working with Golden Gate to replicate set of schema to Reporting

database

. Creation of database monitoring alerts on Grid Control / Cron jobs

. Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning

. Creating or Refreshing QA and staging with preproduction.

. Supporting /patching Data guards and RAC databases.

. Capacity planning and proper object sizing

. Working with Performance issues with RAC environment.

. Adding and delete nodes as per business requirements.

. PL/SQL, Procedure, triggers for Database maintenance

BELL MOBILITY (May 2008 - June

2010)

(Communication / wireless / cellular service)

Position: Oracle DBA

Environment: Oracle 8i//10g, Toad, VERITAS Net Backup, Sun Solaris, MS

SQL 2005 / Informatica Power Center 8.6.1

Large Projects: Data warehouse size 8 TB, ODS size 6 TB, NETRAC (OLTP) for

GSM data = size 4 TB

Oracle RAC 10g (for NRM project)

Small Projects: Dash Boards and ORACLE GRID 10g

TASK:

. Installation of Oracle Binaries 8i,9i,10g and New Instances

. Apply security Patches and upgrades for Oracle and OS level

. Resolving backup / restore issues with RMAN and VERITAS NetBackup.

. Baseline support for Data ware house and access security for Schemas

. Working with ASM instances on Sun Solaris and Linux (red Hat 4.5)

. Working with ORACLE STREAM to replicate set of schema to a DRP

. Code deployment and working on new releases with developers.

. Creation of monitoring alerts

. Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning

. Creating or Refreshing preproduction.

. Supporting /patching Data guards DB.

. Working with Oracle Ware house Builder

. Capacity planning and proper object sizing in Data warehouse

. RAC 10g Support for OLTP databases

. Working with Performance issues with RAC environment.

. Creating and delete nodes as per business requirements.

. Upgrading oracle cluster ware, binaries and databases for RAC 10g

. PL/SQL, Procedure, triggers for Database maintenance

. Supporting MS sql server 2005

. database refreshes from Production to non-production environments

. Participate in change control activities for SQL server

. Design backup and recovery strategies for MS SQL 2005

. Working closely with developers and BA for new projects (logical

/physical structures)

. Creating and supervising MOP for new releases or project deployments

. On call pager support for Databases and ETL Informatica production

support

. Informatica App refreshes along with DB refreshes

IBM Canada (Sep 2008 - Oct-

2008)

(Manage Service)

Position: Oracle Production DBA

Environnent: Oracle 10g, HACMP, Oracle Rac 10g, AIX 5.1

Project: Air Canada RAC Installation

TASK:

. Installation of Oracle Binaries 10g

. Apply security Patches and upgrades for Oracle and OS level

. Working with ASM instances on AIX

. Creation of monitoring alerts

. Develop and crate new environment from scratch like Lab., Dev, QA,

Staging.

. Planning for Data Guard as high availability for 3 nodes RAC

Production environment

Capgemini Richmond Hills (Feb 2008 - Apr

2008)

(SAP impl mentations consultant)

Position: Oracle DBA

Environment: Oracle 8i//10g, PeopleSoft, Net Backup, HP-UX, AIX, SQL

server 2005, Oracle GIS

PROJECT: Hydro One (DATA MART retrofits) size = 2.2 TB

TASK:

. Installation of Oracle Binaries 8i,9i,10g and New Instances

. Cloning production Databases to staging and QA

. Migration of oracle Databases & some legacy DBs from PeopleSoft/

Primavera to SAP (ECC 6.0)

. Scripting Backup and Restores by using RMAN with VERITAS NetBackup.

. Data warehouse: creating statistics and analyzing for partition and

rebuilding indexes (in case of unusable indexes).

. Capacity planning and proper object sizing in Data warehouse.

. Retrofit of data warehouse at corner stone project.

TELUS MOBILITY Toronto (Nov2006 -

Dec-2007)

(Communication / wireless / cellular service)

Position: Oracle Production/Support DBA

Environment: Oracle 9i/10g, OEM, Net Backup, MS SQL 2000, HP-UX

TASK:

. Participate on ILM project. Restore using RMAN and imp DMP files.

. Using data pump for recovery or refreshing dev./QA/Staging from

production

. Imp /exp between DBs or archiving Production partition Tables.

Apply security Patches and upgrades for Oracle and OS level.

. Supporting one of the Data Ware house DB (6 TB)

. Using SQL Loader for flat files import.

. Supporting AMDOCS databases and some application side as well (with

knowbility team)

. Supporting Non production Environments (staging, QA and Development)

. Splitting/Dropping of Partition Tables

. Creating or Refreshing preproduction.

. Supporting /patching Data guards DB.

. PL/SQL, Procedure, triggers for Database maintenance/ alerts and jobs.

. Creation of new DB, Cloning, Renaming the oracle 9i/10g DB.

. DB monitoring, Capacity management/planning

. Code deployment and working on new releases with developers.

. Using SQL Loader for flat files to DW staging

. Installation of ORACLE RAC 10g on sun Solaris 10/ Linux 4.5 with ASM

instance

. Support and admin. RAC 10g like patching, adding node, gc performance

issues

. Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning

. Installation of MS SQL server 2000/7.

. Using DTS for backup/restore.

SUN LIFE FINANCIAL INC CANADA (JUL-2006 -

OCT 2006)

(Insurance Company)

Position: Oracle infrastructure DBA

Environment: Solaris 8, Oracle 8i/9i/10g, DBArtisan, Toad. 9i OEM,

NetBackup, TSM 5.3, Peregrine,

TASK:

. Oracle administration and tuning.

. Working with Rollout team to Create SMS packages

. Implementation of 10g Grid and Grid Control agent

. Apply security Patches and upgrades for Oracle and OS level.

. Migration from MS SQL 2000 server to Oracle 10g

. Creating and managing Replica DB of SQL server 2000

. Servers monitoring and database capacity planning for Production DB.

. TSM 5.3 for backup and recovery

. Capacity planning and proper objects sizing.

. Preparing Documentation for Lead DBAs regarding migration to oracle

10g.

. Migrating oracle 8i /9i to Oracle 10g

SPHERES SOLUTIONS TORONTO CANADA (Jan-2005 - May

2006)

(Software and consulting company)

Position: Oracle /SQL server support DBA

Environment: Sun Solaris 9, Linux Red Hat 4 AS, Oracle 9i/10g DB,

Active Directory, MS exchange 2003/5.5, Oracle Collaboration

suites 10g, RAC 10g

Projects Installation of Oracle collaboration Suits 10g on Linux Red Hat

AS 4

Implementation and Upgrades of Oracle 10g 10.1.x.x Database

/RAC

TASK:

. Oracle Installation, administration and tuning.

. Implementation of Oracle RAC 10g, MS SQL 2000 server and Oracle

Collaboration suites 10g & data migration from MS exchange to OCS 10g.

. Design and Implement backup & restore strategies.

. Servers monitoring and database capacity planning for Production.

. SQL tuning by using SQL navigator

KIC, TORONTO CANADA (Aug-2003-Oct-

2004)

(Software and consulting company)

Position: Intermediate Oracle DBA

Environment: Sun Solaris 8, SPARC servers Oracle 8i/9i DB, Red hat AS 3

2.6.22

TASK:

. Oracle 9i installation / migration between 8i to 9i, Planning the

methods and Documentation

. Design and Implement backup & restore strategies, Capacity planning

and proper objects sizing.

. Database monitoring & performance tuning through OEM & Performance

Tuning Pack.

. SQL tuning by Explain & Plan, SQLTRACE TKPROF for developers.

. Configure database development and testing environments for users

OLAYAN DESCON INDUSTRIAL COMPANY, (SAUDIA Arabia) (May 1991-Feb

2003)

(Fabrication / Plant Erection for Oil, Gas, chemical, power Plants and

Oil refineries)

Position: intermediate database Admin / Developer

Projects:

. Material Management System

. Financial Application & Cost control Systems

(VB 6/ Crystal Report/ Oracle 7.3)

Contact this candidate