Software Engineer Oracle
Resume:
Title:Database Administrator/Software Engineer
*******@***.***
Document
Source below
NAME: BHOOPAL KANTE
ADDRESS:
CITY: Milpitas
STATE/PROVINCE: CA
ZIP/POSTAL CODE: 95035
COUNTRY: USA
EMAIL: *******@***.***
PHONE: 408-***-****
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
BHOOPAL KANTE
220 Ayer Lane
Milpitas, CA 95035
Email *******@***.***
Job Title Oracle DBA
email:*******@***.***
Objective
To obtain a challenging position in Database Administration, Data
Modeling,
Database Design or Client/Server Development.
Summary
Three and half years of substantial experience in the DBA, design,
development, and SQL testing of Oracle applications including one and
half
years of Oracle Database Administration.
Skills
Machines:Sun Workstation, HP 800, PC.
OS:Windows NT, HP-UX, Unix, SunOS, Windows/95
Languages:C, SQL, and COBOL
RDBMS: Oracle 7.3 (SQL*DBA, PL/SQL, SQL*Plus,
SQL*Loader, Pro*C, SQL*Net, Reports)
Front End Tools:Developer/2000, Visual Basic 5.0, Crystal Reports,
ODBC
Unix Tools:Make, Ksh, Perl, awk, sed, RCS.
Experience
Database Administrator/Software Engineer
[Dec 94 - March 98]
Melstar Information Technologies
Finance and Revenue Accounting system [
July 1996
- March 98]
Involved in the Database Administration, design, development, database
design
and performance tuning of "Finance and Revenue Accounting system" that
was
developed for client, Air India. The system is used for analyzing the
finances and the revenue incurred by various sectors of Air India. The
system
collects various data (Data relating to flight Ids, passenger ticket
numbers,
coupons and routing etc) that is entered by data entry operators at
various
sectors on daily basis. The data is downloaded in Flat Files and
entered into
Oracle 7.3 database that consists of around 200 tables. The front end
developed in Visual Basic 5.0 helps a user to browse through the data
and to
generate various reports using Crystal Reports.
Role:
Activities as DBA included the following:
Data Sourcing: Development of tools for downloading data in flat
files from
IBM/Unisys mainframes and loading into Oracle database. The shell
scripts
that run as cronjobs every day ftp the Data Flat Files from various
sites and
run SQLLOAD to load into Oracle Tables.
Schema Maintenance: Responsible for creating and trouble shooting
database,
defining ORACLE parameters, creating/altering tables and managing
table
spaces, creating indexes and clusters and properly defining foreign
keys to
maintain referential integrity. Also responsible for documenting,
version
controlling of Schema SQL file and releasing schema.
Performance Tuning: Activities Included the following:
Involved in query optimization and normalization. Utilized SQL Trace
Facility, TKPROF and "EXPLAIN PLAN" commands to analyze queries
executed by
application, and improved performance by effectively writing SQL and
properly
defining indexes.
Monitored network, disk, CPU etc., for ensuring best performance and
set
Oracle parameters properly for best performance.
Greatly improved the performance of Data Sourcing tools by utilizing
"Partitioned Views" feature of ORACLE.
Wrote numerous stored procedures and triggers for efficiently
performing
time consuming database processing and to enforce proper business
logic
rules.
Backup and Recovery: Involved in defining Backup and Recovery
strategies.
Performed online and offline backups.
Setting up Client machines to use SQL*Net connections to the server.
Maintaining user privileges.
Also involved in the development of client using Visual Basic 5.0 and
ODBC,
Crystal Reports on Windows 95.
Utilized:
Oracle 7.3 (PL/SQL, SQL*Loader, Pro*C, SQL*Net, SQL*DBA, svrmgrl), C,
Korn
shell on Sun Workstation, Visual Basic 5.0, ODBC, Crystal Reports on
Windows95.
Express Machinery Parts
[Dec 1994 - June 1996]
A menu driven system used by Machinery/Auto Part Retailers to generate
quotes
for the configuration of various parts that are requested by
customers. The
system maintains the information related to various suppliers, the
items
provided by them, such as individual automobile parts, their brand
names and
prices. The system also maintains a set of rules that enforce certain
pre-
determined configurations. A customer can follow these rules to come
up with
an optimal configuration which is best suited for the price and
purpose. The
system also maintains the previously generated quotes for reediting.
Role:
Involved in the design, development and testing of the system
SQL optimization, index creation and normalization for better
performance.
Wrote numerous stored procedures and triggers.
Utilized:
Oracle 7.1 (PL/SQL, sqlplus), Developer 2000 on Windows 95.
Projects
Implemented "Student Registration System" using Oracle 7, Forms 4.5
on
Windows 95
Training
[1997]Oracle 8.0 For Database Administrators
[1996]Oracle Developer/2000
[1995]IBM Programming (CICS, JCL, DB2, COBOL)
[1994]Unix/C and Shell Scripts
Education
[1994
]P.G. Diploma in Computer Applications,
Gemini Electronics and Computer Technologies,
Hyderabad,
India.
[1992
]Bachelor of Engineering (Mechanical),
Osmania University,
Hyderabad, India
Contact this candidate