Sharmake Omar

**** ****** ***** ** #*

Toronto, Ontario

M9V 3S5

647-***-**** or acvvxs@r.postjobfree.com

TECHNICAL SKILLS FROM WORK EXPERIENCE

Installing and configuring Oracle 10g/11g/12c on Linux/Unix and windows platforms

Three plus years’ experience working with RDBMS databases running on Oracle and SQL server 2008/2012

Performing database migrations on all platforms

Mirroring and Replication using SQL server management studio

Log shipping SQL Server 2005,20098

Ability to manage high volume databases in terabytes

Extensive knowledge of SQL, PL/SQL and performance tuning, data modeling

Creating and maintaining database objects such as tables, indexes, views, synonyms, triggers, procedures, sequences

Managing Oracle Data Guard using DG broker for standby databases

Using Rman to implement database backup, restore and recovery to periodically perform disaster recovery tests

Using data pump utility to perform logical backup and import/exporting of schema objects as well as database migration

Replicating data using Oracle Streams and Golden Gate

Generating and analyzing AWR reports for performance analysis

Minimizing the risk of instabilities by using real application testing to capture workloads and assessing the impact of changes on production databases

Using Oracle flashback recovery to recover lost data and use queries to view past data

Extensive experience with Oracle patching and upgrades to the most stable version of Oracle

Configuring and installing Grid, migration of Oracle databases from non-asm to asm file system

Performing routine DB health management tasks such as gathering statistics, defragmentation,compiling DB invalid objects and instance hang analysis

Monitoring user session, roles and providing controlled access to application developers

Cloning databases manually and using RMAN utility

Tuning SQL using SQL trace and TKPROF

Managing tablespaces and partitioning tables using OEM

Applying patches to fix performance and security problems

Creating Unix shell scripts for various tasks such as backups and performance analysis

Work Experience

Hertz Rental

Returning cars back and forth from the airport to the main office.

Dealing with customer enquiries about the availability and cost of vehicles.

Completing paperwork with the customer and taking payments.

American Eagle Sept 2012- Mar 2013

Maintence on planes such as cleaning the plane and fueling equipments.

Loading and offloading the planes.

In the bag room organizing all bags.

PCL Agrium Potash Mine Dec 2011- July 2012

Cleaning work vehicles and company cars

Cleaning cafeteria’s, washrooms and offices

Pumped water out of areas using a sub pump

Assisted carpenters with tasks

Pinnacle Rental May 2010- July 2010

Showed vehicle to customers and pointed out any bumps, scrapes or special features

Checked mileage and scrutinized for damage when vehicles were returned.

Driving vehicles to and from rental agencies, also driving to customers for breakdowns

Colossus Cineplex Summer 2008-2009

Operated in Customer Service

Cleaned movie theaters and washrooms

Organized and distributed food products

ATS Solutions 2006-2008

●Loading, unloading, moving, stocking and staging products and materials using a forklift, clamp truck or other power equipment(sitting, standing and reach)

●Shipping: pull and pack carton’s and skid’s

●General clean up of job site and equipment on a daily basis.

Education

West Humber Collegiate Institute- High School Diploma 2004-2008

SENECA COLLEGE

Microsoft SQL Server 2008-2012 Database Administration

(September2015-Januay2016)

CERTIFICATIONS

ORACLE UNIVERSITY

Certified Oracle 11g 12c Database Administrator Associate

(Completed March2015)

Volunteer Work

YMCA Youth Volunteer 2005-2007

●Supervised domestic exchange youth

●Chief planner of annual community event

●Overlooked weekly and overall reports

Horn of Africa Community Development 2004-2005

Tutored young children in Math and English

Involved in mentoring and providing helpful advice to young children

Managed and kept a safe environment for the kids

Contact this candidate