Sql Server Oracle

Hassan Dirie MCP, OCP

** ******* ******* ***** ********, ON, L7A 2C5, Canada

Tel. 905-***-**** ******@*****.***

CAREER OBJECTIVE:

Looking for a challenging position senior role in Database Administration or Database Analysis which utilizes my

COMPUTER SKILLS:

Languages: ORACLE DEV (Oracle FORMS, Oracle REPORTS, SQL LOADER), T-SQL, RPG/400, PASCAL, and COBOL

RDBMS: MS SQL Server 6/7/2000/2005/2008, Oracle 7.x/8i/9i/10g,

O/S: Windows NT/2000/2003/2008, UNIX (Solaris, AIX), Linux, Mac, DOS

Hardware: IBM RS6000, IBM AS/400, SUN E4500, Compaq Proliant and HP

Oracle / MS SQL Server DBA functions:

- install, configure, upgrade software: server, tools, applications

- monitor, tune, size, backup, recover, analyze, defrag, and migrate

- design and implement DB security, user management

- TSQL, SQL and PL/SQL: scripts, triggers, procedures, packages, automation projects

- high availability, 24/7, clusters, replication, standby database, RMAN

- design/model DB structures to support a variety of software applications

- support developers in tuning DB and apps for optimal performance

- monitor DB growth and provide DB capacity planning for apps expansion

- design and implement backup methods and disaster recovery strategies

- migrate DB between software versions, platforms, DB products

PROFESSIONAL EXPERIENCE:

Senior Database Administrator April-2006-Present

First Canadian Title /IT Architecture Work environment consists of Oracle 9i/10g and MS-SQL Server 2000/2005/2008 connected through LAN using Sun Solaris and NT/40 and 2000/2003/2008 Server.Installed and configured Oracle 8i/9i/10g and MS SQL Server 2000/2005/2008 and created Oracle and SQL Server databases according to specifications required for operation of applications requiring access to data.Performed SQL Server upgrade from 2000/2005 32 bit to SQL Server 2008 64 bit and upgraded Oracle from version 7/8i to 10gSupported development effort by providing T-SQL statement tuning and provided data load techniques and strategies, reviewed/analyzed SQL code (stored procs, views, tables, indices, UDFs and constraints), promoted databases changes to QA/Stress and eventually to production environment and used MS VSS for version control.Performed Capacity planning of Disk, Processors, Memory and Network bandwidth on the basis on data growth and usage ratio.Educated developers on proper coding practices and enforce coding policy/procedures.Performed analysis and provided recommendations related to Oracle/SQL Server database architecture or performance related improvement and database capacity planning.Designed and implemented backup and restore strategy that consists of full, differential and transaction log backup. Also, designed, implemented hot stand by disaster recovery site and performed and coordinated BC/DR test every three months with business units.Managed database physical storage and structures, developed and implemented Backup and disaster recover strategy as FCT requirement.Monitored Oracle/SQL Server databases usage and tuned systems to optimize performance Provided technical expertise to resolve database incompatibility issueIdentified, tracked and reported daily problem/issue/progress to Project ManagersCreated and maintained ETL /SSIS packages which utilized different source system s including mainframe, Oracle10g and CSV filesDesigned availability infrastructure with Oracle Server Cluster and MS clusterProvided 7x24 database support for business systems users and provided 99.9% of databases availability as per FCT Service Level Agreement with DBA team.

Sr.Database Administrator Nov-2000 April-2006

AIC Group of Funds / IT Services http://www.aic.com/Work environment consists of ORACLE 9i/8i/7.3.4, MS-SQL Server 7/2000 and AS/400 connected through LAN using UNIX (SUN/OS), NT/40 and 2000 Server on MS Cluster.Supported development effort by providing T-SQL statement tuning and provided data load techniques and strategies, reviewed/analyzed SQL code (stored proc, views, tables, indices, functions and constraints), promoted databases changes to production environment, used VSS for version control and documented implementation issues into Remedy system.Designed and developed SQL Server databases that meet .NET/ASP application developer’s requirements. Installed, configured SQL Server/Analysis Server 7/2000 on NT 4.0./2000/2003 environments. Performed evaluation/installation of service packs/hot fixes.Proactively tuned databases and studied server activity with SQL Profiler, NT event viewer and SQL Server error logs to minimize contention problems and locking issues. Performed data transfer/migration/Refresh between AS/400 and SQL Server 7/2000 and Oracle 7.3.x/8i/9i and SQL Server 7/2000 using DTS mechanism. Also participated data migration between Miximizer contact management and Siebeljanna CRM database.Installed and configured Oracle databases and configured to its optimum by coalescing free space, sizing the buffer cache, tuning sort operations, monitoring locks, balancing disk I/O, memory allocation and Shared-pool sizing, monitored/assessed Oracle parameterization and managed database configuration (data files, control files, redo log files)Designed and implemented a backup strategy. Managed RMAN backup software/technology and other tools i.e. OEM (Oracle Enterprise Manager) that are yet to be implemented and performed/coordinated Disaster Recovery Test for twice a year on remote siteImplemented server and database level security for SQL and Oracle

