Oracle Management
Resume:
Title:Oracle DBA
********@*******.***
Document
Source below
NAME: kaipa, rama
ADDRESS: ***** ********* ***
ADDRESS2: b3010
CITY: fremont
STATE: CA
ZIP: 94538
CANDIDATE ID: 2327780
US CITIZENSHIP: Permit
EDUCATION: Post Graduate Work
EXPERIENCE: 7
WILL RELOCATE: Open - willing to relocate
JOB WANTED: Any
RATE NEEDED: negotiable
TELEPHONE: 408-***-****
EMAIL: ********@*******.***
HOMEPAGE:
HOTTEST SKILLS: oracle database administrator
REVISION: 19-JAN-02
YOE: 7
RESUME:
RAMA KAIPA
(M)
********@*******.***
CAREER OBJECTIVE:
To work as an ORACLE DBA and utilize my experience in Client/Server management
Systems so as to impact Company development and enrich personal professional
skills.
SUMMARY:
Total of Seven years experience of which around Four years as
ORACLE DBA and Three years of experience in Analysis, Design,
Development, Testing and Implementation of Commercial Application Packages
using Oracle Tools.
COMPUTER PROFICIENCY
Languages C, C++ with OOPS, COBOL, SQL, PL/SQL, Basic & Pascal
RDBMS ORACLE 7.X/8.x, 8i
ERP Oracle Applications 10.7SC, 11i,
Front-end Developer/2000,Visual Basic
Packages Ms-Office, WordStar, Lotus & Internet browsers
Data Base Tools AD Utilities, Developer /2000, Reports 2.5,Enterprise
Manager,RMAN, Designer 2000, SQL*PLUS, SQL*LOADER, SQL*TRACE Server
Manager, SQL*NET, Export/Import
DBMS FoxPro, Dbase IV & Unify DBMS
Operating Sys. UNIX, MS-DOS, Windows 95 / 3.1, Netware LAN
Windows NT
System Tools VMSTAT, IOSTAT, SAR, CRON,
EDUCATION
Bachelor's Degree
in Math, Applied Math & Statistics, Osmania University, India.
Database Administration Experience Summary
Database Planning & Design including logical storage structures and
forecasting future expansions.
Installation and up gradation of Oracle Server and application tools.
Writing stored procedures, Functions and Database Triggers by using
PL/SQL.
Modify the current database storage structures.
Creation of primary database objects like tables views and indexes.
Security Administration by creating users with appropriate roles and
privileges.
Creation and Implementation of Effective Backup and Recovery strategies
for
Cold and Hot backups, which included writing, backup scripts.
Distributed Database Configuration.
Creation of Database links and Snapshots.
Fine-tune SQL Statement for Oracle Applications using Explain Plan and
Oracle
SQL*Trace with Tkproff utility
Tuning of Database, Memory Tuning, I/O Tuning and contention for best
performance
As an Oracle Apps DBA, involved in the following.
Do Sizing Oracle Apps DB based on client business operation and server
platform.
Install 10.7SC/NCA using AUTOINSTALL, R11 using One-hour Install and
R11i,
Rapid install for Oracle Manufacturing and Financials
Configure Listener/Tnsnames, directory mapping etc
Port over data from single to multiple instance like from production to
test
ENV.
Apply patches to Oracle Apps using adpatch and adctrl utilities and
maintain
APPL_TOP
Support large team of development to create/drop D/B objects like users,
tables, index, sequence, D/B link etc and grant each role and privilege using
Oracle OEM
Schedule and optimize Oracle concurrent managers in different node and
each
job running frequency/shift
Do stress test and tune D/B & long running reports
Do cold/hot D/B backup using Unix scheduler and recovery
SOFTWARE EXPERIENCE
MCI WorldCom
Sep 00PresentOracle DBA
XBOSS
(Xstream BackOffice Support Services)
Environment :SUN Solaris 2.7, ORACLE 8i,WinNT 4.0,Oracle Application11i
The XBOSS system will provide the essential services that are required to handle
network provisioning and validations, order entry and management, and
accounting and billing. The relationship of XBOSS to other systems involved in
the invoicing of Xstream network related products and services. XBOSS will
eliminate dependence on the CONCERT information system and allow WORLDCOM to
pursue its tactical objectives in regards to future plans for network
consolidation and split.
Role:
Configuring FORMS, REPORTS and Application Server for R11i Environment.
Providing services like performance tuning, Capacity Planning, Hardware
Planning & Database File Structuring
Creation of New Environments on HP-UX, SUN SOLARIS, DEC & IBM AIX
machines.
Installation, up-gradation and maintenance of Oracle Applications. 11i
from
10.7.
Apply patch and data patch to Oracle Apps using adpatch utility
Mapping of existing and new user responsibilities and their menus.
Copied and refreshed the databases according to user requirements.
Created QA
environments for testing.
Installed Client software on PC machines and configured them. Also
involved in
setting up Report agents for Oracle Applications for accessing reports from
Client machines. Other System Administration tasks include setting up printer
style, type for Oracle Applications.
Working on automating using UNIX Shell scripts for various processes
Environment creation, Backup/Recovery.
Other tasks include running health checks on the databases for
validating
database links, objects etc., integrating third party tools with Oracle.
Knowledge of Oracle Application Server
Worked & cross-trained a team of DBA, System administrators and NT
group.
COM21, Milpitas, CA Mar 00- sep 00Oracle DBA
Environment : Oracle 8i, SUN Solaris 2.7, Java
The Com21 DOCSIS CM and CMTS Management Solution (Dolman ger) is a value-added
product which provides system-level management for DOCSIS CMTSs (Com21 AND
others) and cable modems, as well as functionality proprietary to Com21's CMTS.
It provides features in addition to those in the Embedded Web Management of
the CMTS, offering a system view. DOXmanager shall provide a task-oriented
approach to network management, where applicable.
- Management & Provisioning Module - basic CMTS provisioning
- Device Core Module (Plant Core) - data collection
- Plant Analysis Module (Plant Tools) - data display at head end
Role:
Designed logical storage structures and forecasting future expansions
Installed 8.1.6 versions of Oracle 8i
Crated script files to create database, table spaces and other schema
objects
like tables indexes and views
Changed the Kernal parameters of the Unix before creating the database
Using third party tool Advent Net (DB utility tool) created oracle
schema
script
Automated the Startup/Shutdown process when the Unix box is coming
up/down
Created users, roles, profiles and maintaining system security
Controlling and Monitoring the database activity
Managing backup management including cold backup, database export and
import
management any kind of recovery from database crash.
Hewlett Packard, Burlington MA Jan 00Feb00
Unified Communication Systems
Oracle DBA
Environment : SUN Solaris 2.5, ORACLE 8i, JAVA JSP, XML, LDAP, CISCO Routers
Unified Communications System is an Internet-based Advanced Messaging & Personal
Communication Services being developed by Belle Systems, Software.Com, Effect
Net, IBasis and IBM. The Cisco Unified Communications (UC) solution uses the
open Internet standard to unify communications methods and supports E-mail, fax
machines, voice mail systems, cellular phones, and the Web. The Cisco Open
Network Exchange (uOneT) application, a pivotal component of Cisco's overall UC
solution, enables users to initiate and return voice calls and send and receive
faxes, e-mail, and voice messages independent of location, time or device.
Role: Writing stored procedures, functions and database triggers to integrate
Java and Oracle database by using PL/SQL. Crated script files to create
database, table spaces and other schema objects like tables indexes and views.
Wausau
Insurance, WI Jul99Dec99
Database Administrator
As Oracle Database Administrator:
Installed and upgraded the ORACLE Server and application tools for a
network
of 12.
Allocated system storage and planned future storage requirements for the
multiple instances.
Created primary database storage structures.
Created database objects like tables, views, and indexes.
Modified the database structure.
Enrolled users and maintained system security.
Controlled and monitored user access to the database.
Monitored and optimized the performance of the database.
Created backup and recovery of database information by effective
planning.
Maintained backup data on tape.
Developed & customized Startup/Shutdown kit to enhance the
manageability and
performance of the database.
Hardware : Intel Pentium based HCL HP machine -CHECK-
Languages : PL/SQL, SQL * Plus,
Utilities : SQL* Loader, Export/ Import.
RDBMS : Oracle ver. 8.0.5
Operating System: UNIX SOLARIS
Indus International
Jan 99 - Jun 99
Asset Care Management Solution
Administration and Database Analysis of Asset Care Management Solution databases
at Indus International. Provided solutions for optimizing the Oracle database
objects used by the base application product (Enterprise Maintenance Program).
Migration of databases across the versions. Monitored the growth of the
databases and performed the re-organization of relevant database objects.
Regular Backup and Recovery functions. Resolved database connectivity issues
involved with SQL*Net, ODBC by the users. Proper privilege management and
creation of Tables, Packages, Triggers, Stored Procedures. Performance Analysis
and tuning of database objects, SQL and PL/SQL queries posed on the databases
was a notable contribution.
The Job Responsibilities also include Oracle Database Analysis and Performance
Tuning making necessary Recommendations.
Environment: Oracle 7.2/7.3/8.x, WinNT4.0, UNIX, SQL*Plus3.1, PL/SQL, SQL*Net2.0
Sprint RPG India Ltd
Jan 98 to Nov
98
Sales Accounting System
Database Administrator
Environment : HP9000, SUN SOLARIS, Oracle 7.3
1. Maintenance of the systems and the databases, which is 2 to 16 GB in
size.
Managing table-spaces, data-files, space, tables, indexes, views, users, and
rollback segments roles according to requirement and application.
2. Managing online redo logs
3. control files, backup management including online backup, database
export and
import management any kind of recovery from database crash.
4. System analysis and design, planning of complex database and networks.
Monitoring and tuning of database SQL areas and disk I/O performance.
Reorganization of database and Insurance Tuning.
5. Developing shell scripts, scripts in SQL*Plus. Involved in the
generation of
specific reports using PL/SQL Procedures and Triggers that is used by
application.
6. Providing assistance in computerization, troubleshooting, and bench-
marking
for different machines and training to end-users.
7. Installation of UNIX and Oracle, Database creation and configuring
different
parameters of UNIX, Oracle and database according to site and application.
Thermopads, Hyd
Feb 97 to
Dec 97
Project Planning System
DBA
Project Planning System is responsible for performance and monitoring of the
Projects. Activities undertaken include maintenance of Projects, initiating
purchase and manufacturing actions, monitoring progress and scheduling
assembly, and dispatch of the final product.
The job of the Dispatch Cell was also computerized. Here the dispatch plan is
made right at the time of initiation of the Project. The module provides for
updating the committed dates depending upon the requirements of the customer,
printing of the dispatch advises, printing of gate pass etc. A MIS for dispatch
compliance was also developed to track the dispatches made.
Contributions included:
Performed as an ORACLE DBA performing database and system administration
activities.
Database Tuning with relevant changes in parameter file like DB Block
Buffers,
Shared Pool Area, Sort Size, Rollback Segments etc. to have Hit Ratio of over
0.85, reduce sleeps,
Other Database administrative activities including creation of
database, table
spaces (for data, index, rollback segments), users, grant/revoke of
roles/privileges from users, SQL loading from data files, export/import of
data, backup of relevant files etc.
Prepared ERD and created tables, indexes using Erwin.
Developed programs for the module with three more persons
Environment
ORACLE 7.3, Developer 2000, Designer 2000, Forms 4.5, Reports 2.5, Unix,
Windows95
Veera Pharma Ltd
. Aug
96
- Jan 97
Material Management System
Environment : Oracle 7.1, Forms 4.5
This Package was developed to replace the manual maintenance of stores accounts
and to effectively manage the stores. This project mainly divided into 5
modules
1. Item master entry and updating
2.Receipts entry
3.Issues entry
4.Order placing
5.Issues returns
I designed and developed user friendly inquiry screens for accessing data from
multiple tables using SQL*Plus and SQL*Forms. I coded several Stored
Procedures and Triggers using PL/SQL, which were used for complex calculations,
validations and maintaining data integrity. I used SQL*Reports for extensive
ad-hoc reporting and also for analysis purposes. .Custom menu was created using
SQL*MENU. In addition to these I used SQL*Loader data transfer
Veera Pharma Ltd
. Nov 95 to
June 96
Sales Order Processing System
Environment : Oracle 7.0, Forms 4.5
This project was developed to handle the transactions standing from receiving
order for supply of materials till rising of receipts.
Objects & Features
To maintain total control over orders i.e., orders receives, invoices,
receipts etc.
Online updating of master files with transactions.
To provide information on pending orders customer-wise and age wise
To provide information on receivables, region wise, customer wise,
order wise
and age wise.
All the checks like validating invoice quantities with other quantities
identification Numbers etc. are included in the project.
It maintains order master, item-master, customer master, invoice
transaction
file, receipts Transaction files.
The database is designed using normalization's and E.R.modelling
techniques.
Venus Tobacco Company Private Ltd
. Mar 95 to Sep 95
Inventory Control System
Environment: Oracle 7.x, Oracle Developer 2000, SQL Plus, Unix
The application is an Inventory Management System for a Tobacco manufacturing
company. The application handled user query and maintained stock of various
inventory items. Database triggers were used to monitor stock levels.
Developed each products reports using Oracle reports 2.5. Made extensive
enhancement and fixed bugs on the basis of error reports in oracle environment.
Involved in the deployment of applications at client site. The user interface
was developed using Developer 2000 tools. Involved in gathering requirements,
functional analysis.
Venus Tobacco Company Private Ltd
. Jun 94 to Feb 95
Payroll Processing System
Environment: ORACLE 6.0, SQL*FORMS 3.0, SQL*PLUS, SQL*REPORT, SQL*MENU, UNIX,
NOVELL NetWare 3.1
The system deals with maintenance of Employees Personal details and Monthly
Attendance Entry. The various allowances and deductions as well as number of
leaves allowed are maintained along with employees personal details. The
attendance Entry is done as a batch process at the end of month for all
employees. The query facility is also provided. The output of the system is
Monthly Salary Report and payslip for individual
employee are taken care
Contact this candidate