Resume

Sign in

Oracle Manager

Location:
Fort Washington, MD
Posted:
April 30, 2016

Contact this candidate

Resume:

Haytham Suliman

** ********* **.

Nottingham MD *1236

acukuz@r.postjobfree.com

650-***-****

Sr. Oracle Database Administrator

650-***-****

Summary:

Oracle Certified Professional (OCP) 8i/9i/11g in database administration, design and development.

More than thirteen years of experience in database administration, design (Physical & logical), development of Oracle 12c/11g/10g/9i/8i/8.0 with focus on Migration, RAC, DATAGUARD, RMAN with EMC Avamar 6.1, VERITAS, TSM under Linux, AIX, HP-UX 11.0, Solaris 2.7 environment handling both production and development databases.

Expert in handling both production and development database environment of various databases on multiple platforms

Experience in UNIX (AIX, Solaris, Linux and Tru64) Windows NT/2000 & 95. Oracle 9i/8i/8.x – Installation and configuration of Oracle and large databases on UNIX (AIX/ SUN/HP) and Admin. Functions, security Planning, Creation of Database, Physical Database Configuration and Disk Space Layout Planning using NAS (Netapp F820, EMC Symmetrix 8000 series) & SAN (IBM & SUN Blades) storage.

Education Qualification & Certifications:

Oracle Certified Professional 11g 2012

VMware Sales Professional (VSP 4) 2010

VMware Technical Sales Professional (VTSP 4) 2010

IT Infrastructure Library (ITIL v3) 2010

Netapp Certified Data Administrator (NCDA) 2010

Masters in Computer Information Systems, UOP, San Jose CA, USA 2005

Oracle Certified Professional 9i - 2003

Oracle Certified Professional 8i - 2002

Sun Java 2 Certified Developer - 2001

Sun Java 2 Certified programmer - 2001

AA Integrated Avionic Technology – 1997

Bachelors in Computer Science, AAST, Egypt, 1996

Awards & Achievements:

US Air Force Achievement Medal

US Armed Forces Expeditionary Medal

Southwest Asia Service Medal

US Armed Forces Service Medal

Professional Experience:

NES Associates, 11/2014 – current

Oracle database engineer

Part of a new team to scope and architect a new development and test lab including developing proposal, inventory, tech specs, budgeting and business analysis.

Installed and configured 12c for testing migration from 11g.

Performed STIG to oracle databases 11g. Implemented security measure like oracle wallet, Tablespaces encryption, oracle auditing and listener security.

Install and configure 11G databases and integrate with applications.

Upgrade 10g to 11g databases.

Developed shell scripts to automate management tasks.

Documentation

InScopeInternational/PRISM/LSi, Washington D.C. 4/2010 – 9/1/2014

Coached and sponsored junior to mid-level DBAs for the HR DoS team. This includes developing step by step work documents, training, day to day guidance.in troubleshooting.

Assisted in architecting and developing high level HR projects including upgrade of all the backend systems from 9i to 11g, setup central monitoring 11g Grid Control for mid-tier and backend systems, Business continuity and disastrous recovery using EMC VPLEX and SRDF, develop a program to refresh DEV, TST databases from production databases on daily basis.

Develop and architected backup programs for all productions databases using OSS in ASM

11g RAC installation on ASM

Implemented Oracle Wallet for TDE (Transparent Data encryption).

Provided proposals and developed new methods and work processes to streamline periodical release and scheduled maintenance resulting in cut of costs. This includes automation of routine work, study and analyzes of legacy systems and provided alternative solutions that cut costs in terms of time and efforts.

Design VI solutions for DoS data center

Install/configure/ tune VMware products.

Install, configure and tune ESX hosts

Upgrade ESX software

Apply patches and firmware

Assemble, rack and install HP c7000 BladeSystems enclosures, blades and hardware.

Configure HP blades Onboard Administrator, Virtual Connect, FlexNet NICs and FC modules.

Troubleshoot HP blades, remove and replace parts

Perform on-call duties

Update passwords

Create, customize, deploy and manage VMs

Install, configure and test 11g Oracle RAC in virtual environment for bench mark.

Work with developers to tune virtual Oracle environments

Work with Architects to plan and develop transition plans to migrate Oracle databases to virtual environments.

Respond to customer real world issues and provide suggestions to technical concepts

