🚀 go-pugleaf

Professional Summary
Over 8 years of experience in Oracle Database Administration.
Experience in Data Modeling, Design, Testing, Development & Production
support
Educational Qualification
Bachelor of Engineering (B.E) Computer Science & Engineering
Technical Skills
HARDWARE              :	Pentium,RS-6000, RAC,RAID
OPERATING SYSTEMS:	Windows NT, Sun-Solaris, Sco-Unix, HP UNIX, VAX/VMS,
AIX
LANGUAGES		 :	PL/SQL, C, C++, Pro*C, Unix Shell Programming
Databases		 :	Oracle  7.x/8.x/9.x/10g, Oracle Applications 11i, Ms-
Access
GUI			 :	Developer 2000,VB
TOOLS & UTILITIES	 :	RMAN, Quest.com, Oracle Enterprise Manager, Erwin,
Designer
2000, MS-Visio,Tkprof, RMAN
DOMAIN KNOWLEDGE  :	Logistics, Banking, government, Insurance
Testing Tools               :         Load Runner, SiteScope, BAC
Professional and Project Experience

Organization		: 	Polaris Software Lab ,NJ
Duration		: 	Oct'05 till date
Project Name		: 	Intellect
Role			: 	Senior Oracle DBA
Description		: 	Intellect Lending 9.5.0 application was deployed in
PACE SIT
				Environment by SEDBA and PVCS has been used for Version
				Control.
Environment             :            Oracle 8.x/9.x/10g,RAC,UNIX All,
Erwin, Designer

Flavours,Developer2000,Standby,Replication,Windows,3Tier
                                                 Architecture


Project Details :
Intellect Lending is a complete lending management product catering to
various functions of Loan management. The product caters to Retail and
Corporate Loans. The product captures all the information through out a
loan life cycle. It supports various business requirements of lending;
generating proposals, sales, booking, foreclosure, maturity closure,
rescheduling etc. It caters to various business processes like
delinquency, post dated cheques, standing instructions, top up loans,
rollover loans, component rollover, charges & waivers and excess refund
& excess adjustment etc.




Responsibilities:

·	Experience in installing & configuring Oracle9i RAC.
·	Expert in systems analysis and architecture, capacity planning,
backup/recovery, installation, configuration, apply patches,
monitoring, performance tuning, restructuring of databases, trouble
shooting.
·	Good knowledge in design, development and testing of backup and
recovery to ensure complete recoverability.
·	Skilled in logical and physical database design. Experienced in
logical data modeling including business rules with
Erwin Model Mart in multi-user environment with for normalized and
dimensional data structure.
·	Highly skilled in disaster recovery, routine maintenance for oracle
databases.
Experienced in advanced replication, & one physical standby database
using Data Guard 9i.
·	 Oracle data Dictionary and Tunable init.ora parameters.
·	Database migration from 7.3 to 8i & 8i to 9i using FTP for file
transfer, SQL Loader, Toad export feature.
·	Wrote Unix K-Shell scripts for hot backups, SQL Loads, export and
import of database.
Familiarity with oracle10g. Perform Database Sizing, Object Sizing and
planning adhering to oracle OFA
·	Perform Daily Monitoring of oracle Instances using oracle Enterprise
Manager, monitor users, and tablespaces, Memory Structures, Rollback
Segments, Logs and Alerts.
Excellent interpersonal and strong analytical, problem-solving and
conceptual skills
            This project is in study phase which has to be implemented
