Title:MARAN BAKSHA
***@************.***
Document
Source below
NAME: MARAN BAKSHA
ADDRESS:
CITY: Atlanta
STATE/PROVINCE: GA
ZIP/POSTAL CODE: 00000
COUNTRY: USA
EMAIL: ***@************.***
PHONE: 770-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
Maran Baksha
No Address
Atlanta, GA 00000
Email ***@************.***
Job Title Oracle DBA
Maran Baksha
Maran has ten years of experience in Oracle. He has skills in
administration, design and development of business systems in Oracle.
He has extensive experience as an Oracle DBA. His experience includes
Client/Server application development using Oracle and Developer 2000.
Maran has successfully functioned as DBA, systems analyst and
programmer during his career. He possesses excellent communication
skills.
Tools and Hardware: PC, UNIX Platforms Technologies: Software: Oracle
7.3, Developer 2000, SQL*Forms 4.5/4.0 SQL*Reportwriter 2.5, PL/SQL
Windows Workgroup, Windows 95, Novell Netware
Experience:
Bhabha Atomic Research
Aug '88 - PresentOracle DBAJan 94
- Present
Systems AnalystAug 88 - Dec 93
As an Oracle DBA and Systems Analyst involved in development of
various systems for Bhabha Atomic Research Center. The systems he was
involved include:
Materials Management System
These applications consist of modules for purchase order registration,
receiving, stock management and others. System security was enhanced
by the creation of different user classes and their associated object
privileges. The applications were optimized for network operations to
control required bandwidth.
Human Resources System
The application encompasses many modules such as Recruiting, Payroll,
Benefits and Termination. This system has functions to include new
applicant processing, promotions and confidential employee reports.
Liquid Effluent Treatment System
This system is for keeping and updating data on liquid waste
collected, total activity and liquid treated . This system provides
user with report of all required operational data.
Inventory Management System
This indent management and inventory system is used to enter indents
for items and to keep track of all goods in stock, goods on order and
location. It also assigns a new number to the item and adds it along
with specifications to master file.
In relation to the above said applications he has carried out the
following tasks.
Responsibilities as an Oracle DBA
Application Performance Optimization
Performance Tuning- Using Indexing, Sequencing, Hints and SQL
statements and Explain Plan, Plan Table Memory tuning using Library
Cache, Data dictionary Cache and buffer cache Tuning I/O which
consists of separating datafiles, redo log files, separating indexes
and tables
Database Design
Logical Design Designing tables and normalization of tables
Creating Entity Relationship models Estimating storage parameters
Defining integrity constraints, indexes, clusters views Defining
database triggers(DBTs) to ensure logical integrity Defining
database roles and assigning privileges Creating synonyms
Estimating tablespaces and object storage
Physical structural Design Creating datafiles, redologfiles and
control files Using initialization parameter file and creating
parameter files Database tuning Changing Archive status Adding
datafiles Preparation of necessary Documents Interaction with
personnel department
Creating database objects Defining integrity constraints
Designing indexes, clusters Designing views
Database Operation Functions
Product Installation, Upgrading and Migration Tablespace
administration using storage parameters and calculation of tablespace
requirements. Backup administration which involves Hot backup(off
line tablespace and on line tablespace backup), cold backup, Backup of
data files, control files, redolog files, Using export and import
manager utilities Database Recovery using log files and backup files
User and Database Role administration. Rollback segment
administration Logfiles and Archivelog file administration Display
of archive status and Changing archive mode Package / Procedure /
Function / Trigger / Constraint administration Auditing
Responsibilities as a Systems Analyst
Preparing conceptual design using ER modeling Creating Oracle
databases Creating database objects like tables, views, index,
sequence etc Creating database triggers for logical integrity
Creating parameter files System design System Development using
Oracle 7.x, Developer 2000 Testing applications.
Tools used: Oracle 7.x, Developer 2000, Forms 4.5, Reports 2.5,
PL/SQL, Procedure Builder, SQL DBA, Windows 95, NetWare 3.12
Madras University
Aug '86 - Aug '87Associate Lecturer
Presented complex technical information to undergraduate engineering
students. Planned and prepared course materials, lectured and
evaluated outcomes on topics in mechanical engineering.
Education: Bachelor of Engineering Master of Business Administration
(Information Systems management
)
STATEGA COUNTRYUSA
C Shell -- Oracle DBA
City, State Metuchen, NJ Phone 732-***-**** Email *******@*-*****.***
Job Title Oracle DBA
Available through C-Shell Contact:Sim or Jo
Hardware IBM and Compatibles, Compaq, HCL-HP, Packard Bells, VAX
Operating Systems SCO Unix/ Xenix, UnixWare 1.01/2.01,VMS, Windows
3.x, Windows 95, Windows NT 3.51 / 4.0, Dos Software ORACLE, SQL,
Power Builder (4.0), Forms 3.0, SQL Menu 5.0,FoxPro (2.6) on Windows,
Visual Dbase (5.0) On Windows, Developer 2000, MS-Office, Lotus 123,
C, C++, Netscape Gold, Internet Explorer, TCP/IP, Telnet, FTP ORACLE
DBA Installation, Configuration and management of Oracle 7.x on
UnixWare, Unix and Windows NT. Tablespace Management, User Management,
Security Management, Backup & Recovery, Performance enhancement.
Professional Experience PROJECT WISE DETAILS 1. Project Name : SERMON
(System for Excise & Revenue Monitoring) Client : Central Excise
Department, Chandigarh Duration : November 97 to till date Role :
Oracle DBA Administrator Enviroment : Pentium Pro, Oracle 7.1,
Unixware 2.01 Responsibilities : Active member of team which designed
and developed the application software. Activities were tablespaces
design, User Management, Security Management, Backup and Recovery,
Database Tuning & Performance Enhancement. I installed the application
software at 10 client's site. My duties involved installation of
operating system (Unixware/Unix/Xenix), Oracle, Application Software,
Initial training to end-users. Continuous DBA support to users at
client site. 2. Project Name : Land Records Information System Client
: Revenue Department, Punjab Duration : January 97 to October 97 Role
: Oracle DBA Administrator Enviroment : Pentium 166 Server, Oracle
7.1, Unixware 2.01 Responsibilities : Active team member which
designed application software. Activities were Backup and Recovery,
Tablespace Design, User Management, Security Management, Database
Tuning. The application software was tested and thereafter installed
at 17 client's site by me. My duties involved installation of
operating system (Unixware), Oracle, Application Software, Initial
training to end-users. In addition to above, continuous DBA support to
users. 3. Project Name : Sixth All India Education Survey Client :
School Council of Education and Research, Punjab Duration : March 96
to December 96 Role : Oracle DBA Responsibilities : I was responsible
for Database administration, Backup & Recovery, testing,
implementation and user training. Installation of Oracle and
application software at client site. 4. Project Name : Assembly
Elections Result System Client : State Election Commission, Punjab
Duration : January 96
to February 96 Role : Team Leader
Responsibilities : Responsible for Installation of Oracle, Application
software at client site. As a team leader of 3, I was responsible for
Testing, implementation and running of software at the time of
elections. The application has excellent MIS & statistical reporting
and query system.
5. Project Name : Annual Plan of Govt. of Punjab Client : Punjab State
Planning Board Duration : July 95 to December 95 Role : Team Member
Description : Punjab State Planning Board prepares the annual plan of
Govt. of Punjab. This project is designed to provide effective
monitoring of sectorwise allocation of funds, State and district level
allocation of funds, Scheme wise allocation of funds. Responsibilities
: Designing, Database Administration, Implementation, User training 6.
Project Name : Village Directory and Census Abstract Client : E.S.A.,
Punjab Duration : June 94 to June 95 Role : Team Member Description :
This software facilitates Government as well as NGOs to query about
the basic amenities in the villages as well as population district
wise, village wise, literacy rate and Marginal workers in the
District. Responsibilities : Database Administration, Testing,
Implementation, User training
7. Project Name : Personnel Management and Information System Client :
D.P.I.(s), Punjab Duration : January 94 to May 94 Role : Team Member
Description : This project is designed to provide accurate upto date
information on executives individual and collectively for the
management in personal admn, manpower planing training, promotion,
transfer, etc. Responsibilities : Database Coding, Testing,
Implementation, User training 8. Project Name : Recruitment System
Client : Staff Service Selection Board, Punjab Duration : July 93 to
December 93 Role : Team Member Description : Staff service selection
board is recruiting agency for Class III & IV posts in the state of
Punjab. This project is designed to streamline the work of allotting
Rollin, interviews to candidates. Responsibilities : Database Coding,
Testing
9. Project Name : Vocational Education Information System Client :
D.P.I.(s), Punjab Duration : January 93 to June 93 Role : Team Member
Description : This project is designed to provide information about
the vocational education schools, courses offered, no. Of seats, staff
positions for the state of Punjab. This project provides information
about every aspect of vocational education. Responsibilities :
Database Coding, Testing
Education B.E. (Production Engineering),
Panjab Engineering College,
Chandigarh P.G. Diploma in Computer
Science & Applications, Centre for Computer Sc. & App., Panjab
University, Chandigarh
STATENJ COUNTRYUSA