Monitor HP blades, VMs and respond to alerts.

Assist with storage team(Netapp SAN) with applying PKI certificates to Netapp Filers, audit DFS (file shares), monitor scheduled snapmirrors and rack filers

Watch and Complete tasks submitted in Remedy system, Internal Service Request and requests thru emails.

Qinetic North America / 3HT Technology 5/2009 – 4/2010

Sr. Oracle DBA

Provide database/middle tier systems and application support for Oracle based technologies.

Researched new 11g Snapshot standby database features.

Tested migration of 10g to 11g.

Worked with 10g Grid Control configurations and agent install and deployment.

Install and configure Oracle 10g databases, Oracle application server 10g.

Responsible of automating daily DBA tasks using UNIX BASH scripting.

Maintained and resolved 10g Dataguard issues.

Assisted with installing and configuring Cognos 8

Apply database patches.

Worked and modified PL/SQL code.

Assisted in maintaining Oracle Forms code in CVS

Environment: Red Hat AS 4.0, IBM blades, SUN Blades, ColdFusion, J2EE, Oracle 11g, Oracle 10g, Oracle Forms 9i, Oracle iAS 10g, Cognos 8

ProQual I.T, Rosslyn, VA 6/2008 – 4/2009

Sr. Database Engineer

Supported and managed the US-VISIT (Department of Homeland Security) Enterprise Reporting System Oracle 10g database schema release using CVS and Version Manager.

Worked and troubleshot issues with Advanced Queue (AQ) and automated a Metalink internal note to resolve known AQ orphan objects using PL/SQL.

Developed scripts in PL/SQL, UNIX shell scripts to facilitate database management.

Analyzed data, performed code reviews and identified architectural issues by enforcing integrity relationships in the source tables instead of Materialized Views.

Performed SQL tuning using Explain Plan and suggested query rewrite, using hints and create of indexes to eliminate Full Table Scans.

Worked with Oracle schedulers

Worked with release documentation.

Responded to ad-hoc database requests and resolved various database issues.

Reardencommerce, Foster City, CA 6/2007 – 6/2008

Sr. DBA

Performed senior database administrator duties.

Planned and developed database management projects

Setup Dataguard for disastrous recovery plans

Installed and setup Grid Control monitoring.

Installed and configured ASM for storage management in LINUX platform for analysis and testing purposes.

Troubleshot performance issues and developed solutions

Worked with application and QA team to resolve design problems.

Analyzed and presented PPT featuring 11g new features.

Yahoo Inc. Sunnyvale CA 6/2006 – 6/2007

Sr. Oracle DBA

Worked as the primary Database engineer for Oracle 10g environment for the Yahoo mobile systems (Y! Go) application for mobile devices.

Setup, installed and configured 10g in RAC environment using NetApp.

Developed cold/hot backup & recovery scripts using NetApp snapshots.

Worked closely with system engineer to configure Netapp storage using Netapp System Manager tool

Developed monitoring scripts to alert, capture debugging oracle data and to automate some of the DBA daily routine tasks.

Setup and worked with AWR reports

Performed duties of database upgrade from 10.1 to 10.2.

Managed and worked with 10g Enterprise Manager (Grid Control)

Performs on-call duty.

Worked close to developers to tune SQL statements and Applications support

Environment: Red Hat AS 4.0, NetApp, JBOSS, JMS, JDBC, EJB, PL/SQL, Oracle 10g, RAC, 10g EM

MobileAria Inc. Mountain View CA 1/2006 – 6/2006

Database / Application Admin

Worked as the primary DBA for Oracle 10g environment.

Setup, installed and configured 10g Data Guard.

Plan, develop and implement disastrous recovery strategy using 10g RMAN scripts for different backup & recovery plans.

Setup & installed Oracle 10gR2 RAC using Clusterware on Netapp

Installed, configured and tested ASM for storage management in LINUX platform using raw devices.

Developed Oracle monitoring scripts for Big Brother Alerts using BASH & Korn shell.

Setup and worked with AWR reports for tuning

Performed duties of database upgrade from 10.1 to 10.2.

Installed and configured 10g Warehouse using (OWB)warehouse builder

Managed and worked with 10g Enterprise Manager.

Performs on-call duty

24/7 support