in 3 tier architecture.
·	This project Installed oracle 9i & applied patch set on development
& production server.
Setup the advanced replication for a single master site & a snapshot
site in development & production .
·	Set up OMS & configured RMAN for backup & recovery of existing
instances on development & production servers.
·	Planned and implemented archival, backup / recovery of databases.
Fine tuned the memory & init.ora parameters for databases (1 TB).
Performed application, SQL, and database instance tuning using a wide
range of technologies including Statspack, SQL Trace (Event 10046 trace
files), OEM Performance Manager, and custom scripts.
·	Configured Standby Database in manually managed mode. Shell scripts
and Cron jobs are written to transfer the logs to standby site
(Disaster Recovery site) at frequent intervals and apply to the Standby
Database as per Business requirements.
·	Scripts are developed to monitor the growth of the Database and
purging policy is implemented at frequent intervals by raising change
controls to GE-Capital Bank.
·	By monitoring production Database through Instance Monitor,
suggested some parameters for Database Tuning.
·	Performed Smoke testing during the installation of every full build
for the Intellect Lending 9.5.0 application to validate the fitness of
the application for testing.
·	Functionality testing has been performed against the identified
modules. The testing was primarily intended to facilitate the Business
Scenario execution, to identify the defects at the earliest so that the
Business Scenario execution can be smooth.
·	The functional test cases do not cover inter-module integration,
which was covered in the identified Business Scenarios



Organization		:	Satyam computers Ltd
Project Name 	:	Glass
Client			:	GE Money Bank, USA
Role			:	Sr. Oracle DBA
Duration		:	Mar'05 to Sep'05
Team Size		:	5
Environment             :          Oracle 9.x,RAC,SunSolaris, Shell
Scripts,

DataGuard,Replication,Windows,3Tier Architecture



Project Details :

Pan Credit - a Lending software package was obtained by GE-GCF, to
cater their Lending and Leasing Business needs. Suitable software
modifications are made to the product to meet the requirements of GE
Capital Bank, Austria. Satyam is entrusted with the maintenance of this
product by GE-GCF. The maintenance includes activities like bug fixing,
support during online and batch processing in the live environment,
performance enhancements, software releases and configuration
management etc.,

Production servers are located at Copenhagen. Satyam access the servers
through GTN Link and provides offshore operations and Database
Administration. All the three servers (Pan Credit production, Data
warehouse, Test/Standby) are configured in Sun Clustering to make sure
high availability of the system.   In case of production down (one-node
fails) the other node automatically takes over without notice of users.
Disk mirroring (striping across the disks) is implemented for optimum
performance gain. Cron jobs take care of switching from one node to
another node in case of any failure.

Verities Volume manager is used to configure Disk groups and Verities
Net Backup R3.2 is configured to automate the physical Backup of the
Database.

CSC (Computer Science Corporation) is responsible for high availability
of System and takes care of Operating System and Satyam co-ordinates
with CSC for smooth maintenance of operations.

Satyam is responsible for the following

1.	Maintenance of three production databases and twelve Test
Databases.(Size of each Database is 60 GB)
2.	Database Administration.
3.	Offshore Batch runs
4.	Raising Change controls to CSC for necessary privileges or
permissions.

Responsibilities:

