Mohammed Tabrez Alam
Career Objective:
To
work in a professional organization where my knowledge of
systems procedures can be applied to challenging problems.
Synopsis of Experience:
Professional summary
Around five years of experience in IT
industry-encompassing exposure to diversified business
areas with an extensive exposure to the vertical financial
segment. Total work experience includes a major
constitution of over three years in Database
administration
Related activities in Oracle on different operating
system, also over one and half year into application
development with client server environment involving
system analysis and designing.
Currently working as senior team member for Path Infotech
Limited, Mumbai for their projects and the responsibility
includes.
Ø
Installation of Oracle application 11.0.3 and 11i on
HP-UNIX, Windows NT,
Sun Solaris, and
linux.
Ø
Installation and upgradation of Developer 2000 i.e Forms
, Reports.
Ø
Installation of 9iAS, Discoverer server.
Managing the overall database
system performance, capacity planning.
Ø
Problem analysis and conflict resolution.
Ø
Implementation standards and procedures for database
system management.
Ø
Participation in new development projects to analyze
requirements and plan project
Activities related to database.
Ø
Designing, testing, implementing and operation of database
systems for the development environment.
Ø
Monitoring, analyzing and reporting service availability
and performance.
Ø
Implementing and administering system access and security
controls.
Ø
Designing backup policies for the development as well as
production database, which are being used in different
environment.
Ø
Administering backup, archives and restoration
activities.
Ø
Designing, development, testing and maintaining system
disaster recovery procedures.
Ø
Network administration.
Ø
System administration.
Technical Environment
Hardware: IBMSP RS/6000,
SUN E45000 SUN SPARK V880/V480, HP D-class 9000 .
Operating System: SUN
Solaris ver.2.6,2.7,2.8, Hp-UNIX ver 11, SCO-UNIX ver 7.1.
Database: Oracle (ver.
7.x,8.x,9.x).
Deployment Platform:
Oracle 9iAS, Oracle 9iDS.
Language: UNIX Shell
programming, C
Tools: SQL*Plus, PL/SQL,
Forms 4.5, Reports 2.5
Work Experience
A.
Duartion: April 1999-till date
Organization: Path
Infotech Limited, New Delhi.
Path infotech is an IT
company engaged in providing information solution for
domestic and overseas clients for over a decade. They have
been providing total solution s and manpower for their
client's information system needs. Their main areas of
focus are providing quality business software solutions,
system integration solutions, software support services
and education in all leading technologies. Here I have
been working as
A 'Member of support
group ' My job profile includes providing middle-ware as
well as
Professional Experience
Associates Financial Services Ltd.
The Associates is one of the leading Finance organization
engaged in in-house E.R.P package of various modules like
Finance, I-apply and Administration. The total database
contains 60 GB with 400 users and they have
6 database servers (Production, Dedup and Test Database
Server’s). It has facilities to connect different branches
of India through ISDN lines. And hardware like Compaq
Proliant 6400 R, Window NT 4.0 95 & 98, Oracle
8.0.5/Oracle 8.1.6 as database.
Ø
Administration of Oracle database
Ø
Tuning Database according to the application.
Ø
Analyze & Monitoring Tablespace, Indexes and datafiles
space as per cost based.
Ø
Performing statistics report as per database and O/S
level.
Ø
Allocated system storage and planed future storage
requirements for the database system
Ø
Developed strategy for Backups and Recoveries.
Ø
Reorg of Database and Upgraded to Oracle 8i
Bharat Petroleum, Mumbai.
Activity Performed were
Ø
Installed the RAC binaries
on sun cluster.
Ø
Created the 9I RAC database
on RAW Partition file system.
Ø
Installed the 9iAS release 2
on veritas file system.
Ø
Created the 9I database on
veritas file system.
Configured the
DataGuard Logical standby database.
Ø
Configured the Oracle
Advance Replication (OAR) using Raw partition and ufs.
Ø
Prepare their backup policy.
Sona Steering, Gurgaon
At Sona Steering I was working
as the part of the Oracle Solution Services Team involved
in the implementation of Oracle 11.5.3 from Single Node to
Dual Node. My primary responsibility were as follows;
Ø
Installation and patching of
Oracle Application
Ø
Setup of test and vision
database for the customization team.
Ø
Installation and
Configuration of different tools like application server,
discoverer etc.
Ø
Taking care of the backup
and recovery.
CANON India Ltd.
(N.Delhi)
Ø
Monitor the performance of database.
Ø
Setup and configuration of Oracle setup at the client
site.
Ø
Introduction of new Backup strategies according to client
requirements.
Ø
Allocating the system storage and capacity planning for
the production system.
Ø
House Keeping Activities like Tablespace Management and
occupied space Optimization using index rebuilding time to
time.
Ø
Creation of new Datafiles and Rollback Segments
in OLTP environment and assigning them to different
processes.
Ø
Tuning the production databases.
Ø
Deploying database security at user level through roles
and profiles.
Ø
Monitoring system performance, Disk I/O, processes, Memory
etc
Ø
Introduction of new Backup strategies according to client
requirements.
Ø
Analyse & Monitoring Tables space, Indexes and data files
spaces.
Indian Petro Chemical Ltd. (IPCL)
Ø
Monitor the performance of database.
Ø
Allocating the system storage and planning future storage
requirements for the production database system.
Ø
Tablespace Management and occupied space Optimization
using index rebuilding time to time.
Ø
Creation of new Datafiles and Rollback Segments
in OLTP environment and assigning them to different
processes.
Ø
Taking Monthly report of for all database and check it
properly like fragmentation.
Ø
Granting and Monitoring user access rights and privileges
through roles and profiles.
Ø
Monitoring system performance, Disk I/O, processes, Memory
etc using SAR, Vmstat.
Airtel Bharti , New Delhi
Activity Performed were
Ø
Installed Oracle 8.1.7 binary on Sun Cluster
Ø
Created Databases in TB on RAW partition file system.
Ø
Operating system Sun soalris.
Ø
Provided support to Application people.
Gas authority of India Ltd (GAIL Agra,Ujjain,Jhabua)
Ø
Installed the Oracle binaries file.
Ø
Created the database in GB.
Ø
Migrate their Oracle database from 7.3.4 to Oracle 8.1.6.
Ø
Operating system is SCO-UNIX 7.1.
B.Duration:July 1997 to march 1999
Organization: City Info system Pvt Limited, Patna
City
Info system is a development company involved in the
development of software application project on contract
basis and based on the client's requirement. The main
area of exposure for me was FoxPro and developer 2000 as
development tools.
Assignment :
1.
Designing and development of payrol , Kaiser Steel.
The
Payroll System deals with the companies requirement for
designing a system which can effectively handle the
generation of Pay slip for Employees .For the management
department produce regular reports which makes then aware
of the total expenditure. The Payroll system processes all
calculation to generate employee pay checks and maintain
current quarterly and yearly-earned income history for
each employee.
Environment:
Oracle 7.3.4, SQL*Plus, PlSQL, Forms 4.5, Reports 2.5
Windows 95.
2.
INVOICE, at Dogra Associates , New Delhi
3.
system analysis and design of Material requirement
Planning, at Kaliani Cement, Bihar.
Education:
Ø
Hons Diploma in Software
Technology and System Management , NIIT , New Delhi
Ø
Oracle Database administration training from Path Advanced
Computing Environment.
Ø
Bachelor of Science from
Magadh University
Personal Information
Name:
Md. Tabrez Alam
Father's Name:
Md. Sulaiman
Sex:
Male
Date of Birth:
September 25, 1973
Marital Status:
Married
Nationality:
Indian
Languages: English, Arabic, Urdu and
Hindi
Hobbies:
Cricket, Swimming and Chess
Contact
Address: C-8, Fifth Floor, Silver Anklet, Yari
Road, Varsova, Mumbai.
Contact
No: +91-9820574470
Email: alamtabrez@hotmail.com
tabrez_alam2000@yahoo.com
References: On request.
|
