Manager Support

Curriculum Vitae

AbdulBakhi Shahed Mohammed

Address: Harrogate, North Yorkshire

Nationality: British Citizen

Driver’s license: Full and clean UK driving license

Email: ******@*****.***

Mobile: 0044 - 078********

PROFILE

An Oracle 11g certified Database Administrator with over 6 years’ experience of working with Oracle E-Business Suite R12 along with supporting SOA Fusion Middleware, as well as a number of other Oracle databases and 12c Cloud Control on Linux/AIX/Windows platform is currently seeking a new challenge.

SKILLS SET

Administration, Maintenance & Support: Oracle 10g, 11g, Oracle E-Business Suite 11i/R12, SOA Fusion Middleware 11g, Redhat Linux, OEL, AIX, Window 7, Windows 2008 R2.

Monitoring: OEM11g Grid Control, 13c Cloud Control, BSM, Service Manager (SM9), KanBan (Jira), SVN, Shell Scripts and Nagios.

EMPLOYMENT HISTORY

Wolseley UK Ltd Sep 12 - Current

Technical Analyst (Oracle DBA & APPS)

In this role my main duties are to provide 3rd line, and CSI support to Oracle E-Business (Financial), SOA Fusion Middleware, and other Oracle database Production systems along with supporting E-Business Development, Test, and UAT environments.

Migrated Database and Application monitoring from OEM 12c Cloud control to OEM 13c Cloud control.

Upgraded Application Management Pack (AMP) plug-in from 12.1.0.3 to 12.1.0.4 on 12c Cloud Control.

Automated Information Publisher reports for E-Business System Availability from 12c Cloud control for presenting to the senior management and for system monitoring.

Installed/Built Single/Multi node E-Business environment (RAC, Non-RAC, Single/Shared APPL_TOP)

Migrated databases from old in-house data center in Ripon to new European data center in Uxbridge and built non-prod environments at DR site in Leamington.

Perform periodic clones/refreshes of non-prod environment for supporting month-end, year-end and for resolving data specific related Production Incidents.

Perform periodic clones for Month-end, Year end and Cloned non-production, project environments from Production Primary/Standby, Disk/Tape Backup using RMAN.

Setup RMAN Backup of databases and application working with NetBackup Administrators and System Administrators.

Performed restore & recovery of databases from tape backup and disk backups using RMAN.

Performed restore & recovery of tablespaces, schemas using utilities Data pump.

Provided audit information on to internal and external auditors.

Applied Application, OMS, and Database patches (adpatch, adctrl, admrgpch, OPatch) including RPC’s.

Proactively & reactively tuned performance of resource intensive SQL using 12c Cloud Control (AWR, ADDM, SQL Tuning Advisory).

Setup alerting and monitoring on 12c Cloud control for both Database and Application using AMP.

Participated in DR rehearsals.

Raised several SR’s and worked closely with Oracle Troubleshoot the incidents until issues resolved.

Provide on-call support for 24/7 systems.

Provided KT sessions to new starters.

Documented SOP’s for iterative tasks which are performed on period basis and updated Known-Issues tracker for OOH support

Although my key strength is E-Business Suite, as part of BAU activity I perform weekly/period code deployment/support of non-prod and production environment:

oApplication code deployment to E-Business environments

oApply General Data fixes

oProvide users with output file of their concurrent request which is very large in size.

oStop and Start of concurrent managers if any OPP concurrent manager goes into stale sate following approval from Business owners.

oStopping and starting of EBS Application & Databases Linux patching and maintenance.

oSOA composite deployment to middleware using Antscripts and from console.

oMove third party files on the server for recovery of any failed interface.

oRolling restart of SOA Managed servers, resetting data sources.

oStopping and restarting of Weblogic server

oStopping and restarting of Node Manager

oCode deployment/support to WMS, NDC, ODS Dataware house environments.

Work within ITIL framework to raise/implement/resolve a Change, Incident, & Problems.

Belzona Polymerics Ltd Feb 11 – Aug 12

IT Support Technician (Duties and responsibilities)

In this role my main duties are to proactively and reactively monitor, administer and support Oracle Databases, along with supporting other Belzona production systems, and Oracle EBS SysAdmin,. Below is a summary of tasks performed routinely and on adhoc basis.

Installation: Creation of Oracle E-Business Suite Stage, Performed Single/Multi node installation.

EBS Backup & Recovery: Planned, Tested and Implemented EBS Applications and database backups and restores/recovery.

Sysadmin: Creation of Users, Assigning Responsibilities to users, Creation of Custom Responsibilities, Creation of request group, Creation of datagroup, Creation of Custom Application, Managing Concurrent Programs & Reports, Administrating Concurrent Managers, Creation of Custom Concurrent Manager, Managing Profiles Options, Structure of Profiles, Seeded Profiles, Custom Profiles, Managing Printers, Managing the Workflows activities (Notifications/Mailer).

Patching: Downloaded and applied patches, Perform Pre & Post Steps Checks, Patch History, Monitor & Troubleshoot Patch Sessions, Reduce Patch time (by Merging Patches, Patched Non Interactively, Patched on Shared AppsTier using Distributed AD Features, Patched on Stage Instance) Troubleshooting scenarios of failed Patch and Hanging Patch’s Sessions.

Upgradation: Upgraded EBS 11.5.10.2 to R12

Cloned using Rapidclone: Single Node to Single Node with Refresh, Single Node to Multiple Node, Multi Node Single Node.

Ensure that there is robust IT support (help desk) in place that supports the technical need of staff based in

the UK office, remote workers in the UK and staff based in US, Canada, & Thailand.

Provide training and support to staff when required