Database Administrator August-1999 Nov-2000

MD Robotics / IS Dept .Work environment consists of ORACLE 7.3.4/MS-SQL Server 6.5/BaaNIV connected through LAN using UNIX (SUN/OS), NT Server and Novel NetWare.Performed Oracle DBA duties such as installing/upgrading Oracle Server 7.3.4 and application tools, creating Oracle database storage structures and primary objects allocating system storage and planning future storage requirements for the database system, modifying Oracle database structure, controlling and monitoring user access to the database, backing up/recovering the Oracle database, maintaining system security, developing SQL*PLUS scripts and optimizing database performance such as sizing buffer cache, balancing disk i/o, memory utilization and shared-pool sizing.Administrated SQL Server databases and performed SQL Server DBA activities such as installing/applying patches, backing up/recovering, databases/devices creation, managing database users and security, performance monitoring and tuning databases accordingly, scheduling maintenance jobs such as DBCC commands, INDEX reorg, update statistics and writing/implementing stored procedures and triggers. Managed BaaNIV system and performed directory structure, user management, device management, text management, database management, job management, version and release control (VRC) structure and license management.Developed UNIX scripts using Unix Korn Shell.Coached, taught and directed junior DBA staff in Oracle,SQL Server and BaaN.Developed system documentation and system upgrade plans for MS SQL Server 7.0

Database Administrator Nov-1998 August-1999

Sun Life of Canada / Software Services Dept Work environment consists of MS-SQL Server and DB2 Databases connected

Through LAN and WAN using NT Server and Novel NetWare.Installed and upgraded SQL Server (Standard and Enterprise Edition) locally/remotely Set up SQL Mail, Configured and enabled it to communicate with non MAPI interface

by using Eudora Pro 4.1 as an interpreter.Monitoring the Database’s health and tuning it accordingly Performed other DBA duties including backup/recover, database maintenance, Index reorg, DBCC commands, Update Statistics, performance monitoring, and managing database users and security.Provided 7/24 hours database access and worked closely with developers/team leader.

Database Administrator May-1997 Nov-1998

Toronto Dominion Bank / Wealth Management Services http://www.tdcanadatrust.com/ Work environment consists of Oracle, DB2 and MS-SQL Server databases connected through LAN and WAN using NT, and UNIX (AIX) operating systems Installed and configured MS-SQL Server 6.5 for optimum performance.Evaluated physical and logical data model, allocating storage for devices & databases,

creating database objects such as tables, indexes, views and stored procedures.Analyzed & debugged all scripts and systems change prior to implementation. Converted Watcom (SQL AnyWhere) database to MS-SQL Server database 6.5.

EDUCATION:

Bsc (Hons) Computing And Information Systems (Dl) 2007-09

Portsmouth, Hampshire, UK

Certificate in Information Technology Infrastructure Library (ITIL) 2005

BWYZE, Richmond Hill, Ontario

Certificate in Developing High-Performance Microsoft SQL Server Databases 2002

Learning Tree International, Toronto, On

Certificate in Implementing Business Logic with MDX 2002

ThinkPath, Toronto, On

Certificate in Oracle 8.0 Server Backup and Recovery 2000

Oracle Corporation, Mississauga, On

Certificate in Oracle 8.0 Performance Tuning 2000

DesTech Consulting and Education, Toronto, On

Certificate in BaaNIV Tools 1999

BaaN Canada, Mississauga, On

Certificate in Oracle7.3 Server Database Administration

Learnix Ltd, Toronto, Ont. 1998

Certificate in Performance Tuning and Optimization 1998

Certificate in Database Design and Implementation 1998

Certificate in MS-SQL Server Administration 1997

Object Arts, Toronto, On

Diploma in RDBMS/ORACLE PROGRAMMING 1996

University of Toronto (Deeds Project) Toronto, Ont.

Diploma in COMPUTER PROGRAMMING and Analysis 1993 - 96

Seneca College, Toronto, On

REFERENCES: Available upon request

Contact this candidate