Oracle Quality Assurance

Title:Database Administrator

*******@***.***

Document

Source below

NAME: Zakir Hussain

ADDRESS: Sacramento

CITY: Sacaramento

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 95833

COUNTRY: USA

EMAIL: *******@***.***

PHONE:

CANDIDATE ID: 95862

CITIZENSHIP: US

Citizen

EDUCATION: Master Degree

EXPERIENCE: 6

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: WIN NT, Windows, Oracle, and C

ESUME

Application for Oracle DBA / Data warehouse DBA

Name : Zakir Hussain

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

PROFILE

Six years of experience in various IT domains like Database Administration,

Product Support, Implementation of projects, Development, Quality Assurance and

Networking. Extensive experience in database management, database tuning and

security management, backup & recovery activities, Schema design, Problem

solving, Installation and upgrade of database as well as managing the object

and system privileges. Experience in Oracle designing and implementation. And

well versed in Windows NT, Unix and Client/Server environments. Actively

involved in the full project life cycle from User requirements to

Implementation. Excellent written and oral communication skills.

SKILLS/TOOLS

RDBMS: Oracle

8.i, Oracle 8.X, Oracle 7.X, Personal Oracle 8.i, Oracle Replication Server,

Oracle Paralell Server, Oracle Standby Database

Oracle Data Warehouse.

Database Technology: Oracle ODBC,

JDBC

Enterprise Computing & Administration: Oracle Admin, NT Admin.

Front End & Case Tools: Developer-2000,

Oracle Enterprise Manager, Toad, X-Windows, OracleMigrationWorkbench and Remedy

Help Desk.

Languages:

SQL*Plus, PL/SQL, PASCAL and C

Operating Systems & Platforms: Unix (HP,

Solaris and SCO Unix), MS DOS, WIN 9X, Windows 2000 WIN NT,

Software / Utility : Forms

2.3,Oracle Reports, RMAN, SQL*Loader, SQL*DBA SVRMGR, Export/Import, Listener

Control Program.

Communication Networks: TCP/ IP,

SQL*Net,Net8, FTP, PC Any where

Hardware: HP-9000, Intel 80X86, Solaris Sunsparc

Pentium PC families.

Miscellaneous / Knowledge: HTML, Java,

IBMWebsphere, DataWarehouse, Sybase, Oracle Applications (11.0.3) Veritas,

Oracle Application Server (OAS 4.0), Designer 2000, Oracle Discoverer-2000, HP-

Openview, Oracle Warehouse Builder (OWB), Legato Storage Manager

EXPERIENCE

Working as

Database Administrator

for MCI WorldCom, California, USA

Emission Test

Sept00

-- Till date

As a

Database Administrator

/ Data warehouse DBA,

Responsible for Oracle Database (Production and Data warehouse), and related

Issues

Installed and Configured Oracle8 and Oracle8i Server

Troubleshooting production Oracle database problems

Reorganizing the database and tuning.

Installing and debugging new Oracle releases.

Creation of table spaces, tables using proper storage clause.

Creation of new instances for Production, Development, Testing and Training

Servers.

Regularly monitoring the database and responsible for Performance Tuning.

Responsible for backup and recovery strategy

Applying patches, for application requirements.

Migrate oracle 7.3.4.1 to Oracle 8.0.2.1 Using Migration Utility

Install Designer 2000, Created Repository

Automated RMAN backups using Legato network storage Manger

Installed and Configured Oracle applications 11.0.3 Server

Responding to system failures (Database Recover) to maximise availability on a

24 x 7 basis..

Working with other Technical Operations team members to ensure smooth

operations of Production applications

Environment: Oracle 8.0.5, Oracle 8i, Win-NT, UNIX (Sun Solaris

)

Onyx, USA

Client : Imetrix Corp, USA

Database Administrator

TRADECENTRUM

July 00

Sept 00

TradeCentrum is internet marketplace for the buyers and sellers of photographic

films. The project has been developed for parastrade, which is a world leader

in the distribution of the photographicfilms. Parastrade owns tradecentrum and

facilitates electronic business of photographic films to various buyers and

sellers over internet. The project-involved activities of registration and

administration of access Details, Creation of screens to facilitate the

activities of viewing and Quotations, Invoices and Purchase orders.

As a Database Administrator, responsible for the following

Installed and configured Oracle 8i database.

Database Management.

Estimate Storage capacity for database objects.

Working with Oracle Enterprise Manager

Created database and Instances

Upgrade and implementation planning

Configuring SQL * Net for client and Server.

Managing Logins and Permissions.

Installed Oracle Application Server 4.0

Environment : Oracle8i, Win-NT,

British Physical Laboratory (Innovision) Ltd

Database Administrator- P.L

Mar 00

-July00Coreman Financials

This is a Complete Accounting Information System to provide a comprehensive

solution for various transactions, analysis on financial statements,

