Home » Other » Marketplace » Re: Oracle DBA needed in Cleveland, OH
Re: Oracle DBA needed in Cleveland, OH [message #104988] Tue, 17 April 2001 16:38
chandra mohan
Messages: 4
Registered: April 2001
Junior Member
CHANDRA MOHAN

SUMMARY:

Chandra is an Oracle Database Administrator who has four years of experience in the IT industry. During his experiences as a DBA, he has used various Oracle Components required for Database administration. Chandra is also experienced as a developer, using Oracle tools such as PL/SQL in an Oracle 8i/8/7.3 environment. Chandra is a motivated, young computer professional. Chandra is a self-starter and he displays clear communication skills. He has the experience of implementing Oracle Flexible Architecture. He has also finished three papers of Oracle 8i Certified Professional Exam.

EDUCATION:

B.Sc. (Chemistry)
GNIIT - (Graduation in NIIT)
Oracle Database Administration from STG.

TECHNICAL SKILLS:

RDBMS : Oracle 8i/8.0.5/7.3, MS Access,
SQL Plus, Forms, Reports
Others : MS Office 97, Lotus Notes
Operating Systems : Windows NT 4.0, SCO UNIX, WIN 95
SUN Solaris 8.0
Hardware Tools : Pentium - II, Oracle Enterprise Manager, Recovery
Manager, Replication Manager, Oracle Tuning Pack,
Oracle Diagnostic Pack, Oracle 8i Lite, Oracle Expert,
Oracle Personal Edition, Oracle Designer


PROFESSIONAL EXPERIENCE:

ECOMSERVER Inc. Princeton, NJ 01/2001 - 03/2001
Role : Oracle Database Administrator
Platform : Oracle 8i on UNIX, Sun Solaris 8.0

This company is situated in “Princeton Executive Campus”. This company has developed a medical Product “GLOBALFIT” and is providing the support for the application remotely.

Responsibilities as Oracle Database Administrator:

Logical and Physical design of the database.
Database Creation and subsequent maintenance of the Database.
Database Design and Implementation.
Creation of Schemas and allocation of proper roles and privileges.
Security management using privileges.
Killing inactive sessions at specified intervals to see that max sessions parameter
is not reached.
Checking the various tablespaces for space management and taking preventive
measures accordingly.
Performance tuning - SQL using SQL Trace.
Maintenance of Backups using operating system backups / hot backups / cold
Backups And logical backups like exports.
Optimization of SQL QUERIES for query tuning using Explain Plan scripts.
Redesign of existing tables for normalization and space saving.
Performed media recovery for a database using archive redo logs.
Loading Up data using SQL LOADER

VISUAL WEB SOLUTIONS 09/1998 - 12/2000
Role : Oracle Database Administrator
Platform : Oracle 8i on SCO UNIX, Sun Solaris 8.0, NT

Responsibilities as Oracle Database Administrator:

Installation of Oracle and related products.
Logical and Physical design of the database.
Database Creation and subsequent maintenance of the database.
Database design and implementation.
Creation of Schemas and allocation of proper roles and privileges.
Security management using privileges.
Killing inactive sessions at specified intervals to see that max sessions parameter
is not reached.
Checking the various tablespaces for space management and taking preventive
measures accordingly.
Performance tuning - SGA, SQL using tools like Oracle Tuning Pack, SQL
Trace.
Maintenance of Backups using operating system backups / hot backups / cold
backups and logical backups like exports.
Creation of triggers and stored procedures for validations.
Optimization of SQL QUERIES for query tuning using Explain Plan scripts.
Redesign of existing tables for normalization and space saving.
Identifying row chaining using analyze table scripts and redesigning the tables.
Performed media recovery for a database using archive redo logs.
Trouble shooting some critical errors like archive destination full.
Monitoring the database using Alert / trace files and v$views.
Migrating data from MS Access to Oracle database.

Backups & Recovery Performed:

Online Backup, Offline Backup, Logical Backup
Operating System BACKUP
Full Database Online backup using control file
Full Database Online backup using Recovery Manager
Incremental Backup
Control file backup
Individual datafile & tablespace backup
Archive log backups
Generating creation script for control file
Full Database offline backup
Creation & Maintenance of STANDBY Database
Individual User, tables backup using Data Manager
Full Database Export
Creating and Replacing Scripts
Instance Recovery, Media Recovery (Complete, Incomplete, Disaster
Recovery)
Database Instance Recovery
Recovering with or without Recovery Manager
Creating and Replacing Scripts
Database point-in-time recovery
Tablespace point-in-time recovery
Restoration of Datafile, archive logs, control files
Recovering offline tablespace in open database
Activating STANDBY Database
Recovery from Loss of Datafiles
Recovery from loss of Online Redo log files
Recovery from loss of Archived Redo log files
Recovery from loss of Control Files

Oracle Database Replication:
Basic Replication, Advanced Replication
Setup & maintenance of read-only Snapshot sites
Creation of both simple & complex snapshots
Setup & maintenance of multiple master sites
Setup & maintenance of multiple master & updateable snapshot sites
Managing Refresh Groups, Snapshot Logs, Snapshots
Handling Conflict Resolutions using predefined methods
Configuring & maintaining uniqueness conflict methods
Configuring & maintaining update conflict methods
Maintaining Data Convergence
Defining Conflict Notification Method
Monitoring Advanced Replication System
Auditing Successful Conflict Resolution
Diagnosing Problems with Snapshots, Master sites, Scheduled Links
Database backup and recovery in replication systems
Managing administration requests, deferred transactions, error transactions
Database Tuning (Oracle & Sybase) :
Tools Used: Oracle, Tuning Pack, Oracle Diagnostic Pack, Performance
Monitor, Sybase SQL Monitor

Tuning Procedure Followed:
Tune the Business Rules
Tune the Data Design
Tune the Application Design
Tune the Logical Structure of the Database
Tune Database Operations
Tune the Access Paths
Tune Memory Allocation
Tune I/O and Physical Structure
Tune Resource Contention
Tune the Underlying Platform(s)

SMITHKLINE BEECHAM PHARMACEUTICALS LTD. 01/1998 - 07/1998
Project : Inventory Control & Attendence Processing Package
Role : Programmer

This application was mainly developed to automate the inventory control process for the company for one of its departments. This product was also used to handle the attendance processing of its employees for one of its departments.

Responsibilities as programmer

Application Designing
Coding
Testing the product
Debugging the code
Implementation of the product

Environment : Oracle 7.3, Windows NT

BHORUKA STEEL LTD. 05/1995 - 09/1997
Project : Handling Inventory Control & Payroll Systems
Role : Programmer

This application was mainly developed to automate the inventory control process for the company for one of its store’s department. This product was also handing the payroll processing for its contract workers.

Responsibilities as programmer

Debugging the code
Testing the product
Implementation of the product

Environment : Oracle 7.3, Windows NT

----------------------------------------------------------------------
Previous Topic: Re: Oracle Financial Functional Consultants Needed!
Next Topic: Re: Oracle DBA needed in London, UK
Goto Forum:
  


Current Time: Fri Oct 22 07:06:12 CDT 2021