Oracle Data

Search Resumes - Results

Job Description *: Oracle DBA

Willing to Relocate: Yes

Additional Info

Pavan K Adusumalli

Work Status: Permanent Resident

Phone#: 513-***-****

.

e-mail:****************@*****.***

.

An organized detail oriented individual who has over 8 years of technical experience in

software industry with extensive experience in Oracle Database Administration. I take

initiative in learning and implementing new trends in technology that would benefit the

company. Ability to integrate and harmonize successfully in a team.

Technical skills:

Operating Systems: MS Windows 9x/NT/ME/2000, MS DOS, Sun OS/Solaris.

Programming Languages: JAVA, C, C++, HTML, JAVA SCRIPT.

RDBMS: Oracle 7x/8x/8i/9i, MSSQL Server 7x/2000, MS Access, Dbase,

FoxPro, Watcom.

Case Tools: Erwin, Rational Rose, ER-Studio, PowerDesigner.

DB Tools: Platinum DBA Advantage, SQL Station, Embarcadero DBArtisan,

Data Junction, Oracle Enterprise Manager

Browsers: MS Internet Explorer 4.x, Netscape Communicator 4.x, WAP Browser.

Application Server: WEBSPHERE.

IDE Tools: VisualAge For Java.

Languages: C, C++, FORTRAN, Basic, SQL, PL/SQL, Transact SQL and Shells.

Experience:

Clopay Corporation, Cincinnati(04/2003 V Present)

Project: MARKVIEW

MARKVIEW is an image documenting system. Markview is used for the Install and Furnish of

Garage doors business. Each Purchase Order received from the stores is scanned as a TIF

image and stored on the document server. This document (image) flows through the system

depending on the Workflow defined in the System. The Workflow determines the next queue

where the document has to go by triggering the Rules. The System is designed as a Web

Client and Oracle as back end database.

Responsibilities:

Performed Oracle Database Administration activities such as Installation of software,

creating databases for all environments, Upgrading the existing databases, planning and

Implementing the Backup and Recovery strategies for the Production databases.

Creation and maintenance of Database Objects.

Extensively used Oracle Export, Import utilities to export and import data into the

databases.

Involved in tuning the database for better performance.

Wrote and maintained UNIX shell scripts to perform day-to-day database monitoring.

Oracle Backend development (PL/SQL) to generate the monthly lead-time reports.

Caminus Corporation, Houston(08/2002 V 03/2003)

Project: CAMINUS GAS PIPE.

CAMINUS GAS PIPE (CGP) product provides software solution for various Gas and Energy

Companies and Trading Companies. The system consists of different modules such as Gas

Accounting, Capacity Management, and Custody Contracts etc. The system is supported on

different backend databases such as Oracle, MS SQL Server and Sybase.

Responsibilities:

Performed several Oracle 7.x/8.x/8.1.x/9i, SQLServer 6.x/7.x/2000, Sybase 10.x/11.x/12

server installations, database implementations, systems migration and setting up

maintenance scripts for GMS, GISB and EnGenius customers on Windows NT/2000.

Implemented several 24x7 application environments, troubleshot customer servers and set

up different backup strategies such as Transaction Log, Exports, Hot Backups, Cold Backups

and Archive Logs and Replication for several customers.

Gathering business requirements, analyzed and Designed Logical and physical models for

web based (Internet) new Gas Pipeline system using Erwin, Rational Rose on Oracle 8.1.7

and SQL Server 2000.

Worked in the design analysis and implementation of Gas Management System (GMS), GISB SQL

Server, Oracle and Sybase database servers using Erwin. Designed and written several

database stored procedures, triggers, and defaults for SQL Server, Oracle and Sybase.

Was responsible for documentation, maintenance of internal servers, and setting up

testing application environments. Supported several internal databases on daily basis.

Implemented various automated maintenance scripts such as computing statistics, backup

procedures, space management, and schema maintenance scripts for customer servers and

internal servers.

Performed I/O and Memory performance monitoring and tuning of database servers for

various customers.

Created database standards and object naming standards for the physical Implementations.

Worked on the performance analysis for high volume transactions. Assisted development

team in database design analysis, query performance tuning and query optimization. Worked

in application migration team on the migration process and analysis.

Responsible for setting up database upgrade path for GMS, GISB applications.

Performed/Ported several database migrations from Oracle to SQL Server and Vice Versa.

Designed and Developed Database Schema Migration tool to convert SQL Server and Sybase

databases to Oracle Schemas and vice versa.

GE Card Services, Cincinnati (03/2002 V 07/2002)

Project: APOLLO PROJECT.

APOLLO PROJECT is a data store for the Collections information of different credit cards

issued by GE to different Customers and Stores. The Marketing analysts generate various

reports against the Oracle Data store for their statistics. All the information received

from the Mainframe Systems (CASS and FDR) is loaded into the Oracle Database to generate

the reports.

Responsibilities:

Performed Oracle Database Administration activities such as Installation of software,

