Hi, We have an urgent opening for *Sr. Oracle DBA 10g R2 *for our client in *Providence, RI* for *6+ Months.* A brief job description is given below. ------------------------------ Job Title: *Sr. Oracle DBA 10g R2* Location: *Providence, RI (Locals Only)* Duration: *6 Months+*
*Please send resumes directly to [email protected] Job Description:* 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. 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 If you are interested for the above position, would appreciate if you can please revert back to us at the earliest with the following: a) Updated Resume b) Contact Numbers c) Hourly Rate d) Current Location e) Availability f) Work Status ------------------------------ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OracleD2K" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/OracleD2K -~----------~----~----~----~------~----~------~--~---
