Resume

• 2009

  Alcatel-Lucent Enterprise

  Blue Cross Blue Shield of Michigan

  Banque Saudi Fransi

  Non-Profit Organization - Confidential

  Dearborn

  Database Administrator in Dearborn

  MI

  Database Administrator

  Non-Profit Organization - Confidential

  Pittsfield

  MA 01201

  SABIC

  Pittsfield

  MA 01201 Apr 2009 –Dec 2011\nRole\t\t : SR Oracle DBA Team leader\nEnvironment : Windows

  AIX

  SQL

  PL/SQL

  Oracle 9i/10g/11g

  OEM Grid Control

  Data-Guard

  SQL SERVER

  Scripting

  TOAD

  Dataguard

  OEM

  Oracle Streams.\n\n\nPerforming all the Database Administration activity like space management in database

  user and roles administration

  schema management

  checking alert log of all the databases\nInstalled High Availability database solution like physical standby databases.\nExperienced with RMAN

  BACKUP and RECOVERY

  POINT-IN-TIME RECOVERY (PITR) of databases.\nHands on experience working and managing VLDB’s up to 1TB. \nPerformed cross platform migrations from Oracle 10g to Oracle 11g ( AIX/Windows 2008)\nInstalled OEM agents and monitored them timely.\nReplicated databases and Data Guard for reporting purposes in OLTP environment with minimum lag.\nExperienced with RMAN

  BACKUP and RECOVERY

  POINT-IN-TIME RECOVERY (PITR) of databases.\nHands on experience in shell scripting for dataguard monitoring

  purge alert logs

  trace files

  \nProficient in migrating data base from 9i/10g to 11g by applying latest patch sets.\nMaintained Production databases.\nImplemented zero downtime migration and upgrade of 10g to 11g database.\nImplemented Oracle advanced security across various database levels.\nSQL*Loader; and Unix scripts to download and manipulate files.\nDeveloped and performed the quality assurance activities and unit testing.\nProficient in Oracle Materialized view replications.\nUsed Data guard for data migration from various database’s.\nInstallation and maintenance of Oracle 11g database.\nImplementing 10g Data guard with one physical database\nDeveloped Hot

  cold and logical backup scripts to automate the backup procedures.\nReplicated databases using Oracle Streams for reporting purposes in OLTP environment with minimum lag.\nInvolved in team management

  team building and lead the DBA team.

  Oracle Database Administrator

  SABIC

  Greater Detroit Area

  System Analyst II

  Blue Cross Blue Shield of Michigan

  Alcatel-Lucent Enterprise

  Loyola Marymount University

  Major Projects:\n\nActively participated in the launching of LMU website`s database project.\n\nLunch

  Participate

  and enhance the Information Technology documention project.\n\nAnalyze

  and review the SQL/PLSQL queries needed for the upgrade of LMU Extension websites database.\n\nResponsibilities:\n\nImplemented Oracle advanced security across various database levels.\nData migration and data distribution.\nInvolved in administration of Oracle 9i/10g R2 instances. \nWeb administration tasks with C# and .NET and MS. SQL server database.\nPerforming all the Database Administration activity like space management in database

  user and roles administration

  schema management

  checking alert log of all the databases\nMonitoring database events as part of a Production support and level 1 staff. \nExperienced with RMAN

  BACKUP and RECOVERY

  POINT-IN-TIME RECOVERY (PITR) of databases.\nPerformed cross platform migrations from Oracle 9i to Oracle 10g ( Solaris-Linux)\nProficient in migrating data base from 9i/10g to 11g by applying latest patch sets.\nMaintained Production

  Development

  Quality assurance database (QA) and Test databases.\nManaged production and development databases timely.\nUsed Data guard for data migration from various database’s.\nInstallation and maintenance of Oracle 10g database.\nExtensively used Erwin for data modeling and Dimensional Data Modeling.\nInvolved in the process of tuning and refining queries of various applications.\nImplementing 10g Data guard with one physical database\nConverted a single instance database to Oracle RAC 10g.\nOptimization and tuning SQL queries using TRACE FILE

  TKPROF

  EXPLAIN PLAN.\nExtensive usage of ADDM

  AWR

  ASSM

  features of 10g.\nDeveloping Hot

  cold and logical backup scripts to automate the backup procedures.\nDatabase Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.

  ORACLE DBA

  Greater Los Angeles Area

• 2007

  Master of Science (MS)

  MS in Computer Since and concentrate in finding a cheap solution for database recovery.

  Computer Science

  Loyola Law School

  Loyola Marymount University

  SQL&PL/SQL

  ORACLE

• 2006

  English

  MS

• 2003

  Role\t\t : Oracle DBA.\nEnvironment : IBM AIX

  Win NT

  SQL PL/SQL

  Oracle 10g

  9i and Oracle 8i

  Oracle Application Server 9i

  10g

  RMAN

  Sybase Adptive Server

  MS SQL 2000

  2005.\n\n\nResponsibilities:\n\n24 X 7 Production Oracle database support and administration and on call rotation. \nInstallation

  Configuration and Administration of Oracle 10g databases includes Database cloning for test environment and applying patches

  tuning etc.\nHands on experience working for replication of databases\nPerformed cross platform migrations for Oracle.\nImplemented zero downtime migration and upgrade of 9i to 10g database.\nBackup and Recovery

  Setting up and testing the backup and recovery strategies.\nOracle Database and SQL tuning using STATSPACK

  EXPLAIN PLAN

  TKPROF etc…\nUsed External Tables to Load data from flat files to database.\nImplemented different Partition methodologies to improve performance and manageability.\nDiagnose and troubleshoot Database problems and failures\nEstablish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.\nInvolved in the Design (Logical & Physical) of Databases\nInvolved in administering Oracle database running on Unix and Windows Machines to support Oracle database.\nInvolved in the installation of Oracle 10g

  on Windows NT and Linux. \nPerformed various database refresh’s

  patching

  upgrading over the databases.\nStorage and space management including table spaces and data files.\n\nDefined backup procedures using daily hot backups and weekly cold backup.\nBuilding disaster recovery solution for the bank from secrach using mainly Physical standby option and Oracle Data Gurad\nSybase administration on Aix and Migration through Sybase Reengineering tool to Windows server.

  Database Administrator

  Saudi Arabia

  Banque Saudi Fransi

  Detroit

  GTA

  Wayne State University

  Greater Detroit Area

  Graduate Teaching Assistant

  Wayne State University

• Provide IT solution to My Orphans Org

  My Orphan org Technical Support Manager

  Sybase Adaptive Server

  Troubleshooting

  Oracle 9i

  Databases

  Microsoft SQL Server

  M.S. SQL server 2000 - 2007

  Oracle Application Server

  Oracle Database 11g

  PL/SQL

  SQL

  Disaster Recovery

  Oracle

  Oracle Database 10g

  Oracle 8i-11g

  SQL Tuning

  Oralce 7

  Analysis

  Oracle Certified DBA

  RMAN

  Oracle SQL

  Alghumgham

  Hussein

  Alghumgham

  Loyola Marymount University

  SABIC

  Wayne State University