Oracle Sql Server
Resume:
[pic] [pic]
[pic]
SHAKIL ZUBAIR
**************@*******.*** Cell. 1-416-
*** ****** ***** ****** **, Canada Home 1-
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