KHALED WAHBA

613-***-****

HTTPS://WWW.LINKEDIN.COM/IN/WAHBAKHALED

ac4nep@r.postjobfree.com

PROFILE :

Extensive technical experience in relational database management and administration with a solid background in logical and physical database design. Solid experience in Oracle Database Management with strong analytical and problem-solving skills, client focused with attention to details and a proven ability to assimilate and apply technologies through independent research.

An active team participant with excellent interpersonal and communication skills, that also excels in a self-directed environment, and thrives on new challenges and opportunities.

Specialties:

Database Technologies including Oracle, SQL Server ( MS SQL -2005, 2008, 2012)

ORACLE DBMS (ver. 7, 8i, 9i, 10g,11g and 12 ) on various operating systems UNIX, Linux, Windows, VMware on Sun, Hp, AIX and VMS

Database Technologies: Performance Tuning, Data guard, data warehousing, Emgrid 12c,13c, Patching, proactive monitoring, backup, RMAN, database security, capacity planning and operational 24x7 support

PROFESSIONAL EXPERIENCE

Bank of Canada

Senior Database Administrator Sep 2008 – Present

Migration from 11.2 to oracle 12, oracle 12 : install, upgrade, covert to pdb, snap clone

Supporting the bank’s financial systems and oracle dataware houses

Supporting the banking high availability systems ( oracle on Solaris sun cluster with dual data guard )

Managing 13c Emgrid for all targets, setup, notification, monitoring, alerts, reporting and tuning

Working in Coordination with enterprise data architects to implement database enhancements and take ownership of changes from logical design ( develop designs in ERStudio) and follow through to physical design and deployment

All DBA duties, install, upgrade, patch, build, maintain, tune, backup, monitor, recover, migrate .. etc

Shell scripting to automate, env setup, data refreshes, dataguard rebuilds, rman backups, custom monitoring

Cross-platform Database Migration ( soraris to Linux ) using various methods

Working as a development DBA, involved in daily scrums and working closely with data architects and developers

Provide bank wide database application production support ( on-call 24x7 and on-seat support )

Databases : Oracle 10g, 11g databases, middle tier components

Platforms : Unix on clustered Sun, windows, Linux on virtual machines

Data warehouse performance tuning, partitioning, text indexes, parallel query

Database Consulting

PWGSC Apr 2008 – Jun 2008

Short contract to consolidate various Unix sun servers and upgrade databases from 8i to 9i at the same time

CSC – Senior Database Administrator

Nortel Networks Global Database services Mar 2000 – Apr 2008

Supported 15 projects concurrently involving 30 to 40 (prod and dev) oracle database worldwide (8i,9i and 10g)

Provided DBA support to various Nortel Networks project groups : Optical Networks, Wireless, financials, web,OLTP

Provided oracle support in a multi platform environment, HP Unix, Sun Solaris, IBM AIX, Linux and windows

Provided close liaison with Oracle Canada on sensitive problem areas such as bug reporting, special patch request and other technical challenges

Pro-active Database Performance Tuning and Monitoring ( periodical database health checks, Oracle Enterprise Manager, 10g grid control, memory buffer tuning, I/O tuning etc.)

Application Performance Tuning ( SQl and PL/SQL tuning, tracing, explain plan etc ..)

Disaster recovery and contingency planning, implementation, backup and recovery ( RMAN )

Setup, maintained and monitored production database replication

Install, patch and maintain all Oracle software

Installation and configuration of the Oracle 10g grid control

Database creation, migration, upgrades, patching, cloning, reorganizing

Capacity planning, Space management and Security management

Review database design and approve all production schema changes and collaborate with development teams

Work closely with the Unix administrators to perform database server consolidation, migration, SAN storage migrations, failover server setup

Automated administration tasks through shell scripting (ksh, sh)

Mentoring and knowledge transfer to other team members.

Production database support, 7x24 on call rotation for all Nortel databases worldwide

Work closely with customers to resolve problems, meet and exceed SLAs (service level agreements)

Strong understanding of the Oracle 10g database Real Application Cluster (RAC) and Application Server Architecture including High Availability.

PRIOR EXPERIENCE

EDS Canada, Ottawa Global Delivery Center - Database Administrator

MCI WorldCom - Local Number Portability, Department of Justice - Canadian Firearms Registration System, Human Resource Development Canada - Income Security Program

Jeraisy Computers, Riyadh, KSA. - Database Administrator

Saudi General Intelligence Department - Application Redesign and Data Migration, Riyadh Municipality - Application development, Maintenance and Support

Maritime Research and Consultation Centre - Programmer

Developing a Maritime Data warehouse (Oracle 7 on HP Unix)

EDUCATION

B.SC. IN COMPUTER SCIENCE & AUTOMATIC CONTROL

FACULTY OF ENGINEERING, ALEXANDRIA UNIVERSITY, EGYPT

Contact this candidate