Direct Client -Senior, Lead Oracle DBA with strong skills in 10g R2 - United Health Group - Face 2 face required.-- Immediate interviews
martin
10g R2. Client is United Health Group in Providence, RI. FACE TO
FACE INTERVIEW REQUIRED - 3 month contract. Rate is $60/hr. 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 (9.2.0.7) 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
Daniel Martin
Business Development Manager
IOIOS Inc
3262 N Garey Ave, Pomona, CA 91767
Tel: 909-657-2465
Fax: 270-626-3441
Fax: 909-912-8243 (for timesheets)
E-mail:daniel...@ioiosinc.com
www.ioiosinc.com
http://www.linkedin.com/pub/4/71b/b79
Note: This Email is not intended to be a solicitation or Spam. It is
specifically targeted for recruiting professionals in the consulting
business. Who can benefit from a mutually beneficial relationship. If
you have received this in error, please accept our apologies and
please reply with a "Remove" in the subject line. Also mention the
email id you wish to be removed Include complete address and/or domain
to be removed. Thank you for your patience and any inconvenience
caused is regretted