Worked with SonicMQ 6.0 (Java Based messaging system)

Applications support

Assisted in Setup Kerberos servers.

Environment: Red Hat Linux AS 3.0, Red Hat AS 4.0, NetApp, JSP, JDBC, PL/SQL, Oracle 9i/10g, Windows 2000 Server, SonicMQ 6.0, RMAN, RAC, Oracle 10g Data Warehouse, Unix, Oracle Warehouse Builder (OWB), SUN Storage 1000A.

Genentech, South San Francisco CA 8/2005 - 11/2005

Database/ Applications Admin

Setup Oracle 8i/9i/10G databases environments.

Participated in database and application schema architect for the Research environment.

Worked with Materialized Views and implemented snapshot replications.

Developed processes to facilitate data loading using transportable tablespace.

Installed, configured and tested Oracle 9i on RAC (Real Application Cluster).

Performed database tuning for distributed applications via dblinks using Statspack and SQLTrace.

Developed and automated applications management using UNIX shell scripts (korn89/Bash)

Performed DBA support for Oracle Datawarehouse 9i.

Troubleshot and worked with Oracle Java classes.

Cisco Systems, San Jose CA 4/2005 – 8/2005

Database/ Applications Admin

Setup, implement, and deploy Oracle Advanced Queuing (AQ).

Developed and automated processes using PL/SQL for recovering Oracle databases from Advanced Queuing object corruption.

Troubleshot and debug AQ propagation problems.

Worked with Oracle support to debug and implement solutions for Oracle bugs and Oracle internal problems

Setup Oracle 8i/9i/10G databases environments.

Installed, configured and tested Oracle 9i/10G on RAC (Real Application Cluster).

Performed database tuning using Statspack and SQLTrace.

Setup testing environment simulating Production environment to troubleshoot complex enterprise Load performance. This involves installation of Perl modules, JDBC connection pooling and setting up and installation of Bea Weblogic 6.2

IBM, Burlingame CA 10/2004 – 12/2005

Database/Unix Admin

Design, setup, networked and configured UNIX servers for a newly built data center for WebSphere Integration Team (WBI) (AIX 5.2, Solaris 8, Linux RH 2.4, Linux Suse 9.1)

Installed and configured HMC for managing AIX servers

Design, Install & Configure Oracle (9i, 10g) & DB2 8.1 test databases

New United Motors Inc, Fremont, California 08/2004 – 10/2004

Database Administrator / Application Engineer

Responsible for monitoring and achieving maximum database performance.

Plan and perform all database configuration, management, monitoring, tuning, capacity planning, data extraction, backup and recovery using RMAN.

Performed migrations to all PeopleSoft8 backend repositories from Oracle 8.1.7.4 to Oracle 9.2.0.0

Configured, administered Oracle databases for PeopleSoft8

Worked with EMC Symmetrix 8000 Series (Control Center v5.1.18.3)

Migrate Oracle parallel Server (OPS) (Oracle 8.1.7.4/HP-UX) to Real Application Cluster (RAC) (9.2.0.4/HP-UX)

Apply Oracle patches to upgrade to 9.2.0.4

Charles Schwab, San Francisco, California 04/2004 – 08/2004

Oracle DBA

Installed, configured and administered oracle (8i, 9i, 10g) and UDB v7.1 and v8.1 databases. Worked with Oracle 9i Data warehouse & (Power Center) Informatica 6.2

Installed and configured Weblogic and Websphere Application Server

Installed Veritas Volume manager and Set it up for taking regular backups and recovery.

Responsible for all aspects of Oracle 9i & 10g Database Administration in a production phase to facilitate 24/7 operations.

These responsibilities include database configuration, backup and recovery, capacity planning, improving database performance, data extraction, troubleshooting, security, schema maintenance, applying patches and performance tuning.

Used Encryption wizard to configure & enable data encryption

Used Parallel query server processing, Tuning tools like EXPLAIN PLAN, SQL Trace, TKPROF, scripts like STATSPACK, monitoring SQL tuning through use of optimizer hints within SQL statements. Reorganized the database to reduce fragmentation, which includes table, index, Synonym etc

Architected and planned a 3-tier module for the rollout of BMC monitoring and administering tools to more than 240 production and development UDB and Oracle databases.

