Please don't reply on this mail.
Hi All,


Hope you are doing well!!!!


Please Send me the suitable profiles to 


With rate confirmation Contact Details with Current Location.

Position: Senior/Lead Oracle DBA

Location: Providence, RI

Duration: 3 Month Contract

Rate: $50-55/hr (Not Negotiable)


I need a very Senior, Lead Oracle DBA with strong skills in 10g R2.  FACE TO 
FACE INTERVIEW REQUIRED - COM SKILLS MUST BE 10/10... 8-10+ yrs of overall 
experience please.

Candidates in MA, RI, ME, CT and NH would likely be able to attend a face to 
face interview... 

Oracle Contractor 

There are three areas for the Oracle contractor to address: Oracle 10g R2 
Education, CareTracker running on an Oracle 10g R2 database, and Upgrading 
current caretracker 9i database to 10g R2.  Each of these is discussed in more 
detail below.


Oracle 10g R2 Education

Staff currently has experience with oracle 9i ( in a production 
environment.  The database server is hosted on Windows Server 2003 R2 
Enterprise Edition SP2.  The host has 16CPUs and 16GB RAM.  The database is 
approximately 1TB in size.  Data is hosted on an EMC CX3-20 with many Raid 
Groups and LUNs.  These are mounted as NTFS filesystems to the windows server.  


The database is accessed via a single Oracle instance.  The instance is 
configured to use AWE and is sized with a 10GB buffer cache.  Data guard is 
used to provide four physical standby databases.  Three of these are local 
(hosts accessed via a LAN from the primary host) and one is accessed via a WAN 
at an off-site location.  One of the local standby databases is in managed mode 
and actively applies the received archive logs.  The others apply the logs 
during a maintenance window the early am hours.  The primary database is online 
24X7 with occasional offline maintenance scheduled as needed during off-peak 
hours.  9i RAC has been explored but never put into production.


OEM is not used.  Database monitoring is performed using Quest Spotlight on 
Oracle along with home-grown SQL "capture" scripts.  Quest Central aids in 
database maintenance activities.


Given knowledge of the current database environment, one objective we be to 
educate the staff on what Oracle 10g R2 brings to the table with special focus 
on in the areas of scalability and management efficiencies.  Topics involving 
the following will need to be covered:


-         64-bit: >4GB windows process size and > 16GB RAM access

-         RAC (is RAC required or just an option - Pros/Cons)

-         Grid and Grid Control

-         OEM

-         Adding nodes to cluster

-         Load balancing

-         Data guard and TAF


CareTracker running on an Oracle 10g R2 database

The following are all included in supporting the CareTracker application's 
access of the current 9i database:


-         ASP/VB6 via MSDAORA (i.e. Microsoft Data Access Provider for Oracle) 
from both IIS web pages and DLLs

-         .net via the 'Microsoft .NET Data provider for Oracle

-         Both 8i and 9i SQL*Net

-         MSDTC

-         ADO


Given the knowledge of the current application access methods, one objective 
will be to determine what changes need to be implemented in the environment 
and/or by the CareTracker applications to enable access of a 10g R2 version of 
the database and to be production-ready.  Areas of concern might be:


-         Upgrading client-side SQL*Net

-         Upgrading client-side drivers to be those available from Oracle 
rather than those available from Microsoft for Oracle

-         Scope of CareTracker application code changes required to function 
properly in the 10g environment


Upgrading current CareTracker 9i database to 10g R2

Given the knowledge of the current database environment, one objective will be 
to develop a plan of attack for the database and environment upgrade from 9i to 
10g R2.  This objective will include the following:


-         Staging the upgrade in a test environment as many times as needed to 
full-proof the process

-         Accounting for the effort involved in upgrading the data guard 
servers in conjunction with the primary database

-         Accounting for the effort involved in upgrading the web servers and 
other client hosts as needed

-         Fully understanding and minimizing primary database offline time as 
much as possible

Thanks & Regards,

Sophia Jones
Technical Recruiter
Data Group, Inc.
Certified Minority Women Owned Business Enterprise (MWBE) & Small Business 
Enterprise (SBE)
|Office: 1 - 732 - 791 - 2348 xtn: 250| Fax: 732 - 907 - 1174 | Email: | Website: |
Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail 
cannot be considered Spam as long as we include contact information and a 
remove link for removal from our mailing list. To be removed from our mailing 
list reply with "remove" and include your "original email address/addresses" in 
the subject heading. Include complete address/addresses and/or domain to be 
removed. We will immediately update accordingly. We apologize for the 
inconvenience if any caused to you.

You received this message because you are subscribed to the Google Groups 
"zilliontechnologies" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at

Reply via email to