Oracle Data

PROFESSIONAL PROFILE

Ali Bin Osman

IT Support Engineer

Mobile: +971*********

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

OBJECTIVE

Having 7 years of Experience in I.T, Installation, configuration, Planning & Implementation of various technologies in Oracle database.

Professional summary:

Handled mission critical 24/7 database environments.

Expertise in installation and configuration of Oracle 10g/11g on Windows Servers and Linux.

Configured DR site for critical production databases and tested for failover and switch over.

Experience in Memory Tuning, Tuning at Application level and optimization of queries.

Database Tuning – Tuning Applications, Tuning Memory, Tuning I/O and Tuning Disk Usage.

Memory tuning, SQL query tuning by using AWR, ADDM, ASH.

RMAN cloning with Active Data Base.

Create and configure Data guard, Physical Standby, Snapshot standby databases.

Convert protection mode Like Maximum Protection, Performance, Availability

Manage and monitor ASM instance and Managing ASM disk groups.

Database Migration

Also having knowledge on various Oracle 11g new features like schema management, table space encryption, Active and snapshot standby (new features of data guard in 11g).

Managing Tablespaces.

Creating database users and by setting the default & temporary table spaces, assigning quotas, roles, privileges and profiles to users.

Extensively using the Export/Import Utilities for selective regular backup, incremental (Incremental, Cumulative, Complete).

For taking fast backup using DATAPUMP (parallelism), using DATAPUMP Plugging the Table space in different platform (Windows and Linux).

Creating Materialized view and materialized view log on master table for fast refresh.

Creating the Private, Public database links.

PTR (point-in-time recovery through) COLD, HOT and RMAN.

Collecting performance statistics using AWR (Automatic workload Repository) and Analyzing by Using ADDM (Automatic Database Diagnostic Monitor).

Hands on experience in STATSPACK, TKPROF, and EXPLAIN PLAN utilities for improving the performance of the Database.

Memory Tuning using ASMM (Automatic shared memory Management). Sort area size, shared Pool size, Different pool like keep pool, Recycle pool.

Availability through log miner.

Worked with Different types of Partitioned tables.

Monitor RMAN backup and configuration with help of data dictionary views.

Check backup and archive log availability with the help of crosscheck.

Manage space allocation and rebalancing.

Reorganized databases to minimize fragmentation for maximum performance.

Implementation of advanced Indexes.

Installed and configured 2 Node RAC and tested for failover.

Configured high availability services for load balancing and tested for failover.

Patched and upgraded 10.2.0.2 RAC environment to 10.2.0.4 RAC environment.

WORK EXPERIENCE

Presently working with NATIONAL BANK OF ABU DHABI (FAB) through TASC Outsource as Oracle DBA from August 2014 till date.

Worked as an Oracle DBA for IT LABS INDIA Ltd from April 2011 to July 2014.

QUALIFICATION

MBA from Jawaharlal Nehru Technological University Hyderabad 2013

B.com from Osmania University India, Hyderabad 2011

12thfrom M.S Jr College Malakpet, Hyderabad 2003

10th from Fr Roch Memorial High School, Hyderabad, India 2001

Technical Skills:

Operating system : Linux, salaries.

Database : Oracle 10g/11g (10g RAC).

Languages : SQL,

Oracle Tools : EXP, IMP, SQL plus, OEM, TOAD

Database Tools &

Utilities : OEM, SQL*Loader, TKPROF, Export /Import, RMAN, Data Pump

Project Experience:

Project #1:

Title : CFST (Citizen Friendly Services of Transport Department)

Client : APRTA (Andhra Pradesh Road Transport Authority)

Role : Database Administrator

Project Type : Production Support and Maintenance.

Database version : Oracle 11g.

Operating System : Linux.

Roles & Responsibilities:

Installation and Configuration of Oracle10g databases on windows and Linux.

Upgrade databases to latest versions.

Maintaining and configuring of data posted through the front end forms in to the central data base

Updating and modifying of backend data of customers following standard processes in case of

Any issues or discrepancies

Enhance database administration by automating administration tasks, for e.g. developing scripts for new patches, check alert log files for error messages, Clean up old log files before log destination gets filled.

Created new user accounts, profiles, and roles, assigned them to different users, and enabled auditing to monitor the system privileges and roles granted.

Database links created to access the data from remote databases.

Create and Manage Tablespace, Datafiles.

Designed and implemented cold and hot backups using RMAN.

Manage backups with RMAN/EXPORT.

Monitoring the mount point size limits and performing necessary actions.

Monitoring Oracle backups.

Monitoring alert log.

Monitoring the locks and waits status for oracle processes

Monitoring archive logs

Monitoring the lock and wait status of oracle processes.

Monitoring alert log report daily for oracle errors.

Re-organizing the tables.

Create/Clone databases.

Maintain database security.

Creation and configuration of standby database.

Cloning databases from:

RAC to RAC, RAC to Non-RAC and Non-RAC to RAC

Project #2:

Title : E-Governance

Client : E-Governance

Role : Database Administrator

Project Type : Production Support and Maintenance.

Technologies : Oracle10g

Roles and Responsibilities:

Creating database and table spaces.

Installed Oracle server Software

Design, Creation and Maintaining of Standby Database for no data loss

Complete Database and system administration support for the project

Taking the Logical, Cold and Hot backup of the database regularly.

Monitored table spaces & their growth and took proper actions.

Created users and granted appropriate privileges.

Maintaining System security, defining of roles, profiles.

Installation and Configuration of Oracle10g databases on windows and Linux.

Upgrade databases to latest versions.

Maintaining and configuring of data posted through the front-end forms in to the central database

Updating and modifying of backend data of customers following standard processes in case of

any issues or discrepancies

Enhance database administration by automating administration tasks, for e.g. developing scripts for new patches, check alert log files for error messages, Clean up old log files before log destination gets filled.

Created new user accounts, profiles, and roles, assigned them to different users, and enabled auditing to monitor the system privileges and roles granted.

Database links created to access the data from remote databases.

Create and Manage Tablespace, Datafiles.

Designed and implemented cold and hot backups using RMAN.

Manage backups with RMAN/EXPORT.

Monitoring the mount point size limits and performing necessary actions.

Monitoring Oracle backups.

Monitoring alert log.

Monitoring the locks and waits status for oracle processes

Monitoring archive logs

Monitoring the lock and wait status of oracle processes.

Monitoring alert log report daily for oracle errors.

Re-organizing the tables.

Create/Clone databases.

Maintain database security.

Creation and configuration of standby database.

Personal Information

Father’s Name : Osman Bin Ahmed

Date of birth : 16 Jan 1985

Gender. : Male

Marital Status : Married

Nationality : Indian

Passport no. : G1890082

Language Proficiency: English, Hindi, Urdu

Contact this candidate