Developed Java program and stored procedures to automate the installation and configuration of BMC software. Administered BMC middle tier application server. Used the BMC tools to perform DB troubleshooting, SQL trace and databases tuning.

Worked with oracle failover and RAC. Used shell scripting to create tarballs as part of the rollout plan for BMC software.

TRIGO Technologies, Brisbane – California, 9/2003 – 3/2004

Sr. Oracle Database/ Unix Administrator

Performed the roles of UNIX administrator and Oracle DBA.

Installed, configured and tested Oracle 9i on RAC (Real Application Cluster).

Assisted with the daily maintenance and administration of Oracle 9i on different platforms like Linux, AIX, HP-UX and Solaris.

Performed Unix Administration activities like creating and managing users accounts, Disk Management, Disaster recovery, handling UNIX kernel parameters, file system permissions, startup and shutdown daemons, Automation of data loading process using UNIX crons and extensive usage of UNIX awk, sed scripts and Perl.

Involved with adding, modifying and promoting database objects through the development environments.

Performed Oracle 9i/10g and SQL tuning with the development teams.

Responsible for all aspects of Oracle 9i Database Administration in a production phase to facilitate 24/7 operations.

These responsibilities include database configuration, backup and recovery, capacity planning, improving database performance, troubleshooting, security, schema maintenance,

Assisted in installing and configuring PERFORCE and perform control management tasks.

Installed and configured Weblogic and Websphere Application Server

Installed Veritas Volume manager and Set it up for taking regular backups and recovery.

Installed and maintain Oracle security server and setup server side security.

Worked with ANT and generated configured builds.

Configured the Standby Database for high availability of the database and Cloning.

Responsible for building, configuring HP OpenView/Performance Insight

Extensively used Unix Shell Scripting (Korn shell/Bourne shell/C Shell), CGI-Perl and JSP scripts to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring crons, usage of ufsdump, ufsrestore, cpio, and tar. Alerts

Performed Space management, Defragmentation of the database.

Implement RMAN backup script for taking Full, Incremental backups.

Racked, setup and configured Netapp F820 for Oracle storage

ADP / PROBUSINESS, Pleasanton, Ca 5/2003 – 8/2003

Oracle Database Engineer and Administrator

Installed, managed and configured Oracle databases and responsible for 24x7 production support

Configured and managed Oracle Advanced Security features

Handled online application downtime problems and worked with IIS 5.0, DNS and Load balancer (BGP).

Configured RMAN, with TSM for backup, recovery

Installed, configured and worked with OEM.

Involved with upgrades, migrations, cloning and performance tuning

Worked with documentation and change control management.

Applied online application upgrades.

Worked with SQL Server management in clustered environment. Platforms used were Solaris, windows 2000 and Windows NT.

Worked with ETL & Data Mart for Finance Dept.

The logical data modeling was done after going through the existing system and plans were suggested.

Created and modified Oracle Schema objects like Tables, Indexes.

Created Programs in PL/SQL to implement business Logic.

Installed HP OpenView Performance Insight Manager.

Extensively used the Entity relationship, Data Flow diagrammer, Repository, Repository reports, Database Transformer etc.

ITRON, Spokane - Washington, 3/2002 -12/2002

Engineer

Performed duties of quality assurance and software testing for power & energy applications.

Worked with SILK TEST software to develop scripts and harnesses to debug .NET enterprise applications

Installed, managed SQL Server 2000 for the QA environment

Experience with identifying and submitting software defects/bugs and categorizing priorities using RATIONAL TEST SUITES.

MEDICALERT, Modesto - California, 5/2001 to 7/2001

Java Client/Server Developer

Modeled, planned, developed and implemented a Java client / server solution to maintain medical records.

Application developed using Enterprise JBuilder 6.0 tools to develop Java SWING GUI components.

Developed JDBC to interact with PL/SQL code using SQL*PLUS and TOAD.

Developed web reports using JSP, JServlet and HTML on BEA Weblogic servers for the company Intranet.

United States of America Air Force – Fairchild Washington March 1997 – March 2001

Communication/Navigation Technician

Military Basic Training.

OSHA responsibilities for the flight, training, documentation and follow up.

Performed duties of an avionics technician in KC-135 refueling aircrafts and H1 helicopters.

Expert in full aircraft maintenance in hangers.

Honorably discharged



Contact this candidate