Oracle Engineer
Resume:
Title:Infrastructure/Client Support
**********@*****.***
Document
Source below
NAME: suresh, suresh
ADDRESS:
ADDRESS2:
CITY: singapore
STATE:
ZIP: UNKNOWN
CANDIDATE ID: 2279918
US CITIZENSHIP:
EDUCATION:
EXPERIENCE:
WILL RELOCATE: -
JOB WANTED:
RATE NEEDED:
TELEPHONE:
EMAIL: **********@*****.***
HOMEPAGE:
HOTTEST SKILLS: 2167, 3270, 80.86, a+ certification, abap, active server, activex,
animation, apache, applet, as 400, as/400, as400, assembly language, athlon, autocad,
automatic test equipment, aviation, baan, banyan
REVISION: 22-MAY-02
YOE:
RESUME:
Suresh Kumar Kancherla
Block 433, # 12-1419,
Ang Mo Kio Avenue 10,
Singapore - 560433
Tel : (65) 5543581,4527114
Hand phone: 94521123
Email : **********@********.***
******@*********.***
EXPERIENCE SUMMARY:
A total of 5 years of experience in IT Industry. About 3 years of experience in Oracle
Database administration, Analysis, Installation and Implementation Experience in Windows
NT, Linux, Sun Solaris, Windows 95 platforms using Oracle 8i, 8.x / 7.x, Oracle Enterprise
Manager, Oracle Applications, Oracle Development, PL/SQL, SQL * Loader, implementation of
Java Application, JRun, Java Handling of Techsupport for all Macromedia Products, Done
Some prototype on C#, Integrating a Legacy systems with latest Web Technology with
standards of Rossettanet (Xintegrate).
EDUCATION QUALIFICATION :
B.Sc
. Computers From Nagarjuna University, 1994
M.B.A
From Andhra University - 1996
Experience:
Working as
Sr. Solution Engineer
in INTRACOMM, Intranesis Communications Pte, Ltd., in
Singapore August 2000
to till date
.
Working as
Software Programmer
in Sekhar Soft Pvt. Ltd, Hyderabad & Singapore, sinceAugust 99
to May 2000 & placed in Singapore for May 27 to July with a client .
Worked as
Software Programmer
at SMC Technologies Pvt. Ltd., (Mumbai and Hyderabad)
from July 96
to August 99
.Software Skill Set:
Expertise : Oracle DBA on 8i, 8.0 & 7.x
Language : Java (RMI, JDBC, Servlets, Beans, EJB, JMS), C, C++, Pascal
Databases : Oracle 8i, 8.0, 7.x, SQL 2000, 7.0, 6.0 & DB2
Java Tools : JRun, Progress Sonic MQ (Java Messaging Server),
Web Applications : JRun, Flash, ColdFusion, Spectra,
Oracle Utilities : Oracle Enterprise Manager
Front End Applications : VB 5, Developer 2000, PL/SQL
Operating Systems : Sun Solaris, Windows NT, Windows98, Linux.
Packages & Tools : MSOffice, Dbase, Jetforms.
Worked On Platforms : Unix, Windows, Windows NT, Sun Solaris.
Tools : Macromedia Generator, Dream Waver Ultradev, Jbuilder
Web Test Tools : E-Test Suit, Skill Performer, Bean Test
Training Under Gone : Progress Messaging Server (Java Messaging Server),
ColdFusion Advance Developer, JRun Advance Developer,
E-Gain, E-Test Suit
Certified Programmer : Progress Sonic MQ (Java Messaging Server), Rosettanet,
JRun J2EE Certified Trainer and Programmer
Experience in Singapore :
Working as a
Sr. Solution Engineer
in INTRACOMM, Intranesis Communications Pte, Ltd.,
August 2000
till date
Intracomm is an Organization which provides the Solution for the Web Technology in
Singapore on the Platforms of Oracle, SQL, DB2, JAVA, JMS (Java Messaging Services),
ColdFusion, NetObjects, Spectra, HomeSite with the Backend database as Oracle, SQL.
Special skills in Oracle Database tuning, backup and maintaince and tuning of Java Web
Servers JRun.
Profile of The Job :
Key Roles: Designing of application on databases on Oracle, SQL, DB2 and application on
Java, ColdFusion, System integration of various technology and providing solution to the
customer requirements, JRun (Java Web Server) Technical Support for the South Asia (Hong
Kong, Singapore, Malaysia, India). Performance Tuning of the Web Application and Solving
the bottlenecks of the Application using the web Analyzing Tools like E-Test Suit, Skill
Performer.
As a Sr. Solution Engineer my profile is to Design the Databases and Application for the
Clients and the necessary tools and scripts for the backup and Maintenance of the database
on the Sun Solaris & WindowsNT Platforms. Also involved in Developing the GUI components
in JAVA for the front end Utilities for the easy access of the database administration and
Maintenance Strategies on the Web, using the Java interfaces. We are now developing the
front-end interfaces and utilities for the database to take the back up and other
administration utilities of the Database. I am also involved in design and developing the
Java based application with Java Messaging services that will be communicating with the
web applications to the legacy systems. This front end actually performance all the DBA
activities of the Database for the module. Clustering of application in ColdFusion and
JRun. I also look after the JRun Web Server and the maintenance of the Web servers of the
clients. As a System Designer we have designed the application on ColdFusion integrating
with the Microsoft Exchange 2000 server for customer using the com objects for
communications between Exchange server and ColdFusion.
Database Administration:
Designing of administration strategies of Oracle 8i database
Involved in the installation of Oracle 8i Server around the world and replication of
Databases.
Creation and maintenance of database
Configuration of database parameters for tuning and replication
Monitoring Database for fragmentation and correcting them timely.
Analysis and advising on capacity planning based on transaction volumes and growth
Backup and Recovery
Replication the full databases across the globe synchronizing the database hourly.
Trouble shooting correction of application programs for bugs and performance tuning
Clustering the databases across the globe.
Done partial replication of the database across the Globe.
Introduced and trained other team members in creating, maintaining and troubleshooting
the database of different character sets.
In-charge for the contingency setups (porting the database from one machine to the
other)
Establishing and implementing sound Backup and recovery procedures
Evaluate Oracle features and Oracle related products
Technical trouble shooting and give consultation to development teams
Interface with Oracle Corporation for technical support.
Leading the team of database developers and guiding junior DBA's.
Designing the quality metrics for the database, which includes the rules for fixing the
size of tables, the schema objects naming conventions, code of conduct for writing SQL,
backup strategy and other tuning tips.
Independently involved in the consolidation of database scripts for all the interim
deliveries.
Developed various types of generalized stored procedures using the dynamic SQL package
which includes procedure to dynamically create a table to generate new data structure,
dynamically altering the existing data structure, generalized procedure for writing and
reading into /from LOB's etc.
Involved in integrating the SQL database with Oracle and synchronizing them.
Projects Involved in the Intracomm:
Singapore:
Involved in a project for a Workflow Application Build on Java and ColdFusion. The
backend database used is the Oracle. My profile in the project is to build up the Workflow
for the application and to handle the integration part with the ColdFusion and Java. Also
the implementation of the project on site.
Involved in a project that has integration of the MicroSoft Exchange 2000 with the
ColdFusion. This application is a Typical customization for the Client to integrate the
Exchange with the ColdFusion for better
Malaysia:
Involved in the creating a replication of Oracle replication for a Production Industry to
online synchronization of data for their Organization. For this we have done two kinds of
Oracle replication one Database is completed replicated (Full Database) from Singapore to
Malaysia so that this also helps them to maintain a standby database, other we have done
the snapshot replication of the database.
Hong Kong:
Involved in a performance tuning of a database in that is replicated form Singapore and
Hong Kong. Involved in the analysis of the database statistics given by the scripts of the
Oracle and implemented a Tuning Strategies for their database for a better performance of
the database.
Korea & Taiwan
:
Involved in design a Oracle database for a Stock broker organization for their online
messaging queuing server to maintaince a Asynchronous messaging Server for their internal
subscribers and clients in their application. I have involved in design of the Database.
Writing the scripts of the database backup and scheduling the backup scripts in their Sun
Solaris server. Also written Scripts for their tuning of their database for a better
performance.
2. Worked as a Software Programmer in Sekhar Soft Pvt. Ltd, May July.
As Oracle Database Designer and Java Web Application implementation for an Internet based
Applications in Singapore.
Involved in System Analysis of the Oracle Database and Java Interfaces Designing.
Installation of the Oracle 8i on the Solaris and WindowsNT.
Creating the database.
Configuring the database.
Configuring and creating the Roles and Privileges of the Database.
Creating the Java Components for the Access the database using the ColdFusion.
Replication of the databases in two different locations.
Designing the Back Strategies for the Database.
Designing the SQL scripts and interfaces for the Java for the backup Process of Oracle.
Designing the scripts for analysis of the Tuning of the database.
Analysis and advising on capacity planning based on transaction volumes and growth of
Database
Designing the Backup and Recovery strategies.
Environment: Sun Solaris, ORACLE 8I, Java, ColdFusion.
Experience in India :
1. August 1999
- May 2000
As a Oracle Database Administrator was responsible for the following:
Involved in administering Oracle 7.x database
Involved in the installation of Oracle 7.x Server
Upgradation of Oracle 7.x to Oracle 8.0.5
Creation and maintenance of database
Configuration of database parameters for tuning
Monitoring Database for fragmentation and correcting them
Analysis and advising on capacity planning based on transaction volumes and growth
Backup and Recovery
Trouble shooting correction of application programs for bugs and performance tuning
Introduced and trained other team members in creating, maintaining and troubleshooting
the database of different character sets.
In-charge for the contingency setups (porting the database from one machine to the
other)
Establishing and implementing sound Backup and recovery procedures
Evaluate Oracle features and Oracle related products
Technical trouble shooting and give consultation to development teams
Interface with Oracle Corporation for technical support.
Leading the team of database developers and guiding junior DBA's.
As the person in charge of the database team, I designed the quality metrics for the
database which includes the rules for fixing the size of tables, the schema objects naming
conventions, code of conduct for writing SQL, backup strategy and other tuning tips.
Represented the database team for client interaction and actively taken part in all the
database discussions with the client. Played a major role as an interface between users
and programmers
Independently involved in the consolidation of database scripts for all the interim
deliveries.
Actively involved in the database recovery and performed variety of complete and
incomplete recoveries including log file and data file recoveries.
Developed various types of generalized stored procedures using the dynamic SQL package
which includes procedure to dynamically create a table to generate new data structure,
dynamically altering the existing data structure, generalized procedure for writing and
reading into /from LOB's etc.
Played a key role in the design and development of database.
Also developed components in Java for the interface in Oracle Database for Intranet
Mail Application for the Organization.
Environment: Windows NT in Sun Solaris server, Oracle 8.
Organization:
SMC Technologies Pvt.Ltd
., (Mumbai & Hyderabad) July 1996 - August 1999
As a Software programmer, was responsible for the following:
Trained as Database Consultant in Oracle Related Activities,Web Applications.
Monitoring of Database for growth and performance
Defined backup procedures using weekly logical backups.
Wrote export scripts to export important tables and database structure.
Lead other team members for better performance
End User Training Support Activities
Individually and independently managed / administered the SAP Oracle database.
Undertaken the responsibility as an ORACLE consultant to the group of ERP
professionals.
Troubleshooting the database.
Analysis and advising on capacity planning based on transaction volumes and growth.
Backup and Recovery strategies implementation for Oracle databases.
Trouble shooting correction of application programs for bugs and performance tuning
Introduced and trained other team members in creating, maintaining and troubleshooting
the database of different character sets.
In-charge for the contingency setups (porting the database from one machine to the
other)
Establishing and implementing sound Backup and recovery procedures
Evaluate Oracle features and Oracle related products
Technical trouble shooting and give consultation to development teams.
Interface with Oracle Corporation for technical support.
Environment: Windows NT, Oracle 7.3.
PROJECTS UNDERTAKEN: SMC TECHNOLOGIES Pvt. Ltd.,
Title : REPORT MANAGEMENT SOFTWARE
MY RESPONSIBILITY :
My role in developing the system is designing the database, which involve the table
growth prediction and sizing the table's extents.
I was involved in the client interaction during the design and developmental stage and
represented the database team for the product.
I was involved in optimization and fine-tuning of database applications for the system
and independently involved in the consolidation of database script for all the interim
deliveries.
I have written many generalized stored procedures, which uses dynamic SQL package,
Dynamically altering and creating tables at runtime etc.
Involved in all the phases of development in this project and as a DBA, developed many
database backend utilities in scripts as a part of continuous process improvement like
automated backup, DB sync utility (checksum utility) etc.
Personal:
Date Of Birth : 05-06-1974
Sex : Male
Martial Status : Single
Canadian Immigration
Status : Approved
Personality & Traits:
Dynamic & Hardworking.
Good Communication Ability.
Ambitious and dynamic.
Have Good Debating & Orientation skills.
Contact this candidate