Sign in

Oracle Maintenance

San Jose, California, 95134, United States
May 25, 2010

Contact this candidate
Sponsored by:
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial


** *** ****** ****, #****, San Jose, CA - 95134

Phone #: (908)-***-****


> 4 years of strong technical support experience in the software industry.

> 3+ years of experience in writing SQL queries.

> Experience in refreshing and manipulating data in tables using PL/SQL


> Experience in maintaining and monitoring databases by Oracle Enterprise

Manager (OEM)

> Performance tuning of SQL queries and advising the application programmer

of the opportunities in tuning the application

> Extensive experience in setup, configuration, upgrade, maintenance,

performance monitoring and troubleshooting on different platforms like

Sun Solaris, Linux, HP-UX, AIX and Windows

> Involved in writing SOPs

> Excellent interaction with global and cross functional teams.

> Ability to bridge the gap between business needs and technology

> Excelled in performance while under pressure and met deadlines in high

demand client oriented environment

Work Experience

Sanofi-Aventis Pharmaceuticals, USA

Apr 07-Present

Sanofi-Aventis is dedicated to improve life by treating and preventing

human disease through the discovery and development of innovative

pharmaceutical products.

> Application Support Analyst

. Installing and Configuring Oracle 9i/10g database

. Understanding the existing Database Structure and suggesting the database


. Installation and maintenance of Oracle database application software

which includes creation of database, installation/maintenance of Oracle

objects (function, procedure, views, packages)

. Designed and Implemented database security using and Oracle roles


. Created and maintained Databases and their objects like tablespaces,

datafile, redo groups, tables, indexes, views, materialized view etc

. Helped developer to install Oracle Client, troubleshoot and establish the

connection to Oracle database

. Installed and Configured Clinical software Clintrial 4.X and Clintrace

2.X .To manage user access rights and parameters, to query the database,

to manage coding dictionaries and to code data

. Support all production Clinical Data Management Oracle 9.X/10.X database

applications worldwide, clients use these database applications for FDA


. Currently working on Pharmacovigilance Drug Safety System called AWARE

(Aware is a AERS application from Oracle) to create, modify and

inactivate access to the application. Initiate or authorize change

control for the application. Being involved in the maintenance of the

validated status during the operation phase (change control process and

anomaly management)

. Troubleshoot Database performance issues using Automated Workload

Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)

. Monitoring Alert Log Files

. Created various OS authenticated users on the databases

. Supporting web-based customised application for the different

business needs.

Responsibilities include:

. Work with the end user for their application access


. Help users to write SQL queries in Oracle database

. Manage global user application issues, requests and resolution using

ticket tracking system HP OpenView

. Provide training to end users on Oracle applications

. Maintaining internal case study database(KBD) which can help the team for

future issue

. Run weekly/monthly pre-defined reports using Oracle


. Involved in extensive design of sql and shell scripts

. Maintenance and support of Oracle Clinical v4.5.1

. Citrix metaframe presentation server administration

Global Documentum based application: It is used for the management and

storage of product related documents that needs to be retained for a longer

period. It also supports the development of submission related documents

and publishing of reports in a validated compliant system.

. Currently working on GDMS being involved in the maintenance of the

validated status during the operation phase (change control process and

anomaly management)

. Supporting CRF Workflow application, designed to capture Case Report Form

(CRF) images via scanning or Faxing. Troubleshoot the issues related to

CRF Submission, Refax Management, PDF Generation.

. Working with Network Administrators to fix issues that occur

with LDAP synch job

. Administrating and maintaining the blogs of Research and


System/Application Testing:

. Wrote and executed system test cases, performed installation,

qualification and UA Testing

. Tested application security features, including session expiry, passwords

and compatibility across multiple browser types and encryption levels

. Designed test plans and defined cases for functional,

integration system, and user acceptance testing

Environment and Tools: Windows 2000 Server, Oracle 10g/8i/9i, TOAD,

Documentum 5.X suite, MS SQL Server 2000, SQL Plus, Apache Tomcat

Viru Electronics, INDIA

Jan 05-Jan 06

Viru Electronics is renowned organization in the field of hardware and

technology. It has the best servers, and advanced technology to offer.

> Technical Support Analyst

. Actively participated in gathering of user requirement and system


. Managing security, which includes monitoring and controlling database

access, assigning permissions to application owners

. Helped developer to install Oracle Client, troubleshoot and establish the

connection to Oracle database

. Provide technical support on UNIX and Oracle related issues

Environment and Tools: Windows 2000 Server, Oracle 8i/9i, PL/SQL, SQL Plus


Technical: Personal:

Technologies: PL/SQL, C/C++, Visual Basic, Excellent analytical, leadership

HTML, Matlab and communication skills

Databases: Oracle 10g/8i/9i, MS SQL Server, Organized, self starter and hard

MySQL 4.0 worker

Web Server: Apache, Oracle Application Multi-tasker with a strong sense

Server, Netscape Enterprise Server, and IIS of responsibility

Reporting Tool: Crystal Reports 4.5, Oracle Productive as both individual

Reports 3.0 contributor and team member

Documentum 5: Documentum 4i/5.X, Documentum

Content Server 5.2.5/5.3

OS: Unix, HP-UX, SunOS, VAX/VMS, Windows

Protocols: TCP/IP,UDP,HTTP

Tools: MS Excel, Word, Visio, Outlook,

PowerPoint, MS project


M.S, Electrical Engineering University

of Bridgeport, CT GPA 3.7

B.S, Instrumentation and Control Engineering S.V.I.T, Gujarat

University, India GPA 3.7


Contact this candidate