Oracle Sql Server

[pic]

Mohammed Mehraj Hussain

***,*** *****, ****** ********

1st Cross, B.T.M Layout 1st Stage,

Old Madiwala,

Bangalore - 560068.

Mobile: +91-984**-***** E-mail: *********@*****.***

Overview

. Having around 6 years of experience in Oracle and SQL Server

Database Administration and Development.

. Hands-on experience with Installation, configuration and

Administration of Oracle on Windows, Red Hat Linux and HPUX

Operating Systems and SQL Server 2005,2008 on Windows Operating

System.

. Extensive Knowledge in High availability Methodologies like Oracle

data guard and Oracle RAC.

. Implementing Database security on Oracle and MS SQL Databases.

. Strong knowledge in Oracle database architecture, Database

Management, Oracle Data dictionary, Performance tables, Views and

Sizing of various table spaces viz. data, index, undo, temp etc.

. Experienced on Optimizing Oracle databases and tuning resource

consuming sql statements.

. Planning and allocations of system storage and future requirements.

. Dynamic space management by eliminating migration and chained rows

in data blocks, and assigned large rollback segments for long

transactions.

. Importing Data according to the users request and maintenance of

Oracle Production, Development and Testing databases

. Strong knowledge on networking technologies, communication

topologies and TCP/IP protocols etc.

. Sound knowledge in Backup and Recovery strategies, overall database

performance tuning, Explain plan, OEM, AWR etc.

. Excellent interpersonal and communication, documentation skills.

Education Qualification

Qualification : M.B.A., (Systems)

University : Annamalai University, Chidambaram.

Duration : 2009-2011

Qualification : B.E., (Electrical & Electronics Engineering)

College : Crescent Engineering College, Chennai.

University : Anna University, Chennai.

Duration : 2002-2006

Professional Certification

Oracle (9i, 10g, 11g) Certified Professional in Database

Administration

Six Sigma Green Belt Certification

Technical Skills

Programming Languages : SQL, and PL/SQL

RDBMS : Oracle 9i, 10g, 11g, SQL Server 2005, 2008

Oracle Technologies : RAC, Data guard

Oracle Utilities : RMAN, AWR, Data Pump, Toad, SQL Developer

Operating Systems : Windows and Linux

Professional Experience

> Working for Honeywell Technology Solutions Lab, Bangalore as a Senior

Engineer from Feb' 2010 to till date.

> Worked for Vista Info Systems, Bangalore as an Oracle DBA (Deputed @

Honeywell Technology Solutions Lab) from Mar' 2009 to Feb' 2010.

> Worked with 4SPL, Bangalore as an Oracle DBA from Sep' 2008 to Feb'

2009.

> Worked with Flint Solutions, Bangalore as a Database Administrator

from Dec' 2006

to Aug' 2008.

Experience Summary

Mar '2009 to present

Clients : Exxon Mobil Corporation / Shell Corporation Etc.

Role : Database administrator

Technology : Oracle 9i, 10g, 11g, SQL and PL/SQL

Platform : Windows & Linux

Honeywell introduces Business FLEX Release 240, the latest release in

Honeywell's broad

Portfolio of advanced software solutions that significantly enhance

operations in process

Industries. R240 increases the flexibility and reliability of operations

while optimizing

resources for oil and gas, refining, petrochemical, mining and minerals,

pulp and paper and

Chemical customers. By unifying business goals with production automation,

R240 enables

users to execute projects and make mission-critical business decisions more

quickly.

I am involved in solving out the Tickets raised by the customers On BFlex

Database, Carrying

Out the regular builds in the Database, Code Reviewing and Tuning, Product

Migration

Responsibilities

. Installation, configuration and upgrading of Oracle Database and

related applications.

. Implement and maintain database security as per the customer

standards.

. Provided all kinds of DBA support to development teams as well as to

the customers for various issues.

. Developed scripts to cater various Database activities.

. Modified code to improve software performance

. Provided on-call support regarding production-related database

problems

. Setup and Maintain Documentations and Standards.

Sep '2008 to Feb '2009

Client : Life Style International.

Role : Database administrator

Technology : Oracle 8, 9i, 10g, SQL and PL/SQL

Platform : Red Hat Linux

Lifestyle is part of the Landmark Group, a Dubai-based retail chain. With

over 30 years

experience in retailing, the Group has become the foremost retailer in the

Gulf.

I am involved in carrying out the Periodic Health Check for the database,

planning out space

requirements, backup & recovery strategy, performance tuning etc.

Responsibilities

. Installation, configuration and upgrading of Oracle server software

and related products

. Setup Test, Development and Staging instances for various customer

requirements

. Establishing and maintaining sound backup and recovery policies and

procedures.

. Developed scripts to monitor the storage usage, object status for

daily job

. Worked as part of a team and providing 24 7 support when required for

production-related database problems

. Performed SQL Statement tuning by using various tools, like Tkprof and

Explain plan.

Jul '2007 to Aug '2008

Client : Travel Corporation (India) Pvt. Ltd., Mumbai.

Role : Database administrator

Technology : Oracle 10g, SQL and PL/SQL

Platform : Red Hat Linux

Travel Corporation India Pvt. Ltd. (TCI) is premier travel and tour

organization having more

than 35 offices in India and abroad. TCI's core activities are inbound

tourism, business travel

and leisure travel.

TCI developed TRIBS (TCI's Real-time In-house Business Solution), an

enterprise resource

planning (ERP) solution based on Oracle database technology and on

client/server architecture.

This project includes upgrading their software, developing new modules and

to deploy Internet

based solution to cater thousands of travel agents. This involves

fundamental changes in

design, technological components etc.

I am involved in carrying out the changes to database, enabling new

features, planning out

space requirement, backup & recovery strategy, performance tuning etc.

Responsibilities.

. Installing Oracle software and creation of database on Linux.

. Import & Exports. Initial schema dump and managing various activities

to cater development team.

. Creation of database objects via tables, indexes, packages,

tablespaces etc.

. Space management. Making sure enough space available before data

loading and proactively

manage space availability for any segment growth.

. Performance & Tuning. Periodically checking the health of database,

Gathering statistics,

helping development team to identify and index requirements,

monitoring high resource

consuming operations etc.

. Cloning or refreshing database for various developments & testing

needs.

Personal Profile

Father's name : Haja Mohideen

Marital Status : Married

Gender : Male

DOB : 19/04/1985

Permanent Address : 49, North Chetty Street, Vallam,

Tanjore DT, Tamil Nadu -613403,

India.

Contact this candidate