creating databases for all environments, Upgrading the existing databases, planning and

Implementing the Backup and Recovery strategies for the Production databases.

Creation and maintenance of Database Objects.

Worked with Erwin tool for Data Modeling to design the STAR SCHEMA.

Extensively used Oracle Export, Import utilities to export and import data into the

databases.

Involved in tuning the database for better performance.

Wrote and maintained UNIX shell scripts to perform day-to-day database monitoring.

Wrote SQL scripts to extract data from the billing source system.

Backend Programming (PL/SQL) to load the data from flat files into Oracle Database

Objects.

Developed control files to load data to the tables using SQL*LOADER.

Prepared the DOCUMENTATION for the system.

Environment: Unix Sun OS 5.6, Windows NT 5.0,Oracle 8.1.7 and Business Objects.

Convergys Corporation

(12/1997 - 02/2002)

Project: DATA WAREHOUSING. (CHURN MANAGEMENT)

DATA WAREHOUSING is a data store for the Wireless billing system called Atlys. Billing

data is extracted from the Billing System in form of flat files and loaded into the

database on a daily basis. End users generate reports from the Data warehouse application

database.

Churn management is a term used in the telecommunications industry to describe the

process of ensuring that profitable customers stay with a particular company. Data

warehousing is used to gather data relating to churn from an organization's operational

systems, such as billing, and organize it into a form suitable for analysis. A data

warehouse allows the relevant operational data to be stored separately from the

transactional systems themselves so that reporting on the data does not impact processing

speed, and organized according to units that helps marketing analysts for customer

retention.

Responsibilities:

Performed Oracle Database Administration activities such as Installing of software,

creating databases for all environments, Upgrading the existing databases, planning and

Implementing the Backup and Recovery strategies for the Production databases.

Creation and maintenance of Database Objects.

Worked with Designer2000 tool for Data Modeling to design a STAR SCHEMA.

Extensively used Oracle Export, Import utilities to export and import data into the

databases.

Involved in tuning the database for better performance.

Wrote and maintained UNIX shell scripts to perform day-to-day database monitoring.

Wrote SQL scripts to extract data from the billing source system.

Backend Programming (PL/SQL) to load the data from flat files into Oracle Database

Objects.

Developed control files to load data to the tables using SQL*LOADER.

Performed Unix Administration activities like taking the file systems backup and

Operating System level Backup.

Prepared the DOCUMENTATION for the system.

Environment: Unix Sun OS 5.6, Windows NT 5.0,Oracle 8.1.5, Visual Basic 6.0 and Sagents.

Atlantic Systems, Inc

. New Jersey (03/1997 V 121997)

Project: VISION

Vision is Insurance based Workers Compensation System. The system processes quote

requests, Policy Renewals, Cancellations, Reinstatement and rating of the policies. The

system is also responsible for Backend Daily Close process, to move cash from the Account

Receivable. Disbursements of cash and automatic cancellation and renewals of policies were

handled.

Responsibilities:

Involved in creation of complex Stored Procedures, Triggers and Functions using Oracle

PL/SQL.

Developed several reports to handle Agent Summary, Account Summary, Cash balance

transactions and Work In Process files.

Developed control files to load data to the tables using SQL*LOADER. Used Oracle Export,

Import utilities to export data and import data into the database.

Performed Database Administration activities like creating database and other day to day

DBA jobs like taking backup and giving online assistance to the team like creating

database objects, and Managing database effectively.

Prepared the DOCUMENTATION for the system.

Environment: Unix Sun OS 5.6, Oracle 7.3, Power Builder V5.0.

Indus Solutions Limited, India (03/1995 V 031997)

Project: DISPATCH MANAGEMENT

Dispatch Management helps in the preparation of dispatch advice. The system provides On-

line information on the availability of goods in the factory and regional warehouses. The

availability information includes available on-hand, blocked quantity and quantity on-

order or on transit. The aggregate dispatch file is transmitted automatically for timely

shipment. Each warehouse transmits shipment data back to the system for invoice

preparation. The system generates sales order dispatch advice and invoice reports upon

request and periodically.

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, and Triggers to handle the Backend

database transactions.

Developed conversion utility programs using PL/SQL to maintain changes to the production

database.

Developed control files to load data from the database using SQL*Loader.

Export and Import utilities were used to export and import data from the database.

Environment: Unix Sun OS 5.6, Oracle 7.3, Power Builder V5.0

Education/ Training/ Recognition:

Bachelor of Technology,

India 1992

Trainee at Software Technology Park,

India.

SEE (Spotlighting Employee Excellence) Award for Second Quarter2001.

References: Furnished upon request.

Back to Search Results

Employment Job Seekers Employers Members Affiliate Program Post A Job Post A

Resume Resume Writing

Link Map About Employment 911 Contact Us

Employment911.com, 1998 - 2002. All Rights Reserved.

Click here for our Terms of Use Policies.

Contact this candidate