·	Configured Standby Database in manually managed mode. Shell scripts
and Cron jobs are written to transfer the logs to standby site
(Disaster Recovery site) at frequent intervals and apply to the Standby
Database as per Business requirements.
·	Scripts are developed to monitor the growth of the Database and
purging policy is implemented at frequent intervals by raising change
controls to GE-Capital Bank.
·	By monitoring production Database through Instance Monitor,
suggested some parameters for Database Tuning.
·	User names are changed to new names as per business requirement
during migration time.
·	Suggested for the Backup strategy as per affordable downtime of
production system.
·	Worked on Recovery manager to recover the Database.
·	Also involved in SQL performance tuning.
·	Creation of database links
·	Estimating the size of Databases.
·	Creating Databases
·	Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4
·	Executing and monitoring offshore Batch run operations (End of the
Day and Start of the Day of operations of GE-Capital Bank
·	Monitoring Standby Database whether all the logs transferred to
Standby site and applied properly.
·	Checking the Alert Logs of production Databases for any errors
reported by Oracle.
·	Adopting change control Mechanism (Lotus Notes Server) for
replicating the changes made to the production Databases.
·	Export and Import of databases from one database to another
databases.
·	Monitoring the performance of production database through Instance
Monitor (Quest Tool) and growth of the database and suggesting for
change in parameters if required.
·	Writing the shell scripts to automate the Backup and copying the
production copies to Test environment. (Scripts to copy from one test
database to another database)
·	Attending specific requests from online, bug fixing, Bulk rate, Data
warehouse Teams.
·	Adhering the process as per GE Security guidelines.


Organization		:	Satyam computers ltd
Project Name 	:	Bplpg
Client			:	British petroleum,UK
Role			:	Sr. Oracle DBA
Duration		:	June'04 to Feb'05
Team Size		:	8
Environment             :            Oracle 9.x,Unix, Shell Scripts,
DB2,SQL-Loader




Project Details :

This project was implemented in backend oracle where data is taken from
DB2 and Loaded in oracle Through SQLLoader and designed the database .

Responsibilities:

·	Installed database in Sun Solaris on staging server.
·	Tuned database parameters and applications for optimal performance.
Responsible for support of the databases and database servers which
includes performance monitoring, performance tuning, optimize
programming code/ SQL, troubleshooting and client support.
·	Actively involved in archival, backup / recovery, import / export
(SQL Loader) of relevant  data.
·	Used Toad and SQL Plus for executing PL/SQL procedures, packages for
business.
Wrote shell scripts to backup, restore database and automate daily
activities.
·	Installed Oracle RAC with Data Guard implementation for disaster
recovery.
Used Erwin for physical data model design.
·	Database Design,
·	Backup & Recovery,
·	Tuning the Database and
·	Analyzing the Database,
·	Coding PL/SQL & Shell Scripts,
·	Database Maintenance,
·	Data warehousing.
·	Database Design,
·	Data Modeling using Erwin
·	software design of medium/large business applications
·	Design methodologies
·	Database (SQL)design
·	E-R Modeling.
·	Design and Development Of database design
·	Design/Code reviews


Organization		:	InfoTech Enterprises Ltd
Project Name		: 	Logos
Client			:	Metro Retail Group, Germany
Role			:	Sr. Oracle DBA
Duration		:	Nov'03 to May'04
Team Size		:	40
Environment             :            Oracle 8.x,RAC,AIX, Shell Scripts,
DataGuard,Replication,
			                  Developer 2000.webservers,discoverer



Project Details :

This Project is for the client Metro Retailer with more than 22,000.
Outlets worldwide. Client already had application on FoxPro, which had
to be migrated to oracle with Oracle Server as Back-end and Forms
&Reports as Front End with Data warehousing. Scope included: Maintain
Customer support Database, Testing Database, Design database.

Responsibilities:
·	Managed Installation, Configuration and Administration of Oracle
8i/9i Databases.
Created database, database objects like table, index, DB Link, table
space, rollback segments, views and analyze relevant objects to collect
statistics to tune the system performance.
·	Tested and Implemented different physical and logical backup and
Recovery methods like crash point in time recovery, Full/partial
export/import.
Defined backup procedures, alert checking, Remote archive copying,
monitoring and tuning database using cron jobs.
·	Tuned application with EXPLAIN PLAN and TKPROF, analyzing database
objects, maintaining the security of the databases.
Participated in the development and testing of backup and restore
strategies for development and production system.
·	Applied Oracle Software patches when required.
·	Worked on Database Sizing, Rollback Segments and Queries. Performed
STATSPACK tuning.
·	Created and maintained Unix scripts for Oracle maintenance and
statistics.
Altered, modified, Partitioned, dropped, created database objects daily
on a 24 X 7 production, Development, testing environments using TOAD
and OEM (Oracle Enterprise Manager).
·	Implemented multiplexing of control files and redo-logs for disaster
recovery scenario.
Monitored Rollback segments and its Space management.
·	Installed, configured and administered DataGuard Environment.
·	Developed the scripts for creating the Users and allocation of rolls
to the users and maintaining system security.
·	Checked Alert file and Trace files regularly
·	Database Design,
·	Data Modeling using Erwin
·	software design of medium/large business applications
·	Design methodologies
·	Database (SQL)design
·	E-R Modeling.
·	Design and Development Of database design
·	Design/Code reviews


Organization		:	Indian Soft Technologies
Project Name		: 	Customer Support Database Maintaince
Client			:	United Bank Of Switzerland, Singapore
Role			:	Sr. Oracle DBA
Duration		:	Feb'03 to Oct'03
Team Size		:	4
Environment             :            Oracle 9.x,RAC,VAX-VMS, Shell
Scripts, ,Replication
                                                 DataGuard







Project Details :

There were about 50 different databases, which were residing on
different platforms. The project aimed to monitor all the databases and
provide customer support. For Maintaining the database Enterprise
manager was loaded on Windows NT System for monitoring the space of
tablespaces, Rollback Segments, Security For users, networking etc..,
Online Backup's were preferred since database was running for 24 hours.
Tape drives were used for storing the export files and system files
like data, redo log files etc

Responsibilities:

§	The activities included the database administration of the various
databases assigned to the division for the internal as well as external
clients.
§	Installation of the Databases, Environment Building to OFA
compliancy
§	Control File Maintaince
§	Backup Cold, Hot, Online, Exports
§	Performance Tuning
§	Remote sessions tracing
§	Recovery Manager (RMAN) Implementation and strategies
§	Database Designing using ERWIN
§	Various Database Recovery scenarios  verification in advance
§	Altering the Database objects  and  files  during maintenance
§	Implementation of RAC  Technology
§	Strong experience in Oracle Databases Migration and Upgrade.
Solved issues related like Space Management, Locks resolution, Batch
Job failures, Database Cache Hit Ratios (SQLCache, Library Cache, Data
Dictionary Cache) and Backup failures.
§	Performed daily monitoring and checking of the alert Logs for
errors.
Resolved Oracle networking and connectivity issues.
§	Wrote some utility SQL and Shell scripts for performing routine
database activities.
Researched and Identified Issues or Problems. Provided Solutions and
Work with vendors / Oracle Support to open tar if necessary. Ensured
all cases are resolved to customer satisfaction and solutions are
properly documented.
§	Implemented Backup and Recovery strategies using User-Managed and
RMAN backups.
Wrote scripts to automate routine database monitoring, diagnostics and
backups.
Created user profiles and roles. Also granted system level and object
level privileges to users.
§	Performed Resource Management by creating and managing Indexes,
Clusters, and Tables.
§	Managed physical storage structures like Datafiles, Redo logs,
Control files. Managed logical storage structures like Tablespaces,
Segments and Extents.
§	Installed, configured and administered SQL Server 200 and its
clients on workstations and laptops. Applied latest service packs to
address the possible security issues. Wrote triggers and stored
procedure to handle various functions. Performed backups, maintenance
on and recovery of SQL Server databases. Fine-tuned queries and stored
procedures. Upgraded and upsizing databases from earlier versions to
the latest versions.
§	Created DTS packages and migrated data from MS Access and from flat
files. Created jobs to automate repetitive tasks. Upgraded SQL Server
7.0 to SQL Server 2000. Resolved SQL Server issues relating to DTS
connectivity, replication and backup/restore


Organization		:	Indian Soft Technologies
Project Name		: 	Customer Support Database Maintaince
Client			:	Conseco,USA
Role			:	DBA
Duration		:	Nov'02 to Jan'03
Team Size		:	6
Environment             :            Oracle 8.x,RAC,Unix, Shell
Scripts, ,Replication
                                                 DataGuard


Project Details :

The parent company was having database of insurance company, where if
any problem occurred, mails were sent with details. There was a direct
connection to the database through leased line and telnet, from where
database was assessed. For resolution rewriting and fixing the problem
was done.. This database was present in Minneapolis USA, where they
were using for Insurance Company. The data was published for online
sharing Enquiry. The size of the database was about 20GB.Daily around 3
MB of data will be inserted inside the database. For Marinating the
database Enterprise manager was loaded on Windows NT System for
monitoring the space of table's paces, Rollback Segments, Security
for users, Networking etc.., Online Backup's were preferred since
database was running for 24 hours and tape drives were used for storing
the export files and system files like data, redo log files etc..,

Responsibilities:

·	Jobs Scheduling,
·	Exports/ Imports,
·	Space Management,
·	Hot and Cold Database Backups and recovery
·	Shell Scripting,
·	Restoration Tuning Memory,
·	SGA, I/O, OTIMIZATION,SQL-tuning ,Security Management,
·	Remote Database Access Security management 24 x 7 Monitoring,
·	troubleshooting and maintaining
·	Database Recovery,
·	Automation of the Database Start up and Shut down.
·	Database Migrations,
·	Writing Stored Procedures, functions, packages, triggers.
·	The loops were developed to create the temporary tables, handle the
records dynamically and
·	This involved lot of records comparison for the selection as the
best records needed to be updated as the final address for the client
·	Snapshots creations and Refreshing,
·	Managing the network and service changes on the network of the
databases,
·	STANDBY Database implementation and Automation of the process (KSH,
LOADER, PL-SQL scripting combination) of ftp download of files to
proper load and update on tables.
·	Writing shell scripts.
·	Loading data into the database from the flat files with   SQL*Loader
·	Implementation of RAC


Organization		:	Indian Soft Technologies
Project Name		: 	Online Information Management System
Client			:	Hyderabad Race Club
Role			:	DBA
Duration		:	July'02 to Oct'02
Team Size		:	6
Environment             :            Oracle 11.x, Shell Scripts,Windows




Project Details:

The main aim of the project was to maintain the departments like Oracle
HRMS, Oracle Payroll, Racing Accounts, Administration, Secretarial
Department Accounts, Racing Accounts, Racing department, Tote, Civil
Engineering & Electrical Engineering Privileges, Reports. Since the
organization was working for 8 hours, it was recommended to take cold
backups. The size of the database was about 100 GB and every day 15MB
transactions were inserted. Daily Entire export was taken and stored in
tape drives. Shell scripts were written for taking the entire database
export and incremental exports.

The total size of this database was about 50GB.Daily around 5GB of data
was inserted. This database is on SunSolaris. Here database was
replicated to another server. Whatever the data present in primary was
updated to secondary. For the sake of reports organization used
secondary database. If there was any problem in the primary database,
secondary became online. There was a  standby database for the
development only some of the data were exported in this standby daily.
Online Backup's were preferred for this database Daily export was
taken. Hourly incremental and cumulative exports were taken

Responsibilities:

·	Installed and configured Oracle Servers on UNIX, Linux and Windows.
Applied Oracle Corporation recommended patches. Created development,
test and production databases.
·	Created storage structures and database objects. Performed database
maintenance including tablespace management, tablespace sizing and
resizing, creating and rebuilding indexes and large table management
through partioning and user tablespace quota management.
·	Created tablespaces based on the OFA model. Implemented physical
database design after sizing tables and indexes and creating
tablespaces for proper account I/O load distribution.
·	Configured Oracle servers and optimized initialization parameters in
INIT.ORA (DB Block Size, DB Block Buffers, Shared Pool Size, Sort Area
Size) and adjustment of OS Kernel parameters.
·	Diagnosed and tuned databases for performance problems and lock
conflicts using monitoring and diagnostic tools, shell scripts and
dynamic performance V$ views.
Refreshed development and test databases from production database using
Exp/Imp to provide the latest data is available in the development/test
database for the developers.
·	Executed file system, server based (RMAN) backups and logical (exp)
backups. Executed complete and incomplete media recovery procedures
(Time/Change/Cancel-based).
·	Installed, configured and administered Standby Database. Cloned
databases for testing.
Loaded data from flat files to Oracle databases and migrated from older
Oracle versions.
·	Managed Users access control and security by creating appropriate
roles and profiles.
Implemented and configured Oracle Net and resolved connectivity issues.
·	Contributed in Database Installations,
·	Database Recreations,
·	Moving the database on the network 24 x 7 support on pager call
duty,
·	Troubleshooting and Problem resolution Exports/ Imports,
·	Hot and Cold Backups
·	Shell Scripting,
·	Restoration Space Management,
·	Tuning Memory, SGA, I/O,
·	Security Management,
·	Objects sizing Strategizing Backups including usage of RMAN Database
Recovery, Involvement in Database Migrations
·	Snapshots creations
·	strategizing and troubleshooting
·	DBA JOBS  scheduling,  monitoring  and  maintaining,
·	Jobs scheduling with CRON TAB
·	Altering the Database objects and files during maintenance


Organization		:	Indian Soft Technologies
Project Name		: 	Computerization Of Ration Card
Client			:	Electronic Corporation Of India Ltd
Role			:	DBA
Duration		:	Sep'00 to June'02
Team Size		:	8
Environment             :            Oracle 9.x,RAC,VAX-VMS, Shell
Scripts, ,Replication
                                                 DataGuard

Project Details:

This was one the largest Database where daily around 50MB transactions
were getting inserting. The main server was running on Sun-Solaris
Platform where Database was replicated for the Security sake. The total
size of the database was about 500 MB of data. The main database was
located at the headquarters from there around 20 places are connected
to the central database through leased line. Every day there were
roughly 0.5 GB data inserted inside the database. Every week all the
data was taken into tape drives, with hot backups. Database was about 1
terabytes of data with 500 data files and tablespaces. Scope included
Creating database, managing oracle instance, control files, redo log
files, table spaces, data files, rollback segments, temporary segments,
tables, indexes, roles, profiles, users, auditing Backup & recovery
considerations, oracle export & import utilities Tunings the shared
pool, buffer cache, redo log buffer etc.,

Responsibilities:

·	Installed and migrated Oracle Servers on Sun Solaris, Linux and
Windows. Created databases, storage structures and database objects.
Performed database maintenance using Oracle Tools and Utilities like
Server Manager, SQL Plus and Oracle Enterprise Manager.
·	Managed databases including space management, Rollback segments and
Extents management, tablespaces and datafiles management, monitoring
and resizing. Multiplexed control files and redo groups members and
replicated data using snapshots and db links.
·	Performed Performance monitoring and tuning through Alert and Trace
logs for problem queries, tuned Shared Pool size, Library Cache, Buffer
Cache, used oracle database block size efficiently, optimized sorts
operations, monitored tablespace I/O, tuned rollback segments and
monitored and detected locks and latch contentions and eliminated the
dead locks.
·	Installed, configured and maintained hot standby database for high
availability. Cloned databases for developers testing. Loaded data
SQL*Loader. Executed hot, cold and logical backup and restore
procedures. Managed system resources creating user profiles and roles.
·	Developed shell scripts to carry out routine checks on databases.
This included checking whether all databases are running, listener is
up, Unix error messages, disk space availability, segments nearing max
extents, checking regularly the alert logs and trace files for errors.
·	Coordinated with database administrators, application developers and
support personnel to ensure that applications code and databases were
configured for optimal performance.
·	Developed Database Marketing Manager (DMM) as a team member. My
responsibilities included analysis and design, code modification and
addition more functionality, generation of on-line screens,
identification of bugs, making reports on bugs along with possible
solution, fixing the bugs, quality testing, creating documentation and
user training guides.
·	Worked on maintenance and Development of Pisa Project and Addition
Customization for Pisa Project. This is a Customer Relationship
Management (CRM) tool especially designs for Newspaper Industry.
Created stored procedures, triggers, functions, reports, designed input
screens on multiple canvases and user alerts.
·	Load data using SQL*Loader
·	Scripts for Complete and
·	Hot backup, Tuning the database,
·	SGA  sizing,
·	Give technical guidance to team members.
·	Create  database-links,
·	Create snapshots,  views,   remote procedure calls on the  remote
databases,
·	Granting  roles  and
·	Security Management using roles and privileges,
·	Developing stored procedures, packages, functions and database
triggers   .
·	Tune the complex SQL queries,
·	Develop Forms, Menus and Reports for VASP integration as well as
other  independent  processes,

Organization		:	Indian Soft Technologies
Project Name		: 	Vehicle Management
Client			:	Parliament House Of India.
Role			:	DBA
Duration		:	Dec'99 to Aug'00
Team Size		:	4
Environment             :            Oracle 8.x,Unix, Developer2000
Project Details:

Since the organization was working for 24 hours, it was recommended to
take hot backups and tuning has been done. The size of the database was
about 40 GB and every day there will be about 5MB transactions will be
inserted. Daily Entire export will be taken and stored in tape drives.
Shell scripts were written for taking the entire database export and
incremental exports. Tuning was done for the database for better
performance

Responsibilities:

·	Worked on enhancement and modification of Inventory of Control
System. Duties included analysis, modification, generation of on-line
screens, identification of bugs, making reports on bugs along with
possible solution, fixing them and quality testing.
·	Developed Employees Payroll System as a team member. Created forms
and reports and designed input screens on multiple canvases and user
alerts. Wrote stored procedures, triggers and functions. Conducted
unit, system and user acceptance testing.
·	Worked on development and maintenance of Inventory Control System as
a team member. My responsibilities included analysis and design, code
modification, generation of on-line screens, identification of bugs,
making reports on bugs along with possible solution, fixing them,
quality testing, creating documentation and user training guides.
·	Performed maintenance, bug fixing and support for many projects. It
included changing the implementation code, adding new methods to the
classes for additional functionality and adding new modules. Also
created utility class packages to be used for various projects.

·	Did quality testing, user acceptance testing and created
documentation for many projects and trained the clerical staff about
the applications usage.
·	Maintaing the space for tablespace and rollback segments.
·	Performance query tuning for SQL statements
·	Auditing the database
·	Maintaing standby database
·	Replication implementation
·	Distributed database for production and development
·	Security policy, application architecture, interfaces, document
sequence,
·	flex fields Folders, report & form registration, form development,
(template.fmb,
·	appstand.fmb) Queries find windows, upgradition, cloning or copying,
oracle alerts, and
·	Installation Of Database


Organization		:	International Computers India Ltd
Project Name		: 	Automated Timesheet system
Client			:	International Computers India Ltd
Role			:	DBA
Duration		:	Oct'98 to Nov'99
Team Size		:	5
Environment             :            Oracle 7.x,OEM,Toad,Developer2000.

Project Details :

Since the organization was working for 24 hours, it was recommended to
take hot backups and tuning had been done. The size of the database was
About 40 GB and every day there will be about 5MB transactions were
getting inserted. Daily Entire export was taken and stored in tape
drives. Shell scripts were written for taking the entire database
export and incremental exports. Tuning was done for better performance.



Responsibility:

The activities included the database administration of the various
databases assigned to the division for the internal as well as external
clients.
·	Installation of the Databases, Environment Building to OFA
compliancy
·	Control File modifications and Security
·	Backup Cold, Hot, Online, Exports
·	Performance Tuning
·	Remote sessions tracing
·	Recovery Manager Implementation and strategies
·	Database Designing with ERWIN
·	Various Database Recovery scenarios  verification in advance
·	Altering the Database objects  and  files  during maintenance


Personal Profile:

Name as in Passport			:	Batchali Vamsi Krishna
DOB					:	20-02-1973
Type of Visa holding (if any)	:	H1B VISA


bachalli@yahoo.com