Resume

Sign in

Database Administrator

Location:
Mississauga, Ontario, Canada
Posted:
October 28, 2016

Contact this candidate

Mounir Touahri

**, ******* ******* **** ****: 647-***-****

Mississauga, ON, Canada Email: acxaho@r.postjobfree.com

Database Administrator

Highlights of Qualification

Over 11 years of experience in IT industry including 9 years as a Database Administrator encompassing installation, configuration, patch installation, migration, upgrades, backup & recovery, cloning, replication, database security, memory management, performance monitoring, tuning, RAC, Data Guard, Grid Control and Enterprise Manager

Extensive knowledge on administration, installation and configuration of Oracle Databases 9i/10g/11g under Linux, Unix, Sun Solaris, IBM-AIX and Windows platforms

Strong knowledge and experience of managing Oracle 9i, 10g and 11g using the OEM Grid Control tools

Developed database monitoring/health check alert scripts for database uptime/downtime status and sizing issues using grid control (OEM)

Experience in providing 24x7 support to the production environments (On-Call DBA rotation support)

Extensive experience in database upgrades/migration between different environments and versions

Experience in applying critical patch updates (CPU), patch set updates (PSU) and other oracle patches under Linux, Unix, Sun Solaris, IBM-AIX and Windows platforms

Extensive knowledge in Database backup and recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN and Document)

Experience in using EXP/IMP, EXPDP/IMPDP to refresh/backup the schemas, replicate/migrate database and restore the DEV and Test databases

Proficiency in performance tuning databases of tera bytes size and SQL for Optimized results using various tools like STATSPACK/AWR, ADDM report, ASH, tkprof, SQL-Trace, autotrace and Explain-Plan

Extensive experience in dataguard configuration, implementing and monitoring standby databases

Hands on experience in installation, configuration and setup Grid Control (10g,11g) for database monitoring/performance/diagnostics

Hands on experience in oracle RAC 10g implementation & administration

Experienced in using features like database replay, partitioning, log miner, flashback technologies, schema management, case sensitive passwords and Security

Proficient in SQL, PL/SQL, stored procedures, functions, cursors and triggers and extensively used TOAD for querying databases etc

Experience in maintenance of databases on large production, Test, DEV environments and database security

Proficient in raising TAR with oracle support and using metalink to resolve Issues and bugs

Experience in Unix Shell scripting

Strong troubleshooting, problem solving skill

Result oriented, self-motivated, trilingual, excellent communication skills, ability to work independently and within a team, co-ordination and communication with system administrators, business data analysts and development teams

Expertise in Managing production databases on Ms SQL Server

Functional DBA with Ms SQL Server Administration […]

Designing security architecture in assigning database roles, creating logins for users, schema privileges, table and column level permissions

Proficient with SQL Enterprise Manager, SQL Query Analyzer

Deploying recovery model and interval log maintenance

Hands on experience in implementing log Backups

Mounir Touahri Cell: 647-***-**** Email: acxaho@r.postjobfree.com

Work Experience

IT Database Administrator 2011-FEB 2016

Optimum Telecom

OTA is a leading GSM operator company with more than 3000 employees. OTA offers mobile telephony services to individuals and businesses (over than 18 million subscribers).

Responsibilities:

Administered, monitored and maintained database solution (Billing, CRM, CCM, Fraud, Revenue Assurance, IVR, Calls, Loyalty, warehouse, HR …) over 45 Oracles and SQL Server database with an occupation area of up to 300 TB.

Managed and implemented the project with the collaboration of Oracle advanced support such as (Maintained and reviewed database performance, Security and Backup/Restore in order to identify opportunities for enhancements, patching and upgrades)

Upgraded Oracle Grid Control from 10gR2 to 11gR2 and integrated it with HPOVO.

Ensured E-Business Suite Systems patch and clone solution DEV, TEST and UAT environments.

Managed the Database technology Support ensuring high availability of all production databases to facilitate the proper functioning of all business areas. Upgraded, migrated and managed a huge DB

Managed database security, defined and improved the process according to SOX recommendation: segregation of duties, Control & Security Policy

Migrated Databases IVR, POS System, provisioning order management system solution

Upgraded Databases Revenue assurance, Fraud management, HP Openview solution, ETL and loyalty from 10g to 11gR2

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups

IT Database Administrator 2006-2011

Orascom Telecom

Responsibilities:

Deployed Oracle Grid Control successfully

Participated Billing System Upgrade & Migration project with Oracle RAC

Managed incident, changes and day-to-day internal client request. Supported the developers’ team. Tracked Incident with Oracle and Microsoft Support

Installed, created new databases, configured, patched, upgraded and migrated loyalty solution from Windows to HP UX platform and implemented Oracle Data guard

Established and maintained backup/recovery policies and exp/imp, expdp/impdp data

Performed general technical troubleshooting database performance, analyzed, administered and monitored Build monitoring and maintenance scripts of databases and UNIX/Windows

Administered, patched and cloned a DEV, TEST and UAT E-Business Suite system 11i.(11.5.10.2)

Administered SQL Server Database about 10 database server (Payrolls, Access, HR …)

IT Operation Analyst 2004-2006

Orascom Telecom

Responsibilities:

Monitored, analyzed and installed on production environments all new process rating, mediation, provisioning and CCM in TABS and INTEC (billing and interconnection systems)

Putted new products and platforms on production environments (GPRS, MMS, RCP, OSP, SSP and HUW)

Mounir Touahri Cell: 647-***-**** Email: acxaho@r.postjobfree.com

Implemented UNIX shell and Oracle PL/SQL scripts to schedule processes

Monitored provisioning processes, such as HLR command formats, related to new products (Mas Market, C&C

Corrected using background scripts (PL/SQL Oracle 9i), system’s defects such as HLR command regeneration

Education and training

Computer Science Engineer 2004

University of Algiers USTHB, Algeria

Bachelor’s and Master’s Degree 2015

Canadian equivalency, Wes World education Services

•Oracle 9i: PL/SQL, DBA1, DBA2 Oracle10g: RAC for administrators

•Oracle10g: Backup & Recovery Oracle10g: Grid Control

•Oracle10g: Performance/Tuning Oracle10g: E-Business Suite 11i administration

•Oracle10g: E-Business Suite Cloning and Patching Oracle11g: Oracle Security

•Oracle11g: WebLogic Administration Essentials Oracle11g: E-Business Suite 12i Oracle Apps/DBA

•SQL Server 2008: Maintenance SQL Server 2008: Restore/Recover Database

•Teradata: DB Design, Administration DWH Teradata Scripting Shell LUNIX.

•Design and operate a dashboard Project management according to PMI standards

•Service Delivery Management, ITIL & KPIs PPL Program Passion, Professional, Leadership

Technical Skills

Databases: Oracle 9i/10g/11g (RAC), MS-SQL, TERADATA

Operating Systems: UNIX, Linux, Solaris, Windows Servers 2000/2003/2012

Applications servers: Oracle Grid Control 10/11, Oracle application server 9/10, Oracle E-Business

Suite 11i

Languages: SQL, PL/SQL, Shell, Korn Shell, Perl

Tools: Toad, AWR, ADDM, ASH report, STATSPACK, TKPROF, DB Verify,

RMAN, Export/Import, DATA PUMP, ASM CMD, Sql*Net, OEM, NETCA, Adadmin, Adpatch, Adcontrol, Opatch, Adautoconfig, DBCA, SRVCTL, ORCAD, SQL Enterprise Manager, Management Studio



Contact this candidate