Sr Developer/DBA

MAHFOOZ ALI

House No ***,Street No -* West- Email: iscwpe@r.postjobfree.com

Vinod Nagar , Delhi – 92 Contact No. +91-971*******

I am an oracle DBA and having 3+ years of Experience.

Career Objectives:

To work in an organization that provides conductive work Environment and challenging job opportunities with exposure to emerging issues in the field of ORACLE and Continue my career as an Oracle DBA utilizing my strong technical and Communication skills.

Industrial Experience:-

As a Database Administrator in Oracle (on site at client end in U.P. WEST BSNL CDR Project) form July 2008 to till now.

Currently working with Maxtel Infosystem Pvt Ltd. As an Oracle Database Administrator in CDR project for BSNL handling by TCS.

As with changing the location on BSNL SSA office working on different systems used in BSNL CDR project (Dot soft, trichur) in Oracle.

CDR (Call Detail Record) is a Database application Developed by the core team TCS, for providing the facility to BSNL for automated reading loaded from the switch for the particular subscriber, billing generation, in the case of late of bill payment automated disconnection the phone services etc.

Dot soft is a Database Application Developed by core team BSNL Hyderabad is based on Client/Server Technology, developed in Developer 2000 which includes 700 Forms and Reports and 100 GB Oracle Database which is divided into 30 Table spaces and 1500 database objects and is concurrently access by 800 users connected through WAN. The Application installed on a HP server with Xeon Processor with Red Hat Linux 9 and Oracle 9i,10g and with UNIX wares 7 and Oracle 8i.

Responsibilities:-

Perform Installation &configuration and upgrading of oracle server software.

Perform creation of database by manual method and DBCA.

Perform configuring multithreaded server (Shared server).

Perform Implement and maintain database security (create and maintain users and roles, assign privileges.).

Perform Creating, monitoring and managing Oracle physical and logical storage structure for storage space availability and its growth.

Perform Creation, administration and reorganization of database objects when required.

Perform Restoration and cloning of databases using Hot, Cold, RMAN and Export backup.

Perform Transporting data between database using Export /Import.

Perform Involved in implementing backup and recovery methodologies/strategies for databases using: Logical backup – Export/import and physical backup – Cold and Hot backup.

Perform Managing database by monitoring diagnostic files like Alert_SID.log, trace files.

Perform Experience in creation and management of Listener and resolving network issues.

Perform general technical trouble shooting and give consultation to development team.

Understanding the Existing System Database and check the Billing status of BSNL Landline Phones.

Exclude the Landline phones from the wll Phones for migrate the only Landline phones.

Match the exiting working Phones in Exchange Switch and TRA account Database.

Handling daily Database Queries by BSNL Related to Commercial, TRA.

Export the billing dump for migrates to the new CDR system Database server.

Training and supporting the clients on the Dotsoft Functionality.

GLOBAL CERTIFICATION:

Oracle 10g Database Administrator:

ORACLE CERTIFIED ASSOCIATE (OCA).

Oracle 10g Database Administrator:

ORACLE CERTIFIED PROFESSIONAL (OCP).

TECHNICAL QUALIFICATION:

Red Hat Certified Engineer (RHCE) trained from SQL STAR INTERNATIONAL LTD. (Delhi).

System and Database administration (SDBA) trained from SQL STAR INTERNATIONAL LTD. (Delhi).

Diploma in SQL from STAR INTERNATIONAL LTD.(Delhi)

PROFESSIONAL QUALIFICATION:

Bachelor of Computer Application (BCA) from IGNOU

A-Level from DOEACC Society.

ACADEMIC QUALIFICATION:

10th from GIC from UP Board.

12th from GIC from UP Board.

TECHNICAL SKILLS:

Database Servers

Oracle 10g

DBA Utilities

SQL*Plus, SQL*Loader, SQL*Datapump, Flashback, SQL Queries, Database Control, SQL*Net, NetConfiguration Assistant,Import and Export using SQL*datapum, Backup and Recovery of any type using RMAN & UMAN

Operating Systems

RHEL 4.0 and 5.0, UNIX, Windows NT/2000/2003/XP

Programming

C, C++, Core Java,Visual Basic

Application Servers

Oracle 10g AS (Architecture knowledge)

Skill Set:

Installation &configuration and upgrading of oracle server software.

Experience in creation of database by manual method and DBCA.

Having sound knowledge of Oracle Architecture.

Configuring multithreaded server (Shared server).

Implement and maintain database security (create and maintain users and roles, assign privileges.).

Creating, monitoring and managing Oracle physical and logical storage structure for storage space availability and its growth.

Creation, administration and reorganization of database objects when required.

Restoration and cloning of databases using Hot, Cold, RMAN and Export backup.

Transporting data between database using Export /Import.

Involved in implementing backup and recovery methodologies/strategies for databases using: Logical backup – Export/import and physical backup – Cold and Hot backup.

Managing database by monitoring diagnostic files like Alert_SID.log, trace files.

Experience in creation and management of Listener and resolving network issues.

Perform general technical trouble shooting and give consultation to development teams.

CASE STUDIES (ORACLE 10g)

Case #1: Use Sql Access advisor to tune complex aggregate

Case #2: Loading Data into Database Using OEM

Case #3: Backup implementation with a catalog database

Case #4: Loss of a System Tablespace Data file in Catalog Db

Case #5: Resolving Snap shot too old error of undo tablespace

Case #6: File system to ASM conversion

Case #7: Reclaiming space in a Table Using Segment Advisor

Case #8: Eliminate table (Row Migration & chaining) fragmentation

Case #9: Diagnosing and Resolving Performance Issue through ADDM

Case# 10: Cloning Database Using Rman

PROJECT:

Visual Basic PROJECT(THE GLOBAL JOBS FAIR MANAGEMENT)

Description: The Project was based on the interfacial interaction between organization and the most suitable required candidate.

Purpose: Through this project one organization can easily search a suitable candidate for their opening/s; which can easily cut down the cost as well as the time and the accuracy of a search engine.

Application or Software Used: Visual Basic 6.0 (front end) Oracle 9i (back end)

PERSONAL DETAILS :

Father’s name : Mohd Haneef

Marital Status : Single

Gender : Male

Nationality : Indian

Date of birth : 15-Aug-1989

Language known : Hindi & English

Present Address : Vill-Rasoolpur ,teh- Swar, Distt-

Rampur UP (244924)

Hobbies : Listening Music, Reading Books,

DECLARATION:

I hereby declare that all statements mentioned above are true and correct to the best of my knowledge and belief. I hope, keeping in view the above particulars, you may kindly offer me the assignment. For this I will be ever grateful to you.

Date: ……………….. MAHFOOZ ALI

Place: ………………..

Contact this candidate