decision-making, and all accounting functions. It caters to the following

areas - Accounts Payable/ Receivable, Bank / Cash Transactions, Journal

Entries, Contractor Vouchers and Bill Booking Modules. It supports multiple

accounting Periods.

Payroll System

This system deals with monthly salary calculation of employees based on the

available inputs and distribution of the pay to the employees. It helps

in maintaining the employees prerequisites claims. It is integrated with Human

Resources Information, Personnel Information, Payment Control and Financial

Accounting Systems

As a Database Administrator, responsible for the following

Responsible for Production Database.(27*7 Support of Oracle database)

Taking care of Regular Maintenances related to the Production Database.

Managing/applying patches.

Reorganizing the database using export, import utilities.

Creation of tablespaces, tables using proper storage clause.

Responsible for Tuning and troubleshooting Database Performance.

Creation of new instances (Oracle 8.0.5)

Recreated the application tables with proper storage clause.

Solving the database problems. Monitoring the database

Optimizing stored procedure and trigger code for production applications.

Mentoring junior staff members and database developers on proper SQL coding

techniques.

Planed / Maintaining database backup and recovery Plans.

Environment: Oracle 7.3.4, Oracle 8,oracle8i, Win-NT, HP-UX

Kindle Banking Systems Pvt Ltd,

Database Administrator

- Research Division.

Dec 98

-Feb 00Bank Power Tool

This is front-end tool for banking systems, this project takes care of all

banking requirements as well as ATMs. For this project Backend is Oracle 7.3.2

As a Oracle Database Administrator, responsible for the following:

Transferred data from Dublin office to India office

Created and Modified Schema design (Logical and Physical).

Responsible for designing and implementing system interfaces

Database tuning and attending to database related problems.

Recreation of Rollback segments with Optimal Size.

Responsible for backups, Network Monitoring.

Assisted planning the Y2K Client Server effort

Assisted Certifying Y2K Client Server Compliance

Export and Import of database objects.

Configuration of B*treive.

Cleaning up of the database (removing unwanted data, tables and freeing space)

Moving all application related tables from System user to another User using

export and import utilities.

Environnant: WIN- NT, Oracle 7.3, Oracle8

Lanier Corporation, USA

(BEE Electronics Machines Ltd

)

Sr. Engineer Database Support

Sep 96

-Nov 98

As an Oracle Database Administrator/ Data warehouse DBA, responsible for

Implemented and Maintained Oracle 7.X, 8.X and 8i Servers at Different Clients

Sites.

Implementation of Interfaces for application / database connectivity.

Database capacity and growth planing, Installation and upgrades.

Unix Scripting, to support data warehousing tasks.

Install, Upgrade and administer backend database products.

Database Development (Tables, stored Procs.) for On-line Trading System

Responsible for tuning of relational database pertaining to data loads.

Responsible for Database tuning and End user Problems.

System upgrade and data migration

Conduct Basics Training for DBAs

Managed / Plan for Backup and Recovery Tasks.

Analyzing tables, Index, Schema for elimination of chaining.

User Training and Support of the Application.

Environment: WIN NT, UNIX, Oracle 7.3, Oracle 8.X, Oracle 8.i

Deepak Electronics Pvt. Ltd

. India

Engineer

Database Support

Jan 96

-Sep 96

As an Oracle Database support Engineer, responsible for

Database support and maintenance for the Projects.

Install and configure oracle products.

Plan / Estimate for new database.

Design, implement and support databases using oracle DBMS.

Implemented projects at customer sites.

Installed and upgraded Software Applications.

Evaluation of Network.

Database Space Management.

Database Management and performance tuning.

User Creation providing them with object and system privileges.

Rolls Creation and Maintenance

Environment: WIN-NT, Windows, Oracle 7.X, D2k

Electronics Corporation of India Ltd

. India

Engineer

Jun 95

-Jan 96

As an

Engineer, responsible for

Quality Assurance activities.

Audited and trained.

Quality Control and Tested Procedures.

Designing Technical Manuals, Software Configuration Management Plan etc.

Environment: WIN NT, Windows, Oracle, and C

EDUCATION/CERTIFICATION

Pre PhD

Studies in Computer Systems, Birla Institute of Technology, India.

Masters Degree

in Electronics, Sri Krishna Devaraya University, India.

Bachelors Degree

in Electronics, Gulbarga University, India

Diploma

in Oracle DBA (Server 8.0) Al-Ameen Institute of Information

Technology,

India.

Diploma

in RDBMS (Oracle) Software Solution of Integrated Ltd., India.

Diploma

in Quality Assurance & ISO 9000,All India Institute of Management

Science, India.

Certification in Computing, IGNOU, India.

Professional Affiliations

Associate Member, Computer Society of India

Associate Member, Data warehousing Institute.

Associate Member, Management Studies Promotion Institute

Zakir

Hussain.

Contact this candidate