Lifecycle management of IT for personnel i.e. IT starter process for new joiners, carry out IT inductions and also

manage the IT process for leavers (e.g. email, IT equipment etc)

Manage the ‘asset tagging’ process of all new IT equipment ensuring it is correctly logged onto the database

Publishers Interactive Mar 10 – Dec 10

Database Support Technician (Duties and responsibilities)

Perform routine DBA activities for Oracle database instances.

Monitor and Manage Tablespaces and datafiles and Manage Database Users

Controlling and monitoring user access to the database and Application

Performed Database upgradation from 10g to 11g

Patching on Production and test environments, execute developer' installation scripts to create tables, indexes, stored procedures and load initial data, including upgrades after DBA review and approval.

Liaison with Oracle-Support for bug fixes and patch applications

Configure the standby database for the database through shipping of archive log file in high performance mode and make sure the proper shipping of archive logs using tns service.

Perform physical (OS level) backups as well as through RMAN utility. Assist the DBA in guaranteeing that the organization will not lose any data, and that data is always recoverable and available

Monitoring Alert log’s Backing and restoring the database.

Clone the database using RMAN as well as user managed.

Maintains strong relationships with all lines of business and business units, through customer focused service delivery.

Assist the DBA in maintaining documentation and coding standards, lessons learned best practices, and quality improvement documentation.

Total Systems (TSYS) Jul 09 – Jan 10

Oracle Database administrator (Duties and responsibilities)

Provide 3rd line support to internal and external customers.

Work closely with Design and Server teams to ensure that the best Database solutions are deployed.

Ensure that all Critical Security patches are deployed to all Databases in accordance with the Network Services LAN Operations (Standard Operating Procedures). Liaise with the Systems Management Server Administrator ensuring that automatic patch deployment poses no risk to Database operation.

Liaise with the Service Support team to resolve and report on issues, produce metrics and trending when required.

Ensure the appropriate change control ticket(s) is raised to cover any database work ensuring that tickets are approved in accordance with Service Centre guidelines.

Ensure that all Databases systems are available in accordance with the Corporate Network policy and client SLAs.

Continually reviewed the platforms and services under control and provide management updates to ensure that hardware and software components are refreshed at the appropriate intervals. Constantly review capacity and availability provide feedback, metrics & trend analysis for management review.

Ensure that databases are monitored via approved monitoring tools such as sitescope, review and test on a regular basis to ensure that alerting is fully operational, thresholds are meaningful, metric data is archived for historical analysis. Provide training and documentation for Operations staff as required.

Ensure that all critical data is backed up using RMAN to the relevant media and data restores are tested regularly.

Central Greenwich College Dec 07– Jun 09

Database administrator (Duties and responsibilities)

Provide first-level technical support for IT infrastructure supporting internal staff and college students.

Assist users with policies and procedures for setting up new accounts.

Escalate issues as needed and maintained communication with customer and Technical Teams. Extensively utilized

Remedy to record and track.

Demonstrate exceptional skills in professionalism and responsiveness across a wide variety of areas.

Assist in conducting DBA workshops and support students during their practice

Perform many Oracle server installation and patching

Create Databases using Manual and DBCA

Day to day database administration activities like user support, space management(including objects, tablespace and OS level)

Transferring required files between different servers and machines through SFTP & SCP

SQL*Net configuration (over TCP/IP)

Perform Backup and recovery (using Recovery Manager (RMAN))

Perform database refreshes using import and export utilities and RMAN.

Ambala Foods Apr 04 – Jul 07

Business Development Executive

Analyzed previous sales performance and established patterns for the supply of individual products to meet the customer demand.

Created logical and feasible solutions for order taking, production planning and dispatching finished products to the customers.

Administered and managed E-Commerce portal.

Increased sales through proactive marketing to the internal and external clients with the aid of periodic promotions.

Successfully signed a deal with Lufthansa airlines for supplying Indian confectionery for their in-flight promotions to their Asian destinations.

Liaison with TV channels, radio channels, and various publications for product marketing and advertising.

Organised and managed a public event of 10,000 audiences “Global Peach Event at Excel” working along side with the Islam Channel TV.

Organised photo shoots and video shoots for producing high definition advertisement for internal promotions, TV channels, and various publications.

Revised, designed art work and implemented it on companies’ stationary, packaging, banners, and dispatch trucks.

Liaison with suppliers for quotations and negotiated prices of raw material and packaging.

Managed stock inventory working along side stock control department ensuring efficient supply to the production and its timely replenishment.

Carried out research and development of new products working alongside technical teams and successfully launched new products.

Produced project feasibility report for integrating supply chain management;

Translated user requirements into highly specified project briefs;

Identified options for potential solutions and assessing them for both technical and business suitability.

Liaison with solution providers and a variety of end users to ensure technical compatibility and user satisfaction;

Supported end-users in sales, e-commerce and accounts department

Written user manuals; provided training to users of a new system;

Created feasible plan for the relocation of the food processing machinery before the relocation from the Olympic village site in Stratford to St Albans.

EDUCATION HISTORY

Sep 99 to Jul 03 B. Sc Hon ours in Business Information Technology,

South Bank University, London

Sep 97 to Jun 99 GNVQ Advanced in Business Information Technology,

City of Westminster College, London

PROFESSIONAL CERTIFICATION

Aug 2015 Oracle 11g DBA, Oracle Certified Professional (OCP)

TRAININGS ATTENDED

Oracle Database 11g: Administration Workshop II Release 2 (OCP 11g)

Oracle SOA Suite 11g: Administration

PERSONAL INTERESTS & HOBBIES

Play cricket, chess, table tennis, badminton, read books on popular psychology, & watch films.

References available on request

Contact this candidate